A customer at a 7-11 store selected four items to buy, and was told that the cost was $7.11. He was curious that the cost was the same as the store name, so he inquired as to how the figure was derived. The clerk said that he had simply multiplied the prices of the four individual items. The customer protested that the four prices should have been ADDED, not MULTIPLIED. The clerk said that that was OK with him, but, the result was still the same: exactly $7.11.

What were the prices of the four items? You MUST create a Solver model to answer this question. There are NO FRACTIONAL pennies allowed for the prices. Remember, cell formatting has NOTHING to do with the actual value contained in a cell. Submit your Excel file which includes your Solver model and an explanation regarding how you solved the problem.

Warning: While it's not terribly difficult to come up with A model, it can be very difficult to come up with a formulation and set of Solver options that actually lead to the correct answer. There is only one correct set of four prices. Again, a price of 2.34576 is NOT valid as it can only contain pennies, NOT fractional pennies. Simply rounding the four prices is not the answer either. If you do that, sum up the four rounded prices and take the product of the four rounded prices and, unless you got lucky and found the one solution, the sum and/or product will NOT equal 7.11 EXACTLY.