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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!