Question
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
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 tyour 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.
| 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 |
| Food Buzz | 60 | $ 20.25 | $ 78.15 | $ 27.15 | 60 | 0 | 0 | 60 | $ 1,215.00 |
| Healthy Stuff | 78 | $ 50.85 | $ 50.00 | $ 47.90 | 0 | 0 | 78 | 78 | $ 3,736.20 |
| Smoothie City | 125 | $ 84.00 | $ 38.40 | $ 65.55 | 0 | 125 | 0 | 125 | $ 4,800.00 |
| Burger Barn | 187 | $ 86.65 | $ 25.40 | $ 13.90 | 0 | 0 | 187 | 187 | $ 2,599.30 |
| Caf Organic | 313 | $ 108.95 | $ 21.50 | $ 33.95 | 313 | 0 | 0 | 313 | $ 34,101.35 |
| Dessert Center | 567 | $ 116.45 | $ 7.95 | $ 26.20 | 567 | 0 | 0 | 567 | $ 66,027.15 |
| Total | 1330 | 940 | 125 | 265 | 1330 | $ 12,350.50 | |||
| Initial Inventory | 1,005 | 335 | 275 | 1,615 | |||||
| Remaining Inventory | 65 | 210 | 10 | 285 | |||||
| Infeasible Constraints | |||||||||
| Number Shipped (F5:H9) | int | Integer | |||||||
| Shipped (I5:I9) | >= | Demand (B5:B12) | |||||||
| Total Costs (J10) | <= | 12,000 | |||||||
| Constraints with Solution | |||||||||
| Number Shipped (F5:H9) | int | Integer | |||||||
| Shipped (I5:I9) | >= | Demand (B5:B12) | |||||||
| Review of Model: | |||||||||
| Ingredients R US, Inc. provides the raw materials for food preparation to several local eateries. | |||||||||
| The ingredients are ordered by pallet and transported from one of three distribution centers. | |||||||||
| Depending on order type, the nearest distribution center cannot always be utilized to fill orders. | |||||||||
| Ingredients R US, Inc. has tasked you with satisfying demand while minizing total cost to ship product to customers. | |||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
The Partnership And Alliances Audit
Authors: David Connell, Peter J. LaPlaca, Kenneth Wexler
1st Edition
1907766065, 978-1907766060
