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: Yards of Fabric Minimum Veekly Maximum Weekly Demand Selling Price Fabric Shirt er Shirt Requirenent Contracts At least 60% cotton No more than 500 650 300 600 850 700 $30 $40 $36 thletic 1.00 1.20 0.90 rsi 30% Up to 80% cotton Surfer 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. https://d2vlcm61l7u1fs.cloudfront.net/media%2F952%2F95285cae-b142-483c-b194-fea191433259%2FphpJMQIto.png