Question: PLEASE SHOW THE EXCEL SOLUTION FOR ALL PARTS 1. A sports equipment manufacturer makes four types of footballs which earn a profit of $3, $6,
PLEASE SHOW THE EXCEL SOLUTION FOR ALL PARTS
1. A sports equipment manufacturer makes four types of footballs which earn a profit of $3, $6, $5 and $4 per unit respectively. Making a football requires three operations: cutting, sewing, and inspection.
|
| Time for Each operation in minutes for each unit | |||
|
| A | B | C | D |
| Cutting | 12 | 15 | 6 | 3 |
| Sewing | 10 | 15 | 8 | 4 |
| inspection | 4 | 5 | 6 | 3 |
During the next period, the firm has 400 hours of cutting, 475 hours of sewing, and 200 hours of inspection time available. The sales force requires that at least 1000 units of type A football be produced next period. At least 25 % of all footballs made must type B . (Hint: Be careful of Minutes versus Hours)
- Show the mathematical formulation.
- Use solver to find the solution and the objective function value.
- Are we making money or losing money by producing Type A football? Explain.
- Overtime in sewing department can be scheduled for $12 per hour. Should we schedule overtime? If yes, how many hours? What will be the new profit?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help