In: Accounting
Preble Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labor-hours and its standard cost card per unit is as follows:
Direct material: 6 pounds at $8.00 per pound | $ | 48.00 |
Direct labor: 3 hours at $14 per hour | 42.00 | |
Variable overhead: 3 hours at $5 per hour | 15.00 | |
Total standard variable cost per unit | $ | 105.00 |
The company also established the following cost formulas for its selling expenses:
Fixed Cost per Month | Variable Cost per Unit Sold | ||||||
Advertising | $ | 250,000 | |||||
Sales salaries and commissions | $ | 200,000 | $ | 17.00 | |||
Shipping expenses | $ | 8.00 | |||||
The planning budget for March was based on producing and selling 19,000 units. However, during March the company actually produced and sold 24,000 units and incurred the following costs:
Direct-laborers worked 60,000 hours at a rate of $15.00 per hour.
Total variable manufacturing overhead for the month was $336,600.
Total advertising, sales salaries and commissions, and shipping expenses were $260,000, $480,000, and $165,000, respectively.
1. What raw materials cost would be included in the company’s flexible budget for March?
2. What is the materials quantity variance for March? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input the amount as a positive value.)
3. What is the materials price variance for March? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input the amount as a positive value.)
4. If Preble had purchased 175,000 pounds of materials at $7.20 per pound and used 160,000 pounds in production, what would be the materials quantity variance for March? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input the amount as a positive value.)
5. If Preble had purchased 175,000 pounds of materials at $7.20 per pound and used 160,000 pounds in production, what would be the materials price variance for March? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input the amount as a positive value.)
7. What is the direct labor efficiency variance for March? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input the amount as a positive value.)
8. What is the direct labor rate variance for March?
(Indicate the effect of each variance by selecting "F" for
favorable, "U" for unfavorable, and "None" for no effect (i.e.,
zero variance.). Input the amount as a positive
value.)
1) | Raw materials cost to be included in planning budget | ||||||
planned units *direct materials cost per unit | |||||||
19000*48 | |||||||
912000 | |||||||
2) | material quantity variance | ||||||
(Actual quantity used - standard qty allowed)*standard rate | |||||||
(160,000 - 24000*6)*8 | |||||||
32000 | U | ||||||
3) | Material price variance for March | ||||||
(actual rate - standard rate)*actual quantity purchased | |||||||
(7.20 -8)*160,000 | |||||||
128000 | F | ||||||
4) | material quantity variance | ||||||
(Actual quantity used - standard qty allowed)*standard rate | |||||||
(160,000 - 24000*6)*8 | |||||||
32000 | U | ||||||
5) | Material price variance for March | ||||||
(actual rate - standard rate)*actual quantity purchased | |||||||
(7.20 -8)*175000 | |||||||
140000 | F | ||||||
7) | Direct labor Efficiency variance | ||||||
(Actual hours - standard hours allowed)*Standard rate | |||||||
(60000-24000*3)*14 | |||||||
168,000 | F | ||||||
8) | Direct labor rate variance | ||||||
(Actual rate- standard rate)*actual hours | |||||||
(15 -14)*60000 | |||||||
60,000 | U | ||||||