RoseBusch is a manufacturer of large flower pots for urban settings. The company has these standards for their purple flower pots:

Direct Materials (Purple Resin)10 pounds per pot at a cost of $4.00 per poundDirect Labor2.0 hours at a cost of $16.00 per hourStandard Variable Manufacturing Overhead Rate$3.00 per direct labor hourBudgeted Fixed Manufacturing Overhead$10,000Standard Fixed MOH Rate$7.00 per direct labor hour (DLH)

RoseBusch allocated fixed manufacturing overhead to production based on standard direct labor hours. The Company expected to produce 1,200 pots. Last month, RoseBusch reported the following actual results for the production of 1,000 flower pots:

Direct MaterialsPurchased 10,500 pounds at a cost of $4.20 per pound; used 10,500 pounds to produce 1,000 potsDirect LaborWorked 2.2 hours per flower pot (2,200 Total DLH) at a cost of $15.00 per hourActual Variable Manufacturing Overhead Rate$3.40 per direct labor hour for total actual variable manufacturing overhead of $7,480Actual Fixed Manufacturing Overhead$11,800Standard Fixed Manufacturing Overhead Allocated Based on Actual Production$14,000

1. Complete Spreadsheet:
2. Compute:
3. the direct materials price variance
4. the direct materials quantity variance
5. Compute:
6. the direct labor rate variance
7. the direct labor efficiency variance
8. Compute the variable manufacturing overhead variances.
9. Compute the fixed manufacturing overhead variances.

Upload your completed spreadwheet into Question 1, 2 or 3 Compute the Variance [indicate favorable or List who you would SHOW YOUR WORK HERE FOR PARTIAL CREDIT unfavorable as Explain ONE thing that may have List one question you ask about the ask about the appropriate) caused the variance variance variances Material purchase price variance 2100 Purchasing Manager Material quantity variance Production Manager Direct labor rate variance Production Manager Direct labor efficiency variance Production Manager Variable overhead price variance Finance Variable overhead efficiency variance Finance Fixed overhead spending variance Finance Fixed overhead volume variance Finance