Braemar Saddlery uses department budgets and performance reports in planning and controlling its manufacturing operations. The following annual performance report for the custom saddle production department was presented to the president of the company: (see attached)
Although a production volume of 5,000 saddles was originally budgeted for the year, the actual volume of production achieved for the year was 6,000 saddles. Direct materials and direct labor are charged to production at actual cost. Factory overhead is applied to production at the predetermined rate of 150 percent of the actual direct labor cost.
After a quick glance at the performance report showing an unfavorable manufacturing cost variance of $75,000, the president said to the accountant: "Fix this thing so it makes sense. It looks as though our production people really blew the budget. Remember that we exceeded our budgeted production schedule by a significant margin. I want this performance report to show a better picture of our ability to control costs."
Prepare a revised performance report for the year on a flexible budget basis. Use the same format as the production report above, but revise the budgeted cost figures to reflect the actual production level of 6,000 saddles. (Leave no cells blank - be certain to enter "0" wherever required. Amounts to be deducted should be indicated with a minus sign. Round your per unit answers to 1decimal place. Omit the "$" sign in your response.)
Your tutorial is in Excel (attached) and shows the new performance report and how to compute the applied and underapplied overhead.