The management of Madeira Manufacturing Company is considering the introduction of a new product. The xed 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. a. Develop a what-if spreadsheet model (Please explain how to do this In Excel)computing profit for this product in the basecase, worst-case, and best-case scenarios. b. Discuss why the simulation would be appropriate for this situation. Would simulation be a preferable approach to analyze this situation? Why or why not?

THANK YOU!!