Use the information below to answer the following question(s).

Squished Fruit Inc. manufactures jam products. It makes a strawberry-plum jam by blending strawberries and plums. If costs rise on one variety of fruit, then they will use more of the lesser expensive fruit, however, they need at least 40% plums to ensure that there is enough pectin that naturally occurs in plums for the jam to set.

Budgeted costs to produce 200,000 kilograms of jam in September were:

Input Ingredient	Budget Input Kilograms	Budget Input Mix %	Cost per Kg.	Budget Total Cost
Strawberry	90,000 kg.	45%	$1.50	$135,000
Plum	110,000 kg.	55%	$2.00	$220,000
Total	200,000 kg.	100%		$355,000

Actual costs to produce 205,000 kilograms of jam in September were:

Ingredient	Actual Input Kilograms	Actual Input Mix %	Cost per Kg.	Actual Total Cost
Strawberry	121,000 kg.	55%	$1.00	$121,000
Plum	99,000 kg.	45%	$2.20	$217,800
Total	220,000 kg.	100%		$338,800

REQUIRED: Squished Fruit is interested in obtaining a variance report for the Flexible Budget variance, the Rate and Efficiency Variance, and the Mix and Yield variance.

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 to the exam (you only need to attach the final spreadsheet to one of the questions 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.