Question: You walk into a 7-11 store and pick up four different items. You place them on the checkout counter. The clerk says to you,
You walk into a 7-11 store and pick up four different items. You place them on the checkout counter. The clerk says to you, "that will be $7.11". You laugh and say, how did you get that price? The clerk says, "I took the four individual prices and multiplied them together and the result was $7.11. MULTIPLY?! You say, you can't do that, you need to ADD the four prices together. Clerk says, "doesn't matter, the result is still a total of $7.11 whether I multiply the four prices or add the four prices. So, the puzzle is for you to develop a Solver model in Excel that can (possibly) determine the four individual item prices. Of course, each price CANNOT contain fractions of pennies. In other words, the final solution must be dollars and a whole number of pennies for each of the four products. Yes, you can simply use math and Google to find the four unique prices, but that's not the puzzle. The puzzle is to develop a Solver model that can produce the four distinct prices.
Step by Step Solution
3.42 Rating (152 Votes )
There are 3 Steps involved in it
he ansurer Jeun hung 150 243141120 DS425 the Jetal cast and the Prod... View full answer
Get step-by-step solutions from verified subject matter experts
