1 B C D E F G H I J K L M N 0 Format...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
a. Consider the effect of population growth on the allocation on the dynamic efficient allocation of a depletable resource across time. Suppose we have two versions of the two-period model, discussed...
-
A coin slides over a frictionless plane and across an xy coordinate system from the origin to a point with xy coordinates (3.0 m, 4.0 m) while a constant force acts on it. The force has magnitude 2.0...
-
The following table shows the cumulative effects of a succession of separate transactions on the assets and liabilities of a business. Identify clearly and as fully as you can what transaction has...
-
What can organizations do to discourage the ability to be creative and to innovate?
-
Varto Company has 7,000 units of its sole product in inventory that it produced last year at a cost of $22 each. This years model is superior to last years and the 7,000 units cannot be sold at last...
-
Calculus III Sample Midterm 1 - Page 3 of 7 2. (a) (7 points) Recall that the cylindrical coordinates are (r, 0, 2) and that the spherical coor- dinates are (p, 0, $). Consider the surface S in 3D...
-
Stock XXX is currently trading at So= 100 and the price is widely expected to fall. The put option prices therefore start to build up and become quite expensive. You believe that the fear is probably...
-
Can someone help me in answering this question in its entirety and show how you got to the conclusion? The S&P 500 spot is 2,271.31 and it is expected to pay a dividend yield of 3%. The riskfree rate...
-
2) Kevin a CFO of Durant Co. identified five reporting units for goodwill annual impairment test. Kevin knows that goodwill impairment test is a time consuming process. Therefore, he suggested to the...
-
Explain and identify the treatment of the following costs by the future manufacturing company i) Sunk costs in short term decision making and provide an example for such short- term decision making...
-
Loapo Ohyeah and her team are competing in a speed skating relay race having n race segments, where each race segment has integer length. Loapo will skate exactly two of the race segments, and she...
-
A stock that you can purchase for $90 a share, a 110,1 year call option can be sold for $9. The stock pays a $4 annual dividend. If you execute a covered call, and the stock is in the money at the...
-
3 0 ) Naomi wants to deposit a cheque for $ 2 , 0 0 0 into her premium - rate savings account that pays interest of 3 . 1 5 % . Interest is calculated on the daily closing balance and paid at the...
-
Define the term utility software and give two examples.
-
Describe the recording of transactions that begin and end at a particular point in time and the recording of continuous transactions. LO6
-
Describe the effect on the financial statements when an adjustment is prepared that records (a) unrecorded revenue and (b) unrecorded expense. LO11
-
How is the amount for an interest expense (or interest revenue) adjustment determined? LO10
Study smarter with the SolutionInn App