q9

Solve this problem using Excel X1 = 150,45 boxes of front-only sweatshirts X2 = 50 21 boxes of front and back sweatshirts X3 = 250 boxes of front-only T-shirts X4 = 250 boxes of front and back T-shirts Z (Profit) = $45 000.00 X1 = 250 boxes of front-only sweatshirts X2 = 250 boxes of front and back sweatshirts X3 = 500 boxes of front-only T-shirts Z (Profit) = 547 252 22 X1 = 175,56 boxes of front-only sweatshirts X2 = 57 78 boxes of front and back sweatshirts X3 = 500 boxes of front only T-shirts Z (Profit) = 545,522 22 X1 = 170 boxes of front-only sweatshirts x2 =50 boxes of front and back sweatshirts X3 = 250 boxes of front only T-shirts X4 250 boxes of front and back T-shirts Z (Profit) = $4222222 QUESTION 8 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, either State University or Toch, following a college football bowl game on New Year's Day The items produced include two sweatshirts one with sikscreen printing on the front and one with print on both sides and two T-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 shirts The company will work around the clock The truck has enough capacity to accommodate 1200 standard boxes A standard sir box holds 12 T-shirts and a box of 12 sweatshirts three times the che of a standard box The company has budgeted $25,000 for the production run it has 500 dozen blank sweatshirts and T-shirts each in stock, ready for production The resource requirements are Proing Cost ProG Time (ha) (5) (5) Per duen pede perdeen 0.10 .25 Sweatshirt -T Sweatshirt - /T T-shirt T-shirt - B/ b e ach type of the producentom