Question

In: Statistics and Probability

Simulation Case Study: Phoenix Boutique Hotel Group Phoenix Boutique Hotel Group (PBHG) was founded in 2007...

Simulation Case Study:
Phoenix Boutique Hotel Group

Phoenix Boutique Hotel Group (PBHG) was founded in 2007 by Bree Bristowe. Having worked for several luxury resorts, Bristowe decided to pursue her dream of owning and operating a boutique hotel. Her hotel, which she called PHX, was located in an area that included several high-end resorts and business hotels. PHX filled a niche market for “modern travelers looking for excellent service and contemporary design without the frills.” Since opening PHX, Bristowe has invested, purchased, or renovated three other small hotels in the Phoenix metropolitan area: Canyon Inn PHX, PHX B&B, and The PHX Bungalows.

One of the customer service enhancements Bristowe has implemented is a centralized, toll-free reservation system. Although many customers book specific hotels online, the phone reservation system enables PBHG to find the best reservation match at all properties. It has been an excellent option for those customers who have preferences regarding the type of room, amenity options, and the best price across the four hotel locations.

Currently, three agents are on staff for the 6 a.m. to 2 p.m. call shift. The time between calls during this shift is represented in Table 1. The time to process reservation requests during this shift is in Table 2.

Table 1: Incoming Call Distribution

Time Between Calls (Minutes)

Probability

1

0.13

2

0.23

3

0.27

4

0.19

5

0.15

6

0.09

Table 2: Service Time Distribution

Time to Process Customer Inquiries (Minutes)

Probability

1

0.19

2

0.17

3

0.16

4

0.15

5

0.11

6

0.08

7

0.03

Bristowe wants to ensure customers are not on hold for longer than 2 minutes. She is debating hiring additional staff for this shift based on the available data. Additionally, Bristowe and PBHG will soon be featured in a national travel magazine with a circulation of over a million subscriptions. Bristowe is worried that the current operators may not be able to handle the increase in reservations. The projected increase for call distribution is represented in Table 3.

Table 3: Incoming Call Distribution

Time Between Calls (Minutes)

Probability

1

0.26

2

0.27

3

0.24

4

0.14

5

0.11

6

0.06

Bristowe has asked for your advice in evaluating the current phone reservation system. Create a simulation model to investigate her concerns. Make recommendations about the reservation agents.

Arrival Interval Distribution

Random Number Lower Limit

Range Upper Limit

Arrival Gap Minute

Probability

0.13

0

10

1

0.23

11

31

2

0.27

32

53

3

0.19

54

73

4

0.15

74

89

5

0.09

90

99

6

Service Time Distribution

Random Number Lower Limit

Range Upper Limit

Service Time (minutes)

Probability

0.19

0

19

1

0.17

20

38

2

0.16

39

56

3

0.15

57

73

4

0.11

74

86

5

0.08

87

96

6

0.03

97

99

7

Customer Number

Random Number

Arrival Gap

Random Number

Service Time

Arrive Time

Service Start

Service End

Time in System

Time on Hold

Time Server Idle

Percent Utilization

Summary for This Trial Run Average:

maximums

1

1

19

2

49

13

3

96

28

4

60

78

5

19

61

6

9

55

7

83

60

8

94

25

9

28

15

10

48

47

11

7

84

12

76

52

13

39

74

14

2

7

15

73

8

Solutions

Expert Solution


Related Solutions

