CanSports is manufacturing company that produces 4 types of T-shirt/sweatshirts by printing on blank products. For...

 

Transcribed Image Text:

CanSports is manufacturing company that produces 4 types of T-shirt/sweatshirts by printing on blank products. For each of 4 types of product, the processing (printing) time (in hrs), cost, and profit are given in below table for a dozen units. They must complete printing process within 72 hours. Their truck capacity is 1,200 standard-sized boxes. A standard size box holds 12 T-shirts. One dozen sweatshirts box is three times size of a standard box. They have $25,000 available for a production run and also 500 dozen blank T-shirts and 500 dozen black sweatshirts in stock. How many dozens (boxes) of each type of shirt they should print to maximize total profit? Hint: Consider unit profits in the objective function and use costs for the total cost budget. a. Formulate CanSports's problem as an LP model. b. Then solve this problem using Excel Solver. Sweatshirt - F Sweatshirt B/F - T-shirt - F T-shirt - B/F Processing Time (hr) Per dozen 0.10 0.25 0.08 0.21 Cost ($) per dozen $36 48 25 35 Profit ($) per dozen $90 125 45 65 CanSports is manufacturing company that produces 4 types of T-shirt/sweatshirts by printing on blank products. For each of 4 types of product, the processing (printing) time (in hrs), cost, and profit are given in below table for a dozen units. They must complete printing process within 72 hours. Their truck capacity is 1,200 standard-sized boxes. A standard size box holds 12 T-shirts. One dozen sweatshirts box is three times size of a standard box. They have $25,000 available for a production run and also 500 dozen blank T-shirts and 500 dozen black sweatshirts in stock. How many dozens (boxes) of each type of shirt they should print to maximize total profit? Hint: Consider unit profits in the objective function and use costs for the total cost budget. a. Formulate CanSports's problem as an LP model. b. Then solve this problem using Excel Solver. Sweatshirt - F Sweatshirt B/F - T-shirt - F T-shirt - B/F Processing Time (hr) Per dozen 0.10 0.25 0.08 0.21 Cost ($) per dozen $36 48 25 35 Profit ($) per dozen $90 125 45 65