PLEASE SOLVE IN EXCEL WITH SOLVER - PLEASE DO NOT POST A WORD DOC OR SHEET OF PAPER -THANK YOU

The Penny Veracruz Company (PVC), a small startup firm, manufactures three types of clothing: shirts, shorts and pants. To make each type of clothing requires that PVC has the appropriate type of machinery available. The machinery needed to manufacture each type of clothing must be rented at the following rates: shirt machinery, $200 per week; shorts machinery, $150 per week; pant machinery, $100 per week. The labor and amount of cloth needed to manufacture each type of clothing is given below.

	Labor (hours)	Cloth (square yards)
Shirt	3	4
Shorts	2	3
Pants	6	4

Each week PVC has 150 hours of labor and 160 square yards of cloth available to them. The variable cost per unit and the selling price for each type of clothing is given below.

	Sales Price	Variable Cost
Shirt	$12	$6
Shorts	$8	$4
Pants	$15	$8

Penny wants a solution that will maximize her weekly profits. (10 points)