CASE STUDY /big 4 Consultants has been appointed by a leading group in hotel industry to...
CASE STUDY /big 4 Consultants has been appointed by a leading group in hotel industry to prepare feasibility report for opening a five-star hotel in Ras al Khaima. The group had been most successful one in the hotel industry and had always kept its eyes open for new opportunities. In view of the very fast industrial growth in the city of Ras al Khaima, the city had attracted the attention of the group. It is historically known as Julfar, is...
Sitcom Technology Case Case Study: Cost Concept and Cost Sheet Sitcom Technology was founded by two...
Sitcom Technology Case Case Study: Cost Concept and Cost Sheet Sitcom Technology was founded by two IIT graduates Rehan and Nixit in the year 2016 with the objective of providing IT solutions to various companies. They launched their FinTech start-up after getting funded Rs 25,00,000 by Business Ventures, one of the FinTech Angel investors. This was in the form of a loan at a 12% rate of interest. Rehan utilized his unused two bedrooms flat in Bannerghatta, Karnataka worth Rs...
Phoenix Airways Inc. is an airline company headquartered in Hong Kong. It was founded in 2010...
Phoenix Airways Inc. is an airline company headquartered in Hong Kong. It was founded in 2010 and currently provides passenger and cargo services to more than 50 regional and international destinations. The passenger service is operated by Phoenix Airways under the brand name of “Phoenix” while the cargo service is provided by its wholly owned subsidiary, Phoenix Cargo. The airline operates a fleet consisting of Boeing 737, Airbus 320, Airbus A330, and Airbus A350 aircrafts. In September 2016, the airline...
Case Study Deutche Bank Deutsche Bank was founded in Berlin in 1870 as a specialist bank...
Case Study Deutche Bank Deutsche Bank was founded in Berlin in 1870 as a specialist bank for foreign trade by Georg Siemens and L. Bambeger.  During the early years  major projects included the. Northern Pacific Railroad in the US and the Baghdad Railroad in Iraq.  During WWI the Deutsche Bank lost most of its foreign assets and had to sell of many holdings.  At the same time, however the bank helped to establishment of the film production company, UFA, and the merger of Daimler...
You are the manager of a luxury boutique hotel. You are presented the following facts: Johnny...
You are the manager of a luxury boutique hotel. You are presented the following facts: Johnny Rose was a guest at the Creek Motel which was famous for it’s Sunday brunch. After filling his plate with mountains of eggs and French toast, Johnny turned to return to his table and so excited at the prospect of eating, tripped over the dessert cart. The dessert cart was located at the end of the buffet line, right next to the three-meat buffet....
In an initial simulation, a small population of six snails (out of 85) founded a new...
In an initial simulation, a small population of six snails (out of 85) founded a new population. Suppose 50 snails from the original site. (rather than six). Assuming these 50 snails survived and reproduced on the new island, what effect would the larger sample size have on the result? Could you predict any shifts in the gene pool due to random genetic drift? Now consider the two populations of snails living on a single island. Is it at all plausible...
Case study Hotel owners and operators recognize that while we are currently living in a world...
Case study Hotel owners and operators recognize that while we are currently living in a world of scant lodging demand, talk of reopening the country is the necessary precursor to a recovery in travel and the need for hotel accommodations. Just like cities and states need to plan, closed hotels must plan the "how" and "when" of their reopening. As in any business decision, the costs and benefits of remaining closed versus resuming operations must be weighed. During a time...
Marketing assignment The Inn at Prescott Ranch is a small, boutique hotel located in Prescott, Arizona....
Marketing assignment The Inn at Prescott Ranch is a small, boutique hotel located in Prescott, Arizona. It opened in 1998. The Inn has identified the main competition as the Prescott Resort, owned and operated by the Yavapai Nation, and the Hassayampa Inn, a historic hotel in downtown Prescott, adjacent to Whiskey Row. The Inn has 65 rooms on two floors—each with a private balcony. The nightly room rates are the highest in Prescott. The Inn offers a full array of...
from this case study "the 2007-2009 Financial Crisis" , whats the role of derivative securities, government,...
from this case study "the 2007-2009 Financial Crisis" , whats the role of derivative securities, government, politicians played in increasing indebtedness of households?
CASE STUDY: The Nepalese Himalayas, A Protected Ecosystem? In May of 2007 some 43 expeditions totalling...
CASE STUDY: The Nepalese Himalayas, A Protected Ecosystem? In May of 2007 some 43 expeditions totalling 470 climbers summitted Mount Everest from both the Nepalese and Tibetan sides of the mountain. At one stage over 60 climbers were on or near the summit waiting (in some cases up to 1–2 hours) in order to get their chance to stand on the highest point in the world. If those 470 climbers had been asked why they chose to climb Mt Everest,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT