Exercise 2: Transportation Problem INPUTS C D Unit Cost (in dollars Per Pallet) from Plant to Customer Customer Plant A B Plant 1 $ 7 $ 7 $ 6 $ 4 1 2 $ 4 $ 11 $ 7 $ 2 3 $ 5 $ 10 $ 7 $ 8 3 Customer B D Demands 100 150 100 120 Pallets Supply (# Pallets) 200 200 100 Nm 000 1 Cormory TOTTUTOCLAV prvu CS VITETCIPIOTI 1-; UU ITU - them to four different Customers (A, B, C and D). The cost to ship one unit (one pallet) from each Plant to each Customer is shown below. Unit Cost (in dollars Per Pallet) from Plant to Customer Customer Plant ABCD 1 $ 7 $ 7 $ 6 $ 2 $ 4 $ 11 $ 7 $ 3 $ 5 $ 10 $ 7 $ 8 4 6 Each plant has a capacity (supply) of so many Pallets on hand, and each Customer has a demand of so many Pallets, as shown below. Supply (# Pallets) Plant 1 200 2 200 3 100 Customer ABCD Demands 100 150 100 120 Pallets STEP 1) On the worksheet Exercise 2", formulate and solve an optimization model to MINIMIZE TOTAL SHIPPING COSTS in Excel. Be sure the Solver dialog box is populated and the correct (optimal answer) is displayed in your objective cell when you submit your file. STEP 2) In a cell or textbox in the worksheet containing this problem, indicate HOW MANY of each product should be shipped FROM EACH PLANT TO EACH CUSTOMER. For example, how much should be shipped from Plant 1 to Customer A? From Plant 1 to customer B? etc. (Note there are potentially up to 12 different amounts shipped from three plants to four customers.)