I have no clue how to do this problem! I missed the last class!

A . B C DE F G 1 E5.9 Compute break-even point in sales units and in sales dollars 2 3 The Palmer Acres Inn is trying to determine its break-even point during its off-peak 4 season. The inn has 50 rooms that it rents at $60 a night. Operating costs are as 5 follows. 6 Salaries $ 5,900 per month 7 Property tax 1,100 per month 8 Depreciation (straight-line) 1,000 per month 9 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) 15 sales dollars. 16 17 NOTE: Enter a formula, a cell reference, or a value (if you are unable to reference 18 a cell), into the yellow shaded input cells. 19 20 21 2 a. Contribution margin per room 3 Rent per room 4 Variable cost per room 5 Contribution margin per room 6 7 8 Contribution margin ratio 9 Contribution margin per room -0 Rent per room :1 Contribution margin ratio 32 33 Fixed costs 34 35 Break-even point in rooms 36 Fixed costs 37 Contribution margin per room 38 Break-even point in rooms 39 10 41 b. Break-even point in dollars 12 Break-even point in rooms Rent per room Break-even point in dollars 45 46 OR 47 Fixed costs 48 Contribution margin ratio 49 Break-even point in dollars 43