Which of the alternatives is preferable.
Answer to Problem 100P
The option to be selected is Solar Collector Field, since it results in a higher overall
Explanation of Solution
Given information:
Installation Cost:
Flat Solar Panels$87 Million
Mechanized Solar Panels $101 Million
Solar Collector Field $91 Million
Annual Operation and Maintenance costs (year 1):
Flat Solar Panels $2 Million
Mechanized Solar Panels $2.3 Million
Solar Collector Field $3 Million
Increase in Annual Operation and Maintenance costs (year 2 onwards):
Flat Solar Panels $250,000
Mechanized Solar Panels $300,000
Solar Collector Field $350,000
Annual Revenues in the form of Electricity
Flat Solar Panels $6.9 Million
Mechanized Solar Panels $8.8 Million
Solar Collector Field $9.7 Million
Annual Increase in Revenues:
Flat Solar Panels8%
Mechanized Solar Panels 8%
Solar Collector Field 8%
Useful Life: 20 Years
Rate of Interest for calculation: 10%.
Based on the above information, the following tables outlines the
Flat Solar Panels:
Year | Cash Flows | Cash Inflows | Cash Flows | Net Cash Flows | P.V. @10% | Amount | |
0 | Electricity Benefits | $ - | Initial Cost | $ 87,000,000.00 | $ (87,000,000.00) | 1 | $ (87,000,000.00) |
1 | Electricity Benefits | $6,900,000.00 | Operating Costs | $ 2,000,000.00 | $ 4,900,000.00 | 0.9091 | $ 4,454,590.00 |
2 | Electricity Benefits (8% higher than last year) | $7,452,000.00 | Operating Costs($250,000 higher than previous year) | $ 2,250,000.00 | $ 5,202,000.00 | 0.8264 | $ 4,298,932.80 |
3 | Electricity Benefits (8% higher than last year) | $8,048,160.00 | Operating Costs($250,000 higher than previous year) | $ 2,500,000.00 | $ 5,548,160.00 | 0.7513 | $ 4,168,332.61 |
4 | Electricity Benefits (8% higher than last year) | $8,692,012.80 | Operating Costs($250,000 higher than previous year) | $ 2,750,000.00 | $ 5,942,012.80 | 0.683 | $ 4,058,394.74 |
5 | Electricity Benefits (8% higher than last year) | $9,387,373.82 | Operating Costs($250,000 higher than previous year) | $ 3,000,000.00 | $ 6,387,373.82 | 0.6209 | $ 3,965,920.41 |
6 | Electricity Benefits (8% higher than last year) | $ 10,138,363.73 | Operating Costs($250,000 higher than previous year) | $ 3,250,000.00 | $ 6,888,363.73 | 0.5645 | $ 3,888,481.33 |
7 | Electricity Benefits (8% higher than last year) | $ 10,949,432.83 | Operating Costs($250,000 higher than previous year) | $ 3,500,000.00 | $ 7,449,432.83 | 0.5132 | $ 3,823,048.93 |
8 | Electricity Benefits (8% higher than last year) | $ 11,825,387.45 | Operating Costs($250,000 higher than previous year) | $ 3,750,000.00 | $ 8,075,387.45 | 0.4665 | $ 3,767,168.25 |
9 | Electricity Benefits (8% higher than last year) | $ 12,771,418.45 | Operating Costs($250,000 higher than previous year) | $ 4,000,000.00 | $ 8,771,418.45 | 0.4241 | $ 3,719,958.57 |
10 | Electricity Benefits (8% higher than last year) | $ 13,793,131.93 | Operating Costs($250,000 higher than previous year) | $ 4,250,000.00 | $ 9,543,131.93 | 0.3855 | $ 3,678,877.36 |
11 | Electricity Benefits (8% higher than last year) | $ 14,896,582.48 | Operating Costs($250,000 higher than previous year) | $ 4,500,000.00 | $ 10,396,582.48 | 0.3505 | $ 3,644,002.16 |
12 | Electricity Benefits (8% higher than last year) | $ 16,088,309.08 | Operating Costs($250,000 higher than previous year) | $ 4,750,000.00 | $ 11,338,309.08 | 0.3186 | $ 3,612,385.27 |
13 | Electricity Benefits (8% higher than last year) | $ 17,375,373.81 | Operating Costs($250,000 higher than previous year) | $ 5,000,000.00 | $ 12,375,373.81 | 0.2897 | $ 3,585,145.79 |
14 | Electricity Benefits (8% higher than last year) | $ 18,765,403.71 | Operating Costs($250,000 higher than previous year) | $ 5,250,000.00 | $ 13,515,403.71 | 0.2633 | $ 3,558,605.80 |
15 | Electricity Benefits (8% higher than last year) | $ 20,266,636.01 | Operating Costs($250,000 higher than previous year) | $ 5,500,000.00 | $ 14,766,636.01 | 0.2394 | $ 3,535,132.66 |
16 | Electricity Benefits (8% higher than last year) | $ 21,887,966.89 | Operating Costs($250,000 higher than previous year) | $ 5,750,000.00 | $ 16,137,966.89 | 0.2176 | $ 3,511,621.59 |
17 | Electricity Benefits (8% higher than last year) | $ 23,639,004.24 | Operating Costs($250,000 higher than previous year) | $ 6,000,000.00 | $ 17,639,004.24 | 0.1978 | $ 3,488,995.04 |
18 | Electricity Benefits (8% higher than last year) | $ 25,530,124.58 | Operating Costs($250,000 higher than previous year) | $ 6,250,000.00 | $ 19,280,124.58 | 0.1799 | $ 3,468,494.41 |
19 | Electricity Benefits (8% higher than last year) | $ 27,572,534.54 | Operating Costs($250,000 higher than previous year) | $ 6,500,000.00 | $ 21,072,534.54 | 0.1635 | $ 3,445,359.40 |
20 | Electricity Benefits (8% higher than last year) | $ 29,778,337.31 | Operating Costs($250,000 higher than previous year) | $ 6,750,000.00 | $ 23,028,337.31 | 0.1486 | $ 3,422,010.92 |
Net Present Value | $ (11,904,541.97) |
Mechanized Solar Panels:
Year | Cash Flows | Cash Inflows | Cash Flows | Cash Outflows | Net Cash Flows | P.V. @10% | Amount |
0 | Electricity Benefits | $ - | Initial Cost | $ 101,000,000.00 | $ (101,000,000.00) | 1 | $ (101,000,000.00) |
1 | Electricity Benefits (8% higher than last year) | $ 8,800,000.00 | Operating Costs | $ 2,300,000.00 | $ 6,500,000.00 | 0.9091 | $ 5,909,150.00 |
2 | Electricity Benefits (8% higher than last year) | $ 9,504,000.00 | Operating Costs($300,000 higher than previous year) | $ 2,600,000.00 | $ 6,904,000.00 | 0.8264 | $ 5,705,465.60 |
3 | Electricity Benefits (8% higher than last year) | $ 10,264,320.00 | Operating Costs($300,000 higher than previous year) | $ 2,900,000.00 | $ 7,364,320.00 | 0.7513 | $ 5,532,813.62 |
4 | Electricity Benefits (8% higher than last year) | $ 11,085,465.60 | Operating Costs($300,000 higher than previous year) | $ 3,200,000.00 | $ 7,885,465.60 | 0.683 | $ 5,385,773.00 |
5 | Electricity Benefits (8% higher than last year) | $ 11,972,302.85 | Operating Costs($300,000 higher than previous year) | $ 3,500,000.00 | $ 8,472,302.85 | 0.6209 | $ 5,260,452.84 |
6 | Electricity Benefits (8% higher than last year) | $ 12,930,087.08 | Operating Costs($300,000 higher than previous year) | $ 3,800,000.00 | $ 9,130,087.08 | 0.5645 | $ 5,153,934.15 |
7 | Electricity Benefits (8% higher than last year) | $ 13,964,494.04 | Operating Costs($300,000 higher than previous year) | $ 4,100,000.00 | $ 9,864,494.04 | 0.5132 | $ 5,062,458.34 |
8 | Electricity Benefits (8% higher than last year) | $ 15,081,653.57 | Operating Costs($300,000 higher than previous year) | $ 4,400,000.00 | $ 10,681,653.57 | 0.4665 | $ 4,982,991.39 |
9 | Electricity Benefits (8% higher than last year) | $ 16,288,185.85 | Operating Costs($300,000 higher than previous year) | $ 4,700,000.00 | $ 11,588,185.85 | 0.4241 | $ 4,914,549.62 |
10 | Electricity Benefits (8% higher than last year) | $ 17,591,240.72 | Operating Costs($300,000 higher than previous year) | $ 5,000,000.00 | $ 12,591,240.72 | 0.3855 | $ 4,853,923.30 |
11 | Electricity Benefits (8% higher than last year) | $ 18,998,539.98 | Operating Costs($300,000 higher than previous year) | $ 5,300,000.00 | $ 13,698,539.98 | 0.3505 | $ 4,801,338.26 |
12 | Electricity Benefits (8% higher than last year) | $ 20,518,423.17 | Operating Costs($300,000 higher than previous year) | $ 5,600,000.00 | $ 14,918,423.17 | 0.3186 | $ 4,753,009.62 |
13 | Electricity Benefits (8% higher than last year) | $ 22,159,897.03 | Operating Costs($300,000 higher than previous year) | $ 5,900,000.00 | $ 16,259,897.03 | 0.2897 | $ 4,710,492.17 |
14 | Electricity Benefits (8% higher than last year) | $ 23,932,688.79 | Operating Costs($300,000 higher than previous year) | $ 6,200,000.00 | $ 17,732,688.79 | 0.2633 | $ 4,669,016.96 |
15 | Electricity Benefits (8% higher than last year) | $ 25,847,303.89 | Operating Costs($300,000 higher than previous year) | $ 6,500,000.00 | $ 19,347,303.89 | 0.2394 | $ 4,631,744.55 |
16 | Electricity Benefits (8% higher than last year) | $ 27,915,088.20 | Operating Costs($300,000 higher than previous year) | $ 6,800,000.00 | $ 21,115,088.20 | 0.2176 | $ 4,594,643.19 |
17 | Electricity Benefits (8% higher than last year) | $ 30,148,295.26 | Operating Costs($300,000 higher than previous year) | $ 7,100,000.00 | $ 23,048,295.26 | 0.1978 | $ 4,558,952.80 |
18 | Electricity Benefits (8% higher than last year) | $ 32,560,158.88 | Operating Costs($300,000 higher than previous year) | $ 7,400,000.00 | $ 25,160,158.88 | 0.1799 | $ 4,526,312.58 |
19 | Electricity Benefits (8% higher than last year) | $ 35,164,971.59 | Operating Costs($300,000 higher than previous year) | $ 7,700,000.00 | $ 27,464,971.59 | 0.1635 | $ 4,490,522.86 |
20 | Electricity Benefits (8% higher than last year) | $ 37,978,169.32 | Operating Costs($300,000 higher than previous year) | $ 8,000,000.00 | $ 29,978,169.32 | 0.1486 | $ 4,454,755.96 |
Net Present Value | $ (2,047,699.18) |
Solar Collector Field:
Year | Cash Flows | Cash Inflows | Cash Flows | Cash Outflows | Net Cash Flows | P.V. @10% | Amount |
0 | Electricity Benefits | $ - | Initial Cost | $ 91,000,000.00 | $ (91,000,000.00) | 1 | $ (91,000,000.00) |
1 | Electricity Benefits (8% higher than last year) | $ 9,700,000.00 | Operating Costs | $ 3,000,000.00 | $ 6,700,000.00 | 0.9091 | $ 6,090,970.00 |
2 | Electricity Benefits (8% higher than last year) | $ 10,476,000.00 | Operating Costs($350,000 higher than previous year) | $ 3,350,000.00 | $ 7,126,000.00 | 0.8264 | $ 5,888,926.40 |
3 | Electricity Benefits (8% higher than last year) | $ 11,314,080.00 | Operating Costs($350,000 higher than previous year) | $ 3,700,000.00 | $ 7,614,080.00 | 0.7513 | $ 5,720,458.30 |
4 | Electricity Benefits (8% higher than last year) | $ 12,219,206.40 | Operating Costs($350,000 higher than previous year) | $ 4,050,000.00 | $ 8,169,206.40 | 0.683 | $ 5,579,567.97 |
5 | Electricity Benefits (8% higher than last year) | $ 13,196,742.91 | Operating Costs($350,000 higher than previous year) | $ 4,400,000.00 | $ 8,796,742.91 | 0.6209 | $ 5,461,897.67 |
6 | Electricity Benefits (8% higher than last year) | $ 14,252,482.34 | Operating Costs($350,000 higher than previous year) | $ 4,750,000.00 | $ 9,502,482.34 | 0.5645 | $ 5,364,151.28 |
7 | Electricity Benefits (8% higher than last year) | $ 15,392,680.93 | Operating Costs($350,000 higher than previous year) | $ 5,100,000.00 | $ 10,292,680.93 | 0.5132 | $ 5,282,203.85 |
8 | Electricity Benefits (8% higher than last year) | $ 16,624,095.41 | Operating Costs($350,000 higher than previous year) | $ 5,450,000.00 | $ 11,174,095.41 | 0.4665 | $ 5,212,715.51 |
9 | Electricity Benefits (8% higher than last year) | $ 17,954,023.04 | Operating Costs($350,000 higher than previous year) | $ 5,800,000.00 | $ 12,154,023.04 | 0.4241 | $ 5,154,521.17 |
10 | Electricity Benefits (8% higher than last year) | $ 19,390,344.88 | Operating Costs($350,000 higher than previous year) | $ 6,150,000.00 | $ 13,240,344.88 | 0.3855 | $ 5,104,152.95 |
11 | Electricity Benefits (8% higher than last year) | $ 20,941,572.47 | Operating Costs($350,000 higher than previous year) | $ 6,500,000.00 | $ 14,441,572.47 | 0.3505 | $ 5,061,771.15 |
12 | Electricity Benefits (8% higher than last year) | $ 22,616,898.27 | Operating Costs($350,000 higher than previous year) | $ 6,850,000.00 | $ 15,766,898.27 | 0.3186 | $ 5,023,333.79 |
13 | Electricity Benefits (8% higher than last year) | $ 24,426,250.13 | Operating Costs($350,000 higher than previous year) | $ 7,200,000.00 | $ 17,226,250.13 | 0.2897 | $ 4,990,444.66 |
14 | Electricity Benefits (8% higher than last year) | $ 26,380,350.14 | Operating Costs($350,000 higher than previous year) | $ 7,550,000.00 | $ 18,830,350.14 | 0.2633 | $ 4,958,031.19 |
15 | Electricity Benefits (8% higher than last year) | $ 28,490,778.16 | Operating Costs($350,000 higher than previous year) | $ 7,900,000.00 | $ 20,590,778.16 | 0.2394 | $ 4,929,432.29 |
16 | Electricity Benefits (8% higher than last year) | $ 30,770,040.41 | Operating Costs($350,000 higher than previous year) | $ 8,250,000.00 | $ 22,520,040.41 | 0.2176 | $ 4,900,360.79 |
17 | Electricity Benefits (8% higher than last year) | $ 33,231,643.64 | Operating Costs($350,000 higher than previous year) | $ 8,600,000.00 | $ 24,631,643.64 | 0.1978 | $ 4,872,139.11 |
18 | Electricity Benefits (8% higher than last year) | $ 35,890,175.13 | Operating Costs($350,000 higher than previous year) | $ 8,950,000.00 | $ 26,940,175.13 | 0.1799 | $ 4,846,537.51 |
19 | Electricity Benefits (8% higher than last year) | $ 38,761,389.14 | Operating Costs($350,000 higher than previous year) | $ 9,300,000.00 | $ 29,461,389.14 | 0.1635 | $ 4,816,937.12 |
20 | Electricity Benefits (8% higher than last year) | $ 41,862,300.27 | Operating Costs($350,000 higher than previous year) | $ 9,650,000.00 | $ 32,212,300.27 | 0.1486 | $ 4,786,747.82 |
Net Present Value | $ 13,045,300.56 |
Net present value is the difference of Sum of Present values of cash inflows and Sum of Present values of cash outflows. If the value is positive then the project may be accepted. While evaluation of two or more alternatives takes place, then the proposal with the higher net present value may be selected since it results in a greater cash inflow over the duration of the project.
In the given scenario, Present values are calculated by calculating the present values of cash inflows in the form of revenues in the form of electricity and cash outflows such as installation cost and operating cost.
Installation Costs in case of Flat Solar Panels are $87 Million, Mechanized Solar Panels + $101 Million and Solar Collector Field + $91 Million.
Annual Operation and Maintenance costs for year 1, in case of Flat Solar Panels+ $2 Million, Mechanized Solar Panels + $2.3 Million and Solar Collector Field + $3 Million.
Increase Annual Operation and Maintenance costs year 2 onwardsin case ofFlat Solar Panels+ $250,000, Mechanized Solar Panels + $300,000 and Solar Collector Field + $350,000.
Annual Revenues in the form of Electricity in case of Flat Solar Panels + $6.9Million, Mechanized Solar Panels + $8.8 Million and Solar Collector Field + $9.7 Million
Annual Increase in Revenues is 8% in case of all alternatives and the Useful Life is 20 Years. Rate of Interest for calculation is considered as 10%
Present value factor is calculated as 1/1.10 ^ N where N is the year of operation.
Conclusion:
Hence the option to be selected is Flat Solar Panels since it results in higher overall cash flow for a period of 20 years.
Want to see more full solutions like this?
Chapter 5 Solutions
ENGINEERING ECONOMIC ENHANCED EBOOK
- What challenges do medical facilities face when trying to become more culturally competent? What kinds of assumptions do providers sometimes make about people from other cultures? What factors may cause providers to relate to patients in a biased manner? What can healthcare organizations do to ensure cultural competence among their employees?arrow_forwardBrazil, Russia, India, China, and South Africa, also known as BRICS, are emerging countries poised to be dominant economic players in the 21st century. What are some of the political, legal and economic conditions that help or hinder economic expansion for these countries?arrow_forwardExplain what is Microeconomics? Why is it important for all of us to understand what are the drivers in microeconomics?arrow_forward
- The production function for a product is given by Q =100KL.if the price of capital is 120 dollars per day and the price of labor 30 dollars per day what is the minimum cost of producing 1000 units of output ?arrow_forwardخصائص TVAarrow_forwardplease show complete solution, step by step, thanksarrow_forward
- To determine the benefits of extending hours of operation for a food truck business, the couple should calculate additional revenue, break-even analysis, market demand, and raise prices. They should analyze competitors' prices and customer sensitivity to price changes, determine price elasticity, and test the strategy by implementing a slight price increase and monitoring sales closely. If costs exceed revenues, the couple should analyze their financials, evaluate their business model, explore new revenue streams, and consider long-term viability. They should analyze their financial statements to identify high costs and areas for reduction, evaluate their business model based on market demand, and explore new revenue streams like catering, special events, or partnerships with local businesses. Long-term viability is a key consideration, as if the business still operates at a loss after making adjustments, it may be necessary to consider shutting down. Staying in business should be…arrow_forwardRespond to following post. You can charge higher prices if the parents think these are valuable by providing different services such as extended hours, healthy lunches, and smaller staff-to-child ratios. But pushing for prices much higher won’t make sense unless parents think the added value is worth the price hike. You should research your local parents to find out what they want. If you want your business to be profitable, then focus on your strengths, do great work and have a reputation. Promote your special products and keep your prices low. If you want to see if you’re making money, keep a log of all your profits and losses. You’re making money if you’re earning more than you’re losing. A break-even analysis can help you figure out how many customers you need to eat and start making money. Keep an eye on your budget so you don’t get off track.arrow_forwardIf you are willing to pay up to $8 for your first cup of coffee the blank of your first cup of coffee is $8arrow_forward
- not use ai pleasearrow_forward(Figure: Good Y and Good X) Suppose the budget constraint shifted from constraint 2 to constraint 1. What could have caused this change? Quantity of good Y 18 16 14 Budget constraint 2 12- 10 8 Budget constraint 1 6 4 2 0 2 4 6 8 10 12 14 16 18 20 Quantity of good X an increase in income and an decrease in the price of good X relative to that of good Y a decrease in income an decrease in the price of good X and no change in the price of Y a decrease in income and an increase in the price of good X relative to that of good Y an increase in income a decrease in the price of good X relative to that of good Yarrow_forwardSuppose you have the three scenarios proposed below. Using the language of the Levy and Meltzer paper, Scenario(s). Scenario(s) _ can best be described as a randomized experiment. can best be described as an observational study, and Scenario A: Researchers randomly assign some individuals to a high-intensity workout program and others to a low-intensity program. They then track the participants to see how their cardiovascular health changes over time. Scenario B: Researchers randomly assign individuals to receive varying levels of nutrition education. They track participants and see how eating habits changed. Scenario C: Researchers have data on individuals' workout habits and their cardiovascular health. They use this data to describe the relationship between workout intensity and cardiovascular health. A; B and C A; B and C × A and B; C C; A and B B and C; Aarrow_forward
- Principles of Economics (12th Edition)EconomicsISBN:9780134078779Author:Karl E. Case, Ray C. Fair, Sharon E. OsterPublisher:PEARSONEngineering Economy (17th Edition)EconomicsISBN:9780134870069Author:William G. Sullivan, Elin M. Wicks, C. Patrick KoellingPublisher:PEARSON
- Principles of Economics (MindTap Course List)EconomicsISBN:9781305585126Author:N. Gregory MankiwPublisher:Cengage LearningManagerial Economics: A Problem Solving ApproachEconomicsISBN:9781337106665Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike ShorPublisher:Cengage LearningManagerial Economics & Business Strategy (Mcgraw-...EconomicsISBN:9781259290619Author:Michael Baye, Jeff PrincePublisher:McGraw-Hill Education