The Burnt-Toast Corporation manufactures two types of toasters The Super Model and the Economy model. The Super model can toast up to 8 slices of bread and can also toast bagels, muffins, and other odd-sized items. The Economy model can toast up to 4 slices and has no special features. Budgeted and actual operating data for the year 2022 were as follows:

Actual sales mix for the Super model was 30%, and budgeted sales mix for the Super model was 25%. Actual sales mix for the Economy model was 70%, and budgeted sales mix for the Economy model was 75%.

Prior to the beginning of the year, a consulting firm estimated the total volume of toasters that would be sold in Western Canada to be 200,000 units, but actual industry volume was 152,000 units sold in Western Canada in 2022. The company wants to analyze its sales-volume, sales-mix, sales quantity, market share and market size variances.

REQUIRED:

Choose to solve this question using either the Template Chart method (Method 1) in the provided Excel spreadsheet and answer the multichoice questions. Attach the final spreadsheet with all answers to the exam (you only need to attach the final spreadsheet to one of the questions in the exam that allows you to attach a file - such as this question).

OR... choose the Formula Method (Method 2) and show your calculations in the space provided below and then answer the multichoice questions. If you are using the Formula Method, make sure to identify the multi-choice question number when displaying the work. If there is no calculation for a question, explain why.