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 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

1 Expert Approved Answer
Step: 1 Unlock

he ansurer Jeun hung 150 243141120 DS425 the Jetal cast and the Prod... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!