Spreadsheet: 871338d1717724720-help-with-report-sample-manpower-spreadsheet-stryped-
Sheet: Headcount vs Budget

Prod | Area | kob | Shift | Company | April 2024 Budget | May 2024 Budget | June 2024 Budget | July 2024 Budget | August 2024 Budget | Sept 2024 Budget | Oct 2024 Budget | Nov 2024 Budget | Dec 2024 Budget | Jan 2025 Budget | Feb 2025 Budget | March 2025 Budget |  | Difference | May |  |  |  |  |  | Months
 | Cold Draw | Group Leader | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | January
 |  |  | 2nd | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | February
 |  |  | 3rd | Plant | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | March
 |  | CD#1 | 1st | Plant | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | April
 |  |  | 2nd | Plant | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | May
 |  |  | 3rd | Plant | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | June
 |  | CD#2 | 1st | Plant | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  |  | July
 |  |  | 2nd | Plant | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  |  | August
 |  |  | 3rd | Plant | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | September
 |  | CD#3 | 1st | Plant | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  |  | October
 |  |  | 2nd | Plant | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  |  | November
 |  |  | 3rd | Plant | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | December
 |  |  |  | Total
 | Taper Roll | TR#2 | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  | 2nd | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  | 3rd | Plant | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Total
 | ITM | ITM#1 | 1st | Plant | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 2nd | Plant | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 3rd | Plant | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Total
 |  | President | 1st | Plant | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
 |  | Plant Manager | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Production Mgr (Spring) | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Assistant Mgr Prod Eng. | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Product Engineers | 1st | Plant | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 |  | Production Supervisors | 1st | Plant | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | Production (Staff) | Production Supervisors | 2nd | Plant | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  | Production Supervisors | 3rd | Plant | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  | [NAME] | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | [NAME] | 1st | Plant | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 |  | Warehouse | 1st | Warehouse | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Production (Staff) |  |  | Total Prod (Staff) Plant
 |  |  |  | Total Prod (Staff) (Warehouse)
 |  | Maint and Eng Mgr | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | [NAME] | 1st | Plant | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 |  | Assistant Mgr Elect Eng | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Maint and Engineering | Elect Eng. Tech | 1st | Plant | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  | Electr Engineer | 1st | Plant | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  | Maint Supervisor | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | PM Coordinator | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Maint and Engineering |  |  | Total Maint/Eng Plant
 |  |  |  | Total Maint/Eng Warehouse
 |  | Quality Manager | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Asst. Mgr (Spring) | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Quality | Sr. QA Specialist | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | QA Engineer | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Inspection Supervisor | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | QA Assistant | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Quality |  |  | Total Quality (Plant)
 | EHS |  |  | Plant | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | EHS |  |  | Total EHS (Plant) | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  | PC Manager | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Assist. Mgr, PC | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Production Control (Spring) | Material Handling Supervisor | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Shiping/Logi Supervisor | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | PC [NAME] | 1st | Plant | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7
 |  | Senior Shipping Specialist | 2nd | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | PC Coordinator | 1st | Plant | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | Production Control (Spring) |  |  | Total PC (Plant)
 |  | Accounting Manager | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Cost Accountant | 1st | Plant | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Accounting | AR Specialist | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | AP Specialist | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Payroll | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Assistant [NAME] | 1st | Warehouse | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Accounting |  |  | Total Accounting (Plant)
 |  |  |  | Total Accounting (Warehouse)
 | Purchasing | Purchasing Manager | 1st | NASCO | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75
 |  | Buyer | 1st | NASCO | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Purchasing |  |  | Total Purchasing (Plant)
 | Human Resources | HR Manager | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | HR Generalist | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | HR Specialist | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Translator | 1st | Plant | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Human Resources |  |  | Total HR (Plant)
 | STAFF Totals |  |  | Plant
 |  |  |  | Warehouse