Statistic Problems

1)Levinson Foods is in the process of expanding its distribution system. After some planned acquisitions, the company will have ten regional centers, with monthly volumes.
Information, compiled showing the cost per carton of shipping from each warehouse to any regional center in the system, is shared under the Excel template.

a) Assuming that all of the six warehouses stay open,determine the distribution plan and its corresponding cost.

b) If some warehouses could be closed, what would be the cost minimizing new distribution plan?

c) Discuss the differences in solutions from part (a) and part (b). What are implications?

2)Majestic Enterprises is considering a investing $160 million for capital projects this year.
a) Determine which projects should be selected to maximize the total NPV.