Answered step by step
Verified Expert Solution
Question
1 Approved Answer
if excel is used please provide equations/functions used. thanks Part III Please upload your solutions at CANVAS as an Excel file by midnight, tomorrow night.
if excel is used please provide equations/functions used. thanks
Part III Please upload your solutions at CANVAS as an Excel file by midnight, tomorrow night. 6. The country of Eldorado, population 34 million, area 160,000 sq miles, enjoys fossil fuel resources equivalent to 100 billion barrels of crude oil. Currently, Eldorado's per capita energy use, all from fossil fuel resources, is equivalent to 30 barrels/year. Assume 0.000% population change. a Eldoradoans wish to make their resources last 200 years. To achieve this goal they are implementing series of energy austerity measures. These measures are anticipated to result in an annual energy-use-reduction of r % every year for the 20 following years. The use will remain constant thereafter. Determiner such that the resources do last 200 years. b. An alternative plan calls for extending the resources' lifetime even further by shifting some of the use to renewable sources, in addition to the 20-year energy-use-reduction regime. The plan calls for installing 2000 wind turbines every year, for a period of 40 years, starting at year 11. Each turbine will generate an average of 4.3 million kWh a year. Assuming an annual usage reduction rate of 4.25% in years one through 20, how long will the fossil fuel resources last? Assume 6.10 x 10 J as the inherent energy in one barrel of crude oil. Use a spreadsheet to process the numbers. Provide your solution in two parts; a narrative, where you describe your approach; and the spreadsheet. Part III Please upload your solutions at CANVAS as an Excel file by midnight, tomorrow night. 6. The country of Eldorado, population 34 million, area 160,000 sq miles, enjoys fossil fuel resources equivalent to 100 billion barrels of crude oil. Currently, Eldorado's per capita energy use, all from fossil fuel resources, is equivalent to 30 barrels/year. Assume 0.000% population change. a Eldoradoans wish to make their resources last 200 years. To achieve this goal they are implementing series of energy austerity measures. These measures are anticipated to result in an annual energy-use-reduction of r % every year for the 20 following years. The use will remain constant thereafter. Determiner such that the resources do last 200 years. b. An alternative plan calls for extending the resources' lifetime even further by shifting some of the use to renewable sources, in addition to the 20-year energy-use-reduction regime. The plan calls for installing 2000 wind turbines every year, for a period of 40 years, starting at year 11. Each turbine will generate an average of 4.3 million kWh a year. Assuming an annual usage reduction rate of 4.25% in years one through 20, how long will the fossil fuel resources last? Assume 6.10 x 10 J as the inherent energy in one barrel of crude oil. Use a spreadsheet to process the numbers. Provide your solution in two parts; a narrative, where you describe your approach; and the spreadsheetStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started