Prepare the Production Department\'s flexible budget performance report for Marc
ID: 2375520 • Letter: P
Question
Prepare the Production Department's flexible budget performance report for March, including both the activity and spending variances. (Leave no cells blank - be certain to enter "0" wherever required. 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. Omit the "$" sign in your response.)
Requirement 3:Prepare the Production Department's flexible budget performance report for March, including both the activity and spending variances. (Leave no cells blank - be certain to enter "0" wherever required. 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. Omit the "$" sign in your response.)
Explanation / Answer
Hi,
Please find the answer as follows:
Thanks.
Planning
Budget Activity Variances Flexible
Budget Spending Variances Actual
Results Labor Hours 8000
9300
Direct Labor 126400 -20540 U 146940 31210 F 115730 Indirect Labor 19900 -1950 U 21850 2990 F 18860 Utilities 14500 -1040 U 15540 270 F 15270 Supplies 4100 -520 U 4620 -1510 U 6130 Equipment depreciation 52300 -4810 U 57110 0 U 57110 Factory rent 7200 0
7200 -700 U 7900 Property taxes 1240 0
1240 0
1240 Factory administration 25450 -2340 U 27790 2320 F 25470 Total 251090 -31200
282290 34580
247710