Fill This Form To Receive Instant Help
Homework answers / question archive / New Perspectives Excel 2016 | Module 10: SAM Project 1b Cortona Coffee Makers WHAT-IF ANALYSES AND SCENARIOS GETTING STARTED Open the file NP_EX16_10b_FirstLastName_1
New Perspectives Excel 2016 | Module 10: SAM Project 1b
Cortona Coffee Makers
WHAT-IF ANALYSES AND SCENARIOS
PROJECT STEPS
Switch to the Single Cup worksheet. Perform a break-even analysis for single cup coffee makers as follows:
Table 1: Automatic Drip Coffee Maker Scenario Values
Values |
Scenario 1 |
Scenario 2 |
Scenario Name |
Standard |
Stainless_Steel |
Auto_Drip_Variable_Cost (B11) |
52.00 |
65.50 |
Auto_Drip_Fixed_Cost (B14) |
260000 |
360000 |
Your workbook should look like the Final Figures below. 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: Single Cup Worksheet
Final Figure 2: Automatic Drip Worksheet
Final Figure 3: French Press Worksheet
Final Figure 4: Suppliers Worksheet
Final Figure 5: Scenario Summary Worksheet
Final Figure 6: Scenario PivotTable Worksheet
Final Figure 7: All Products Worksheet
Already member? Sign In