2010暑期数学建模A_Excel的应用

Table 1.1

Capacity

(in hours per

week)

Engine 120

321Body 80

123

Standard finishing 96

2Fancy finishing 102

3Luxury finishing 40

2Contribution (Profit)$840$1,120$1,200Question:

find the proudct mix that maximize the total contribution earned per week.

Solution:

Step 1: Build up the optimization model.

Manufacturing Times

(in hours per vehicle)

Shop Standard (S)Fancy (F)Luxury (L)

Step 2: complete the corresponding spreadsheet.

120809610240Step 3: use solver to find the optimal solution. .

0,0,0,

402,

1023,

962,

80321,

120123.

.12001120840),,(:

≥≥≥≤≤≤≤++≤++++=L F S L F S L F S L F S T S L

F S L F S on Contributi Maximize