Question: Can someone please show me how to solve this using excel? Thank you Par, Inc., produces a standard golf bag and a deluxe golf bag
Can someone please show me how to solve this using excel? Thank you
Par, Inc., produces a standard golf bag and a deluxe golf bag on a weekly basis. Each golf bag requires time for cutting and dyeing and time for sewing and finishing, as shown in the following table:
| HOURS REQUIRED PER BAG | ||
|---|---|---|
| Product | Cutting and Dyeing | Sewing and Finishing |
| Standard bag | 1/2 | 1 |
| Deluxe bag | 1 | 2/3 |
The profits per bag and weekly hours available for cutting and dyeing and for sewing and finishing are as follows:
| Product | Profit Per Unit ($) |
|---|---|
| Standard bag | 10 |
| Deluxe bag | 8 |
| Activity | Weekly Hours Available |
|---|---|
| Cutting and dyeing | 300 |
| Sewing and finishing | 360 |
Par, Inc., will sell whatever quantities it produces of these two products.
Find the mix of standard and deluxe golf bags to produce per week that maximizes weekly profit from these activities. x1 = [ Select ] ["140", "256", "240", "242"] , x2 = [ Select ] ["180", "177", "183", "190"]
What is the value of the profit? $ [ Select ] ["3568", "2836", "3767", "3840"]
How much would profits decrease if sewing and finishing hours were reduced by 40 hours = $ [ Select ] ["360", "425", "250", "150"]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
