Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

تمرين 4

WHAT-IF ANALYSIS
The following actual overhead costs were incurred in December:

Planned direct labor hours were 4,000. Actual direct labor hours were 4,500. Other budget data for December were identical to November except that fixed maintenance costs have increased to $2,000 and variable indirect materials costs have increased to $0.30 per direct labor hour.
Prepare and print new budget reports for December. Remember to change the month in cell B7. Save your completed file as FLEXBUD4. Compare the two budget reports and comment on the differences disclosed between the static budget and flexible budget performance reports.