Using Prescriptive Analytics

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.


Choose The Best Assignments Expert who have done on a similar assignment

"Do you have an upcoming essay or assignment due?


Get any topic done in as little as 6 hours

If yes Order Similar Paper

All of our assignments are originally produced, unique, and free of plagiarism.