Need Help, need the hold exercise and the additional quuestion.

A B E G 1 E5.9 Additional Question 2 3 The Palmer Acres Inn is trying to determine its break-even point during its off-peak season. The inn has 50 rooms that it rents at $60 a night. Operating costs are as follows. 4 5 7 8 9 Salaries $ 5,900 per month Property tax 1,100 per month Depreciation (straight-line) 1,000 per month Maintenance 100 per month 10 Maid service 14 per room 11 Other costs 28 per room 12 13 Instructions 14 Determine the inn's break-even point in (a) number of rented rooms per month and (b) sales 15 dollars. 16 17 NOTE: Enter a formula, a cell reference, or a value (if you are unable to reference a cell), Into 18 the yellow shaded input cells. 19 20 21 22 23 Additional Question 24 Assume that total fixed costs changed to $8,750 per month and the rental rate per room for a 25 night changed to $65. Show the impact of these changes have on the calculations. 26 27 28 29 + 30 a. 31 Contribution margin per room Rent per room Variable cost per room Contribution margin per room 32 33 34 35 36 37 38 Contribution margin ratio Contribution margin per room Rent per room Contribution margin ratio 39 40 Fiverrete P5.3 P5.3 Add Ques E5.9 E5.9 Add Ques + Ready