19.9Cowuleren The Palmer Acres Inn is trying to determine its break-even point during its ofl-peak season. The inn has 50 rooms that it rents at 560aight. Operating costs are as follows Salaries Utilities Depreciation Maintenance Maid Service Other costs 55.900 per month S1,100 per month $1,000 per month S100 per month $14 per room S28 per room Testions Determine the inn's break-even point in (a) number of rented rooms per month and {b) dollars NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "*". (a) Determine the inn's break-even point in number of rented rooms per month Value Contribution margin per room Rent per room Variable cost per room Maid Service Other Costs Total Variable Cost Contribution margin per room Value Valoe 2 Contribution margin ratio Contribution margin per room Rent per room Contribution margin ratio Value Value ? Fixed costs Salaries Utilities Depreciation Maintenance Total Fixed Costs Value Value Value Value Break-sven point in rooms Fixed costs Contribution margin per room Break-even point in rooms Value Value (b) Determine the inn's break-even point in dollars Break-sven point in dollars Break-even point in rooms Rent per room Break-even point in dollars Value Value 2 OR Fixed costs Contribution margin ratio Break-even point in dollars Value Value