azto.meducation.com Question 1 - ExcelSimulations Ch 5. Connect ations Ch 5 Seved 1. Analyze a mixed cost using the high-low method. 2. Prepare an income statement for a merchandising company using the contribution format. 3 High-Low Method: Contribution Format Income Statement - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME 7 INSERT % Sign Calibri 11 -AA % M Paste BIU- . Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font B33 v > c D E B 22 Year 2 23 Quarter 1 s 72,500.00 24 13,700 Quarter 2 S 80,000.00 14.000 Quarter 3 S 84.000.00 14,300 26 Quarter 4 S 100,000.00 22 500 27 28 Use the data to answer the following 29 30 1. Using the high-low method, determine a cost formula for shipping expenses. 31 32 Total Shipping Cost 33 High level of activity 34 Low level of activity 35 Change in activity 36 37 Variable shipping cost per unit per unit 35 39 Fixed shipping cost: (Note: please use the highest activity point to compute the total cont.) 40 Total shipping cost at high level of activity Prov 1 of 1 18 Score answer > ST