ase right click and open image to view question.

QUESTION 1 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 ATLANTA NEW YORK CITY EAST $ $ $ 5.00 3.20 2.50 3.50 2.60 3.10 SOUTH $ 4.20 $ 1.80 $ 3.30 WEST $ 2.20 $ 4.80 $ 5.40 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, how many pounds of finished product should be sent along the cheapest route? Copy paste the accurate number from your Excel worksheet. Fill in only a number