Hi, I am playing with learning solver and using a test case that I found I
think on the MS Site



A company produces Radios, CD Players and Speakers. These products are made
from common parts: speaker cones, power supplies, electronics, laser parts
and amplifiers. Parts are in limited supply. Use Solver to determine what
mix of products to build to give the greatest sales revenue. The data for
this problem is as follows:




Parts in Stock
Number used in a Radio
Number used in a CD Player
Number used in Speakers

Speaker cone
450
1
0
2

Power supply
300
1
1
0

Electronics
500
1
1
2

Laser part
800
0
1
0

Amplifier
600
1
1
0







The sales price per item is:

Radio
CD Player
Speakers

£35.00
£50.00
£40.00



LARGE ORDERS DISCOUNT:

The sales price per item is reduced by 5% for orders of 100 or more and by
10% for orders of 200 or more. I am trying to use Solver to work out what
is the best combination of items to make, taking into account the limited
number of parts, to create the maximum sales revenue



My calculations say is should be 0,300,99 but Solver says 0,300,100.



Can anyone advise me why this is?



Thanks

A