Question: 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
Number of Invitations . RSVP’ed Guests
50 ............. 0
50 ............. 1
100 ............. 2
25 ........ No response
a. Assist the wedding planner by constructing a simulation model to determine the expected number of guests who will attend the reception. Base your estimate on 1000 replications of the wedding reception.
b. To be accommodating hosts, the couple has instructed the wedding planner to use the 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. Base your estimate on 1000 replications of the wedding reception.
Step by Step Solution
3.32 Rating (167 Votes )
There are 3 Steps involved in it
The Excel worksheet for this problem is as follows Cell C27 contains the formula IFB27... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
272-M-S-Q-M (522).docx
120 KBs Word File
