A company makes three types of shirts: Athletic, Varsity, and Surfer. The shirts are made
from different combinations of cotton and rayon. The cost per yard of cotton is $5 and of
rayon is $7. The company can receive up to 4000 yards of cotton and 3000 yards of rayon
per week. The table below shows relevant manufacturing information:
https://d2vlcm61l7u1fs.cloudfront.net/media%2F952%2F95285cae-b142-483c-b194-fea191433259%2FphpJMQIto.png
a) Formulate a linear program to maximize the company’s profit and put it in standard
format. Clearly define your decisions variables, objective function and constraints.
b) Implement your formulation in Excel and use Solver to find the optimal solution.
Provide answers for the optimal amounts of different shirt types.