The wedding date for a couple is quickly approaching,
and the wedding planner must provide the caterer an estimate of how
many people will attend the reception so that the appropriate
quantity of food is prepared for the buffet. The following table
contains information on the number of RSVP guests for the 145
invitations. Unfortunately, the number of guests does not always
correspond to the number of RSVPed guests.
Based on her experience, the wedding planner knows it is extremely
rare for guests to attend a wedding if they notified that
they will not be attending. Therefore, the wedding planner will
assume that no one from these 50 invitations will attend. The
wedding planner estimates that the each of the 25 guests planning
to come solo has a 75% chance of attending alone, a 20% chance of
not attending, and a 5% chance of bringing a companion. For each of
the 60 RSVPs who plan to bring a companion, there is a 90% chance
that she or he will attend with a companion, a 5% chance of
attending solo, and a 5% chance of not attending at all. For the 10
people who have not responded, the wedding planner assumes that
there is an 80% chance that each will not attend, a 15% chance each
will attend alone, and a 5% chance each will attend with a
companion.
RSVped Guests Number of
invitations
Assist the wedding planner by constructing a spreadsheet simulation model to determine the expected number of guests who will attend the reception. Round your answer to 2 decimal places.
To be accommodating hosts, the couple has instructed
the wedding planner to use the Monte Carlo simulation model to
determine X, the minimum number of guests for which the
caterer should prepare the meal, so that there is at least a 90%
chance that the actual attendance is less than or equal
to X. What is the best estimate for the value of X?
Round your answer to the neares whole number.
Solution:
a)
The expected number of attendees is 134.75
b)
Consider that X represents the best estimate for the value of guests.The calculation of probability to find the best estimate for the value of guests in Analytic Solver Platform is as shown below by considering that 140 is expected to be less tha 90%
Therefore,the probabilities of are as written below
Thus,141 guests would be a relatively safe number on which to base meal preparations
The wedding date for a couple is quickly approaching, and the wedding planner must provide the...
The wedding date for a couple is quickly approaching, and the wedding planner must provide the caterer an estimate of how many people will attend the reception so that the appropriate quantity of food is prepared for the buffet. The following table contains information on the number of RSVP guests for the 145 invitations. Unfortunately, the number of guests does not always correspond to the number of RSVPed guests. Based on her experience, the wedding planner knows it is extremely...
The wedding date for a couple is quickly approaching, and the wedding planner must provide the caterer an estimate of how many people will attend the reception so that the appropriate quantity of food is prepared for the buffet. The following table contains information on the number of RSVP guests for the 150 invitations. Unfortunately, the number of guests does not always correspond to the number of RSVPed guests. Based on her experience, the wedding planner knows it is extremely...
Looking for instructions The wedding date for a couple is quickly approaching, and the wedding planner must provide the caterer an estimate of how many people will attend the reception so that the appropriate quantity of food is prepared for the buffet. The following table contains information on the number of RSVP guests for the 140 invitations. Unfortunately, the number of guests does not always correspond to the number of RSVPed guests. Based on her experience, the wedding planner knows...
The wedding date for a couple is quickly approaching, and the wedding planner must provide the caterer an estimate of how many people will attend the reception so that the appropriate quantity of food is prepared for the buffet. The following table contains information on the number of RSVPs for the 145 invitations. Unfortunately, the number of guests does not always correspond to the number of RSVPs. Based on her experience, the wedding planner knows that it is extremely rare...
The wedding date for a couple is quickly approaching, and the wedding planner must provide the caterer an estimate of how many people will attend the reception so that the appropriate quantity of food is prepared for the buffet. The following table contains information on the number of RSVPāed guests for the 225 invitations. Based on her experience, the wedding planner knows it is extremely rare for guests to attend a wedding if they notified that they will not be...
The wedding date for a couple is quickly approaching, and the wedding planner must provide the caterer an estimate of how many people will attend the reception so that the appropriate quantity of food is prepared for the buffet. The following table contains information on the number of RSVP guests for the 120 invitations. Unfortunately, the number of guests does not always correspond to the number of RSVPed guests.Based on her experience, the wedding planner knows it is extremely rare...
Tony and Peggy Sue graduated from a university in Texas last May. She received a degree in elementary education, and he graduated from the culinary school. They both now work in the Dallas area. Peggy Sue is a teacher, and Tony is a chef at a resort hotel restaurant. It is Christmas Day and Tony asks Peggy Sue to marry him. She excitedly accepts. They set a wedding date of June 30. Tony is from New York City. He is...
How can we assess whether a project is a success or a failure? This case presents two phases of a large business transformation project involving the implementation of an ERP system with the aim of creating an integrated company. The case illustrates some of the challenges associated with integration. It also presents the obstacles facing companies that undertake projects involving large information technology projects. Bombardier and Its Environment Joseph-Armand Bombardier was 15 years old when he built his first snowmobile...