AutoSave Ou R File Home y u Page Layout Excel TemplateAssignment Ch06 (1) Excel Formulas Data Review View Help Search DYMO Label QuickBooks Insert X V f E6-1 Compute break-even point and margin of safety AA B C D E F 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 Mald service 8 per room Other costs 34 per room 10 11 Instructions 12 (a) Determine the inn's break-even point in (1) number of rented rooms per month and 13 (2) dollars. 14(b) 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(a) Determine the inn's break-even point in (1) number of rented rooms per month and (2) dollars (a)(1) Break-even point in rooms Rental per room Variable cost per room Contribution margin per room Value Value Fixed costs Contribution margin per room Break-even point in rooms Value Value [6-1 E6- 3 E6-17 CD-6 | Type here to search AutoSave OD File Home Search DYMO Label QuickBooks B61 A 2 C E xcel TemplateAssignment_C06 (1) Excel Insert Page Layout Formulas Data Review View Help X C D E Break-even point in dollars .I B (a)(2) A 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 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 (b)(2) Margin of safety ratio Margin of safety in dollars Actual sales Margin of safety ratio 65 1. Assume that the rental rate per room changed to $65 per night. Recalculate break-even point E6-1 E6-3 E6-17 CD-61 Ready Type here to search @element Excel TemplateAssignment_Ch06 (1) - Excel Search AutoSave the Home Insert Page Layout Formulas Data Review View HelpDYMO Label QuickBooks A B Value Value C D E 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 (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) Value Value Margin of safety in dollars Actual sales Break-even Sales Margin of safety in dollars TRA Margin of safety ratio Margin of safety in dollars Actual sales Margin of safety ratio (b)(2) Value Val Va - 72. 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 inte 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-1 6-3 6-7 CD-6 Ready Type here to search e