1. The Go Down Inn has 1500 rooms. 2. Use the following format and data to construct your report. The general manager of the property estimates covers for walk-ins (non-hotel guests) as shown on the spreadsheet below. Go Down Inn A. Calculate the number of guests staying in hotel using percentage of occupancy provided. For simplicity, assume one person per room. B. Calculate the number of guests that will dine in hotel for each meal period. The general manager estimates that 38% of the hotel guests will eat breakfast in the hotel, 12% will eat lunch, and 36% will eat dinner. C. Write formulas to calculate total number of covers by adding the number of walk-ins to the number of hotel guests which will dine on the premises