Performing What-If Analysis
Week 4 Discussion Board – Performing What-If Analysis
Using the Internet, conduct a thorough search for more information on performing What-If Analysis in Excel. Choose one bullet listed below and explain and also include a reason to use in your worksheet for your bullet from the following:
Explore the principles of cost-volume-profit relationships
Create a one-variable data table
Create a two-variable data table
Create and apply different Excel scenarios with the Scenario Manager
Generate a scenario summary report
Generate a scenario PivotTable report
Explore the principles of a product mix
Run Solver to calculate optimal solutions
Create and apply constraints to a Solver model
Save and load a Solver model
Answer preview for Performing What-If Analysis
Access the full answer containing 290 words by clicking the below purchase button.