We're Open
+44 7340 9595 39
+44 20 3239 6980

[Solved]You have been commissioned to write a report for Royal Dutch Shell PLC relating to the demand ofpetroleum in different cou

  100% Pass and No Plagiarism Guaranteed

[Solved]You have been commissioned to write a report for Royal Dutch Shell PLC relating to the demand ofpetroleum in different countries.

ACC2002 Assignment

(accounts for 25% of final mark)

ACC2063 Assignment

(accounts for 100% of final mark)

  • The assignment should be a minimum of 2000 words (3000 words maximum), including both Part A and Part B.
  • It should follow the general form described overleaf
  • The report should be well-presented and typed
  • Diagrams and tables should be clearly presented

The ACC2002/ACC2063 Assignment requires you to use OLS linear regression analysis to estimate two models – a demand function and a multivariate demand function, and answer the questions in Part B.

Part A

You have been commissioned to write a report for Royal Dutch Shell PLC relating to the demand ofpetroleum in different countries. Details regarding the format for the report are presented on page 3.

Model 1   Price elasticity demand estimation:

Downloadthe price and quantity (petroleum consumption) data from Blackboard.

The demand function takes the general form:

….(1)

where e< 0 and A is a constant                                 

Note:  Equation 1 above may be linearized using the following transformations: 

….(2)

  • In the first of these, a = lnA (where A is defined in equation 1). To obtain the antilog of a, take e to the power of a. The slope b = the power e in equation 1.

Model 2      Multivariate demand estimation

A new team of analysts has been employed by Royal Dutch Shell PLC, and they report that, having obtained more data, the demand for petroleum, is best represented by a multivariate demand equation:

….(3)

All variables are expressed in logarithms.

where Qxis the quantity demanded of product X; Px, is the price of X; Py is the price of product Y;M is income and ε is a random error term.

Using the data given below, and using the EXCEL DATA-ANALYSIS tool (or a similar package such as SPSS, SAS, Eviews, Minitab, STATA, R,or MATLAB), estimate the demand equation given above.

Sample:

Petroleum consumption: US (EIA2005); UK (EIA1959); Canada (EIA1961); France (EIA1956); Germany (EIA1957); Italy (EIA1958); Japan (EIA1962); South Korea (EIA1963).

Petroleum Price: Crude Oil-Brent Spot FOB (EIACRBR).

Coal & Gas Price: International Coal & Gas Price Index (USIPE059F).

Income: US GDP (USGDP...D); UK GDP (UKGDP...D); Canada GDP (CNGDP...D); France GDP (FRGDP...D); Germany GDP (BDGDP...D); Italy GDP (ITGDP...D); Japan GDP (JPGDP...D); South Korea GDP (KOGDP...D).

Time period: Q1 2000 – Q2 2017

INSTRUCTIONS FOR PRESENTATION OF DATA :

Model (1) Ordinary Least Squares (OLS) Bi-variate Linear Regression

and

Model (2) Ordinary Least Squares (OLS) Multivariate Linear Regression

Your report should take the general form:

Part I:  Introduction

A brief introductory statement.

Part II:  Estimating constant-price elasticity of demand function

  • The demand function for petroleum should be estimated in different countries, with clear presentation of tables used in the calculation of the important values, plus graphs of ln(Q) versus ln(P), and comment on their trends. You should also graph and comment on the change of petroleum consumption and price during 2000-2017.
  • Explain the importance of the OLS model slope estimate in relation to the own-price elasticity, and calculate/explainhow responsive consumers are to a 1% increase in the price of the product.Which country’s petroleum consumption is more likely to be affected by the price? Are your results all in accordance with the law of demand? Explain.
  • Comment on the diagnostics: ‘t’ statistic, p-value, R2, adjusted-R2, and the ‘F’ test.
  • The owner of a small chain of petrol stations in Newcastle read an article in a trade publication stating that the own price elasticity of demand for petrol in the UK is -0.07. Because of this highly inelastic demand in the UK, he is thinking about raising prices to increase revenues and profits. Do you recommend this strategy based on the information he has obtained? Explain.
  • Suppose OPEC announce to decrease the supply of crude oil next year, in the meantime, The Wall Street Journal predict that the demand of crude oil will also reduce due to the recent economy recession. What effect will this have on price?

Part III:  Estimating multivariate demand function

  • Transform the original dataset to ln dataset, anddraw graphs ofln(Py)and ln(M), comment on their change during 2000-2017 compared to the change of ln(Q) and ln(Px).
  • The multivariate model should be estimated, with a clear presentation of results of tables used in the calculation of the important values, comment on the significance of the variables and validity of the regression.
  • Explain the size and sign (ie. + or -) of each coefficient and whether this accords with your expectations and economic knowledge.If not, what reasons may bias your results? Comment on your answer.
  • On the basis of the results, which independent variable(s) should be most concerned with – and does this make sense given the product being analysed? Explain your answer.

Part IV:  Discussion

  • Comment on any possible problems with this model or methodology.
  • What other data may have been useful when assessing demand for petroleumand why?
  • Comparing model 2 with model 3, which do you think is more plausible? Explain your answer.
  • Additional issues of relevance.

Part V:  Conclusion

A brief concluding statement.

References/Bibliography/Appendix

(Total words DO NOT include any words in this part.)

Part B

The book store in Newcastle recently advertised that “buy one, get one free–limit one free book per customer”. You stepped into the store and asked a clerk, “Will you sell me one book for half price?” The clerk answered, "I can`t do that."When you started to leave the store, the clerk hastily offered, "However, I am authorized to give you a 40 percent discount on any book in the store." Assuming you have £100 to spend on books (X) or all other goods (Y), and that books cost £50 per book, answer the following questions:

a. Illustrate the consumer`s opportunity set with the "buy one, get one free" deal and with a 50 percent discount, and explain your answer.

b. Why was the 40 percent discount offered only after the consumer rejected the "buy one, get one free" deal and started to leave the store?

c. Why was the clerk willing to offer a "buy one, get one free" deal, but unwilling to sell a book for half price?

d. The management of this book store is considering a plan to terminate a new employee. The action stemmed from documented evidence supplied by the store`s accounting department that this new employee did not add as much to the store`s overall output as did a worker hired two weeks earlier. Based on this evidence, do you agree that the latest worker hired should be fired? Explain.


100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: [Solved]You have been commissioned to write a report for Royal Dutch Shell PLC relating to the demand ofpetroleum in different countries.
  • Price: £ 169
  • Post Date: 2021-10-06T12:38:37+00:00
  • Category: Assignment Requirements
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

[Solved]You have been commissioned to write a report for Royal Dutch Shell PLC relating to the demand ofpetroleum in different countries. [Solved]You have been commissioned to write a report for Royal Dutch Shell PLC relating to the demand ofpetroleum in different countries.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

Writing is not my field. I take help from this website for my accounting assignment. The work is good and I scored good grades in it. Thank you from the bottom of my heart.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

I have tried other sites for assignment help but the result that Insta Research has produced outweighs others. Since I am weak at writing and shaping the data logically, I am glad I took help from this site. Thanks to my writer for such a great quality of the assignment in Business.