1. Analyze a mixed cost using the high-low method. 2. Prepare an income statement for a merchandising company using the contribution format. High-Low Method; Contribution Format Income Statement - Excel FILE HOME INSERT PAGE LAYOUT 86 Calibri 11 AA Paste BIU- FEL- Clipboard Font To B59 3 I x A 4 Sales in units 5 Sales price per unit 6 FORMULAS DATA REVIEW VIEW Alignment Number Conditional Format as Cell Cells Formatting Table Styles S Styles M Editing B C D E 17,000 48.00 7 After analyzing expenses, the company has determined the following cost patterns. 8 Variable Cost of Goods Sold (per unit) $ 29.00 9 Sales Commissions (per dollar of sales) 9.50% 10 11 Fixed Manufacturing Overhead (per quarter) $ 45,000.00 12 Administrative Salaries (per quarter) S 27,000.00 13 Depreciation Expense (per quarter) $ 36,000.00 14 15 Shipping Cost has been determined to be mixed with the following costs for the past two years: 16 17 Year 1 18 Quarter 1 19 Quarter2 20 Quarter 3 21 Quarter 4 22 Year 2 Total Cost Units ssss $ 67,000.00 12,500 $ 94,000.00 21,000 $ 89,800.00 13,800 $ 92,600.00 20,000 10 x Sign In