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