$19**$ Please put into excel sheet form$**$The Lilly Snack Company is considering adding

an additional plant to its three existing facilities in

Wise, Virginia; Humbolt, Tennessee; and Cleveland,

Georgia to serve three large markets in the Southeast.

Two locations$$Brevard$,$ North Carolina, and Laurens,

South Carolina$$are being considered. The trans$-$portation costs per pallet are shown in the table at

the top of the next page.

$($a$)$ Which site would you recommend? Why?

$($b$)$ Suppose that the Brevard location has been selected.

Due to the perishable nature of the goods involved,

management wishes to restrict the maximum num$-$ber of pallets shipped from any one plant to any

single market. To accomplish this, management is

willing to accept a $10\%$ surcharge on their optimal

transportation costs from part $($a$).$ What is the new

transportation plan, and what is the new cost?

Table for Problem $19$

FROM

TO WISE HUMBOLT CLEVELAND BREVARD LAURENS DEMAND

Charlotte $$20$ $$17$ $$21$ $$29$ $$27250$

Greenville $$25$ $$27$ $$20$ $$30$ $$28200$

Atlanta $$22$ $$25$ $$22$ $$30$ $$31350$

Capacity $300200150150150$