Question

IN EXCEL Q1 The Krampf Lines Railway Company specializes in coal handling. On Friday, April 13, Krampf had empty cars at the following towns in the quantities indicated:

TOWN

SUPPLY OF CARS

Morgantown

35

Youngstown

60

Pittsburgh

25

By Monday, April 16, the following towns will need coal cars as follows:

TOWN

DEMAND FOR CARS

Coal Valley

30

Coaltown

45

Coal Junction

25

Coalsburg

20

Using a railway city-to-city distance chart, the dispatcher constructs a mileage table for the preceding towns. The result is shown in the table below. Minimizing total miles over which cars are moved to new locations, compute the best shipment of coal cars.

                      TO

COAL VALLEY

COALTOWN

COAL JUNCTION

COALSBURG

FROM

MORGANTOWN

50

30

60

70

YOUNGSTOWN

20

80

10

90

PITTSBURGH

100

40

80

30

Answer 1

From the given problem

The krampf lines railway company specializes in coal handling. On friday, April 13, krampf had empty cars at the following towns in the quantities indicates:-

Town

Supply of cars

Morgantown

35

Youngstown

60

pitlsburgh

25

Avaliability of cars is less than demand. Therefore, all the demand cannot be met. So constriaint is formulated to utilise the supply fully.