Solve using excel

7-32

7-32 Comprehensive variance analysis, responsibility issues. (CMA, adapted) Styles, Inc., manufac- tures a full line of well-known sunglasses frames and lenses Styles uses a standard costing system to set attainable standards for direct materials, labor, and overhead costs. Styles reviews and revises stan- dards annually, as necessary. Department managers, whose evaluations and bonuses are affected by their department's performance, are held responsible to explain variances in their department perform- ance reports. Recently, the manufacturing variances in the image prestige line of sunglasses have caused some concern. For no apparent reason, unfavorable materials and labor variances have occurred. At the monthly staff meeting, Jack Barton, manager of the Image line, will be expected to explain his variances and suggest ways of improving performance. Barton will be asked to explain the following performance report for 2011: Actual Results Static-Budget Amounts Units sold 7,275 7,500 Revenues $596,550 $600,000 Variable manufacturing costs 351,965 324,000 Fixed manufacturing costs 108,398 112,500 Gross margin 136,187 163,500 Barton collected the following information: Three items comprised the standard variable manufacturing costs in 2011: Direct materials: Frames. Static budget cost of $49,500. The standard input for 2008 is 3.00 ounces per unit. Direct materials: Lenses.Static budget costs of $139,500. The standard input for 2008 is 6.00 ounces per unit. Direct manufacturing labor. Static budget costs of S135,000. The standard input for 2008 is 1.20 hours per unit Assume there are no variable manufacturing overhead costs. The actual variable manufacturing costs in 2011 were as follows: Direct materials: Frames. Actual costs of $55,872. Actual ounces used were 3.20 ounces per unit Direct materials: Lenses. Actual costs of $150,738. Actual ounces used were 7.00 ounces per unit Direct manufacturing labor: Actual costs of S145,356. The actual labor rate was $14,80 per hour 1. Prepare a report that includes the following: a. Selling price variance b. Sales-volume variance and flexible-budget variance for operating income in the format of the analy sis in Exhibit 7-2 Required 256 CHAPTER 7 FLEXIBLE BUDGETS, DIRECT-COST VARIANCES, AND MANAGEMENT CONTROL c. Price and efficiency variances for the fo following: Direct materials: frames Direct materials: lenses Direct manufacturing labor 2 Give three possible explanations for each of the three price and efficiency variances at Styles in requirementic