Year 2 reads $100,000 of total shipping costs,

Year 2 reads 22,500 units

1. Using the high-low method, determine a cost formula for shipping costs.

Compute the fixed cost portion using the high level of activity.

2. prepare a contribution format income statement for Quarter 1 of Year 3.

Also i need my explanation done on excel using the proper excel calculations and answer

Apps M Gmail YouTube Maps FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 1 Calibri ITI A 16 Daste BIU- Alignment Number Cells Conditional Format as de Formatting Table Styles Styles Font 15 To aid in planning, Jay Corporation is preparing a contribution format income Sales in units Sales price per unit 5 17 000 18.00 is Atte analyzing expenses the company has determined the following cost patterns cost of goods sola IS 29.00 per al 950er dicarillas administrative salares 5 000 per quarter 171020.00h per quarter 135 000.00 per quarter Deprecated expense IS Management has concluded that shipping expense is a mixed cost Units shipped and the related shipping costaven the last eight quarters are: 25 SOO Cuarter Quarter Duarte Cher - Tote Shipping cost 5 572 000.00 94 DOIDO 5 39,800.00 25000 122.500.00 BODO 85,000.00 ante Sheet1 Antargets DIA TOS Clipboard Font A1 V x V To aid in planning, Jay Corporation is preparing a contribution format income A B C D E 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 $ 100,000.00 34 low level of activity 35 Change in activity 36 37 Variable cost per unit 38 39 compute the fixed cost portion using the high level of activity. Total cost at high level of activity 41 Less: Variable casteement 22 Totalted cost 2. Prepare a contribunon format income statement for Quarter 1 of year 3. y corporation budseed contribution Fomat Income Statement For Year 3 Quarter 1 Sheet1 100% Attempts LE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A A 96 Daste BUV Cells Alignment Number Conditional Format 25 Formatting Table Styles Styles To aid in planning, Jay Corporation is preparing a contribution format income B 2. Presse a contation format income statement for Quarter 1 of Year 3. av Corporation Budgeted Contributies Format Income Statement For earum s 811 000.00 S 495.000 250.00 Costot goods see Sales Commissions 5 Shippingspense 55 Total variable expenses 56 Coreanga margin Administrative salaries $$ 45 000.00 200 Sping expense Deprecatione pise ata hedapenses te operatore Sheet1 FEADY MO Attespils)