In Problems 49-54, use Excel to solve each linear programming problem.
Manufacturing A bicycle manufacturer makes mountain bikes and road bikes. Each mountain bike requires 2 units of steel and 6 units of aluminum in its frame and 12 special components for the hub, sprocket, and gear assembly. Each road bike requires 5 units each of steel and aluminum for its frame and 5 of the special components. Shipments are such that steel is limited to 100 units per day, aluminum is limited to 120 units per day, and the special components are limited to 180 units per day. If the profits are $300 on each mountain bike and $200 on each road bike, how many of each should be produced to yield the maximum profit? What is the maximum profit?
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Mathematical Applications for the Management, Life, and Social Sciences
Additional Math Textbook Solutions
Introductory Mathematics for Engineering Applications
Basic College Mathematics
Differential Equations: An Introduction to Modern Methods and Applications
Finite Mathematics with Applications In the Management, Natural, and Social Sciences (12th Edition)
Discrete Mathematics and Its Applications ( 8th International Edition ) ISBN:9781260091991
A Survey of Mathematics with Applications (10th Edition) - Standalone book
- Discrete Mathematics and Its Applications ( 8th I...MathISBN:9781259676512Author:Kenneth H RosenPublisher:McGraw-Hill EducationMathematics for Elementary Teachers with Activiti...MathISBN:9780134392790Author:Beckmann, SybillaPublisher:PEARSON
- Thinking Mathematically (7th Edition)MathISBN:9780134683713Author:Robert F. BlitzerPublisher:PEARSONDiscrete Mathematics With ApplicationsMathISBN:9781337694193Author:EPP, Susanna S.Publisher:Cengage Learning,Pathways To Math Literacy (looseleaf)MathISBN:9781259985607Author:David Sobecki Professor, Brian A. MercerPublisher:McGraw-Hill Education