TJ, Inc. makes three nut mixes for sale to grocery chains located in the Southeast. The three mixes, referred to as the Regular Mix, the Deluxe Mix, and the Holiday Mix, are made by mixing different percentages of five types of nuts.In preparation for the fall season, TJ, Inc. just purchased the following shipments of nuts at the prices shown:Type of NutShipment Amount (pounds)Cost per Shipment ($)Almond6,2007,500Brazil7,6007,225Filbert7,6006,750Pecan6,0007,300Walnut7,4007,875The Regular Mix consists of 15% almonds, 25% Brazil nuts, 25% filberts, 10% pecans, and 25% walnuts. The Deluxe Mix consists of 20% of each type of nut, and the Holiday Mix consists of 25% almonds, 15% Brazil nuts, 15% filberts, 25% pecans, and 20% walnuts.An accountant at TJ, Inc. analyzed the cost of packaging materials, sales price per pound, and so forth, and determined that the profit contribution per pound is $1.60 for the Regular Mix, $2.05 for the Deluxe Mix, and $2.20 for the Holiday Mix. These figures do not include the cost of specific types of nuts in the different mixes because that cost can vary greatly in the commodity markets.Customer orders already received are summarized here:Type of MixOrders (pounds)Regular10,000Deluxe3,000Holiday5,000 Purchase Additional AlmondsShould TJ, Inc. purchase an additional 1,000 pounds of almonds for $1,000 from a supplier who overbought?O TJ, Inc. should purchase the additional 1,000 pounds of almonds for $1,000 from a supplier who overbought.O TJ, Inc. should not purchase the additional 1,000 pounds of almonds for $1,000 from supplier who overbought.Evaluate Order RequirementsDetermine which order requirements would be worth attempting to renegotiate. (Select all that apply.)Regular MixDeluxe MixHoliday MixUpload Your WorkUpload any relevant files. (Submit a file with a maximum size of 15 MB.)Choose File No file chosenThis answer has not been graded yet.Open Response (optional per Instructor)This box can be used for an open response essay and/or to paste a link to a document, video, or other artifact you have created for this assignment. Please contact your instructor if you have any questions about what (ifanything) should be submitted in this essay box. If nothing is to be submitted, type "N/A." Optimal Product Mix and Total Profit ContributionDetermine the optimal product mix (in pounds).RegularDeluxeHolidayDetermine the total profit contribution (in dollars).$lblblbRecommended Additional Purchasing StrategyRecommend how the total profit contribution can be increased if additional quantities of nuts can be purchased. (Give your answers in dollars per pound. Round your numerical values to two decimal places.)per pound, additional filberts are worth $Based on the previous results we find that additional almonds are worth $additional pecans are worth $per pound, additional Brazil nuts are worth $per pound.PecanWalnutper pound, and additional walnuts are worth $Which types of nuts would you recommend TJ, Inc. attempt to acquire. (Select all that apply.)AlmondBrazilO Filbertper pound,

To formulate the LP Model , the decision variables, Objective function and the constraints must be…

TJ, Inc. makes three nut mixes for sale to grocery chains located in the Southeast. The three mixes, referred to as the Regular Mix, the Deluxe Mix, and the Holiday Mix, are made by mixing different percentages of five types of nuts. In preparation for the fall season, TJ, Inc. just purchased the following shipments of nuts at the prices shown: Type of Nut Shipment Amount (pounds) Cost per Shipment ($) Almond 6,200 7,500 Brazil 7,600 7,225 Filbert 7,600 6,750 Pecan 6,000 7,300 Walnut 7,400 7,875 The Regular Mix consists of 15% almonds, 25% Brazil nuts, 25% filberts, 10% pecans, and 25% walnuts. The Deluxe Mix consists of 20% of each type of nut, and the Holiday Mix consists of 25% almonds, 15% Brazil nuts, 15% filberts, 25% pecans, and 20% walnuts. An accountant at TJ, Inc. analyzed the cost of packaging materials, sales price per pound, and so forth, and determined that the profit contribution per pound is $1.60 for the Regular Mix, $2.05 for the Deluxe Mix, and $2.20 for the Holiday Mix. These figures do not include the cost of specific types of nuts in the different mixes because that cost can vary greatly in the commodity markets. Customer orders already received are summarized here: Type of Mix Orders (pounds) Regular 10,000 Deluxe 3,000 Holiday 5,000

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...