Ravindra BagaleCourses & study guides

16. Practice Exercises with Answer Hints

16.10 Module 11: What-If Analysis

By Last updated:

  1. With Goal Seek, find the orders per day needed to break even in the Wakad model. Hint: Data › Forecast › What-If Analysis › Goal Seek; Set cell = Profit, To value 0 → about 507 orders/day.
  2. Create three scenarios (Normal, Ganeshotsav, Monsoon) and a summary report. Hint: Scenario Manager › Add › Summary.
  3. A one-variable data table of profit for AOV ₹300–₹450. Hint: What-If Analysis › Data Table › Column input cell = AOV cell.
  4. A two-variable data table: AOV × orders/day. Hint: formula in the top-left corner; Row and Column input cells.
  5. Use Solver to find the milk and fruit crates that maximise profit within the van capacity. Hint: File › Options › Add-ins › Solver Add-in; Data › Analyze › Solver → 35 milk + 25 fruit = ₹12,800.

Ravindra Bagale's Tip

Khup students Data Table che input cells ulat detat (row input madhe column cha cell) aani sagle uttar same yetat. Values khali (column) astil tar Column input cell, aadvi (row) astil tar Row input cell. Ek-don uttar manually check kara.