Question: Solving this problem using Excel spreadsheet we will find that the profit (max) is 5 45.522,22 If we change the profit of the sweatshirts, front

Solving this problem using Excel spreadsheet we
Solving this problem using Excel spreadsheet we
Solving this problem using Excel spreadsheet we
Solving this problem using Excel spreadsheet we will find that the profit (max) is 5 45.522,22 If we change the profit of the sweatshirts, front printing, from $90 to $100 what will happen to the total profit of the QuickScreen Company? Will decrease to less than $45.000,00 Will increase to more than $47.000,00 Will remain the same 2 Will increase to more than $100.000,00 Quick Screen is a clothing manufacturing company that specializes in producing commemorative shirts immediately following major sporting events such as the World Series Super Bowl and Final Four The company has been contracted to produce a standard set of shirts for the winning team, the State University of Tech, following a college football bowl game on New Year's Day. The items produced include two sweatshirts, one with silk screen printing on the front and one with print on both sides and two shirts of the same configuration The company has to complete all production within 72 hours after the game at which time a trailer truck will pick up the sh The company will work around the clock. The truck has enough capacity to accommodate 1.200 standard boxes A standard box holds 12 T shirts and a box of 12 sweat is three times the size of a standard box The company has budgeted 525.000 for the production run. It has 500 dozen blank sweatshirts and Tshirts each in stock, ready for production The resource requirements are Time (h) Per den 0,10 Cut Pro (5) (5) den pueden Sweatshirt Sweatshirt - B/F T-shirt - Thr / profit The company wants to know how many does boxes) of each type of shit produce in order to main Formulate the LP model for this problem The company wants to know how many dozens (boxes) of each type of shirt to produce in order to maximize profit. Formulate the LP model for this problem. Max Z=90x1+125x2+45x3+65x4 subject to X1 + X2+X3 + X4 72 3X1 + 3X2 X3 X4 1200 36X1 +48X2+25x3 +35X4 $ 25000 X1 + X2 5 500 X3+X4 s 500 X1, X2, X3, X4 20 Max Z=x1+x2+x3+x4 subject to 0.10X1 +0.25X2 +0.08X30.21X4 72 3X1 + 3x2 + x3 + X4 s 1200 36X1 +48X2+25x3 +35X4 25000 X1, X2, X3, X4 > 0 Max Z-36x1+48x2 25x3+35x4 subject to 0.10X1.0.25X2 +0.08X3 +0.21X4 S 12 3X1 + 3X2+X3+X4 s 1200 90X1 +152X2 + 45X365X4 25000 X1 X2 s 500 X3+X4 5 500 X1, X2, X3, X4 20 Max Z-90x1+125x2+45x3+65x4 subject to 0.10X1 +0.25X2 +0.08X3 +0.21X4 $ 72 3X1 + 3X2 X3 X4 S 1200 36X1 +48X2 + 25x3 - 35X4 $ 25000 X1 + X2 5 500 X3+X4 500 X1, X2, X3, X4 2 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!