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.

Volume $=$ Change $in$ total volume $x$ old product rate $x$ old product mix $\%$

Rate $=$ Change $in$ product rate $x$ new total volume $x$ old product mix $\%$

Mix $=$ Change $in$ product mix $\%x$ new total volume $x$ new product rate