Write the linear program, optimal solution, and objective function value on the worksheet.

A clothes manufacturing company produces four different models of shirts, made of cotton, plastic, nylon, and wool. The bookstore which will sell the shirts expects to be able to sell between 10 and 40 of each model. The store has agreed to pay $ 40 for each cotton shirt, $ 59.5 for each plastic shirt, $ 45 for each nylon shirt, and $ 42 for each wool shirt that can be delivered by the end of the week.

One worker can work on cotton, can sew a shirt in 1.5 hours, and will charge $ 7.25 per hour to do the work. This worker can work a maximum of 90 hours during the week.Another worker can sew shirts made of nylon fabric. He can sew a shirt in 1.7 hours, will charge $ 8.25 per hour to work, and can work 42.5 hours in the week. A third worker has the ability to sew plastic. He can sew a shirt in 1.8 hours, will charge $ 9.25 per hour to work, and can work 75 hours during the week.The fourth worker can work on wool. He can sew a shirt in 1.5 hours and will charge $ 7.25 per hour to do the work. This worker can work a maximum of 90 hours during the week.

The following table provides additional information about each shirt.

Shirt model	Material Required (Square Yards)	Material available (Square Yards)	Cost/Square Yard
Cotton	2.25	100	$4.5
Plastic	2.40	150	$4.25
Nylon	2.10	200	$7.65
Wool	2.60	350	$9.45

What is the best combination of shirts to provide the store to maximize the profit?

How much is the maximum profit?

Notes:

1. Submit one MS Excel spreadsheet file (.xlsx or .xls file) including full details of your works (e.g. data, model, figures, table, etc.). Worksheets and variables should be labelled appropriately for audience to easily understand their contents.