4. Betty Stout is the dining room manager at the Fairvicw hotel. Betty's restaurant is very...

  

Transcribed Image Text:

4. Betty Stout is the dining room manager at the Fairvicw hotel. Betty's restaurant is very busy when the 520-room hotel housing her restaurant experiences high levels of occupancy, but it is slower when the hotel's occupancy is reduccd. From past history, Betty knows that scervice in her dining room is best when she schedules one scrver for every 50 rooms occupied. Thus, for example, on a Friday night when the hotel sells 380 rooms, Betty must schedule eight servers for Saturday morning (380 rooms sold/50 scrvers per room = 7.6 servers). Each server scheduled by Betty will work a 6-hour shift and they are paid $17.00 per hour. Betty has just reccived next week's occupancy forecast from the hotel's director of sales (DOS). Help Betty complete her breakfast staffing worksheet to determine how many breakfast servers she must schedule cach day next week, and then answer the questions that follow. Betty's Breakfast Server Worksheet Number of Number of Server Cost Day of Week Rooms Occupancy Forecast (%) Servers per Forecast Servers Server Cost ($) per Occupied Room ($) Date Available Scheduled 20-Oct Sunday 520 35.5 21-Oct Monday 520 60.0 22-Oct Tuesday 520 62.5 23-Oct Wednesday 520 68.0 24-Oct Thursday 520 86.5 25-Oct Friday 520 95.0 26-Oct Saturday 520 91.5 27-Oct Sunday 520 N/A Total (Spreadsheet hint: Use the ROUNDUP function for Number of Servers Scheduled.) a. On what day(s) will Betty schedule the fewest number of breakfast servers? b. On what day(s) will Betty schedule the greatest number of breakfast servers? c. On what day(s) will Betty's total cost of breakfast server staff be lowest? d. On what day(s) will Betty's total cost of breakfast server staff be highest? e. What will be Betty's estimated total breakfast server cexpense for the week? f. On what day will Betty's server cost per occupied room be lowest? g. On what day will Betty's server cost per occupied room be highest? h. Why is your answer to question (f different from your answer to question (g) above? i. Can Betty sum the seven individual days "server cost per occupied room" then divide by seven to get her average server cost per occupied room (CPOR) for the week? Why or why not? 4. Betty Stout is the dining room manager at the Fairvicw hotel. Betty's restaurant is very busy when the 520-room hotel housing her restaurant experiences high levels of occupancy, but it is slower when the hotel's occupancy is reduccd. From past history, Betty knows that scervice in her dining room is best when she schedules one scrver for every 50 rooms occupied. Thus, for example, on a Friday night when the hotel sells 380 rooms, Betty must schedule eight servers for Saturday morning (380 rooms sold/50 scrvers per room = 7.6 servers). Each server scheduled by Betty will work a 6-hour shift and they are paid $17.00 per hour. Betty has just reccived next week's occupancy forecast from the hotel's director of sales (DOS). Help Betty complete her breakfast staffing worksheet to determine how many breakfast servers she must schedule cach day next week, and then answer the questions that follow. Betty's Breakfast Server Worksheet Number of Number of Server Cost Day of Week Rooms Occupancy Forecast (%) Servers per Forecast Servers Server Cost ($) per Occupied Room ($) Date Available Scheduled 20-Oct Sunday 520 35.5 21-Oct Monday 520 60.0 22-Oct Tuesday 520 62.5 23-Oct Wednesday 520 68.0 24-Oct Thursday 520 86.5 25-Oct Friday 520 95.0 26-Oct Saturday 520 91.5 27-Oct Sunday 520 N/A Total (Spreadsheet hint: Use the ROUNDUP function for Number of Servers Scheduled.) a. On what day(s) will Betty schedule the fewest number of breakfast servers? b. On what day(s) will Betty schedule the greatest number of breakfast servers? c. On what day(s) will Betty's total cost of breakfast server staff be lowest? d. On what day(s) will Betty's total cost of breakfast server staff be highest? e. What will be Betty's estimated total breakfast server cexpense for the week? f. On what day will Betty's server cost per occupied room be lowest? g. On what day will Betty's server cost per occupied room be highest? h. Why is your answer to question (f different from your answer to question (g) above? i. Can Betty sum the seven individual days "server cost per occupied room" then divide by seven to get her average server cost per occupied room (CPOR) for the week? Why or why not?

Answer rating: 100% (QA)

a On Sunday Betty will schedule the fewest number of breakfast services b On Friday B... View the full answer