Prepare an Excel spreadsheet to solve the following problems. Make sure that this is done on excel and not a step-by-step written explanation. Need screenshots of excel and solver please.

1. 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.

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.

Penny wants a solution that will maximize her weekly profits.
 
 

Transcribed Image Text:

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