How does your solution from part a change?  interpret the impact of these .Determine which projects should be selected to maximize the total NPV.

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 (in cartons) as

listed below. Six of these sites currently act as warehouses, shipping to other regional centers and

these are designated by (W).

Center Albq.

(W)

Boise Dallas

(W)

Denver

(W)

Houston

(W)

OKC Phoenix

(W)

SLC SanAnt.

(W)

Wichita

Volume 3,200 2,500 6,800 4,000 9,600 3,500 5,000 1,800 7,400 2,700

Because these properties have been acquired under different circumstances, Levinson Food is

considering if they were to keep all of these warehouses or change the distribution plan. The

monthly capacities and monthly operating costs are summarized as follows:

Current Warehouses Capacity Fixed Operating Cost

Albuquerque 16,000 $140,000

Dallas 20,000 $150,000

Denver 10,000 $100,000

Houston 10,000 $110,000

Phoenix 12,000 $125,000

San Antonio 10,000 $120,000

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.

The managers have examined various possibilities and have proposed five projects to

consider. The projects cover a variety of activities, as listed below:

P1: Implement a new information system.

P2: License a new technology from another firm.

P3: Build a state-of-the-art recycling facility.

P4: Install an automated machining center in production.

P5: Move the receiving department to new facilities on site.

There is just one project of each type. Each project has an estimated net present value (NPV)

and each requires a capital expenditure, which must come out of the allocated budget. The

following table summarizes the possibilities, with all figures in millions of dollars:

Projects

P1 P2 P3 P4 P5

NPV 10 17 16 8 14

Expenditure 48 96 80 32 64

The committee would like to maximize the total NPV from projects selected, subject to the

budget limit of $160 million.

a) Determine which projects should be selected to maximize the total NPV.

b) If at most one of Project 3 and Project 4 can be selected AND Project 4 requires

Project 5, how does your solution from part a change?  interpret the impact of these

changes on your solution.