USE EXCEL TO SOLVE:

Instructions:

Ingredients R US$,$ Inc. provides the raw materials for food preparation to several local eateries.

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 formulas in cells $14-19$ and $J10.$

Include the Answer Report for your solver model.