chwinn holds 3 type of bicycles: race bikes, cross-country bikes, and trail bikes. He sells race bikes for $1,900, cross-country bikes for $2,200 and trail bikes for $1300. A race bike costs $1,300, a cross-country bike costs $1,800 and a trail bike costs $1000. He has $12,000 available this month to purchase bikes. Each bike requires assembly: a race bike requires 8 hours to assemble, a cross-country bike requires 12 hours, and a trail bike requires 16 hours. He and his employees have 120 hours available to put the bikes together. He has enough space in his store to order 20 bikes this month. Schwinn wants to stock at least twice as many trail bikes as the other two combined.   A. Formulate a linear programming model for this problem. B. Solve the linear programming model using excel Solver. What is the maximum profit? C. How many bicycles should he purchase from each?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
  1. Schwinn holds 3 type of bicycles: race bikes, cross-country bikes, and trail bikes. He sells race bikes for $1,900, cross-country bikes for $2,200 and trail bikes for $1300. A race bike costs $1,300, a cross-country bike costs $1,800 and a trail bike costs $1000. He has $12,000 available this month to purchase bikes. Each bike requires assembly: a race bike requires 8 hours to assemble, a cross-country bike requires 12 hours, and a trail bike requires 16 hours. He and his employees have 120 hours available to put the bikes together. He has enough space in his store to order 20 bikes this month. Schwinn wants to stock at least twice as many trail bikes as the other two combined.

 

A. Formulate a linear programming model for this problem.

B. Solve the linear programming model using excel Solver. What is the maximum profit?

C. How many bicycles should he purchase from each?

D. What should Schwinn do to increase profit based on the optimal solution?

E. If Schwinn hired an additional worker for 40 hours at least $10 per hour, how much additional profit would he make, if any?

Speak

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 5 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

what is the stock constraint?

Speak

Solution
Bartleby Expert
SEE SOLUTION
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.