1 Sanotronics 249 1000000 Parameters 14 Selling Price per Unit 5 Administrative & Advertising Cost 6 Direct Labor Cost Per Unit 7 Parts Cost Per Unit 8 Demand 45 90 15000 Model 10 11 Profit 12 =((B4-B6-B7)*B8)-B5 1 Sanotronics 2 Parameters 4 Selling Price per Unit 5 Administrative & Advertising Cost 6 Direct Labor Cost Per Unit 7 Parts Cost Per Unit 8 | Demand $249.00 $1,000,000 $45.00 $90.00 15,000 Model 10 11 Profit $710,000.00 Suppose Samotronic's management team reevaluates the situation and determines alternative values for the random Variables. The new values for the random Variables are: Direct Labor cost per Unit = $42 to $48 Cinstead of $ 43-847) part Cost per Unit = $80 to $110 Cinstead of $80-$100) Demand = 0 to 40 000 Cinstead of o to 30000) Questimi : following to figurell. I excel worksheet example, Construct an Excel spreadsheet Simulation model and determine the profit for the worst-case Scenario. Put your answer on the Blackboard. Question 2 : Run the Excel spreadsheet Simulation model and determine the profit for the Best-case Scenario. Put your answer on the Blackboard Question 3 Simulation function for : Use the following excel the Demand. - NORM. INV (RAND(), 20000 ,5000) Run this demand Sinulation function and get the Simulated demand value. Repeat this five times (5 trials) and answer the following questions. put your answers on the Blackboard. Question 3 a: Maximum Sinulated demand Question 36: Minimum Sinulated demand Question 3c: Average simulated demand