how to review different scenarios in one screen

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to set up three different scenarios with same columns and rows for
Low, Middle, High analysis. What's the smartest way for data input? Three
different files, or in same tab with three different line to indicate L, M, H?
 
Hi Holly,

Do you already have the Lows, middles and highs, or are you dependent on
Excel to determine these based on the range of values for each column or row?
Also, is this for reporting/charting purposes, or are you looking for a
cell/cells to return the low/mid/high analysis based on the data entered?

Jamie
 
I am going to let salesmen input their aggresive budget as high, moderate as
middle, conservative as low, but not all the lines will have three scenarios,
only the big volume customers and skus.

Then I will pick up the mix from these three scenarios into one budget,
which will have the mix of H/M/L, the goal is to review the total sales based
 
Hi,

The "Scenario Summary" sheet is added to the workbook when you define three
scenarios for same cell. Therefore, it is recommended that you have them in
same tab.

Challa Prabhu
 
Thank you.

I am new to scenarios. I have the data below, how to set up the scenario so
it will get me the total sales $ from 3 different scenarios with misc sales
$? Thanks.
Customer SKU Salesman Scenario Type Sales Price Sales Qty Sales $
AAA A111 Jack 1 - Low $5.00 1,000 $1,005
AAA A111 Jack 2 - Mid $5.50 1,000 $5,500
AAA A111 Jack 3 - High $5.50 1,500 $8,250
AAA A112 Bob 1 - Low $10.00 1,000 $10,000
AAA A112 Bob 2 - Mid $5.50 1,000 $5,500
AAA A112 Bob 3 - High $5.50 1,500 $8,250
BBB A113 Jack 4 - Misc $2.00 500 $1,000
 
Back
Top