URGENT PLEASE!!!

Please use excel solver. AND POST EXCEL SCREENSHOTS WITH FORMULAS.

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. (10 points)

\begin{tabular}{|l|c|c|} \hline & Labor (hours) & Cloth (square yards) \\ \hline Shirt & 3 & 4 \\ \hline Shorts & 2 & 3 \\ \hline Pants & 6 & 4 \\ \hline \end{tabular} \begin{tabular}{|l|c|c|} \hline & Sales Price & Variable Cost \\ \hline Shirt & $12 & $6 \\ \hline Shorts & $8 & $4 \\ \hline Pants & $15 & $8 \\ \hline \end{tabular} \begin{tabular}{|l|c|c|} \hline & Labor (hours) & Cloth (square yards) \\ \hline Shirt & 3 & 4 \\ \hline Shorts & 2 & 3 \\ \hline Pants & 6 & 4 \\ \hline \end{tabular} \begin{tabular}{|l|c|c|} \hline & Sales Price & Variable Cost \\ \hline Shirt & $12 & $6 \\ \hline Shorts & $8 & $4 \\ \hline Pants & $15 & $8 \\ \hline \end{tabular}