PLEASE RIGHT CLICK ON THE IMAGE AND OPEN IMAGE IN NEW TAB.

QUESTION 2 4 points Save Answer A pharmaceutical company produces a certain type of medicine in Los Angeles, Atlanta, and New York. Monthly capacity (in pounds) of each site is in the table. Each month, the company must ship to the four regions of the United States-East, Midwest, South, and West. The numbers of pounds listed below are monthly demand of these four regions. The shipping costs per pound are given in the table as well. MIDWEST LA EAST $ $ $ 5.00 3.20 2.50 SOUTH $ 4.20 $ 1.80 $ 3.30 WEST $ 2.20 $ 4.80 $ 5.40 3.50 2.60 3.10 ATLANTA NEW YORK CITY CAPACITY 120 360 150 $ $ DEMAND 230 170 110 120 Use Excel Solver to develop the optimal transportation plan for this company. In your optimal transportation plan, what is the total monthly transportation cost? Copy paste the accurate number from your Excel worksheet. Please note only a number is allowed. No $ sign or other letters/symbols