please state the answers in formulas (ex. =B7-C7)

1. Analyze a mixed cost using a scattergraph plot and the high-low method. 2. Prepare income statements for a merchandising company using the traditional and contribution formats. All answers must be entered as a formula. Click OK to begin. OK Paste BIU. Clipboard Font A1 Alignment Number Conditional Format as Cell Cells Editing Formatting" Table Styles Styles To aid in planning, Jay Corporation is preparing a contribution format income D E $ 36,000.00 per quarter A F 13 Depreciation expense 15 Management has concluded that shipping expense is a mixed cost. Units shipped and the related shipping cost over the last eight quarters are: 16 17 Year 1 Total Shipping Cost Units 18 Quarter 1 $ 67.000.00 12,500 19 Quarter2 $ 94,000.00 21,000 20 Quarter 3 S 89,800.00 13,800 21 Quarter 4 $ 92,600.00 20,000 22 Year 2 23 Quarter 1 $ 72,500.00 13,700 24 Quarter2 $ 80,000.00 14.000 25 Quarter 3 S 84,000.00 14,300 26 Quarter 4 $ 100,000.00 22,500 27 28 Use the data to answer the following 29 30 1. Using the high-low method, determine a cost formula for shipping expenses. 31 32 Total Shipping Cost Units 33 High level of activity 34 Low level of activity 15. Change in activity Sheet1 Paste BIU. E- Clipboard Font Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles fc To aid in planning, Jay Corporation is preparing a contribution format income