KD A 2- ? > 5- HOME Cost Behavior, Operating Leverage, and Profitability Analysis - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW - Sign In FILE INSERT DO D D Calibri A Paste U . A Cells Alignment Number Conditional Format as Cell Formatting Table Styles Clipboard Font Styles Jay Corporation has decided to prepare contribution income statements for C 1 Jay Corporation has decided to prepare contribution income statements for internal planning. 3 Budgeted information for Quarter 1 of Year 3: Sales in units 5 Sales price per unit 17,000 48.00 7 After analyzing expenses, the company has determined the following cost patterns. 8 Cost of Goods Sold (per unit) 29.00 9 Sales Commissions (per dollar of sales) 9.509 $ Administrative Salaries (per quarter) Rent Expense (per quarter) Depreciation Expense (per quarter) 45,000.00 27,000.00 36,000.00 15 1. Prepare a contribution margin income statement for Quarter 1 of Year 3. Jay Corporation Budgeted Income Statement For Year 3 Quarter 1 22 Sales 25 Variable expenses: 24 Cost of goods sold Sheet1 READY HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DIX Paste Cells Editing B I U . A Alignment Number . Font Conditional Format as Cell Formatting Table Styles Styles Clipboard 6 A1 X for Jay Corporation has decided to prepare contribution income statements 16 1. Prepare a contribution margin income statement for Quarter 1 of Year 3. Jay Corporation Budgeted Income Statement For Year 3, Quarter 1 22 Sales 23 Variable expenses: 24 Cost of goods sold Sales commissions 26 Total variable expenses 27 Contribution margin 28 Fixed expenses: 29 Adminstrative salaries 30 Rent expense 31 Depreciation expense 32 Total fixed expenses 33 Net operating income Sheet1 ... + READY Attempt(s)