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.

Prc 250 Parameters Selling Price per Unit Administrative & Advertising Cost Direct Labor Cost Per Unit Parts Cost Per Unit Demand $249.00 $1,000,000 $45.00 $85.22 7,322 200 150 Model Profit -$130,322.36 100 50 $80 $100 Direct Labor Cost Lower End of Interval 0.0 0.1 0.3 0.7 Upper End of Interval 0.1 0.3 0.7 0.9 Parts Cost (Uniform Distribution) Probability Lower Bound 0.1 Upper Bound 0.2 0.4 Demand (Normal Distribution) 0.2 Mean 0.1 Standard Deviation Cost per Unit $43 $44 $45 $46 $47 0 50 -$750,000 $1,000,000 -$250,000 15,000 4,500 -$500,000 $25 0.9 1.0 $1,500,000 -$1,250,000 Simulation Trial 1 2 Profit Summary Statistics Mean Standard Deviation Minimum Profit Maximum Profit P(Profit