Page 27 - Métodos Cuantitativos para Negocios 2
P. 27
Example 2: Olympic Bike Co.
Partial Spreadsheet Showing Solution
A A B B C C D D
6 6 Decision Variables
Decision Variables
7 7 Deluxe Professional
Deluxe
Professional
8 8 Bikes Made 15 17.500
17.500
15
Bikes Made
9 9
10 Maximized Total Profit 412.500
412.500
Maximized Total Profit
10
11
11
12 Constraints
12 Constraints Amount Used Amount Avail.
Amount Avail.
Amount Used
13 Aluminum 100 <= 100
13 Aluminum
<=
100
100
14 Steel 80 <= 80
80
80
<=
14 Steel
Lámina 27
