1. Analyze a mixed cost using the high-low method.

2. Prepare income statement for a merchandising company using the contribution format.

*must be entered in formulas*

High-Low Method: Contribution Format Income Statement -Excel FILE HOME INSERTPAGE LAYOUTFORMULAS DATA REVIEW VIEW Sign In IA A paste B 1 u ,le- , Alignment Number Conditional Format as Cell : Cells Editing Chipboard E48 Formatting Table Styles Font Styles 1 To aid in planning, Jay Corporation 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 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 6,000.00 per quarter