Spreadsheet: 884748d1734012777-index-and-match-issue-i-think-excel-365-for-mac-excel_forum2
Sheet: wsVar

P&L Data Validation |  | Project Phases |  |  |  |  |  |  | Cost Class | Role and Employee | Phase | Year 1 Salary (Placeholders)
Direct Materials and Supplies |  | AC Gen Stes | Duration (Months) | Start Date | End Date | Funding Amount | [NAME] |  | Administrative and General Overheads | CEO | Funding | 450000 |  | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 135000 | 135000 | 135000 | 135000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 135000 | 135000 | 135000 | 135000
Production Facilities |  | Funding | 0 | 2025-01-01 00:00:00 |  | 500000 | 0.2 |  | Administrative and General Overheads | COO | Funding | 375000
Professional and Technical Services |  | Software validation and testing | 6 |  |  |  | 0.2 |  | Sales and Marketing | CTO | Funding | 288000
Equipment and Maintenance |  | Prototype built | 4 |  |  |  | 0.3 |  | Administrative and General Overheads | Corporate Secretary -TBD | Funding | 120000
Licenses and [NAME] |  | Licensing started | 60 |  |  | 1500000 | 0.5 |  | Direct Labor | Chief Engineer - TBD | Funding | 162000
Administrative and General Overheads |  |  |  |  |  |  |  |  | Professional and Consulting Services | Subject Matter Experts, PHD (2) | Funding | 350000
Sales and Marketing |  |  |  |  |  |  |  |  | Direct Labor | Lead Engineer Electrical Machinery - TBD | Funding | 120000
Human Resources and Employee Support |  |  |  |  |  |  |  |  | Administrative and General Overheads | [NAME] (2) | Funding | 100000
IT and Technology Support |  |  |  |  |  |  |  |  | Direct Labor | Program Manager - TBD | Software validation and testing | 162000 |  | 32400 | 32400 | 32400 | 32400 | 32400 | 32400 | 48600 | 48600 | 48600 | 48600 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000 | 81000
Legal and Compliance |  |  |  |  |  |  |  |  | Licenses and [NAME] | Technical Writer III - TBD | Prototype built | 80000
Professional and Consulting Services |  |  |  |  |  |  |  |  | Direct Labor | Lead Electronic Hardware Engineer | Prototype built | 130000
Security and Maintenance |  |  |  |  |  |  |  |  | Direct Labor | Lead Firmware Engineer - TBD | Prototype built | 130000
Utilities and Operational Overheads |  |  |  |  |  |  |  |  | Direct Labor | Firmware Engineer - TBD (2) | Prototype built | 220000
Other Expenses |  |  |  |  |  |  |  |  | Direct Labor | Application Software Engineer | Software validation and testing | 85000
 |  |  |  |  |  |  |  |  | Direct Labor | Mechanical Engineer (3) | Prototype built | 360000
Project Phase Data Validation |  |  |  |  |  |  |  |  | Direct Labor | Industrial Engineer | Prototype built | 132000 |  |  |  |  |  |  |  | 39600 | 39600 | 39600 | 39600 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000 | 66000
Bootstrapped |  |  |  |  |  |  |  |  | Sales and Marketing | Technical Marketing Director | Prototype built | 180000
Funding |  |  |  |  |  |  |  |  | Sales and Marketing | Technical Marketing Staff (1.8) | Prototype built | 100000
Software validation and testing |  |  |  |  |  |  |  |  | Direct Labor | Engineering Safety and Certification | Prototype built | 120000
Prototype built |  |  |  |  |  |  |  |  | Legal and Compliance | Manager [NAME] and Contracts | Prototype built | 130000
Licensing started |  |  |  |  |  |  |  |  | Human Resources and Employee Support | Human Resources Manager | Prototype built | 100000
 |  |  |  |  |  |  |  |  | Administrative and General Overheads | CPA | Prototype built | 90000
 |  |  |  |  |  |  |  |  | IT and Technology Support | IT Manager | Prototype built | 70000
 |  |  |  |  |  |  |  |  | Sales and Marketing | Business Copy Writer | Prototype built | 80000
 |  |  |  |  |  |  |  |  | Sales and Marketing | Marketing & Public Relations Manager - TBD | Licensing started | 90000
 |  |  |  |  |  |  |  |  | Administrative and General Overheads | CFO - TBD | Licensing started | 180000 |  |  |  |  |  |  |  |  |  |  |  | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000
 |  |  |  |  |  |  |  |  | Sales and Marketing | Business Development Executive | Licensing started | 185000
 |  |  |  |  |  |  |  |  | Direct Labor | Shipping Receiving Inventory | Licensing started | 40000
 |  |  |  |  |  |  |  |  | Administrative and General Overheads | Employee-Related Expenses
 |  |  |  |  |  |  |  |  |  | Total Salaries and Wages