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.

https://d2vlcm61l7u1fs.cloudfront.net/media%2F32b%2F32b857bf-e73f-4853-b528-5b744fef0c7d%2FphpjsxqT0.pnghttps://d2vlcm61l7u1fs.cloudfront.net/media%2Fba6%2Fba66bb85-12d4-4080-be85-b8f0d6afa4f4%2Fphp5mIkwG.png

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp