15. The Weedwacker Company manufactures two types of lawn trimmers: an electric model and a gas model. The company has contracted to supply a national discount retail chain with a total of 30,000 electric trimmers and 15,000 gas trimmers. However, Weedwacker's production capability is limited in three departments: production, assembly, and packaging. The following table summarizes the hours of processing time available and the processing time required by each department, for both types of trimmers: Electric Hours Required per Trimmer Gas Hours Available Production 0.20 0.40 10,000 Assembly 0.30 0.50 15,000 Packaging 0.10 0.10 5,000 The company makes its electric trimmer in-house for $55 and its gas trimmer for $85. Alternatively, it can buy electric and gas trimmers from another source for $67 and $95, respectively. How many gas and electric trimmers should Weedwacker make and how many should it buy from its competitor in order to fulfill its contract in the least costly manner? a. Formulate an LP model for this problem. b. Create a spreadsheet model for this problem and solve it using Solver. c. What is the optimal solution?

Micro Economics For Today
10th Edition
ISBN:9781337613064
Author:Tucker, Irvin B.
Publisher:Tucker, Irvin B.
Chapter7: Proudction Costs
Section: Chapter Questions
Problem 8SQP
icon
Related questions
Question

Please make sure to show work for each question. Thank you!

15. The Weedwacker Company manufactures two types of lawn trimmers: an electric
model and a gas model. The company has contracted to supply a national discount retail
chain with a total of 30,000 electric trimmers and 15,000 gas trimmers. However,
Weedwacker's production capability is limited in three departments: production,
assembly, and packaging. The following table summarizes the hours of processing time
available and the processing time required by each department, for both types of
trimmers:
Electric
Hours Required per Trimmer
Gas
Hours Available
Production
0.20
0.40
10,000
Assembly
0.30
0.50
15,000
Packaging
0.10
0.10
5,000
The company makes its electric trimmer in-house for $55 and its gas trimmer for $85.
Alternatively, it can buy electric and gas trimmers from another source for $67 and $95,
respectively. How many gas and electric trimmers should Weedwacker make and how
many should it buy from its competitor in order to fulfill its contract in the least costly
manner?
a. Formulate an LP model for this problem.
b. Create a spreadsheet model for this problem and solve it using Solver.
c. What is the optimal solution?
Transcribed Image Text:15. The Weedwacker Company manufactures two types of lawn trimmers: an electric model and a gas model. The company has contracted to supply a national discount retail chain with a total of 30,000 electric trimmers and 15,000 gas trimmers. However, Weedwacker's production capability is limited in three departments: production, assembly, and packaging. The following table summarizes the hours of processing time available and the processing time required by each department, for both types of trimmers: Electric Hours Required per Trimmer Gas Hours Available Production 0.20 0.40 10,000 Assembly 0.30 0.50 15,000 Packaging 0.10 0.10 5,000 The company makes its electric trimmer in-house for $55 and its gas trimmer for $85. Alternatively, it can buy electric and gas trimmers from another source for $67 and $95, respectively. How many gas and electric trimmers should Weedwacker make and how many should it buy from its competitor in order to fulfill its contract in the least costly manner? a. Formulate an LP model for this problem. b. Create a spreadsheet model for this problem and solve it using Solver. c. What is the optimal solution?
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Micro Economics For Today
Micro Economics For Today
Economics
ISBN:
9781337613064
Author:
Tucker, Irvin B.
Publisher:
Cengage,
Survey Of Economics
Survey Of Economics
Economics
ISBN:
9781337111522
Author:
Tucker, Irvin B.
Publisher:
Cengage,
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics: Applications, Strategies an…
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning
Economics Today and Tomorrow, Student Edition
Economics Today and Tomorrow, Student Edition
Economics
ISBN:
9780078747663
Author:
McGraw-Hill
Publisher:
Glencoe/McGraw-Hill School Pub Co
Economics (MindTap Course List)
Economics (MindTap Course List)
Economics
ISBN:
9781337617383
Author:
Roger A. Arnold
Publisher:
Cengage Learning