3.3 The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost to begin the production of the product is $30,000. The variable cost for the product is expected to be between $16 and $24, with a most likely value of $20 per unit. The product will sell for $50 per unit. Demand for the product is expected to range from 300 to 2,100 units, with 1,200 units the most likely.

Develop a what-if spreadsheet model (Please explain how to do this In Excel) computing profit for this product in the base-case, worst-case, and best-case scenarios.

Discuss why simulation would be appropriate for this situation. Would simulation be a preferable approach to analyze this situation? Why or why not?