Optimizing Employee Numbers

An Excel file that teaches how to perform Optimizing Employee Numbers operation.

Excel Spreadsheet for Optimizing Employee Numbers

Demand forecasts and capacity data are entered. Efficiency assumptions are recorded in the table. Open and closed differences are calculated. Scenarios are evaluated with a comparison chart. The proposed staffing plan is reported.

Hope it is useful.