1 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. High-Low Method; Contribution Format Income Statement - Excel 5 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In points Calibri 11 ' ' % Paste eBook BIU Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Print Clipboard Font Styles References A1 fx To aid in planning, Jay Corporation is preparing a contribution format income A B D E F 1 To aid in planning, Jay Corporation is preparing a contribution format income statement. 2 3 Budgeted information for Quarter 1 of Year 3: 4 Sales in units 5 Sales price per unit $ 17,000 48.00 6 8 Cost of goods sold 7 After analyzing expenses, the company has determined the following cost patterns. $ 29.00 per unit 9 Sales commissions 9.50% per dollar of sales 10 11 Administrative salaries 12 Rent expense 13 Depreciation expense SSS $ 45,000.00 per quarter 27,000.00 per quarter $ 36,000.00 per quarter 14