How to Calculate Your 2027 Overtime Budget Using Actual Working-Hour Data

Direct answer: A 2027 overtime budget is a forecast of expected employee overtime costs based on verified overtime hours, applicable hourly wages, statutory overtime multipliers, staffing changes, and a contingency allowance. The basic estimate is verified overtime hours × hourly wage × applicable multiplier, aggregated by department and reporting period. In Indonesia, the usual overtime hourly wage basis is monthly wage ÷ 173, subject to the applicable wage components and regulations. Timemoz Time Tracker provides working-hour data and exports; final rupiah calculations belong in payroll or financial models.

TL;DR

• Use up to 12 months of prior working-hour and overtime records to capture seasonal differences.
• Forecast by department rather than applying a flat percentage increase to last year's budget.
• Validate overtime hours and authorization through established procedures; Timemoz overtime rules and approval are available in Signature and Enterprise.
• Include wage changes, headcount assumptions, different overtime multipliers, and a clearly stated buffer.

Why do overtime budgets miss the mark?

A forecast built as “last year's total plus 10%” can be wrong when departments have different demand, staffing levels, schedules, and overtime patterns. The stronger approach is to use historical evidence, understand workload peaks, and document which assumptions are likely to change next year.

Managers should also avoid assuming that every recorded hour beyond schedule automatically qualifies for the same overtime compensation. Applicable authorization, employment terms, and legal rules matter.

Step 1: Collect historical hours and pay information

For each department, gather up to twelve months of records: staffing, regular hours, overtime hours, working-day versus rest-day/public-holiday overtime, and relevant wage information from payroll.

A simplified budgeting formula is:

Estimated overtime cost = Σ (verified hours × hourly wage × applicable multiplier)

For standard illustrative Indonesian calculations, hourly wage = monthly wage ÷ 173. Under PP No. 35 of 2021, overtime on an ordinary working day generally pays 1.5 times the hourly rate for the first hour and twice the rate for subsequent hours. Rest-day and public-holiday rates differ; wage components and contractual arrangements can also change the calculation.

Overtime on a regular working day	Multiplier of hourly wage
First overtime hour	1.5×
Each subsequent hour	2×
Average for two consecutive hours	1.75× (one hour at 1.5×, one at 2×)

The 1.75 average suits two consecutive overtime hours on a regular working day; apply the correct rate for other situations such as rest days and public holidays.

Timemoz helps collect working-hour records and export them into a model. Payroll supplies the applicable wage basis and calculates the final amounts.

Step 2: Find the departments driving overtime spending

An organization-wide average can hide the fact that a few departments account for most overtime cost. Segment the records by department, month, and recurring work pattern.

Department	Monthly estimated overtime cost	Share of total
Operations	IDR 25.2 million	47%
Customer Success	IDR 21.0 million	39%
Engineering	IDR 7.0 million	13%
Total	IDR 53.2 million	100%

Chart: monthly estimated overtime cost by department (IDR million)

Operations	████████████████████████████████████████	25.2
Customer Success	█████████████████████████████████	21.0
Engineering	███████████	7.0

These figures are hypothetical, not customer data. Operations accounts for about 47% of the sample total. Its management team should determine whether overtime happens every month or only during seasonal peaks.

Recurring overtime can point to capacity shortages or inefficient processes. Seasonal spikes may call for advance scheduling, temporary help, or an explicitly allocated contingency. Employee conversations and workload evidence should guide the interpretation.

Step 3: Forecast next year's costs with realistic adjustments

Create a baseline from historical authorized and substantiated overtime. Review exceptions individually, document wage and headcount changes, adjust for known seasonal demand, and add a reasoned buffer.

Sample budget: 120 employees

Scenario	Calculation premise	Annual amount
Flat estimate	IDR 42 million/month × 12	IDR 504 million
Historical-data baseline	Department-level modeled overtime	IDR 638.4 million
Gap	Baseline minus flat estimate	IDR 134.4 million (26.7%)
Illustrative adjusted projection	Baseline less an assumed 10% unsupported claims, then plus 5% buffer	IDR 603.3 million

Chart: annual overtime budget by scenario (IDR million)

Flat estimate	████████████████████████████████	504.0
Historical-data baseline	████████████████████████████████████████	638.4
Adjusted projection	██████████████████████████████████████	603.3

This example is illustrative only. The 10% rate is an assumption for demonstration, so each employer should examine its own records, legal obligations, and claims before adjusting a forecast. The adjusted value is rounded.

Important: Do not automatically delete an overtime obligation simply because a software activity record is missing. Review evidence, authorization, applicable law, and payroll obligations appropriately.

How Timemoz supports overtime budgeting

Timemoz Time Tracker can provide recorded-hour data, department workload reporting, and CSV/Excel/PDF exports. Finance can combine the exported records with payroll wage data and forecasting assumptions.

Overtime rules and approval are available in Signature and Enterprise, so approved overtime hours can feed your 2027 budget analysis.

FAQ

What is the formula for an annual overtime budget?

Sum forecast overtime hours × applicable hourly wage × the correct multiplier across employees, departments, and months. Adjust for headcount, wages, seasonal demand, and documented uncertainty.

How much historical data should be used?

Twelve months is a helpful starting point because it captures a full annual cycle. If only partial data is available, state the limitation and update the forecast quarterly.

Can Timemoz calculate the final monetary value of overtime?

Timemoz supplies time and workload records for analysis and export. The final pay amount requires payroll wage information and the legally applicable overtime formula.

Is an unverified activity record proof that no overtime pay is owed?

No. Activity data is one source of evidence, not a substitute for payroll and legal review.

Conclusion

A defensible 2027 overtime budget starts with recorded hours and documented assumptions, not a blanket percentage increase. Analyze departments separately, include pay and staffing changes, and review the final model with HR, payroll, Finance, and legal teams. Try Timemoz or schedule a demo.

Sources: Timemoz; Indonesia's PP No. 35 of 2021; Hukumonline's overtime calculation explanation. Examples are hypothetical and do not constitute legal advice.