The Manager of a Company Decides to Arrange a Party

question 13

Essay

The manager of a company decides to arrange a party for being promoted and has invited 50 guests for dinner. The following table contains information on the number of RSVP'ed guests. He assumes that 12 people will not turn up. He also estimates that 13 guests planning to come solo has a 65 percent chance of attending alone, a 30 percent chance of not attending, and a 5 percent chance of bringing a companion. For each of the 20 guests who plan to bring a companion, there is a 75 percent chance that she or he will attend with a companion, a 10 percent chance of attending solo, and a 15 percent chance of not attending at all. For the 5 people who have not responded, the wedding planner assumes that there is an 85 percent chance that each will not attend, a 10 percent chance they will attend alone, and a 5 percent chance they will attend with a companion.
a. Assist the manager by constructing a spreadsheet simulation model to determine the expected number of guests who will attend the party.
b. Use the Monte Carlo simulation model to determine X, the minimum number of guests for whom the dinner needs to be ordered, so that there is at least a 95 percent chance that the actual attendance is less than or equal to X. What is the best estimate for the value of X?

---

Definitions:

Southern Ohio

A region in the United States characterized by its geographical location within the state of Ohio, often noting its distinct cultural and historical features.

New England Settlers

Refers to the early colonists and immigrants who established the first English colonies in the northeastern part of what is now the United States.

Cotton Gin

A machine invented by Eli Whitney in 1793 that quickly and efficiently removed seeds from cotton fibers, significantly impacting the agricultural economy of the United States.

Inventor

An individual who creates or discovers a new method, form, device, or other useful means that becomes known for the first time.