Spreadsheet: 884786d1734053125-index-and-match-issue-i-think-excel-365-for-mac-project-funding
Sheet: wsVar v3

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