Fill This Form To Receive Instant Help
Homework answers / question archive / Illustrated Excel 2019 | Module 12: SAM Project 1a Tech Togs PERFORM WHAT-IF ANALYSES GETTING STARTED Open the file IL_EX19_12a_FirstLastName_1
Illustrated Excel 2019 | Module 12: SAM Project 1a
Tech Togs
PERFORM WHAT-IF ANALYSES
Table 1: Unit Sales Decrease 3% Scenario Values
Changing Cell |
Value |
Basel_Units_Sold (F12) |
8245 |
Geneva_Units_Sold (G12) |
7988 |
Lucerne_Units_Sold (H12) |
8119 |
Table 2: Solver Constraints
Requirement |
Cell Reference |
Comparison Operator |
Constraint |
The units produced must be integers. |
B11:D11 |
int |
integer |
Vendors must produce at least 3,500 units. |
B11:D11 |
>= |
B16 |
Gansu can produce a maximum of 8,000 units. |
Gansu_Units |
<= |
B17 |
Q Star can produce a maximum of 4,500 units. |
Q_Star_Units |
<= |
B18 |
El Nido can produce a maximum of 8,000 units. |
El_Nido_Units |
<= |
B19 |
Tech Togs requires 20,000 Zurich smart watches. |
Total_Units |
= |
B20 |
Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.
Final Figure 1: Scenario Summary Worksheet
Final Figure 2: Scenario PivotTable Worksheet
Final Figure 3: Expense Report Worksheet
Final Figure 4: Profit Analysis Worksheet
Final Figure 5: Sales Power Pivot Worksheet
Final Figure 6: Zurich Worksheet
Already member? Sign In