Create a table displaying both miles per gallon

Assignment Help Business Economics
Reference no: EM133078903

-Open one of the following: Microsoft Excel spreadsheet or similar blank spreadsheet/table document and provide personal answers to the following questions. A spreadsheet works best because you may use formulas to calculate the following information. Create a table displaying both miles per gallon and kilometers per gallon.

-Complete responses for questions 1-6 below go to the link. Create/embed a similar table in your document and input the required information (just mimic the table displayed in the Car Economics Activity).

-Upload your file in this assignment.

-Provide the initial cost of your vehicle (approximately), miles per gallon, miles driven per day (5-day total=business week), cost per day, and cost per year (see image below for an example).

-Estimate how many miles you "normally" travel (before the coronavirus) using fossil fuels (# of gallons of gasoline) for 7 days. How you travel - bus, car, train, airplane - does not matter, but does not include walking or biking. If you're not sure how far you've traveled, just estimate. Create two columns Convert your total miles for this period to kilometers by multiplying by 1.6.

-Multiply your total kilometers for 1 week by 48 to get kilometers traveled per year.

-Divide kilometers traveled per year by the number of miles per gallon your car gets (convert to kilometers per gallon). This will give you the number of gallons of fossil fuel that were used per year for transportation.

-Multiply the number of gallons of fuel you use per year by 125,000 British Thermal Units (the amount of energy in one gallon of gasoline) to find the number of BTUs you use in one year.

-Now, create another column and calculate the same data for the desired vehicle. Compare and analyze the economics for both vehicles. Provide me the net annual savings or expenses between your vehicle and the desired vehicle. That's it!

Reference no: EM133078903

Questions Cloud

Does the future of capitalism appear promising : In your view, does the future of capitalism appear promising? Why or why not? No reference, just curious what your opinions would be and supporting answer.
Journalize summer bad debts expense : At December? 31, 2018?, accounts receivable total $38,000. Journalize Summer's Bad Debts Expense using the? percent-of-sales method
Advantages and disadvantages in the political system : Define federalism, and describe its advantages and disadvantages in the political system.
What is the hotel adr : In preparing the operating statistics from the night of October 16, 2017: $38,350 room income, 306 rooms available, What is the hotel ADR
Create a table displaying both miles per gallon : -Open one of the following: Microsoft Excel spreadsheet or similar blank spreadsheet/table document and provide personal answers to the following questions.
Calculate the amount at which barrett should record : Calculate the amount at which Barrett should record the note payable and corresponding merchandise purchased on January 1, 2021
Marginal cost of producing the second unit of output : Answer the question on the basis of the following cost data. The marginal cost of producing the second unit of output is:
Comparative advantage in producing cheese : Assume that Italy can produce 10 bottles of wine per worker and 20 pounds of cheese per worker. Build a Production Possibility Curves for these countries.
What is the amount of prior service cost recognized : What is the amount of prior service cost recognized by each company in its income statement for the year ended December 31, 2021

Reviews

Write a Review

Business Economics Questions & Answers

  Calculate the elasticity of demand

Suppose market demand is given by P=100-Q. The only producer in this market has marginal costs given by MC=2Q.

  What is the operating cash

The annual depreciation is estimated to be $456,926 and the interest expense is estimated to be $206,975. If the tax rate is 33%.

  Consider two firms whose marginal costs of production

Consider two firms whose marginal costs of production are MC(Q1) = 10Q1; MC(Q2) = 5Q2: Suppose each unit of output produced, Q, results in one unit of emissions, E. Suppose the two firms sell their output in a perfectly competitive market, with perfe..

  Vertical represents capital and horizontal represents labor

Draw in excel an isoquant that shows little substitution between two factor inputs and on that shows large substitution. Vertical represents capital and horizontal represents labor

  Which situation reflects scarcity rather than shortage

There are not enough of four goods to satisfy the wants of people. For good A, this is true when the price is $100. This is true for good B at a price of $10, for good C at a price of $1, and for good D at a price of zero. Which situation reflects sc..

  What is the growth rate of its debt

Suppose a government has an initial debt of $5 trillion and the nominal rate of interest is 5%. if government keep primary budget in balance, what is the growth rate of its debt? if government keeps its total budget in balance, what s the growth rate..

  Components of an expert system

List five major components of an expert system, and briefly explain two of them.

  Scheme impact the selection of routing protocols

1. How does the IP addressing scheme impact the selection of routing protocols? (Please remember to cite all material that you find and use in your posts. Include at least a URL or Book where you retrieved information.)

  Explain how the how the ppf changes with the new oven

Explain how the how the PPF changes with the new oven. (The oven is used to bake both pizzas and stromboli.)

  What is driving marginal benefits

After viewing the video clip from Cool Hand Luke, first consider how marginal benefits and marginal costs fit in to Luke's decision, and how the concept of diminishing marginal utility is at work as Luke eats more and more eggs.

  Price elasticity of demand for sodas

They then notice that they are selling approximately 15 percent fewer sodas. The price elasticity of demand for sodas from the campus vending machines, therefor

  Assume that all seats and all games are the same in problem

The owner of a baseball team and local stadium has commissioned a study that showed the demand by fans for stadium seats (per playing date) to be P = 22 - 0.2Q, where P is the average price of a ticket and Q represents the number of seats (expressed ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd