If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

scenarios

Thread starter tamg
Start date Apr 28, 2011
Tags

multiple variables scenario solver

tamg

New Member

Apr 28, 2011

Hi all- I am wasting time on this when I know there is a better way. Trying to analyze various scenarios- two customers we make sales (max capacity to make sales is 3.5 million TOTAL) and recognize net profits at two different percentages (constraints for both go from 0-10%)) One customer has no rebate, the other has a rebate varying anywhere from 2-25%. I am trying to demonstrate various scenarios that would show what sales mix/ profit amounts/ rebates are in their best interest- example- take customer a at 1 million in sales at 10% profit, customer b at 2.5 in sales at 10% profit 15% rebate.....what other scenario (any of the 5 variables changing) might equal this? I've tried scenarios, solver, goal seek, manual....at my wits end...can someone advise? I am not the best- dont' do macros etc- but can hold my own. Thanks for any advice.