Page 1 of 1
Linear Optimization 1. This problem comes from the course textbook. Suppose that a sporting goods equipment makes two ty
Posted: Tue May 10, 2022 8:51 am
by answerhappygod
- Linear Optimization 1 This Problem Comes From The Course Textbook Suppose That A Sporting Goods Equipment Makes Two Ty 1 (124.1 KiB) Viewed 30 times
Linear Optimization 1. This problem comes from the course textbook. Suppose that a sporting goods equipment makes two types of baseball gloves: a regular model and a catcher's model. This firm has the following time allotments: Cutting and sowing department: 900 hours Finishing Department: 300 hours Packing and Shipping Department: 100 hours The production time requirements (in hours) and the profit contribution per glove ($) are given in the following table: Profit/Glove Model Cutting and Sewing Regular Model 1 Finishing Packaging and Shipping 1/2 1/8 5 3/2 1/3 1/4 Catcher's Model Assume this company wants to maximize the total profit contribution a. What is the linear programming model for this problem? b. Develop a spreadsheet model and find the optimal solution using Excel Solver. How many of each model should this company produce? What is the total profit contribution the company can earn with these optimal production quantities? d. How many hours of production time will be scheduled in each department? What is the slack time in each department? C. e.