Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Help With Solver Please

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
helen wheels - 28 Mar 2008 19:04 GMT
I want to use Solver to solve the following problem, but I can’t work
out how and its driving me crazy.

I have to organise a prize giving dinner so I know I need to work out
my expenses and make sure I cover those.

I have to break even with 200 ticket sales, but I can sell a maximum
of 300 tickets.

Non members pay full ticket price and member pay 75% of the ticket
price.

Can someone explain to me how I can set the ticket price using solver?

Thank you.

LJK
OssieMac - 29 Mar 2008 05:33 GMT
You need to know the proportion of members to non members or it is not
solvable.

See the following examples. Shows that the price changes significantly with
the proportion of members to non members.

Category           Number    Ticket price       Break even amount
non members      200           $20.00          $4,000.00
           
           
non members      100            $22.85          $2,285.00
members            100            $17.15          $1,715.00
                                                              $4,000.00
           
non members        50             $24.65          $1,232.50
members             150               $18.45          $2,767.50
                                                               $4,000.00


Signature

Regards,

OssieMac

> I want to use Solver to solve the following problem, but I can’t work
> out how and its driving me crazy.
[quoted text clipped - 13 lines]
>
> LJK
 
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.