6 2 Merpes Corner 5 %) Conditional fout Formatting y Format S sode Pont Al P M N o Q R w X Perform an analysis of the TI, Inc. product mix problem. Prepare a summary report of your findings for TI Inc.'s president z AA 1. The cost per pound of the nuts included in the Regular, Deluxe, und Holiday mixer 2. The optimal product mix and the total profit contribution 3. Recommendations regarding how the total profit contribution can be increased it additional quantities of nuts can be purchased 4. A recommendation as to whether TJ, Inc., should purchase an additional 1000 pounds of almonds for $1000 from a supplier who overbought 5. Recommendations on how profit contribution could be increased (if at all) of T), Inc., does not satisfy all existing order answers to submit Sheet ENG 10C 2012-10-22 o o at Nut Mixes Regular Deluxe Holiday 4.00 2.25 3.50 Nuts Almond Brazil Filbert Pecan Walnut Given Profit Contribution/Ib Nut Mixes Regular Deluxe Holiday 15% 20% 25% 25% 20% 15% 25% 20% 15% 10% 20% 25% 20% 20% 25% 3 Given Profit Contribution/ 9 70 11 Almond 12 Brazil 13. Filbert 14 Pecan 15 Walnut 16 Regular Mix produced 17 Deluxe Mix produced 18 Holiday Mix produced 19 Shipment Cost Per shipment Cost/pound 6604 $7,500 $0.88 7500 $7,125 $1.05 6214 $6,750 $0.92 6000 $7,200 $0.83 8979 $7,875 $1.14 10000 3000 5000 Model Decision Variables Regular Deluxe Holiday Number of Pounds Maximize Total Profit 20 answers to submit Sheet H Maximize Total Profit LHS RHS Constraint Almond Brazil Filbert Pecan Walnut Regular Mix produced Deluxe Mix produced Holiday Mix produced > 0 0 0 > 10000 3000 5000 > Calculations by Solver should show in blue areas and elsewhere