Par Inc. is a small manufacturer of golf equipment. It produces two types of golf bags: Standard
Question:
Par Inc. is a small manufacturer of golf equipment. It produces two types of golf bags: Standard and Deluxe. Each bag type requires the following operations (and production times) to produce one unit:
Production Time (hours) | Time Available | ||
Operation | Standard | Deluxe | (hours/month) |
Cutting and Dyeing | 0.7 | 1 | 630 |
Sewing | 0.5 | 5/6 | 600 |
Finishing | 1 | 2/3 | 708 |
Inspection | 0.1 | 0.25 | 135 |
Time available refers to the production capacity for each of the above operations. For example, 630 total hours a month are available for cutting and dyeing, which will be distributed for the production of the two types of bags.
Every standard bag makes a profit of $10, and every deluxe bag makes a profit of $9.
The problem is to determine the optimal number of standard bags and deluxe bags to produce every month to maximize the profit contribution.
Define the variables, formulate the problem, and SOLVE it in Excel (generate the Answer and Sensitivity reports)
Fundamentals of Electric Circuits
ISBN: 9780073301150
3rd edition
Authors: Matthew Sadiku, Charles Alexander