Pelotoni Dips Inc. manufactures a single product that has become very popular in the Windsor area. The income statement for the most Tecent three months prior to taxes are as follows: Pelotini Dips Inc. Income Statement Quarterly Statement ending March 31, 2021 QI Q2 Q3 04 Sales in Units 4,400 4,000 5,000 4,600 Sales Revenues 5440,000 $400,000 $500,000 $460,000 Less:COGS 5264,000 $240,000 $300,000 $276.000 Gross Margin $176,000 $160,000 $200,000 $184,000 Less: Expenses Advertising $ 21,000 $21,000 $21,000 $ 21,000 Shipping $ 35,000 $ 34,000 $ 38,000 $ 36,000 Salaries and Commissions $ 83,000 $ 78,000 $90,000 $ 85,000 Insurance $ 6,000$ 6,000 $6,000 $ 6,000 Depreciation $15.000 15.000 15.000 $15.000 Total Operating Expenses $160,000 $154,000 $170.000 $163.000 Net Income (before taxes) $ 16,000 $ 6,000 $30,000 $ 21,000 a. Using the high-low method, separate cach mixed expense into variable and fixed expenses. Provide the cost formula for each mixed expense. (Hint: identify your expenses to find out the mixed expenses to marks) b. Now redo the company's income statement at the 5.000-unit level of activity using the contribution format. (8 mars c. Your marketing manager sat down with the budgeting team and predicts sales to be at the 4.500 units in the next quarter. Prepare a Cand and submit SATA Wow $440,000 $400,000 $500,000 $450 000 $264.000 $240,000 $300,000 $276.000 $176,000 $160,000 $200,000 $184,000 Sales Revenues Less:COGS Gross Margin Less: Expenses Advertising Shipping Salaries and Commissions Insurance Depreciation Total Operating Expenses $ 21,000 $ 21,000 $ 21,000 $ 21,000 $ 35,000 $ 34,000 $ 38,000 $ 36,000 $ 83,000 $ 78,000 $90,000 $ 85,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 15,000 $15,000 $15,000 $15,000 $160,000 $154.000 $170,000 $163.000 Net Income (before taxes) $ 16,000 $ 6,000 $ 30,000 $ 21,000 a. Using the high-low method, separate each mixed expense into variable and fixed expenses. Provide the cost formula for each mixed expense. (Hint: identify your expenses to find out the mixed expenses. (10 marks) b. Now redo the company's income statement at the 5.000-unit level of activity using the contribution format (8 marks) C. Your marketing manager sat down with the budgeting team and predicts sales to be at the 4.500 units in the next quarter, Prepare a contribution margin income statement. (8 marks) For the toolbar, press ALT 10 PC) or ALT EN F10 (Mac) Click Save and Submit one and submit Chick Se All Anne olurser