Ravindra BagaleCourses & study guides मराठी Track your progress

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

Many students swap the Data Table input cells (a column's cell in the row input) and all the answers come out the same. If the values run down (a column), use the Column input cell; if they run across (a row), use the Row input cell. Check one or two answers manually.

Loading practice tasks...

  1. Total units (Easy): Add up Units in D2:D11. (sheet "Data")
  2. Total price list (Easy): Add up Price (£) in C2:C11. (sheet "Data")
  3. Max price (Easy): Largest Price (£) in C2:C11. (sheet "Data")
  4. Min unit cost (Easy): Smallest Unit cost (£) in E2:E11. (sheet "Data")
  5. Pune rows (Easy): How many rows have City "Pune"? (sheet "Data")
  6. London units (Medium): Total of Units where City is "London". (sheet "Data")
  7. Price over 10 (Medium): How many products have Price (£) > 10? (sheet "Data")
  8. Units of UrbanSip tea (Medium): Units for Product "UrbanSip tea". (sheet "Data")
  9. Mumbai cost (Medium): Unit cost (£) for City "Mumbai". (sheet "Data")
  10. Revenue proxy (Hard): SUMPRODUCT of Price (£) × Units. (sheet "Data")
  11. Avg units (Hard): Average of Units in D2:D11, rounded to 1 decimal. (sheet "Data")
  12. Above avg price? (Hard): "Premium" if C2 > average price else "OK". (sheet "Data")

See all practice tasks in the Task Hub →

Worked example — module 11 what if analysis

Why

Vikram Rao in Pune and Yuki Tanaka abroad both need a clear, repeatable way to use module 11 what if analysis on a BrightLedger Finance sheet without breaking totals.

What

Module 11 What If Analysis is the Excel idea this page teaches. We will walk one tiny example end to end.

How

  1. Open a blank sheet. In A1 type a short label for module 11 what if analysis.
  2. Enter a small made-up value for Vikram Rao using $ where money appears.
  3. Add a second value for Yuki Tanaka using € so you see mixed currencies stay numeric.
  4. Apply the method from this lesson step by step (menu or formula as shown above).
  5. Check the result still works inside SUM or a simple check cell.

Formula / action

Follow the formula or ribbon steps shown in this lesson (keep values numeric).
Result: The demo cell shows the expected result for BrightLedger Finance's sample row.
Meaning: Once module 11 what if analysis is correct on one row, copy the same pattern down the column.

Quick revision cards

Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.

Revision card 1: What is Module 11 What If Analysis?
Card 1: What is Module 11 What If Analysis? · Download PNG
Revision card 2: Tiny example — Module 11 What If Analysis
Card 2: Tiny example — Module 11 What If Analysis · Download PNG
Revision card 3: Checklist — Module 11 What If Analysis
Card 3: Checklist — Module 11 What If Analysis · Download PNG