Essentials of Business Analytics 1st Edition by Jeffrey Camm,James Cochran,Michael Fry,Jeffrey Ohlmann ,David Anderson

Exercise 8

Using Analytic Solver Platform, develop a simulation model for the Sanotronics problem that was presented in Section 11.2 using native Excel functionality.
a. Obtain estimates for the mean profit, maximum profit, minimum profit, and standard deviation of profit.
b. What is your estimate of the probability of a loss