2. = High-Low Method; Contribution Format Income Statement - Excel ? 4 - FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 4 11 * ' % Paste BIU Alignment Number Conditional Format as Cell Formatting Cells Editing Clipboard | Font Table Styles Styles A1 fx A Jay Corporation has decided to prepare contribution income statements for B D E F 1 Jay Corporation has decided to prepare contribution income statements for internal planning. 2 3 Budgeted information for Quarter 1 of Year 3: 4 Sales in units 17,000 5 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) $ 13 Depreciation Expense (per quarter) $ 27,000.00 36,000.00 14 15 Shipping Cost has been determined to be mixed with the following costs for the past two years: 16 17 Year 1 18 Quarter 1 19 Quarter2 20 Quarter 3 21 Quarter 4 22 Year 2 23 Quarter 1 24 Quarter2 Shoot Total Cost Units es es $ 67,000.00 12,500 $ 94,000.00 21,000 es es $ 89,800.00 13,800 $ 92,600.00 20,000 es es $ 72,500.00 13,700 $ 80,000.00 14,000