We want the vaccine within 8 weeks. Is that likely to happen?
We want the vaccine within 8 weeks. Is that likely to happen?
Group of answer choices
yes
no
Flag question: Question 2
Question 25 pts
If someone asks you, what is the most likely number of batches it will take to produce enough of the vaccine, what would you tell them?
Group of answer choices
9
10
11
12
13
Flag question: Question 3
Question 315 pts
Upload your completed Drug Production workbook here. This is where i can assign some credit for your simulation even if you did not get all of the quiz questions correct.
Upload
Choose a File
Flag question: Spacer
Download the attached file and complete the model and simulation as stated in the file.
Answer the questions according to your completed model.
Flag question: Question 4
Question 43 pts
Which of the following is an uncertainty (random variable) in this model?
Group of answer choices
Production Cost
Coffee Shop Demand
Baking Quantity (in Batches)
Cost of Lost Profit
Flag question: Question 5
Question 53 pts
Which of the following is the decision variable in this model?
Group of answer choices
Coffee Shop Demand
Farmer’s Market Demand
Baking Quantity (in Batches)
There is no decision variable in this model
Flag question: Question 6
Question 63 pts
When does the Cost of Lost profits occur?
Group of answer choices
When the number of tarts produced exceeds the farmers market demand.
When the number of tarts produced exceeds the coffee shop demand.
When the number of tarts produced is less than the coffee shop demand.
When the number of tarts produced is less than the farmer’s market demand.
Flag question: Spacer
For the following 3 questions, make a copy of the worksheet on which you built your model. You will need to modify inputs to your model to test your calculations. Making a copy of your completed model will keep you from having to redo your work.
Flag question: Question 7
Question 75 pts
This question will require you to alter your model to test your calculations.
Set the Batches Produced to 70, set Farmers Market Demand at 1200, and set the Coffee Shop Demand to 100.
What is the cost of lost profits with these settings?
Flag question: Question 8
Question 85 pts
This question will require you to alter your model to test your calculations.
Set the Batches Produced to 70, set Farmers Market Demand at 1200, and set the Coffee Shop Demand to 100.
What is the Total Profit with these settings?
Flag question: Question 9
Question 95 pts
This question will require you to alter your model to test your calculations.
Set the Batches Produced to 110, set Farmers Market Demand at 1200, and set the Coffee Shop Demand to 100.
What is the Total Profit with these settings?
Flag question: Question 10
Question 1022 pts
Be sure that all random variables are restored to their original functions. (Pressing F9 should generate new results for all random variables in your model and data table.) Upload your completed model here.
Upload
Choose a File
Flag question: Spacer
Download the attached file and complete the model and simulation as stated in the file.
Answer the questions according to your completed model.
Flag question: Question 11
Question 112 pts
If you were to normalize the standard deviation (calculate the coefficient of variation) for the simulation results for each capacity level you were considering (300,000, 400,000, 500,000, 600,000, 700,000), which capacity level comes with the relative best average profit, and lowest standard deviation?
For this question, look at your average profit and a couple of the averages should stand out as the best options. Now, calculate the coefficient of variation, to determine which one has the lowest relative risk.
Group of answer choices
300,000
400,000
500,000
600,000
Flag question: Question 12
Question 122 pts
Let’s say the company decides they are looking for the capacity level that gives them the best chance to make $3.5 Billion dollars. Which of the capacity levels gives the highest likelihood of making $3.5 Billion for profit?
Group of answer choices
400,000
500,000
600,000
700,000
Flag question: Spacer
For the following 2 questions, make a copy of the worksheet on which you built your model. You will need to modify inputs to your model to test your calculations. Making a copy of your completed model will keep you from having to redo your work.
Question 135 pts
This question will require you to alter your model to test your calculations.
Set the Demand to 500,000 for each of the 5 years.
What is the Average Profit for the capacity level of 600,000 with these settings?
Flag question: Question 14
Question 145 pts
This question will require you to alter your model to test your calculations.
Set the Demand to 400,000 for each of the 5 years.
Which of the Capacity levels you are considering, shows a negative Average Profit?
Group of answer choices
400000
500000
600000
700000
Flag question: Question 15
Question 1515 pts
Be sure that all random variables are restored to their original functions. (Pressing F9 should generate new results for all random variables in your model and data table.) Upload your completed model here.
