CPS Financial Modeling & Forecasting 2 — Questions and Answers
Question 1: When building a payroll cost forecast for a new fiscal year, which input variable has the GREATEST impact on total labor cost accuracy?
- Overtime premium rate
- Headcount assumptions and planned attrition (Correct answer)
- Federal unemployment tax rate
- Workers' compensation class codes
Correct answer: Headcount assumptions and planned attrition
Headcount assumptions drive base pay volume, making them the single largest variable in any payroll cost forecast.
Question 2: A company's payroll financial model shows a 3% merit increase applied mid-year on July 1. How should the annual payroll expense be calculated for a $60,000 employee?
- $61,800
- $60,900 (Correct answer)
- $61,200
- $62,400
Correct answer: $60,900
Six months at $60,000 ($30,000) plus six months at $61,800 ($30,900) equals $60,900 total annual payroll expense.
Question 3: In a payroll forecast model, what does a 'fully loaded labor cost' include beyond gross wages?
- Only federal and state income tax withholdings
- Gross wages plus employer payroll taxes, benefits, and retirement contributions (Correct answer)
- Net pay plus garnishment amounts
- Gross wages minus pre-tax deductions
Correct answer: Gross wages plus employer payroll taxes, benefits, and retirement contributions
Fully loaded labor cost captures all employer-side costs including FICA, FUTA, SUTA, benefits, and retirement match contributions.
Question 4: Which forecasting method uses historical payroll data patterns to project future payroll costs by assuming past trends will continue?
- Zero-based forecasting
- Time-series trend analysis (Correct answer)
- Driver-based modeling
- Scenario-based planning
Correct answer: Time-series trend analysis
Time-series trend analysis extrapolates future values from historical data patterns, assuming past behavior predicts future outcomes.
Question 5: A payroll specialist is asked to model the cost impact of converting 10 full-time employees to part-time (20 hrs/week). The average FTE salary is $50,000. What is the estimated annual savings?
- $250,000 (Correct answer)
- $500,000
- $125,000
- $200,000
Correct answer: $250,000
Converting 10 employees from full-time to half-time (50% reduction) saves 10 × $50,000 × 50% = $250,000 annually.
Question 6: In a rolling 12-month payroll forecast, what is the primary advantage over a static annual budget?
- It eliminates the need for variance analysis
- It always aligns with the calendar year
- It continuously updates as each month passes, keeping the forecast horizon constant (Correct answer)
- It reduces FUTA liability calculations
Correct answer: It continuously updates as each month passes, keeping the forecast horizon constant
A rolling forecast perpetually extends the planning horizon by adding a new future month each time one month closes, keeping the model current.
Question 7: When forecasting payroll for a retail company with seasonal peaks, which technique best accounts for fluctuating headcount needs?
- Straight-line interpolation
- Seasonal indexing applied to base headcount (Correct answer)
- Fixed-cost modeling
- Present value discounting
Correct answer: Seasonal indexing applied to base headcount
Seasonal indexing applies historical peak/trough multipliers to base headcount to model predictable staffing fluctuations throughout the year.
CPS Financial Modeling & Forecasting 2
When building a payroll cost forecast for a new fiscal year, which input variable has the GREATEST impact on total labor cost accuracy?