Using Excel to Prepare a Static and Flexible Direct Labour

Budget

PROBLEM

Hinsdale Company provided the following information needed

for the preparation of its static and flexible budget reports

during January, $2020.$

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Use

mathematical formulas with cell references to the Problem area or work area as

indicated. Use the IF function with cell references to label as Favourable or

Prepare the following budget reports for January, $2020$ using the IF function, and

evaluate the usefulness of each report.

a$.$ A static budget report

b$.$ A flexible budget report.