In: Accounting
4. The firm planned to sell 40,000 units at a price of 14 TL per unit in the master budget. The firm actually sold 38,000 units. The firm planned to produce 42,000 units in the master budget but the firm actually produced 40,000 units. In master budget, each unit requires 0.6 direct labor hours and direct labor cost per hour is 7 TL. (14 Points)
Actual Results |
Flexible Budget |
Master Budget |
|
Sales Revenue |
570,000 |
||
Total Direct Materials Cost |
151,620 |
171,000 |
180,000 |
Total Direct Labor Cost |
170,670 |
||
Total Variable Manufacturing Overhead |
124,200 |
123,500 |
130,000 |
a. Calculate sales revenue, direct materials, direct labor, and variable manufacturing overhead activity variances and indicate whether the variances are favorable (F) or unfavorable (U). (First you have to complete missing values in the table)
b. Calculate revenue variance. Indicate whether the variance is favorable (F) or unfavorable (U).
c. Calculate direct materials, direct labor, and variable manufacturing overhead spending variances and indicate whether the variances are favorable (F) or unfavorable (U).
Sales | 38000 units | 38000 units | 40000 units | |||
Production | 40000 units | 40000 units | 42000 units | |||
Actual Results | Flexible Budget | Master Budget | ||||
Sales Revenue | $ 570,000.00 | $ 532,000.00 | $ 560,000.00 | |||
Total Direct Materials Cost | $ 151,620.00 | $ 171,000.00 | $ 180,000.00 | |||
Total Direct Labor Cost | $ 170,670.00 | $ 168,000.00 | $ 176,400.00 | |||
Total Variable Manufacturing Overhead | $ 124,200.00 | $ 123,500.00 | $ 130,000.00 |
a) | Activity Variances | |||||||
Flexible Budget | Master Budget | Variance | F/U | |||||
Sales Revenue | $ 532,000.00 | $ 560,000.00 | $ 28,000.00 | U | ||||
Total Direct Materials Cost | $ 171,000.00 | $ 180,000.00 | $ 9,000.00 | F | ||||
Total Direct Labor Cost | $ 168,000.00 | $ 176,400.00 | $ 8,400.00 | F | ||||
Total Variable Manufacturing Overhead | $ 123,500.00 | $ 130,000.00 | $ 6,500.00 | F |
b) | Revenue Variance | Actual Results | Flexible Budget | Variance | F/U | |||
Sales Revenue | $ 570,000.00 | $ 532,000.00 | $ 38,000.00 | F |
c) | Spending Variances | Actual Results | Flexible Budget | Variance | F/U | |||
Total Direct Materials Cost | $ 151,620.00 | $ 171,000.00 | $ 19,380.00 | F | ||||
Total Direct Labor Cost | $ 170,670.00 | $ 168,000.00 | $ 2,670.00 | U | ||||
Total Variable Manufacturing Overhead | $ 124,200.00 | $ 123,500.00 | $ 700.00 | U |