Ask a question from expert
Business Data Analysis for Marriott Inn: Solving No-shows and ATM Queuing Issues
8 Pages2295 Words478 Views
Added on 2019-10-09
About This Document
This report discusses how Marriott Inn solved their no-shows and ATM queuing issues through business data analysis. It includes recommendations and key findings on the simulation of no-shows, overbooking, and ATM queuing system. The report also provides a detailed methodology on how the analysis was conducted. Subject: Business Data Analysis, Course Code: N/A, Course Name: N/A, College/University: N/A
Business Data Analysis for Marriott Inn: Solving No-shows and ATM Queuing Issues
Added on 2019-10-09
BookmarkShareRelated Documents
Executive SummaryObjective: The Marriott inn has awesome notoriety and superb qualities, yet there are a few issues. For instance, they are confronting no-shows clients who reserve a spot and afterward never appear. In this report, the proficient way with regards to this matter will be proposed taking into account business insights. Additionally, the inn's VP has a worry that amid occupied periods numerous clients may need to hold up to utilize the ATM in the lodging. As indicated by the inn's administration rule, the normal client holding up time ought to be one moment or less for an ATM and this issue will be dealt with. With regards to undertaking 1, it appears that keeping its two rooms overbooked is prudent. In assignment 2, the likelihood that a client will need to sit tight for an administration is 0.5. Likewise, the likelihood that client need to sit tight for over one moment for taking administration of ATM is 0.98. In this circumstance, the lodging's VP's rules can't be met. Accordingly, Managers can settle on choices effectively by utilizing this valuable device like recreation and it ought to be known broadly.Table of Content1 | P a g e
Introduction..........................................................................................................................42 Methodology.....................................................................................................................5 2.1 Task 1.........................................................................................................................5 a..................................................................................................................................6 b.................................................................................................................................6 2.1.1 Recommendation ............................................................................................7 2.2 Task 2.......................................................................................................................7 a................................................................................................................................7 b .............................................................................................................................8 c...............................................................................................................................8 2.2.1 Recommendation............................................................................................83 Key findings .....................................................................................................................84 Appendix...........................................................................................................................9 BUISNESS DATA ANALYSIS 2 | P a g e
1.IntroductionJ. Willard Marriot opened the nine stool beer stand evolved about into hot shopper’s restaurant chain. For the next couple of decades he expanded his firms into emerging restaurant chain in the world having numerous no of properties all over theworld. He was also keen serving the customer first and pursuing excellence and embracing the change, acting with integrity and serving the world and be a part of the Marriott history and culture. Despite all this reputation there where some problems in the finance department in a scenario where there is no shows when there is costumer is not showing up, so this was issue was attracted by their management. So they asked the finance department look into this problem. The finance department started collect data and records of customer reservations and came up with a no of shows destitution table. To reduce the no of vacant room they decide to add three rooms for the reservation but then they were cases in which some costumer couldn’t get the room because of the full reservations and sometimes they were less reservations. In this case the hotel have to send the costumer to nearby competitive hotel next to the street which they need to spend $125. If the case is opposite and they have vacant rooms in the hotel then they goingto lose $50 per room. For the above situation we need to simulate the average monthly loss due to the over booking and need to replicate the average monthly cost200 times.In the lobby of the Marriott hotel there is an automated teller machine (ATM) in the busy times the costumer have to wait for using the machine in which it tend to be queuing. This led the hotel management to study about the ATM queuing system. The hotel vice president wants determine whether one ATM will be sufficient for the all customers. The hotel established the serving time for the customer should be lessthan one minute or less. One probabilistic input in the ATM simulation find the arrival times of the customer who using the ATM. In queuing simulation is determined by the randomly generating the time between two successive arrivals, referred to as theinterval time. The customer inter arrival times is be uniformly distributed between 0 and 5 minutes. Another probabilistic input is the ATM simulation is the service time, which is the time the customer using the ATM machine. From the past data from ATM indicates the mean of 2 minutes and standard deviation of 0.5. For the above situation we need to design the excel sheet to operate the simulation of the ATM system for 1000 customers. What is the waiting time of the customer for the service?Critically analyse the average waiting time of the customer using the ATM and the probability that he have to wait more than a minute.2Methodology3 | P a g e
End of preview
Want to access all the pages? Upload your documents or become a member.