Please help solve in excel

JeCornell DYS545. Using Prescriptive Analytics in Excel Dyson School of Applied Economics and Management Prescriptive Modeling using Solver Part Three: Example Spreadsheets Instructions: Save this already loaded solver model in L14 in the following worksheet and generate a feasibility report. Next, load the model in L3, run it and create an answer report. (Select REPLACE, not merge when prompted). Finally, provide answers to the following and highlight your answers: From the feasability report, which food retailer will not receive their order? Comparing the two solver models, please explain why the first solver model is infeasible and what constraints changed in the second model. Type in your answer in the text box provided in the "Answer" tab of this worksheet. Include the Answer Report for each solver model. Copyright @ 2023 eCornell All rights reserved All other copyrights, trademarks, trade names, and logos are the sole property of their respective owners Instructions Feasibility Report 1 Distribution Answer + eady Accessibility. InvestigateGet & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline B D G K L M Ingredients R US, Inc. Order Distribution Plan Shipping Costs from Distribution Center (per pallet) Numberof Items Shipped Food Retailers Pallet Orders Distribution Ctr. 1|Distribution Ctr. 2 Distribution Ctr. 3 Distribution Ctr. 1 Distribution Ctr. 2 Distribution Ctr. 3 Shipped Total Costs $ 12,000.00 Food Buzz 60 $ 20.25 $ 78.15 $ 27.15 60 O O 60 $ 1,215.00 18 Healthy Stuff 78 $ 50.85 $ 50.00 $ 47.90 O O 78 78 $ 3,736.20 TRUE Smoothie City 125 $ 84.00 $ 38.40 $ 65.55 O 116 116 $ 4,449.50 TRUE Burger Barn 187 $ 86.65 $ 25.40 $ 13.90 o O 187 187 $ 2,599.30 100 Cafe Organic 313 $ 108.95 21.50 $ 33.95 313 O 313 $ 34,101.35 100 Dessert Center 567 $ 116.45 $ 7.95 $ 26.20 567 O 567 $ 66,027.15 Total 1330 940 116 265 1321 $ 12,000.00 2 Initial Inventory 1,005 335 275 1,615 3 Remaining Inventory 65 219 10 294 5 Infeasible Constraints 6 Number Shipped (F4:H9) int Integer 17 Shipped (14:19) Demand (B4:B9) 18 Total Costs (J10) 12,000 19 20 Constraints with Solution 21 Number Shipped (F4:H9) int Integer 22 Shipped (14:19) Demand (B4:B9) 23 24 Review of Model: 25 Ingredients R US, Inc. provides the raw materials for food preparation to several local eateries. 26 The ingredients are ordered by pallet and transported from one of three distribution centers. 27 Depending on order type, the nearest distribution center cannot always be utilized to fill orders. 28 Ingredients R US, Inc. has tasked you with satisfying demand while minizing total cost to ship product to customers. 29 30 31 32 33 34 35 36 instructions Distribution AnswerProvide answers to the following and highlight your answers: From the feasability report, which food retailer will not receive their order? Comparing the two solver models, please explain why the first solver model is infeasible and what constraints changed in the second model. Type your answer here. Instructions Distribution