| 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 | Total Shipped | Total Costs |
| Food Buzz | 60 | $ 20.25 | $ 78.15 | $ 27.15 | $ - 0 |
| Healthy Stuff | 78 | $ 50.85 | $ 50.00 | $ 47.90 | $ - 0 |
| Smoothie City | 125 | $ 84.00 | $ 38.40 | $ 65.55 | $ - 0 |
| Burger Barn | 187 | $ 86.65 | $ 25.40 | $ 13.90 | $ - 0 |
| Café Organic | 313 | $ 108.95 | $ 21.50 | $ 33.95 | $ - 0 |
| Dessert Center | 567 | $ 116.45 | $ 7.95 | $ 26.20 | $ - 0 |
| Total | 1330 | 0 | 0 | 0 | 0 |
| Initial Inventory | 1,005 | 335 | 275 | 1,615 |
| Remaining Inventory | 1,005 | 335 | 275 | 1,615 |
| Constraints |
| Instructions: |
| 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. |
| Demand must be met and there is enough stock to have pallets left over. |
| Complete the model above by adding necessary formulas and populate the constraints table. |
| Create a solver model to meet demand while minimizing total costs. |
Mina8382
DYS545_course_project_Part_Two_A1.xlsx
