Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fraud Analytics Strategies And Methods For Detection And Prevention

Authors: Delena D. Spann

1st Edition

111823068X, 978-1118230688

More Books

Students also viewed these Accounting questions