Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started