IN EXCEL FORMULAS ONLY

A B D E Problem 1. Par, Inc. is a small manufacturer of golf equipment. They decided to move into the market of standard and deluxe golf bags. Par's distributor has agreed to buy all the golf bags Par produces over the next three months. The manufacturing department determined that each golf bag produced will require the following operations: 1. Cutting and dyeing the material 2. Sewing 3. Finishing (inserting umbrella holders, club separators, etc.) 4. Inspection and packaging The production time requirement (in hours) and the available time in the next three weeks (also in hours) for each type of operation are presented in the template below. The profit per a standard bag is $10.00 and for each deluxe bag is $9.00. Develop a model to determine the number of standard bags and the number of deluxe bags to produce in order to maximize total profit with the condition that number of standard bags produced should be at least twice as much as number of deluxe bags produced. 1 2 A 3 4 Operation 5 Cutting and Dyeing 6 Sewing 7 Finishing 8 Inspection and Packaging B Production Time (Hours) Standard Deluxe 0.700 1.000 0.500 0.833 1.000 0.667 0.100 0.250 9 $10.00 $9.00 10 Profit Per Bag 11 12 Model 13 14 15 Bags Produced 16 Standard Deluxe Hours Used 17 Operation 18 Cutting and Dyeing 19 Sewing 20 Finishing 21 Inspection and Packaging Hours Available 630 600 708 135 22 23 Total Profit 24 25 26