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.
-
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
Similar threads
- Question
- Question
- Question
