1. IMSE Farm supplies apples directly from their two farms (A and B) to the three grocery stores (1, 2, and 3), where th

[answerhappygod]

1 Imse Farm Supplies Apples Directly From Their Two Farms A And B To The Three Grocery Stores 1 2 And 3 Where Th 1 (113.53 KiB) Viewed 53 times

1. IMSE Farm supplies apples directly from their two farms (A and B) to the three grocery stores (1, 2, and 3), where the transportation is operated by a logistics service provider. The two farms are very large that they can supply any quantity of apples whenever needed. The following table shows the unit costs of shipping apples from the farms to the grocery stores and the daily demand for apples at each grocery store. Grocery Store Shipping Cost (per kg) 1 2 3 A 18 23 32 B 30 20 28 Demand (kg) 110 120 50 Every day, there is exactly one scheduled truck, operated by the logistics service provider, going from each farm to each grocery store for a single trip. Due to the load capacity of the truck, only 80kg of apples can be carried on a trip. What is the minimum-cost transportation plan? a. [15marks] Please use an appropriate network optimization technique to solve the problem manually. b. [10marks] Please formulate it as a linear program and use Excel Solver Add-in to solve it.