Problem 18 The condensed income statement of the Allen Hotel (AH) is as follows Fixed Variable Costs Dept. Income Revenue OS Rooms Food Gift shop Other Total department income Other variable expenses Other fixed costs Pretax income Income taxes Net income $5,000,000 $1,000,000 $500,000 $ 3,500,000 700,000 150,000 200,000 100,000(100,000) 4,250,000 950,000* 2,000,000 400,000 200,000 800,000 150,000 500,000 100,000 2,800,000** 500,000 100,000 $ 400,000 "Management fees and rent expense vary with rooms revenue **Includes depreciation of $800,000 Required: 1. 2. 3. Compute the AH's weighted average CMR. Consider all variable costs Com pute the AH's breakeven point. If the AH desires to earn (net income) $500,000, what must its total food sales equal? (Assume the sales mix is constant.) If the AH desires to generate pretax cash flow of $800,000, what must its total revenue equal? Assume its debt reduction payment is $300,000 for the year and it plans to pur- chase equipment for $100,000 using cash. 4. 5. If the sales mix charges to rooms 60 percent, food- 30 percent, gift shop -5 percent and other-5 percent, what is the revised CMR