Prescriptive Modelling solver

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.