(A)Use a Simulation Model to Help the Institute Decide How

question 7

Essay

(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.

---

Definitions:

Value-Added

The enhancement a company gives its product or service before offering the product to customers.

Non-Value-Added

Activities or processes that do not add value to a product or service from the customer's perspective, potentially leading to unnecessary costs.

Value-Added

The enhancement a company gives its product or service before offering the product to customers, which can differentiate a company in the market, increase product value, and command a higher price.

Design Engineering

The branch of engineering focused on the design, development, and testing of products, systems, or structures, ensuring they meet specified requirements.