New Perspectives Excel 2016 | Module 10: SAM Project 1a
• Open the file NP_EX16_10a_FirstLastName_1.xlsx, available for download from the SAM website.
• Save the file as NP_EX16_10a_FirstLastName_2.xlsx by changing the “1” to a “2”.
o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• With the file NP_EX16_10a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
• This project requires you to use the Solver add-in. If this add-in is not available on the Data tab in the Analyze group (or if the Analyze group is not available), install Solver as follows:
o In Excel, click the File tab, and then click the Options button in the left navigation bar.
o Click the Add-Ins option in the left pane of the Excel Options dialog box.
o Click the Manage arrow, click the Excel Add-Ins option, and then click the Go button.
o In the Add-Ins dialog box, click the Solver Add-In check box and then click the OK button.
o Follow any remaining prompts to install Solver.
Values Scenario 1 Scenario 2
Scenario Name Standard Environmental
Noise_Cancelling_Variable_Cost (B11) 179.00 182.50
Noise_Cancelling_Fixed_Cost (B14) 300000 350000
Final Figure 1: Wireless Worksheet
Final Figure 2: Noise-Cancelling Worksheet
Final Figure 3: Earphones Worksheet
Final Figure 4: Earphone Suppliers Worksheet
Final Figure 5: Scenario Summary Worksheet
Final Figure 6: Scenario PivotTable Worksheet
Final Figure 7: All Products Worksheet