Sweetwater Company manufactures two products, Mountain Mist and Valley Stream. The company prepares its master budget on the basis of standard costs. The following data are for March:

Standards Mountain Mist Valley Stream Direct materials 3 ounces at $15 per ounce 4 ounces at $16.50 per ounce Direct labor 5 hours at $60 per hour 6 hours at $75 per hour Variable overhead (per direct labor-hour) $48 $52.50 Fixed overhead (per month) $335,340 $397,800 Expected activity (direct labor-hours) 5,750 7,800 Actual results Direct material (purchased and used) 3,100 ounces at $13.50 per ounce 4,700 ounces at $17.25 per ounce Direct labor 4,900 hours at $60.75 per hour 7,400 hours at $76.50 per hour Variable overhead $242,550 $378,510 Fixed overhead $313,950 $396,000 Units produced (actual) 1,000 units 1,200 units

Required:

a. Prepare a variance analysis for each variable cost for each product.

b. Prepare a fixed overhead variance analysis for each product. In excel should be formatted like: Columns labeled A,B,C,D,E and Rows labeled 1-16