Jon Hoke owns a bicycle shop. He stocks three types of bicycles: road-racing, cross-country and mountain. A...

80.2K

Verified Solution

Question

Basic Math

Jon Hoke owns a bicycle shop. He stocks three types of bicycles:road-racing, cross-country
and mountain. A road-racing bike costs $1,200, a cross-countrybike costs $1,700 and a
mountain bike costs $900. He sells road-racing bikes for $1,800,cross-country bikes for $2,100
and mountain bikes for $1,200. He has $12,000 available thismonth to purchase bikes. Each
bike must be assembled: a road-racing bike requires 8 hours toassemble, a cross-country bike
requires 12 hours and a mountain bike requires 16 hours. Heestimates that he and his
employees have 120 hours available to assemble bikes. He hasenough space in his store to
order 20 bikes this month. Based on past sales, John wants tostock at least twice as many
mountain bikes as the other two combined because mountain bikessell better. Formulate
(develop the objective function and constraints) a linearprogramming model for this problem
where the Jon’s objective is to maximize total profits. Generatethe solution using Excel Solver.
Please include Solver explanation. (step by step)

Answer & Explanation Solved by verified expert

4.2 Ratings (534 Votes)

Let XY Z be the quantities of roadracing crosscountry andmountain bikes respectively that John stocksThese are the decision variablesThe total profit of producingselling XY Z be the quantities ofroadracing See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member