Edison Electric Auto (EEA) has three plants in San Jose, Detroit, and New Orleans, and three major distribution centers in Denver, Miami, and Norfolk. The quarterly capacities of the three plants are 1500, 2000, and 1800 cars, and the demands at the three distribution centers for the same period are 2200, 1200, and 1700 cars. The mileage chart between the plants and the distribution centers is given in the following table.

The quarterly capacity of these plants are given by 1500, 2000, 1800

The demand of these car at the distribution centers are 2000, 1200, 1700 cars

The mileage chart is given that is between the plant and distribution centers.

The cost of each car is 0.13 dollar per mile by trucking company

To find

The main aim of this problem is to find the ideal transportation plan

Solution

Part 3

Solve the transportation problem using Excel solver

Question 2

Five cargo ships will be used for shipping goods from Norfolk to five ports (labelled 1, 2, 3, 4, and 5, respectively). Any ship can be used any one of these five trips. However, because of differences in the ships and cargoes, the total cost of loading, transporting, and unloading the goods for the different ship-port combinations varies considerably, as shown in the following table:

Part 1

Formulate the problem as an assignment problem.

Solution

Consider

Both pants, shirts and jackets require the work of sewing operators and cutters. There are 60 hours of sewing operator time and 48 hours of cutter time available. It takes 10 minutes to sew one pair of pants, 6 minutes to sew a shirt, and 14 minutes to sew one jacket. Cutters take 6 minutes on pants, 8 minutes on shirts, and 10 minutes on a jacket. Furthermore, each item should undergo a final quality control inspection. An inspection takes 1 minute on pants, 2 minutes on shirts, and 3 minutes on a jacket. There are 12 hours of quality control operator time available.

The problem is to find the maximum profit and the amount of pants, shirts and jackets to maximize the profit.

Part 1

What are the decision variables?

In this the decision variables are

Operating time of swing, cutters, quality control operator, and profit

Part 2

Write the objective function?

For the objective function there is need to solve the equations