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. NUR . HOME .. INSERT High-Low Method: Contribution Format Income Statement - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW ? . x FILE - 6 Sign in AX Calibri 1 BE -A A B Cells Paste B T U . Alignment Number Editing Conditional Format as Cell Formatting Table - Styles Styles Clipboard 1 To aid in planning Jay Corporation is preparing a contribution format income statement. 3 Budgeted information for Quarter 1 of Year 3: 4 Sales in units 5 Sales price per unit 17,000 48.00 7 After analyzing expenses, the company has determined the following cost patterns. 3 Cost of goods sold 29.00 per unit 9 Sales commissions 9.50% per dollar of sales 11 Administrative salaries 12 Rent expense 45,000.00 per quarter 27,000.00 per quarter 36 m narrar Prev 1 of 2 5 Next > to search