Labor Cost Projection App

A tool for HR Managers to strategically plan the workforce budget.

Global Assumptions

Workforce Data

(Click on any value in the table below to edit)

Department Staff (Pax) Avg. Salary (Monthly)

Total Staff (Pax):

0

5-Year Financial Forecast

Year Sales (Growth) Sales (Decline) Total Labor Cost YoY Cost Growth Labor % (Growth) Labor % (Decline)

Forecast Visualization

How It's Calculated (Calculation Notes)

  • Sales (Growth/Decline): The base year revenue compounded annually by the respective growth or decline percentage.
  • Total Labor Cost: The sum of the initial staff's cost (with annual increments) and the cumulative cost of new hires (also with annual increments).
  • YoY Cost Growth: The percentage increase in Total Labor Cost compared to the previous year.
  • Labor % (Growth/Decline): Calculated as `(Total Labor Cost / Scenario Sales) * 100`.