The Executive Furniture Corporation is faced with the transportation problem shown in Figure 9.1. The company...

   

Transcribed Image Text:

The Executive Furniture Corporation is faced with the transportation problem shown in Figure 9.1. The company would like to minimize the transportation costs while meeting the demand at each destination and not exceeding the supply at each source. In formulating this as a linear program, there are three supply constraints (one for each source) and three demand constraints (one for each destination). The decisions to be made are the number of units to ship on each route, so there is one decision variable for each arc (arrow) in the network. Let: the network. Let: Supply 100 300 300 Source Des Moines (Source 1) Evansville (Source 2) Fort Lauderdale (Source 3) $3 $8 8 $9 $5 $4 $4 $7 $5 E Destination Albuquerque (Destination 1) D Boston (Destination 2) Cleveland (Destination 3) Demand 300 200 200 ****PLEASE SOLVE ON EXCEL ONLY WITH CLEAR AND EASY FORMULATION AND EASY TO UNDERSTAND STEP BY STEP** NOTE** ONLY SOLVE USING EXCEL SOLVER WITH EASY METHOD** The Executive Furniture Corporation is faced with the transportation problem shown in Figure 9.1. The company would like to minimize the transportation costs while meeting the demand at each destination and not exceeding the supply at each source. In formulating this as a linear program, there are three supply constraints (one for each source) and three demand constraints (one for each destination). The decisions to be made are the number of units to ship on each route, so there is one decision variable for each arc (arrow) in the network. Let: the network. Let: Supply 100 300 300 Source Des Moines (Source 1) Evansville (Source 2) Fort Lauderdale (Source 3) $3 $8 8 $9 $5 $4 $4 $7 $5 E Destination Albuquerque (Destination 1) D Boston (Destination 2) Cleveland (Destination 3) Demand 300 200 200 ****PLEASE SOLVE ON EXCEL ONLY WITH CLEAR AND EASY FORMULATION AND EASY TO UNDERSTAND STEP BY STEP** NOTE** ONLY SOLVE USING EXCEL SOLVER WITH EASY METHOD**

Answer rating: 100% (QA)

Step 1 First we set up the wo... View the full answer