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 HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW Sign In Calibri B Iu- A Alignment Number Conditional Format as Cell Cells Editing Formatting Table" Styles Clipboard Font Fill Color Al is preparing a contribution format income v Color the background of cells to make them stand out. Tell me more 1 To aid in planning, Jay Co statement. Tell me more 3 3udgeted information for Quarter 1 of Year 3 4 Sales in units 17,000 48.00 5 Sales price per unit 7 After analyzing expenses, the company has determined the following cost patterns. 8 Cost of goods sold 9 Sales commissions 10 11 Administrative salaries 12 Rent expense 13 Depreciation expense 29.00 per unit 9.50% per dollar of sales 45,000.00 per quarter 27,000.00 per quarter 36,000.00 per quarter 15 Management has concluded that shipping expense is a mixed cost. Units shipped and the related shipping cost over the