361 4 1 E6-1 Compute break even point and margin of safety 2. The Soma Inn is trying to determine its break-even point. The inn has 75 rooms that are rented at $60 3 a night. Operating costs are as follows. Salaries $10,600 per month Utilities 2,400 per month Depreciation 1,500 per month Maintenance 800 per month Maid service & per room Other costs 34 per room 11 Instructions 12 (6) Determine the inn's break even point in (1) number of rented rooms per month and 13 (2) dollars. 14 (6) If the inn plans on renting an average of 50 rooms per day (assuming a 30-day month), 15 what is (1) the monthly margin of safety in dollars and (2) the margin of safety ratio? 16 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 20|(0 Determine the inn's break-even point in (1) number of rented rooms per month and (2) dollars (a(0) Break.even point in rooms Rental per room Variable cost per room Contribution margin per room Value Value 2 Fixed costs Contribution margin per room Break-even point in rooms Valle Value 2 16-1 6-3 61706 Ready Search AutoSave O File Home R 2 Insert Excel TemplateAssignment_CH06 (1) Excel Formulas Data Review View Help Page Layout DYMO Label QuickBooks 361 X f ABCD (a)(2) Break-even point in dollars Contribution margin per room Rental per room Contribution margin ratio Value Value ? Value Value ? Break-even point in rooms Rental per room Break-even point in dollars OR Fixed cost contribution margin ratio Break-even point in dollars Value Value ? 49 (b) If the If the inn plans on renting an average of 50 rooms per day (assuming a 30-day month), what is (1) the monthly margin of safety in dollars and (2) the margin of safety ratio? (b)(1) Margin of safety in dollars Actual sales Value Break-even Sales Margin of safety in dollars Value (b)(2) Margin of safety ratio Margin of safety in dollars Actual sales Margin of safety ratio Value 651. C Assume that the rental rate per room changed to $65 per night. Recalculator E6-1 6- 36 17 Fler Data Review View File Home Insert Page Layout Formulas B61 . X V fi CDE Contribution margin ratio Value Value Break-even point in rooms Rental per room Break-even point in dollars OR Fixed cost contribution margin ratio Break-even point in dollars Value 49(b) If the inn plans on renting an average of 50 rooms per day (assuming a 30-day month), what is (1) the monthly margin of safety in dollars and (2) the margin of safety ratio? (b)(1) Margin of safety in dollars Actual sales Break-even Sales Margin of safety in dollars Value Value (b)(2) Value Margin of safety ratio Margin of safety in dollars Actual sales Margin of safety ratio Value 1 Assume that the rental rate per room changed to $65 per night. Recalculate break-even point In units and dollars. Round CM ratio to one decimal point. If the Inn plans to rent 60 rooms average per day at the new rate of $65 per night, recalculate the margin of safety in dollars and the margin of safety ratio. E6- 156- 3 86-17 CD-6 Ready Type here to search O