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
(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
Get step-by-step solutions from verified subject matter experts
