Read Section 14.1 in the textbook with specific focus on the Sanotronics Model in Figure 14.9. you need the "SanotronicsModel.xlsx" file, which is provided as a part of our textbook.To obtain this file, refer to the 'Student Resources for "Essentials of Business Analytics, 2nd Edition" textbook' information in this Module's content area.

Specifically for this problem, perform the following (be sure to not alter any other cells in the file):

1. Change "Administrative & Advertising Cost" value to $500,000.Repeatedly press function key F9 to generate new random numbers.What happens to the Profit Distribution?Specifically explain the reason for the change.
2. Change the "Administrative & Advertising Cost" value back to $1,000,000.Change the Lower Bound value of the Parts Cost to $50.Change the Upper Bound value of the Parts Cost to $170.Repeatedly press function key F9 to generate new random numbers.What happens to the Profit Distribution?Specifically explain the reason for the change.
3. Change the Lower Bound value of the Parts Cost back to $80.Change the Upper Bound value of the Parts Cost to $100.Change the Standard Deviation value of the Demand to 1,000.Repeatedly press function key F9 to generate new random numbers.What happens to the Profit Distribution?Specifically explain the reason for the change.
4. Change the Standard Deviation value of the Demand back to 4,500.Change the Selling Price per Unit to $190.Repeatedly press function key F9 to generate new random numbers.What happens to the Profit Distribution?Specifically explain the reason for the change.