(A) Use a simulation model to help the institute decide how many violins they must reserve with the instrument company. Consider five different possible reservation quantities: 400, 500, 600, 700, 800. Which of these quantities yields the highest total revenue, net of instrument costs?
(B) Which simulation yields the largest median total revenue?
(C) Which simulation has the most risk as measured by spread or dispersion in the data? Please state clearly what statistic you used to answer this question.
(D) Are there any simulations in which there is at least a 1 in 20 (i.e., 5%) chance of getting a negative total revenue? Briefly explain in one sentence.
(E) For each simulation, what is the probability of exceeding $175,000 in total revenue (approximate these numbers as closely as possible from the data given in the above table). Please put your answer in the following table: (F) Considering your answers for (A) through (E), please state how many instruments you think should be reserved in advance and explain why.
(G) Suppose the institute is able to negotiate with the instrument company to reduce the cost for a violin from $500 to $350. Re-run the simulation model using the same reservation quantities (but with $350 for the unused instrument cost). Has the reservation quantity that yields the highest average revenue changed? If so, please explain why this has occurred.
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q29: A correlation matrix must always have 1's
Q30: Data tables in spreadsheet simulations are useful
Q31: A common guideline in constructing confidence intervals
Q36: Different random numbers generated by the computer
Q39: Correlation between two random input variables might
Q55: Many companies have used simulation to determine
Q77: (A) What are the appropriate probability distributions
Q78: Suppose you run a simulation model several
Q80: Suppose you are going to invest equal
Q82: An oil company is trying to determine
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents