Problem 3-53 (Algo) CVP Analysis-Sensitivity Analysis (spreadsheet recommended) (LO 3-1) Alameda Tile sells products to many people remodeling their homes and thinks that it could profitably offer courses on tile installation, which might also increase the demand for its products. The basic installation course has the following (tentative) price and cost characteristics. Tuition Variable costs (tiles, supplies, and so on) Fixed costs (advertising, salaries, and so on) $ 420 per student 200 per student 101,200 per year Required: a. What enrollment will enable Alameda Tile to break even? b. How many students will enable Alameda Tile to make an operating profit of $63,800 for the year? c. Assume that the projected enrollment for the year is 830 students for each of the following (considered independently): 1. What will be the operating profit (for 830 students)? 2. What would be the operating profit if the tuition per student (that is, sales price) decreased by 7 percent? Increased by 25 percent? 3. What would be the operating profit if variable costs per student decreased by 14 percent? Increased by 18 percent? 4. Suppose that fixed costs for the year are 8 percent lower than projected, whereas variable costs per student are 9 percent higher than projected. What would be the operating profit for the year?