Prepare the Production Department\'s flexible budget performance report for Marc
ID: 2375480 • 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.)
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
for 8000 man hour prduction budget standard direct labour 126400.00 indirect labour 18700 utilities 12900 supplies 3500 equiepment depreciation 39300 factory rent 6600 property taxes 1340 factory adminstration 2605 actual for march actual direct labour 125730 indirect labour 18260 utilities 15870 supplies 4820 equiepment depreciation 43040 factory rent 7900 property taxes 1340 factory adminstration 17570 spending variance (FOR 8000 MAN HOURS) : spending actual variance direct labour 125730 -670.00 U indirect labour 18260 -440.00 U utilities 15870 2970.00 F supplies 4820 1320.00 F equiepment depreciation 43040 3740.00 F factory rent 7900 1300.00 F property taxes 1340 0.00 F factory adminstration 17570 -8480.00 U for 9700 manhours planed production budget.. plan 9700 direct labour 153260.00 indirect labour 21250 utilities 14090 supplies 4010 equiepment depreciation 43040 factory rent 6600 property taxes 1340 factory adminstration 29110for 8000 man hour prduction budget standard direct labour 126400.00 indirect labour 18700 utilities 12900 supplies 3500 equiepment depreciation 39300 factory rent 6600 property taxes 1340 factory adminstration 2605