Question: I need the answer in excel format; Problem 1 . Par, Inc. is a small manufacturer of golf equipment. They decided to move into the
I need the answer in excel format; "Problem 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:
Cutting and dyeing the material
Sewing
Finishing inserting umbrella holders, club separators, etc.
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 $ and for each deluxe bag is $
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."
Production Time Hours
Operation Standard Deluxe
Cutting and Dyeing
Sewing
Finishing
Inspection and Packaging
Profit Per Bag $ $
Model
Standard Deluxe
Bags Produced
Operation Hours Used Hours Available
Cutting and Dyeing
Sewing
Finishing
Inspection and Packaging
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
