Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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 spreadsheet

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

10th Edition

0137916787, 978-0137916788

More Books

Students also viewed these Databases questions