1 B C D E F G H I J K L M N 0 Format...

Transcribed Image Text:

1 B C D E F G H I J K L M N 0 Format Shape X 2 3 Four Winds Energy Boreas Wind Turbine Product Mix Solver Parameters Set Objective SFSZ 4 Products 5 Price per unit 6 Material cost per unit Boreas 12X $1,139 $515 Boreas 24X $1,339 Boreas 48X $1,539 Assembly Available Used Internal ladder 4,477 4,238 Remaining 239 To: Max O Min Value Of $650 $725 Tower shell 3,352 3,284 68 7 Manufacturing cost per unit $225 $300 $350 Blade pitch control 1,759 1,698 61 8 Drive shaft 2,078 2,031 47 9 Even product mix 1,584 1,584 1,582 Fiberglass nacelle 3,760 3,566 194 10 Optimal product mix Gear box 1,536 1,499 37 By Changing Variable Cells: $C$10SE$10 Subject to the Constraints: $C$10-SE$10-1200 $C$18 4750 Add 11 Change (1,584) (1,584) (1,582) Yaw drive 1,473 1,408 65 SE$10 = integer Change 12 Blades 4,505 4,287 218 13 Revenue even mix $ 14 Revenue optimal mix $ 1,804,176 $ $ 2,120,976 $ 2,434,698 $ Utility box 1,863 1,752 111 Delete 15 Change (1,804.176) (2,120,976) (2,434,698) 16 Solver Results Beset All Load/Save 17 Summary Even Mix Optimal Mix Difference % Difference 18 Units sold 4,750 (4,750) (100.00%) Make Unconstrained Variables Non-Negative 19 Total revenue $ 6,359,850 $ (6,359,850) (100.00%) 20 Total material cost 2,992,310 (2,992,310) (100.00%) Select a Solving Method: GRG Nonlinear Options 21 Total manufacturing cost 1,385,300 (1,385,300) (100.00%) 22 Total fixed expenses 1,678,500 1,678,500 0 23 Net income $ 303,740 $ (1,678,500) 0.00% (1,982,240) (652.61%) 24 Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth 25 26 Help Close Solve 27 28 29 30 1 1 B C D E F G H I J K L M N 0 Format Shape X 2 3 Four Winds Energy Boreas Wind Turbine Product Mix Solver Parameters Set Objective SFSZ 4 Products 5 Price per unit 6 Material cost per unit Boreas 12X $1,139 $515 Boreas 24X $1,339 Boreas 48X $1,539 Assembly Available Used Internal ladder 4,477 4,238 Remaining 239 To: Max O Min Value Of $650 $725 Tower shell 3,352 3,284 68 7 Manufacturing cost per unit $225 $300 $350 Blade pitch control 1,759 1,698 61 8 Drive shaft 2,078 2,031 47 9 Even product mix 1,584 1,584 1,582 Fiberglass nacelle 3,760 3,566 194 10 Optimal product mix Gear box 1,536 1,499 37 By Changing Variable Cells: $C$10SE$10 Subject to the Constraints: $C$10-SE$10-1200 $C$18 4750 Add 11 Change (1,584) (1,584) (1,582) Yaw drive 1,473 1,408 65 SE$10 = integer Change 12 Blades 4,505 4,287 218 13 Revenue even mix $ 14 Revenue optimal mix $ 1,804,176 $ $ 2,120,976 $ 2,434,698 $ Utility box 1,863 1,752 111 Delete 15 Change (1,804.176) (2,120,976) (2,434,698) 16 Solver Results Beset All Load/Save 17 Summary Even Mix Optimal Mix Difference % Difference 18 Units sold 4,750 (4,750) (100.00%) Make Unconstrained Variables Non-Negative 19 Total revenue $ 6,359,850 $ (6,359,850) (100.00%) 20 Total material cost 2,992,310 (2,992,310) (100.00%) Select a Solving Method: GRG Nonlinear Options 21 Total manufacturing cost 1,385,300 (1,385,300) (100.00%) 22 Total fixed expenses 1,678,500 1,678,500 0 23 Net income $ 303,740 $ (1,678,500) 0.00% (1,982,240) (652.61%) 24 Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth 25 26 Help Close Solve 27 28 29 30 1