Resolve the given business problem by applying an appropriate quantitative technique in Excel to achieve an optimal solution.

Once completed, develop a recommendation for the firm. The report should respond to the following writing prompts:

1. Discuss all needs (e.g., financial, non-financial) of the hypothetical firm based on the given scenario.

2. Discuss the firms objective. (One statement is sufficient.)

3. Discuss the reasoning process applied to develop the math model as well as the technique used to achieve an optimal solution (e.g. application of the decision-making process steps).

4. Make your recommendation.

Try-Ball is excited that your firm consents to advise us on our efforts to improve results. As we discussed prior, Try-Ball Inc. is a small manufacturer of consumer sports equipment. Our management team has decided to enter the market for sports bags. We have entered into an agreement with our distributor allowing them to exclusively purchase all the bags we manufacture over the next four months. Each of the bags produced requires the following processes: 1. Cutting and dyeing covers 2. Sewing 3. Finishing 4. Quality assurance and packaging This production information and available man-hours are summarized in this table:

DEPARTMENT	FLEX SPORTS	DUFFLE	AVAILABLE MAN HOURS
Cutting and Dying Cover	7/10	1	500
Sewing	1/2	5/6	530
Finishing	1	2/3	604
Inspection and Packaging	1/10	1/4	80

Our production team believe the available man-hours for each process is consistent.

The accounting department analyzed the production data and arrived at unit profit for each bag at $6 per flex sports bag and $9 per every duffle bag produced.

We are eager to hear your guidance regarding improving our production plan to achieve maximum profit.