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) 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 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 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 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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 11, 2024

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

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):

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.
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.
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.
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.