Scenario Manager...Need Help

I was doing some research on how to create manager scenarios on excel and don't seem so hard to do it, now my problem is that I not really sure how to use the data that I was given. I'm attaching the Data sheet with the information and here is the question:


AYK25_Data_Version_1.xlsx

Profit Scenario

Murry Lutz owns a small shop, Lutz Motors, that sells and services vintage motorcycles.

Murry is curious how his profit will be affected by his sales over the next year.

Project Focus

Murry would like your help creating best, worst, and most-likely scenarios for his motorcycle

sales over the next year. Using Scenario Manager, help Murry analyze the information

in the data file

Thanks a lot

Homework?

http://office.microsoft.com/en-gb/ex...001111776.aspx

Alf

Originally Posted by Alf

Homework?

http://office.microsoft.com/en-gb/ex...001111776.aspx

Alf

Yes, is a school project and for some reason I'm having a really hard time figuring this out. I can't figure out how to use the data. What numbers I should use for the 3 scenarios.Don't know how to use the Tax Rate,the Interest Rate,Sales, Sales Growth, etc , etc. or out of all the data given which number I should be using.I'm really lost in this one, need help here.

Thanks

Originally Posted by habanero02

Yes, is a school project and for some reason I'm having a really hard time figuring this out. I can't figure out how to use the data. What numbers I should use for the 3 scenarios.Don't know how to use the Tax Rate,the Interest Rate,Sales, Sales Growth, etc , etc. or out of all the data given which number I should be using.I'm really lost in this one, need help here.

Thanks

Teethless mama don't do homework.