country- New York, Atlanta, Chicago, San Diego fixed costs are $9,200,000. Chicago to the West Coast ($270)(F24). Finally, the table shows the demand requirements for each region. (Column J) keep fixed cost low. The total cost of this network solution is $132,870,000. (Cell J30) What other solutions are feasible? Is there a solution that is optimal with the lowest cost? How to use the worksheet Only enter data in the grey or yellow cells Select site capacity by putting a ' 1 ' in either the 'Small' or 'Large', Select only one size site. A site can be 'shut down' if there is no '1' in either yellow box. Enter the amount to ship to the region from the site to satisfy regional demand; Do not exceed the demand for the region (Number can be from 0 to value in column J ) Constraints A plant cannot ship (sum of gray boxes)more than it's capacity (200,000 or 400,000) A region can receive shipments from multiple sites but the shipments must equal the regional demand (Column J) Regional facility BIGSTOCK Demand by Region 180,000 110,000 country- New York, Atlanta, Chicago, San Diego fixed costs are $9,200,000. Chicago to the West Coast ($270)(F24). Finally, the table shows the demand requirements for each region. (Column J) keep fixed cost low. The total cost of this network solution is $132,870,000. (Cell J30) What other solutions are feasible? Is there a solution that is optimal with the lowest cost? How to use the worksheet Only enter data in the grey or yellow cells Select site capacity by putting a ' 1 ' in either the 'Small' or 'Large', Select only one size site. A site can be 'shut down' if there is no '1' in either yellow box. Enter the amount to ship to the region from the site to satisfy regional demand; Do not exceed the demand for the region (Number can be from 0 to value in column J ) Constraints A plant cannot ship (sum of gray boxes)more than it's capacity (200,000 or 400,000) A region can receive shipments from multiple sites but the shipments must equal the regional demand (Column J) Regional facility BIGSTOCK Demand by Region 180,000 110,000