Question: please do on excel (LO 16-5, 6) 16-66. Variance Computations with Missing Data The following information is provided to assist you in evaluating the performance

please do on excel please do on excel (LO 16-5, 6) 16-66. Variance Computations with Missing

(LO 16-5, 6) 16-66. Variance Computations with Missing Data The following information is provided to assist you in evaluating the performance of the pro- duction operations of Studio Company: 42.000 $132,000 112,000 159,200 Units produced (actual).. Master production budget Direct materials Direct labor..... Overhead ....... Standard costs per unit Direct materials Direct labor.... Variable overhead. Actual costs Direct materials purchased and used.... Direct labor... Overhead .. $1.65 x 2 gallons per unit of output $14 per hour x 0.2 hour per unit $11.90 per direct labor-hour $150,960 (81,600 gallons) 111,708 (8,560 hours) 163,200 (61% is variable) Variable overhead is applied on the basis of direct labor-hours. Required Prepare a report that shows all variable production cost price and efficiency variances and fixed production cost price and production volume variances

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!