first page

second page

Frank Weston, supervisor of the Freemont Corporation's Machining Department was visibly upset after being reprimanded for his department's poor performance over the prior month. The department's cost control report is given below: FREEMONT COLORATION MACHINING DEPARTMENT Cost Control Report For the Month Ended lone 10 Machine-hours Direct labour wages Supplies Maintenance Utilities Supervision Depreciation Total Actual 38,500 $ 33,100 23,800 105,000 15,800 38.800 81,300 $347,800 Static Budget 36,500 $ 79,400 19,500 116,000 14,700 38,00 31,300 $349,700 Static Budget Variance $ 3,700 4,300 -11,000 1,100 $1,900 just can't understand all of these unfavourable variances, Weston complained to the supervisor of another department. "When the boss called me in, I thought he was going to give me a pat on the back because I know for a fact that my department worked more efficiently last month than it has ever worked before, Instead, he tore me apart. I thought for a minute that it might be over the supplies that were stolen out of our warehouse last month. But they amounted to only a couple of hundred dollars, and just look at this report Everything is unfavourable." Direct labour wages and supplies are variable costs supervision and depreciation are fixed costs, and maintenance and utilities are mixed costs. The fixed component of the budgeted maintenance cost is $82,000, the fixed component of the budgeted utilities cest is $10,400 Required: 1. This part of the question is not part of your Connect assignment Required: 1. This part of the question is not part of your Connect assignment. 2. Complete the performance report that will help Mr. Weston's superiors assess how well costs were controlled in the machining department. (Round your intermediate calculations to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect i.e., zero variance). Input all amounts as positive values.) Volume Variance Machine hours Direct labor wages Supplies Maintenance Uties Supervision Depreciation Total Freemant Comoration-Machining Department Comprehensive Performance Raport For the Month Ended June 30 Actual Flexible Budget Variance Flexible Results Budget 38,500 $ 83.100 23 300 105,000 15,800 38 800 81300 5 Planning Budget 36,500 $ 79,400 19,500 110,000 14.700 38 800 81300