| Department | Budgeted HC | Actual HC |
| Finance | 27 | 34 |
| Human Resources | 28 | 24 |
| Marketing | 20 | 18 |
| Operations | 60 | 54 |
| Procurement | 35 | 35 |
| TOTAL | 170 | 165 |
Using Excel:
1) In the column next to Actual HC, calculate the percentage ofactual headcount for each department.
3) Insert a COMBO Chart, by selecting just the Department,Budgeted HC and Actual HC cell values (Do not includetotal). Do not select % of actual count at thistime.
4) Provide key findings/comparative analysis for eachdepartment.
Please provide instructions as to how this can be done on Excel.Thank You.
