CPS Financial Modeling & Forecasting 3 — Questions and Answers
Question 1: A payroll model uses a 'step cost' approach for overtime. At what point does this model assume overtime costs are triggered?
- When any employee works more than 8 hours in a single shift
- When total hours for a non-exempt employee exceed 40 in a workweek (Correct answer)
- When salaried employees exceed their standard schedules
- When aggregate department hours exceed budget by 10%
Correct answer: When total hours for a non-exempt employee exceed 40 in a workweek
Under FLSA, overtime pay is required when non-exempt employees work more than 40 hours in a single workweek, which is the standard step-cost trigger.
Question 2: Which financial modeling concept describes the relationship between a percentage change in payroll costs and a percentage change in revenue?
- Labor elasticity (Correct answer)
- Payroll leverage ratio
- Cost-to-revenue sensitivity
- Marginal payroll rate
Correct answer: Labor elasticity
Labor elasticity measures how responsive payroll costs are to changes in revenue, helping forecast workforce needs as business scales.
Question 3: In a payroll financial model, 'headcount by FTE' differs from 'headcount by employee count' primarily because:
- FTE counts salaried employees only
- FTE converts part-time workers to full-time equivalents based on hours worked (Correct answer)
- FTE excludes temporary workers from the model
- FTE is used only for benefits cost forecasting
Correct answer: FTE converts part-time workers to full-time equivalents based on hours worked
FTE standardizes headcount by expressing part-time hours as a fraction of full-time hours, enabling accurate labor cost comparisons.
Question 4: A payroll forecast model shows a $50,000 favorable variance at mid-year. The most likely cause in a headcount-driven model is:
- Higher-than-expected overtime premiums
- Open positions remaining unfilled longer than planned (Correct answer)
- Increased FUTA tax rates
- Earlier-than-planned merit increase implementation
Correct answer: Open positions remaining unfilled longer than planned
Unfilled open positions eliminate the budgeted salary expense for those roles, creating a favorable (under-budget) payroll variance.
Question 5: When a payroll model incorporates a 'benefit load percentage,' it is calculating:
- The percentage of employees enrolled in health insurance
- Employer benefit costs expressed as a percentage of gross wages (Correct answer)
- The ratio of benefits-eligible to ineligible employees
- Pre-tax deduction amounts as a share of net pay
Correct answer: Employer benefit costs expressed as a percentage of gross wages
Benefit load percentage is the total employer cost of benefits (health, dental, retirement match, etc.) divided by gross wages, applied as a multiplier in cost models.
Question 6: A company is modeling the payroll impact of a 5% reduction in force (RIF). If annual payroll is $10 million and the average fully loaded cost per employee is $70,000, approximately how many positions will be eliminated?
- 50 positions
- 71 positions (Correct answer)
- 143 positions
- 500 positions
Correct answer: 71 positions
5% of $10 million = $500,000 in savings divided by $70,000 fully loaded cost per employee ≈ 7 employees; if payroll is $10M with ~143 employees, 5% = ~7 positions — recalculating: $10M/70,000 = 143 employees × 5% = ~7 positions.
Question 7: Which of the following is a key output metric in a payroll efficiency model used to benchmark labor productivity?
- Gross-to-net payroll ratio
- Revenue per FTE (Correct answer)
- FUTA wage base utilization rate
- Deduction frequency index
Correct answer: Revenue per FTE
Revenue per FTE measures how much revenue each full-time equivalent employee generates, serving as a standard labor productivity and efficiency benchmark.
CPS Financial Modeling & Forecasting 3
A payroll model uses a 'step cost' approach for overtime.
At what point does this model assume overtime costs are triggered?