Question

Directions: Complete the Grey boxes. You must use formulas in the cells to get credit for this exam. DO NOT HARD CODE DATA (i.e. type numbers) Ex. 2A-1 Mountain Joe has a seasonal business in Franklin selling cat related merchandise. Use the High Low Method to determine the fixed costs and variable costs per unit. Month Units Sold Total Costs High or Low? January 1,096 $ 65,344 February 3,682 $ 101,548 March 1,281 $ 67,934 April 3,873 $ 104,222 May 2,758 $ 88,612 June 2,294 $ 82,116 July 1,154 $ 66,156 August 946 $ 63,244 Joetember 4,787 $ 117,018 October 2,386 $ 83,404 November 4,875 $ 118,250 December 2,464 $ 84,496 Mark the high and the low box (just one of each) Variaiable Cost Per Unit Change in Cost Change in Units VCU Do not hard code data in the grey cells - use formulas. Find the Fixed Costs Low High Units Total Cost Variable Cost Fixed Do not hard code data in the grey cells - use formulas.

          Directions: Complete the Grey boxes. You must use formulas in the cells to get credit for this exam. DO NOT HARD
CODE DATA (i.e. type numbers)
Ex. 2A-1 Mountain Joe has a seasonal business in Franklin selling cat related merchandise. Use the High Low Method to determine the fixed costs and variable costs per unit.
Month Units Sold Total Costs High or Low?
January 1,096 $ 65,344
February 3,682 $ 101,548
March 1,281 $ 67,934
April 3,873 $ 104,222
May 2,758 $ 88,612
June 2,294 $ 82,116
July 1,154 $ 66,156
August 946 $ 63,244
Joetember 4,787 $ 117,018
October 2,386 $ 83,404
November 4,875 $ 118,250
December 2,464 $ 84,496
Mark the high and the low box (just one of each)
Variaiable Cost Per Unit
Change in Cost
Change in Units
VCU
Do not hard code data in the grey cells - use formulas.
Find the Fixed Costs
Low High
Units
Total Cost
Variable Cost
Fixed
Do not hard code data in the grey cells - use formulas.

Directions: Complete the Grey boxes. You must use formulas in the cells to get credit for this exam. DO NOT HARD
CODE DATA (i.e. type numbers)
Ex. 2A-1 Mountain Joe has a seasonal business in Franklin selling cat related merchandise. Use the High Low Method to determine the fixed costs and variable costs per unit.
Month Units Sold Total Costs High or Low?
January 1,096 65,344
February 3,682 101,548
March 1,281 67,934
April 3,873 104,222
May 2,758 88,612
June 2,294 82,116
July 1,154 66,156
August 946 63,244
Joetember 4,787 117,018
October 2,386 83,404
November 4,875 118,250
December 2,464 84,496
Mark the high and the low box (just one of each)
Variaiable Cost Per Unit
Change in Cost
Change in Units
VCU
Do not hard code data in the grey cells - use formulas.
Find the Fixed Costs
Low High
Units
Total Cost
Variable Cost
Fixed
Do not hard code data in the grey cells - use formulas.

Added by Alicia R.

Question

Please give Ace some feedback