1) Identify each of the company's expenses as either variable, fixed, or mixed. For the FC list the total fixed costs per month for each month. For VC list the variable cost per unit for each month. For MC list the total average cost per unit for each mixed cost per month.

17 - x fx A B C D E F G H 1 2 3 Edwards & Shaw Income Statement For the Three Months Ending September 30th 4 5 6 July August September 7 8 Sales in Units 4,500 5,000 6,000 $ 675,000 $ 275,000 400,000 750,000 $ 300,000 450,000 900,000 350,000 550,000 9 10 11 12 13 14 15 16 17 18 19 20 Sales Revenue Cost of Goods Sold Gross Margin Operating Expenses: Advertising expense Shipping expense Salaries and commissions Legal expense Depreciation expense Total Operating Expense Operating Income 11,000 27,000 127,500 7,000 10,000 182,500 217,500 $ 11,000 30,000 135,000 7,000 10,000 193,000 257,000 $ 11,000 36,000 150,000 7,000 10,000 214,000 336,000 $ 21 22 23 Income Statement Template Sheet3 + TextBox1 : A B T K L M N O P q A 5 UV W X 1) Identify each of the company's cxpenses as either variable, fixed, or mixed. For the FC list the total fixed costs per month for each month. For VC list the variable cost per unit for each month. For MC list the total average cost per unit for each mixed cost per month. July August September 3 Fixed Costs & Variable Costa 9 10 11 12 13 Mixed Costs 14 15 16 17 18 It's Ok to type the cast fomu a Cirectly into the cells, although you will not receive credit if the variable rate and fixed costs are not alled using Excel cell references and formulas 2) Using the high-low method, separate each of the mixed expenses into variable and fixed elements. 19 State the cost equation for each mixed cost. You may have more than one mixed cost. 20 21 Variable Rate 22 Fixed Cost 23 Cost Formula 24 25 26 27 28 3. Edwards and Shaw expect to sell 6,500 units in October. Prepare an absorption Income statement for 29 October (assume we produce and sell the same number of units). 30 31 Sales In Units 6,500 32 33 Sales Revenue Income Statement Template Shoct3 +