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

Standards

Direct Materials (Purple Resin)	10 pounds per pot at a cost of $4.00 per pound
Direct Labor	2.0 hours at a cost of $17.00 per hour
Standard Variable Manufacturing Overhead Rate	$3.00 per direct labor hour
Budgeted Fixed Manufacturing Overhead	$10,000
Standard 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 only 1,000 flower pots:

Actual

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

Complete the Excel Spreadsheet table that you downloaded from the Unit 7 Preparation Page page. (50 points)

Compute and put in the spreadsheet:

the direct materials price variance

the direct materials quantity variance

Compute and put in the spreadsheet:

the direct labor rate variance

the direct labor efficiency variance

Compute and put in the spreadsheet the variable manufacturing overhead variances.

Compute Compute and put in the spreadsheet the fixed manufacturing overhead variances.

Compute the Variable Manufacturing Overhead Variances
Price variance
Efficiency variance
Compute the fixed manufacturing overhead variances
Price variance
Production volume variance