For the remaining models, set up and solve LP models in EXCEL.4) Optimized Cookie Production for a BCS Party. A friend wasbringing small bags of cookies to sell at a fairly large BCSChampionship Game Watch Party (there were no TCU fans present,however). Three kinds of cookies were sold: Stars (sold for $1 perbag), Circles (sold for $0.75 per bag), and Stars and Stripes (soldfor $1.50 per bag). He was to bring the cookies to the Watch Partyin three large boxes. (The boxes did not have to be full, but hecould not bring more than three large boxes of cookies). By volume,it is a known fact that one of the large boxes can hold 100 bags ofStars, 120 bags of Circles, or 80 bags of Stars and Stripes (or acorresponding mix of cookies). HINT: Don’t concern yourself withwhat each box held; view this as an aggregate limit in the numbersof cookies. Previous parties had given him some hints on the demandfor cookies – he knew that for the sake of variety, he needed tomake at least 45 bags of each type of cookie. As he was planninghis cookie composition, he also realized he was constrained by timein putting together the cookie bags. Circle cookies and Starscookies took 1 minute per bag to finish; because Stars and Stripeshad more icing, it took 2 minutes to finish each bag. He allocated420 minutes (7 hours) to put the bags together. Can you determinehow many of each of the three cookie types your friend should maketo maximize sales (a surrogate for profit)? To quote POTUS: “Yes,you can!”

•Practice problem #4 out of Module 6. Solve using the Solver inEXCEL.

•There is one modification (Circles in box size) and thefollowing clarification.

•

•2nd paragraph – consider that there are 3 boxes and that youdon’t have to fill up the boxes (but you cannot exceed thatspace).

Each bag of Stars takes up 0.01 (1/100th) of a box

Each bag of Circles takes up 0.008 (1/125th) of a box

Each bag of Stars/Stripes takes up 0.0125 (1/80th) of a box

Use this information to help you in creating the LP Model.