Assignment: Prescriptive Modeling Solver
Ingredients R US, Inc. Order Distribution Plan
Shipping Costs from Distribution Center (per pallet) Number of 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.
Format your assignment according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the assignment, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.