B D E F 1 2 3 Shipping Cost Per Pallet of Bottled Water Store 1 Store 2 Store 3 Warehouse 1 $4.15 $5.95 $6.25 Warehouse 2 $3.75 $4.25 $8.25 1 Rainier Spring Water has two warehouses that service three retail stores. Per week, the first warehouse can supply up to 160 pallets of bottled water and the second warehouse can supply up to 155 pallets. The manager at Rainier Srping Water receives a weekly order from three retail store for 85, 125 and 100 pallets respectively. Note that the combined capacity of the two warehouses is larger than the total number of pallets of bottled water ordered by the three stores, a required condition for a feasible solution. The shipping cost for each pallet varies among the warehouses and retail stores, depending on the distance, traffic, and road conditions. As shown the table on the right, to ship one pallet of bottled water from wharehouse 1 to the three stores, it would cost $4.15, $5.95, and $6.25 respectively. Likewise, to shop one pallet from warehouse 2 to the three stores, it would cost $3.75, $4.25, and $8.25 respectively. 5 5 7 3 0 1 2. 3 Develop an Linear programming model to help the manager decide how many pallets of bottled water to ship from each warehouse to individual stores in order to fulfill the orders while minimizing the total shipping cost. 4 5 1) What are the decision variables? Please use this space to describe. 2) "Note that the combined capacity of the two warehouses is larger than the total number of pallets of bottled water ordered by the three stores, a required condition for a feasible solution. Why the combined capacity has to be larger than the total number of pallets of bottle water ordered as a necessary condition for a feasible solution? 6 7 8 9 o 1 2 3 4 5 6 7 8 9 0 1 2 3 3) If the combined capacity is less than the total demand from these three stores, could you propose a solution to still solve the model with limited capacity? 4) Use the space in this excel sheet to clearly lay out the problem and solve the