with excel formulas

1 High-Low Method; Contribution Formal Income PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In FILE HOME INSERT Calibri - 11 % A . Cells >> Paste Editing B T U Alignment Number Conditional Format as Cell Formatting Table Styles Styles > Clipboard Font TH CSS fo V - B D E F 4 S 1 Jay Corporation has decided to prepare contribution income statements for internal planning. 2 3 Budgeted information for Quarter 1 of Year 3: Sales in units 17,000 Sales price per unit $ 48.00 6 7 After analyzing expenses, the company has determined the following cost patterns. 8 Variable Cost of Goods Sold (per unit) $ 29.00 9 Sales Commissions (per dollar of sales) 9.50% 10 11 Fixed Manufacturing Overhead (per quarter) $ 45,000.00 12 Administrative Salaries (per quarter) $ 27,000.00 13 Depreciation Expense (per quarter) S 36,000.00 15 Shipping Cost has been determined to be mixed with the following costs for the past two years: 16 17 Year 1 Total Cost Units 18 Quarter 1 $ 67.000.00 12,500 19 Quarter2 $ 94,000.00 21,000 VIEW REVIEW Sign In FORMULAS FILE INSERT DATA HOME PAGE LAYOUT M Calibri -11 A A Cells Editing . aste BIU- A % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Font Clipboard 55 v 3 D E F A B C 3 Depreciation Expense (per quarter) $ 36,000.00 4 Shipping Cost has been determined to be mixed with the following costs for the past two years: 6 7 Year 1 Total Cost Units 8 Quarter 1 $ 67,000.00 12,500 9 Quarter2 $ 94,000.00 21,000 0 Quarter 3 $ 89,800.00 13,800 1 Quarter 4 $ 92,600.00 20,000 2 Year 2 23 Quarter 1 S 72,500.00 13,700 24 Quarter 2 $ 80,000.00 14,000 25 Quarter 3 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 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW Sign in VIEW X Calibri - 11 - A A % M aste Cells BIU Alignment Number Editing Conditional Format as Cell Formatting Table Styles Styles