The The Grand Prix Automobile Company manufactures automobiles in three plants and then ships them to...

Transcribed Image Text:

The The Grand Prix Automobile Company manufactures automobiles in three plants and then ships them to four regions of the country. The plants can supply the amounts listed in the right column of Table 5.1. The customer demands by region are listed in the bottom row of this table, and the unit costs of shipping an automobile from each plant to each region are listed in the middle of the table. Grand Prix wants to find the lowest-cost shipping plan for meeting the demands of the four regions without exceeding the capacities of the plants. Table 5.1 Input Data for Grand Prix Example Region 1 Region 2 Region 3 Plant 1 Plant 2 Plant 3 Demand 131 250 178 450 218 116 132 200 266 263 122 300 Region 4 120 278 180 300 Capacity 450 600 500 Objective To develop a spreadsheet optimization model that finds the least-cost way of shipping the automobiles from plants to regions, staying within plant capacities and meet- ing regional demands. Q/Write an appropriate mathematical model for this problem including Decision V description, Objective Function, & Constraints. The The Grand Prix Automobile Company manufactures automobiles in three plants and then ships them to four regions of the country. The plants can supply the amounts listed in the right column of Table 5.1. The customer demands by region are listed in the bottom row of this table, and the unit costs of shipping an automobile from each plant to each region are listed in the middle of the table. Grand Prix wants to find the lowest-cost shipping plan for meeting the demands of the four regions without exceeding the capacities of the plants. Table 5.1 Input Data for Grand Prix Example Region 1 Region 2 Region 3 Plant 1 Plant 2 Plant 3 Demand 131 250 178 450 218 116 132 200 266 263 122 300 Region 4 120 278 180 300 Capacity 450 600 500 Objective To develop a spreadsheet optimization model that finds the least-cost way of shipping the automobiles from plants to regions, staying within plant capacities and meet- ing regional demands. Q/Write an appropriate mathematical model for this problem including Decision V description, Objective Function, & Constraints.

Answer rating: 100% (QA)

To develop a mathematical model for the Grand Prix shipping problem we can define the following vari... View the full answer