A B C D E F G " M 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: (2) Standard Quantity Standard Standard Price Cost Inputs or Hours or Rate (9-(2) Direct materials Direct labor 5 pounds $8.00 per pound $40.00 2 hours $14 per hour 2800 Variable overhead 2 hours $5 per hour 1000 Total standard cost per unit $78.00 The planning budget for March was based on producing and selling 25,000 units. However, during March the company actually produced and sold 30,000 units and incurred the following costs: a. Purchased 160,000 pounds of raw materials at a cost of $7.50 per pound. All of this material was used in production. b. Direct laborers worked 55,000 hours at a rate of $15.00 per hour. c. Total variable manufacturing overhead for the month was $280,500. Required: 1. What raw materials cost would be included in the company's planning budget for March? 2. What raw materials cost would be included in the company's flexible budget for March? 3. What is the materials price variance for March? 4. What is the materials quantity variance for March? 5. If Preble had purchased 170,000 pounds of materials at $7.50 per pound and used 160,000 pounds in production, what would be the materials price variance for March? 6. If Preble had purchased 170,000 pounds of materials at $7.50 per pound and used 160,000 pounds in production, what would be the materials quantity variance for March? 7. What direct labor cost would be included in the company's planning budget for March? 8. What direct labor cost would be included in the company's flexible budget for March? 9. What is the labor rate variance for March? 10. What is the labor efficiency variance for March? 11. What is the labor spending variance for March? 12. What variable manufacturing overhead cost would be included in the company's planning budget for March? 13. What variable manufacturing overhead cost would be included in the company's flexible budget for March? 14. What is the variable overhead rate variance for March 15. What is the variable overhead efficiency variance for March? 1. What raw materials cost would be included in the company's planning budget for March? Planned level of activity (units) Raw materials required per unit (pounds) Total raw materials needed Cost of raw material/pound Cost of raw material in Planning Budget E 2. What raw materials cost would be included in the company's flexible budget for March? 3. What is the materials price variance for March? 4. What is the materials quantity variance for March? 2) Raw materials included in flexible budget: Actual units produced Raw materials allowed/unit Total raw materials allowed Cost of raw materials/unit Cost of raw materials included in flexible budget 3) Materials Price Variance: AQ(AP-SP) Actual price of materials/pound (a) Standard price of materials/ pound (b) Variance (a)-(b) = (c) Actual quantity of raw materials used (pounds) (d) *Materials price variance (c) x (d) If actual-price paid is greater than standard price allowed, the material price variance would be unfavorable and vice versa. 3. If Preble had purchased 170,000 pounds of materials at $7.50 per pound and used 160,000 pounds in production, what would be the materials price variance for March? 6. If Preble had purchased 170,000 pounds of materials at $7.50 per pound and used 160,000 pounds in production, what would be the materials quantity variance for March? 5) Materials Price Variance AQ (AP-SP) Actual Price/ pound (a) Standard price/pound (b) Variance (a)-(b)(c) Actual quantity of raw materials used (d) "Materials Price Variance (c) x (d) If actual price paid is greater than standard price allowed, the material price variance would be unfavorable and vice versa. 6) Materials Quantity Variance SP (AQ-SQ) Actual quantity of materials used (a) Standard quantity allowed - see Q4 (b) Variance (a) (b)=(c) Standard price/pound (d) **Materials Quantity Variance (c) x (d) If actual quantity of materials used exceed standard quantity of materials allowed, 7. What direct labor cost would be included in the company's planning budget for March? Direct labor: Units produced in Planning Budget (a) Direct labor required per unit (b) Total direct labor hours needed (a) x (b) + (c) Cost per direct labor hour (d) Total direct labor cost included in Planning Budget (c)x d) B) 9) 8. What direct labor cost would be included in the company's flexible budget for March? 9. What is the labor rate variance for March? 10. What is the labor efficiency variance for March? 11. What is the labor spending variance for March? Direct labor cost included in flexible budget Direct labor: Units produced in Flexible Budget (a) Direct labor required per unit (b) Total direct labor hours needed (a) x (b) = (c) Cost per direct labor hour (d) Total direct labor cost included in Flexible Budget (c) x (d) Labor rate variance for March: AH (AR-SR) Actual rate/hour (a) Standard rate/hour (b) Variance (a) (b)=(c) Actual quantity of direct labor used (d) *Labor rate variance (c) x (d) *If actual rate paid is greater than standard rate allowed, the labor rate variance would be unfavorable and vice versa. 12. What variable manufacturing overhead cost would be included in the company's planning budget for March? Variable manufacturing overhead included in Planning Budget: Units produced in planning budget (a) Number of direct labor hours /unit (b) Total direct labor hours required (a) x (b)=(c) Standard variable mfg. OH cost /direct labor hour (d) Variable manufacturing overhead included in Planning Budget (c) x (1) 13. What variable manufacturing overhead cost would be included in the company's flexible budget for March? 14. What is the variable overhead rate variance for March? 15, What is the variable overhead efficiency variance for March? 13) Variable manufacturing overhead cost included in Flexible Budget: Units produced in Flexible Budget (a) Direct labor required per unit (b) Total direct labor hours needed (a) x (b) = (c) Variable mfg. overhead cost per direct labor hour (d) Total variable mfg. overhead cost included in Flexible Budget (c) x (d) 14) Variable overhead rate variance for March AH (AR-SR) Actual variable mfg. overhead rate/hour (a) Standard variable mfg. overhead rate/hour (b) Variance (a) (b)=(c) Actual quantity of direct labor used (d) "Variable mfg. overhead rate variance (c) x (d)