1. [0/6 Points] DETAILS PREVIOUS ANSWERS MY NOTES ASK YOUR TEACHER RAGSMDA9 3.E.014. PRACTICE ANOTHER Game Day Fashions makes custom t-shirts for fans of college university sports teams. Currently, the company is trying to determine the best way to fill an order it received from Sable University. The official colors of Sable University are orange and marcon, so most of the t-shirts it orders are for one of those two colors. However, one home game each year is designated as a "white out" games where all Sable University fans are encouraged to wear white shirts. Sable University has placed an order for 50,000 orange shirts, 45,000 maroon shirts, and 30,000 white shirts. Under the terms of the contract, the company is permitted to outsource as many as 25,000 of each of the shirts from a competing company. Game Day Fashions can make the orange, maroon, and white shirts for $8.50, $4.00, and $5.00 per unit, respectively. The company handling the outsourcing has agreed to make up to 25,000 of each shirt color at a cost of $10.00, $6.00, and $5.75 per unit for the maroon, orange, and white shirts, respectively. The following table summarizes the amount of time in seconds it takes Game Day's production department to make each shirt color. Seconds Required per Unit Operation Cutting Orange Maroon White 15 10 12 Sewing Printing 6 L 10 8 6 Game Day has 210 hours of cutting capacity available, 105 hours of sewing, and 160 hours of printing. The company would like to determine the optimal way of filling the order for Sable University. (Let X. X, and X, be the number of orange, maroon, and white shirts respectively that Game Day Fashions should make. Let X, X, and X, be the number of orange, maroon, and white shirts respectively that Game Day Fashions should outsource.) (a) Formulate an LP model for this problem to minimize cost (in dollars). MIN: Subject to: Number of orange shirts Number of maroon shirts Number of white shirts Number of orange shirts outsourced Number of maroon shirts outsourced Number of white shirts outsourced Cutting Time (in sec) Sewing Time (in sec) Printing Time (in sec) 7.5% +3X+4X+9X+5x+4.75% (b) Implement your model in a spreadsheet and solve it. What is the optimal solution? Need Help? Flead Viewing Seved Won Bevert to Last Meanon Submit Answer