XYZ Ltd makes three varieties of shirts:A-Type, B-Type, and C-Type. These shirts are made from different combinations of linen and polyester.

The cost per meter of unblended linen is $5 and for unblended polyester is $4. XYZ can receive up to 4,000 meters of raw linen and 3,000 meters of raw polyester fabric weekly. The table below pertinent data concerning the manufacture of the shirts.

Shirt	Total Meters/Shirt	Fabric Requirement	Weekly Contracts (at least)	Weekly Demand (at most)	Selling Price/Shirt
A-Type	1.00	At least 50% linen	500	600	$14.00
B-Type	1.20	No more than 20% polyester	650	850	$15.00
C-Type	.90	As much as 80% polyester	280	675	$18.00

Formulate and solve this blending problem as a linear program to maximize the overall profit.

Hint: You have to decide how many shirts to make, how much fabric to purchase, and how much of each fabric will be blended into ALL shirts of each type combined.

Define the decision variables

b.Define the objective function

c.Define the constraints

d.Solve the LPusing Excel's Solver. Fully interpret your answer.

Make sure to include in your answer the following information:

- the total profit

- how many shirts of each type to make

- how much of each type of fabric to purchase

- how much of each fabric is blended into ALL shirts of each type combined.

Note 1: Include two relevant Excel's Solver calculations/printouts (Sheet and Answer Report) as exhibits at the end of your report (you may use PrintScreen). Save everything as one and only one file in the pdf format. Do not attach in your email any additional Excel files - they will not be marked.