Using the Morin Method formulas and the budget and actual data assumptions below, calculate the total variance and the composition
between volume, rate and mix and show the results in the Variance and Due to worksheet given.

Using the Morin Method formulas and the budget and actual data assumptions below, calculate the total variance and the composition between volume, rate and mix and show the results in the Variance and Due to worksheet glven Volume = Rate Mix = Change in total volume x old product rate x old product mix% Change in product rate x new total volume x old product mix% Change in product mix % x new total volume x new product rate Variancee Sum Budget Price Actual Price Sales Due to: Units Sales $ Units Total $ VolumePrice Mix Product A Product B Product Product D Tota 150 $ 210.00 31,500 50180.00 9,000 150 $ 200.00 30,000 150 $ 70.00 10,500 500 162.00 81,000 200 S 200.0040,000 600 S 100.00 60,000 50 S 150.00 7,500 300 S 50.0015,000 150 S 106.52 122,500