Hello

Please use excel and excel analytical solver or solver add in to solve each problem. Please have one excel file or one excel sheet for each problem. Please attach excel document after all questions are complete.

18) = https://www.chegg.com/homework-help/tuckered-outfitters-plans-market-custom-brand-packaged-trail-chapter-3-problem-17qp-solution-9781285418681-exc

21) = https://www.chegg.com/homework-help/valu-com-electronics-manufactures-five-different-models-tele-chapter-3-problem-20qp-solution-9781285418681-exc

35) = https://www.chegg.com/homework-help/questions-and-answers/sentry-lock-corporation-manufactures-popular-commercial-security-lock-plants-macon-louisvi-q26426321

42) = https://www.chegg.com/homework-help/jack-potts-recently-won-1-000-000-las-vegas-trying-determine-chapter-3-problem-41qp-solution-9781133169536-exc

50) = https://www.chegg.com/homework-help/embassy-lodge-hotel-chain-wants-compare-brand-efficiency-maj-chapter-3-problem-50qp-solution-9781285418681-exc

18. Tuckered Outfitters plans to market a custom brand of packaged trail mix. The ingredients for the trail mix will include Raisins, Grain, Chocolate Chips, Peanuts, and Almonds costing, respectively, $2.50, $1.50. $2.00, $350, and $3.00 per pound, The vitamin, mineral, and protein content of each of the ingredients (in grams per pound) is summarized in the following table along with the calories per pound of ingredient: Ralslns Grain Chocolate Peanuts Almonds Vitamins 20 1D 10 3D I 20 Minerals 7 4 5 9 3 Protein 4 2 1 10 1 Calories 450 160 I 500 300 500 The company would like to identify the least costly mix of these ingredients that provides at least 40 grams of vitamins, 15 grams of minerals, 10 grams of protein, and 600 calories per two pound package. Additionally, they want each ingredient to account for at least 5% and no more than 50% of the weight of the package. a. Formulate a LP model for this problem. b, Implement your model in a spreadsheet and solve it. c. What is the optimal mix and how much is the total ingredient cost per package? 21. Valu-Com Electronics manufactures ve different models of telecommunications interface cards for PCs and laptops. As summarized in the following table, each of these devices requires differing amounts of printed circuit board, resistors, memory chips, and assembly. Per Unit Requlrements HyperLink FastLlnk SpeedLlnk MlcroLlnk EtherLlnk ' Printed Circuit Board (square Inches) 20 15 10 8 5 l Resistors 28 24 18 12 1e ' Memory Chips > 8 8 4 4 G ' Assembly Labor (in hours) ' H N ' r 0.75 ' V 0.0 r ' V ' 0.5 ' ' ' 70.765 N ' ' 1 The unit wholesale price and manufacturing cost for each model are as fol ows. Per Unit Revenues and Costs HyperLlnk Fastunk Speedunk MIcroLlnk EtherLlnk ' Wholesale Price $189 $149 $129 $169 $139 ' Manufacturing Cost $136 $101 $96 $137 $101 In its next production period, Valu-Com has 80,000 square inches of PC board, 100,000 resistors, 30,000 memory chips, and 5,000 hours of assembly time available. The company can sell all the product it can manufacture, but the marketing department wants to be sure the company produces at least 500 units of each product and at least twice as many FastLink cards as HyperLink cards while maximizing prot. a Formulate an LP model for this problem b. Create a spreadsheet model for this problem and solve it using Solver. c. What is the optimal solution? 35. The Sentry Lock Corporation manufactures a popular commercial security lock at plants in Macon, Louisville, Detroit, and Phoenix. The per unit cost of production at each plant is $35.50, $37.50, $39.00, and $36.25, respectively, while the annual production capacity at each plant is 18,000, 15,000, 25,000, and 20,000. respectively. Sentry's locks are sold to retailers through wholesale distributors in seven cities across the United States. The unit cost of shipping from each plant to each distributor is summarized in the following table along with the forecasted demand from each distributor for the coming year. Unlt shipping Cost to Dlstrlbutor In Plants Tacoma san Diego Dallas Denver 5'. Louis Tampa Baltimore ' Macon $2.50 $2.75 $1.75 $2.00 $2.10 $1.80 $1.65 1 Louisville $1.85 $1.90 $1.50 $1.60 $1.00 $1.90 $1.85 ' Detroit $2.30 $2.25 $1.85 $1.25 $1.50 $2.25 $2.00 1 Phoenix $1.90 $0.90 $1.60 $1.75 $2.00 $2.50 $2.65 ' Demand 8,500 14,500 13,500 12,600 16,000 15,000 9,000 Sentry wants to determine the least expensive way of manufacturing and shipping looks from its plants to the distributors, Because the total demand from distributors exceeds the total production capacity for all the plants, Sentry realizes it will not be able to satisfy all the demand for its product, but wants to make sure each distributor will have the opportunity to fill at least 80% of the orders received. a. Create a spreadsheet model for this problem and solve it. b. What is the optimal solution? 42. Jack Potts recently won $1,000,000 in Las Vegas and is trying to determine how to invest his winnings. He has narrowed his decision down to five investments, which are summarized in the following table. Summary of Cash Inows and outflows (at beginning of years) ' 1 2 3 4 l A 1 0.50 0.80 B 1 ea 1.25 c -1 Ha H 1.35 D 1 1.13 E -1 _s 1.27 If Jack invests $1 in investmentA at the beginning of year 1, he will receive $0.50 at the beginning of year 2 and another $0.80 at the beginning of year 3. Alternatively, he can invest $1 in investment B at the beginning of year 2 and receive $1.25 at the beginning of year 4. Entries of \">" in the table indicate times when no cash inows or outows can occur. At the beginning of any year, Jack can place money in a money market account that is expected to yield 8% per year. He wants to keep at least $50,000 in the money market account at all times and doesn't want to place any more than $500,000 in any single investment. How would you advise Jack to invest his winnings if he wants to maximize the amount of money he'll have at the beginning of year 4? a. Formulate an LP model for this problem. b. Create a spreadsheet model for this problem and solve it using Solver. c. What is the optimal solution?