1. LP and IP. Suppose you are making t-shirts and baseball caps. Each t-shirt you sell give you $10 in profit, and each cap you sell gives you $15 in profit. You have an 8-hour production day. It takes 2 minutes to stitch a t-shirt, and 3 minutes to stitch a cap. You have stitching capacity equal to 200 minutes per day. It takes 1 minute to dye and monogram a t-shirt, and 3 minutes to dye and monogram a cap. You have dye capacity equal to 120 minutes per day. It takes 3 minutes to fold, tag, and package a t-shirt, and 2 minutes to fold and tag a cap for sale. You have capacity for 160 minutes per day.

Please use Excel solver and formulas

1. In Tab 1 set up and solve an LP to find how many caps and t-shirts to produce in one day.
2. Tab 1

1. In Tab 2, set up and solve an IP to find how many caps and t-shirts to produce in one day
2. Tab 2

Information and setup \begin{tabular}{|l|r|r|} \hline & t-shirts & \multicolumn{1}{l|}{ caps } \\ \hline profit coeff & $10.0 & $15.0 \\ \hline \end{tabular} Linear Program Information and setup