Window Help MGMT3901 HW Excel & Integer Problems 3. Sally's Snack Company is considering adding an additional plant to its three existing plants in Virginia, Tennessee, and Ohio. It is considering two locations: North Carolina and South Carolina The table below shows the information on the costs per pallet. a. Which location would you recommend and why? b. Suppose that the North Carolina location has been selected. In order to ensure a fresh product, the company wished to restrict the number of pallets shipped from any one plant to a single location to 100. To accomplish this, they will accept a 10% surcharge on the shipment of their products. How does this change their optimal plan? How much would it cost to increase total costs 10%? This will become a new constraint in this problem You will also have to add a pallet constraint for each location Shipped From Total Demand Ohio South Carolina $27 Virginia $20 $25 North Carolina $29 $30 Shipped to Pennsylvania W. Virginia Georgia Capacity $21 250 Tennessee $17 $27 $25 200 $28 $20 $22 200 350 S30 $31 300 150 130 Window Help MGMT3901 HW Excel & Integer Problems 3. Sally's Snack Company is considering adding an additional plant to its three existing plants in Virginia, Tennessee, and Ohio. It is considering two locations: North Carolina and South Carolina The table below shows the information on the costs per pallet. a. Which location would you recommend and why? b. Suppose that the North Carolina location has been selected. In order to ensure a fresh product, the company wished to restrict the number of pallets shipped from any one plant to a single location to 100. To accomplish this, they will accept a 10% surcharge on the shipment of their products. How does this change their optimal plan? How much would it cost to increase total costs 10%? This will become a new constraint in this problem You will also have to add a pallet constraint for each location Shipped From Total Demand Ohio South Carolina $27 Virginia $20 $25 North Carolina $29 $30 Shipped to Pennsylvania W. Virginia Georgia Capacity $21 250 Tennessee $17 $27 $25 200 $28 $20 $22 200 350 S30 $31 300 150 130