 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Formula Problem
I have $700,000 to spend on advertising for three different products. My market share for the three products is 51.96%, 36.07% and 41.25%. I want to apportion my 700K between the three products so that the product with the lowest market share gets the most advertising dollars, etc. Using my data, I've been trying to devise a formula all night that would do this, but I'm stumped. I could use a hint... Here's one way of doing it - put 700,000 in A1 and put your 2 percentage shares in B1:B3 and then put this formula in C1: =A$1*(1-B1/SUM(B$1:B$3))/2 Format as currency and copy into C2:C3 to give you: $209,328.60 $252,347.60 $238,323.80 But, of course, there are other ways .. Hope this helps. Pete > I have $700,000 to spend on advertising for three different products. > [quoted text clipped - 8 lines] > > I could use a hint... What algorithm do you want to use to apportion the money with? Using the market share numbers seems inappropriate, as the markets will differ in size, so would you want to spend most of you budget on a product in a small market, just because you have a tiny share of that (small) market?  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > I have $700,000 to spend on advertising for three different products. > [quoted text clipped - 8 lines] > > I could use a hint... The markets are close in size. Region one is slightly biggerr than region two, and two is slightly bigger than three. One market doesn't dwarf the other. >What algorithm do you want to use to apportion the money with? > >Using the market share numbers seems inappropriate, as the markets will >differ in size, so would you want to spend most of you budget on a product >in a small market, just because you have a tiny share of that (small) >market? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.