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

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

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. 

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?

 

Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE 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.