Par Inc. is a small manufacturer of golf equipment. It produces two types of golf bags: Standard and Deluxe. Each bag type requires the following operations (and production times) to produce one unit:

	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 the above operations. For example, 630 total hours a month are available for cutting and dyeing, which will be distributed for the production of the two types of bags.

Every standard bag makes a profit of $10, and every deluxe bag makes a profit of $9.

The problem is to determine the optimal number of standard bags and deluxe bags to produce every month to maximize the profit contribution.

Define the variables, formulate the problem, and SOLVE it in Excel (generate the Answer and Sensitivity reports)