Imagine that you are managing a hotel with 120 rooms. In order to track the occupancy rates you use 6 weeks trailing period. You just received information that 102 out of 120 rooms were occupied on Wednesday (10/16/13). Using updated information on the occupancy rates and the occupancy rates for the last 6 Wednesdays in Table 1, calculate the rolling average for Wednesdays. Table 1 Date Occupancy O 64% O 57% 82% O 61% 09/04/13 09/11/13 09/18/13 09/25/13 10/02/13 10/09/13 42.5% 55% 60% 45% 62.5% 77.5%

Imagine that you are managing a hotel with 120 rooms. In order to track the occupancy rates you use 6 weeks trailing period. You just received information that 102 out of 120 rooms were occupied on Wednesday (10/16/13). Using updated information on the occupancy rates and the occupancy rates for the last 6 Wednesdays in Table 1, calculate the rolling average for Wednesdays. Table 1 Date Occupancy O 64% O 57% 82% O 61% 09/04/13 09/11/13 09/18/13 09/25/13 10/02/13 10/09/13 42.5% 55% 60% 45% 62.5% 77.5%

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

40) Burger Cart April has a popular burger cart where an average of 12 customers per hour arrive to buy a burger. April can serve an average of 20 customers per hour. What is the average time a person spends waiting in line? Group of answer choices a) 16.0 minutes b) 2.25 minutes c) 3.0 minutes d) 12.0 minutes e) 7.0 minutes f) 4.5 minutes g) 9.0 minutes h) 1.2 minutes
20.6 114 A Northwest Airlines ticket counter forecasts that 200 people per hour will need to check in. It takes an average of two minutes to service a customer. Assume that interarrival times and service times are exponential and that all customers wait in a single line for the first available agent. a. If we want the average time a customer spends in line and in service to be 30 minutes or less, how many ticket agents should be on duty? b. If we want 95% of all customers to wait 45 minutes or less in line, how many ticket agents should be on duty?|
Q.11 An example of a leading performance measure is: a.Number of new customers b. Average response time for service call
Priority Average Arrival Rate (exponential interarrival times) High 3 per hour Low 5 per hour Number of servers: 5 Service rate: 2 per hour (exponential service times) What is the average time in line (in minutes) for a high priority item? Question 8 options: 2 5 24 35 54
Question 36 of 50 When is it a good idea to avoid using a template to write to a customer on social media? The customer is very emotional about a service failure. A problem is likely to generate a high volume of contacts. ○ You want to adopt a writing style that is unique to you. The customer needs detailed instructions to fix their issue.
6. Gursoy Car Wash will wash a car in exponential amount of time with mean 10 minutes. Arrivals occur as a Poisson process with rate 5 per hour. a) What is percent of the time the car wash is idle? b) On the average how many cars are in the system? c) On the average how many cars are waiting in line? d) On the average how long does a car spends in the system? e) What fraction of times there are more than 3 cars in the system? f) What is the probability that a car spends more than 30 minutes in the system?
Question 8.1 The computer lab at State University has a help desk to assist students working on computer spreadsheet assignments. The students patiently form a single line in front of the desk to wait for help. Students are served based on a first-come, first-served priority rule. Students arrive at the help desk at the rate of 4 every 10 minutes. The average service time is 2 minutes. The Poisson distribution is appropriate for the arrival rate and service times are exponentially distributed.
QUESTION 9 Describe the following: Push system System for moving work to the next station as it is completed System for moving work from a preceding station as needed Maintaining equipment in good condition Maintaining a workplace that is clean System of lights used at each workstation to signal problems or slowdowns QUESTION 10 Identify sources of waste (Waiting) Inefficient routing Excess inventory Poor layout design, unnecessary steps, inadequate training Order waiting to be processed, request for information awaiting answers Excess supplies and equipment QUESTION 11 Describe the following: Takt time purpose is to eliminate product defects by preventing, correcting, or drawing attention to human errors as they occur intelligent automation A highly coordinated processing system in which goods move through the system, and services…
One of the chair lifts at a ski resort unloads 1,900 skiers per hour at the top of the slope. The ride from the bottom to the top takes 19 minutes. Instruction: Do not round your intermediate and round final answer to nearest integer. How many skiers are riding on the lift at any given time? 603 skiers
Short question 4- Leo manages a receiving station for rice. Farmers deliver their loads of rice with a rate of 150 tons per hour from 6:00 am to 2:00 pm. Leo can process them at a rate of 100 tons an hour. The station has room to hold only 200 tons of rice in inventory prior to processing. Once this space is filled, the farmers’ trucks must wait to dump their contents. Leo is considering using seasonal workers to help him with the processing of rice loads. When the seasonal workers are working, the processing rate increases to 125 tons per hour. The seasonal workers would start working at 10:00 am and finish working when the trucks stop waiting. At what time, Leo will finish processing loads of rice using these seasonal workers?
state whether or not each situation would be considered “compensable time” (and why or why not). An employee of a fast food chain has to arrive at work 15 minutes early to change into the“mascot” costume and it typically takes another 15 minutes at the end of the shift to change outof the costume and properly store it. Due to the cost of the costume, employees are notallowed to take the costume home. The “mascots” typically work from 10am – 2pm, to coverthe lunch rush periods. How much time would be “compensable” for the mascots, assumingthe conditions/schedule listed above?2) George is a Radiology Technician at a local hospital and when on call, is required to be nofurther than 30 minutes away from the facility. Is the “on call” time, compensable?
Which of the following terms implies an increase in responsibility and control in the vertical direction? Question 10Answer A. job satisfaction B. job enlargement C. job enrichment D. job re-design E. job rotation