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


"challa prabhu" wrote:

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

"Holly" wrote:

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?