Par Inc. is a small manufacturer of golf equipment. It producestwo types of golf bags: Standard and Deluxe. Each bag type requiresthe following operations (and production times) to produce oneunit:
| 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 theabove operations. For example, 630 total hours a month areavailable for cutting and dyeing, which will be distributed for theproduction of the two types of bags.
Every standard bag makes a profit of $10, and every deluxe bagmakes a profit of $9.
The problem is to determine the optimal number of standard bagsand deluxe bags to produce every month to maximize the profitcontribution.
Define the variables, formulate the problem, and SOLVEit in Excel (generate the Answer and Sensitivityreports)
Please use excel and post pictures so I can see how todo this on Excel
