Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 maroon, 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 $7.50, $3.00, and $4.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 $9.00, $5.00, and $4.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. Operation Cutting Sewing Printing Seconds Required per Unit Maroon 10 Orange 15 6 10 4 8 White 12 7 6 Game Day has 200 hours of cutting capacity available, 85 hours of sewing, and 140 hours of printing. The company would like to determine the optimal way of filling the order for Sable University. a. Formulate an LP model for this problem. b. Implement your model in a spreadsheet and solve it. c. What is the optimal solution?
Step by Step Solution
★★★★★
3.47 Rating (154 Votes )
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started