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 $-
Healthy Stuff 78 $50.85 $50.00 $47.90 $-
Smoothie City 125 $84.00 $38.40 $65.55 $-
Burger Barn 187 $86.65 $25.40 $13.90 $-
Caf Organic 313 $108.95 $21.50 $33.95 $-
Dessert Center 567 $116.45 $7.95 $26.20 $-
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.
