Question: As the project manager for Rick's Coffee and Pastry Stores Inc (GCP) Morty Smith is to evaluate where he will open the next store. He

As the project manager for Rick's Coffee and Pastry Stores Inc (GCP) Morty Smith is to evaluate where he will open the next store. He has limited his choices to two location: A (Near Archer and 13th) and B (near Shands parking garage). Due to the amount of potential traffic and the expenses such as rent, insurance and labor each location has different estimates of operating parameters.

Location A Location B
Customers/Month Normal (10,000, 1,800) Normal (9,000, 700)
Purchases/Customer Uniform ($2.50, $7.00) Uniform ($2.50, $5.500)
Expenses/Month Tri ($10,000, $12,000, $17,000) Tri ($3,000, $4,000, $5,000)

Now create three forecast. One for Profit A, one for Profit B and one for Profit Difference A-B. What is the the average difference between the profit of A and the Profit of B (ie A-B). Run the model with 1000 trails and use the results to answer the questions after this one. Well, answer this question too, dont just skip it. But after you have answered this question go ahead and use the output to answer the remaining questions.

From you model what what is the probability that location A has greater profit than location B, Past a screen shot supporting (or showing) your answer.

For the profit Difference A-B go to the "View" and Click on "Percentiles" or on the "Statistics". Would the range of possible differences make us comfortable with simply using the mean?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!