Par Inc. is a small manufacturer of golf equipment. It produces two types of golf bags:...

80.2K

Verified Solution

Question

Basic Math

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

Answer & Explanation Solved by verified expert

3.9 Ratings (635 Votes)

Let XY be the quantities of Standard and Deluxe golf bags to beproduced We want to find these quantities and hence these are thedecision variablesThe total profit from selling XY be the quantities of Standardand Deluxe golf bags See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

	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