You are the analyst at the Teagarden Resort hired to improve its scheduling. You are tasked to help the resort with staffing the correct number of labor hours for housekeeping and front office. You analyzed two years' worth of weekly historical labor hours and occupied rooms over the same time period. Information The total labor hours over the prior two years is 25,000 for housekeeping and 10,000 for the front office. The total number of occupied rooms over the prior two years is 20,000 rooms. The Revenue Manager of the Teagarden Resort has forecasted 150, 200, 225, and 175 rooms sold in the upcoming weeks. The housekeeping stall earn on average $15 per hour and the front desk staff earn on average $17 per hour. The GM at Teagarden Resort had originally scheduled the housekeeping staff (to 200, 280, 350, and 200 total hours) and the front office (to 85, 110, 120, and 80 total hours). In the next four weeks, prior to using your recommended hours. Table 3. Revenue Forecast. Monday Tuesday 60 65 Rooms sold Rooms available Rooms revenue 100 100 Wednesday Thursday Friday Saturday Sunday 85 65 30 60 30 100 $6,000 $7,500 $8,500 100 100 100 100 $6,500 $3,000 $5,000 $3,000 Questions 1. Calculate the labor hours needed per room for the housekeeping and the front office staff at the Teagarden Resort. Hint: Hours needed per room sold = Hours per staff typel Rooms occupied 2. Calculate the recommended labor hours needed for the housekeeping and front office at the Teagarden Resort for the next four weeks. 3. Using your recommended labor hours calculated (2), determine the total hours saved compared to the GM's original staffing hours for both house- keeping and the front office staff over the next four weeks. 4. How much savings, in wages, for housekeeping and the front office does Teagarden Resort generate by going with your recommended staffing hours when compared to the GM's original labor hours?