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 $14.80 per ounce 4 ounces at $17.20 per ounce Direct labor 5 hours at $60.20 per hour 6 hours at $78 per hour Variable overhead (per direct labor-hour) $48 $53.20 Fixed overhead (per month) $364,425 $399,360 Expected activity (direct labor-hours) 6,450 7,800 Actual results Direct material (purchased and used) 3,800 ounces at $14.20 per ounce 4,700 ounces at $19.00 per ounce Direct labor 4,970 hours at $62.50 per hour 7,480 hours at $82.60 per hour Variable overhead $257,550 $385,510 Fixed overhead $323,950 $399,100 Units produced (actual) 1,070 units 1,220 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