I need to be able to understand how to calculate the answers so that I can appro

Question

I need to be able to understand how to calculate the answers so that I can appropriately reference my cells.

Gourmet, Inc. produces containers of frozen food. During October the company had the following actual production and costs Actual Containers produced in October Variable Overhead Fixed Overhead Direct Labor cost Actual material purchased Actual Material pounds used 725 $5,500 $14,000 $75,600 Which is $33,000 Which is 4,000 Direct labor hours 15,000 pounds 14,900 pounds Overhead is budgeted and applied using direct-labor hours. Standard cost and annual budget information are as follows Standard cost per container 5 hours Direct Labor Direct Material $18 $2 $90 $40 at 20 pounds at Direct labor 5 hours Direct labor 5 hours Variable overhead at $1.50 $7.50 $3 Fixed Overhead Total at $152.50 Budgeted Monthly Fixed Overhead $12,500 Required: Make sure you do not forget to label the variances U or F. You need to show your work either by cell reference or showing your calculation to the side 1. Calculate the direct materials price and quantity variance Materials price variance Materials Quantity variance 2. Calculate the direct labor rate and efficiency variances Labor rate variance Labor Efficiency variance 3. Calculate the variable overhead spending and efficiency variances Variable overhead spending variance Variable overhead efficiency variance 4. Calculate the fixed overhead budget variance Fixed overhead budget variance

Explanation / Answer

a) material Price varaince 3000 U (AQ*AR)-(AQ*SR) 33000-(15000*2) b) Material Qty varaince 800 U SR*(AQ-SQ allowed) 2*(14900-(725*20)) ans 2 Labor rate variance 3600 U (AH*AR)-(AH*SR) 75600-(4000*18) Labor efficiecy varaince 6750 U SR*(AH-SH allowed) 18*(4000-(725*5)) ans 3 Varaible overhead rate variance 500 F (AH*AR)-(AH*SR) -500 5500-(4000*1.5) Varaible overhead efficiency varaince SR*(AH-SH allowed) 562.5 U 1.5*(4000-(725*5)) 4) Fixed overhead budget variance Actual-Budgeted 1500 U 14000-12500

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.