Prescriptive modelling solver | Business & Finance homework help

Prescriptive modelling solver | Business & Finance homework help

WE WRITE ESSAYS FOR STUDENTS

Tell us about your assignment and we will find the best writer for your paper.

Write My Essay For Me

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.

The post Prescriptive modelling solver | Business & Finance homework help appeared first on Academic Works Help.