Hello, I am having some problems with this questions, I have put it in excel but not getting the results i want. can you please provide some help.

Par, Inc., is a small manufacturer of golf equipment and supplies. Pars distributor believes a market exists for both a medium-priced golf bag, referred to as a standard model, and a high-priced golf bag, referred to as a deluxe model. The distributor is so confident of the market that, if Par can make the bags at a competitive price, the distributor will purchase all the bags that Par can manufacture over the next three months. A careful analysis of the manufacturing requirements resulted in the following table, which shows the production time requirements for the four required manufacturing operations and the accounting departments estimate of the profit contribution per bag:

The director of manufacturing estimates that 630 hours of cutting and dyeing time, 600 hours of sewing time, 708 hours of finishing time, and 135 hours of inspection and packaging time will be available to produce golf bags during the next three months.

	PRODUCTION TIME HOURS
PRODUCT	Cutting and Dyeing	Sewing	Finishing	Inspection & Packaging	Profit per bag
STANDARD	7/10	1/2	1	1/10	$10
DELUXE	1	5/6	2/3	1/4	$ 9

a. If the company wants to maximize total profit contribution, how many bags of each model should it manufacture?

b. what profit contribution can Par earn on those production quantities?

c. How many hours of production time will be scheduled for each operation?

d. what is the slack time in each operation?