Analysis of Demand Function of Royal Dutch Shell

This article examines the data to determine the elements influencing demand for Royal Dutch Shell's product. Petroleum consumption from Canada (EIA1961), the United Kingdom (EIA1959), Germany (EIA1957), and the United States (EIA2005) were utilized as samples. Japan (EIA1962), South Korea (EIA1963), Italy (EIA1958), France (EIA1956), petroleum prices, coal and gas prices, income, and time period from 2000 to 2017. Two regression analysis models will be used to compare which one is best. The bivariate regression model, which compares only petroleum use and prices, will be utilized. The multivariate model of regression analysis which entails prices of other related goods such as coal and gas prices and income from various countries will be used.


Firstly, it is known that the function of demand is represent in the form of in which e< 0 and value of A is a constant. In this case the natural logarithm of both consumption quantity and the petroleum price will be calculated then a regression analysis will be run and relevant graphs drawn to find the relationships. Secondly the multivariate model for demand estimation will employ the use of the equation of where the natural logarithm of the variables are used. M represent the income, Py and Px are prices of the product Y and X respectively as well as Qy and Qx to present the quantity consumption of product Y and X respectively. The excel data analysis pack will be utilized to make a conclusion on the demand function for the Royal Dutch Shell products


Estimating constant-price elasticity of demand function


The demand function of the petroleum for various countries are determined in the attached excel file. The functions are arrived at after performing a bi-variate linear regression analysis of the petroleum consumption with the corresponding price for every country. The tables below show the regression output for the various countries and the corresponding graphs of graphs of ln (Q) versus ln (P)


United States


SUMMARY OUTPUT


Regression Statistics


Multiple R


0.409


R Square


0.167


Adjusted R Square


0.115


Standard Error


0.033


Observations


18.000


ANOVA


df


SS


MS


F


Significance F


Regression


1.000


0.004


0.004


3.214


0.092


Residual


16.000


0.018


0.001


Total


17.000


0.021


Coefficients


Standard Error


t Stat


P-value


Lower 95%


Upper 95%


Lower 95.0%


Upper 95.0%


Intercept


11.093


0.062


180.314


0.000


10.963


11.224


10.963


11.224


ln Petro price


-0.027


0.015


-1.793


0.092


-0.059


0.005


-0.059


0.005


The demand equation for US becomes ln (Q) = 11.093 – 0.027 ln (P)


From the above data output, the demand function shows that the demand for petroleum in US is elastic and it obeys the demand cure , whereby an increase in price leads to a decrease in in consumption and vice versa. The graph gives an illustration for it all.


United Kingdom


SUMMARY OUTPUT


Regression Statistics


Multiple R


0.569


R Square


0.323


Adjusted R Square


0.281


Standard Error


0.056


Observations


18.000


ANOVA


df


SS


MS


F


Significance F


Regression


1.000


0.024


0.024


7.642


0.014


Residual


16.000


0.051


0.003


Total


17.000


0.075


Coefficients


Standard Error


t Stat


P-value


Lower 95%


Upper 95%


Lower 95.0%


Upper 95.0%


Intercept


8.801


0.104


85.005


0.000


8.581


9.020


8.581


9.020


ln Petro price


-0.070


0.025


-2.764


0.014


-0.124


-0.016


-0.124


-0.016


Demand equation for UK: ln (Q) = 8.801 – 0.070 ln (P)


The same with demand for US, in UK the demand is elastic and law of demand is followed


The data analysis, output and graphs the other countries are illustrated in the attached excel file. The following table gives a summary of the demand equation of petroleum from various countries.


Country


Demand function


United State


ln (Q) = 11.093 – 0.027 ln (P)


United Kingdom


ln(Q) = 8.801 – 0.070 ln(P)


Canada


ln(Q) = 8.555+ 0.066 ln(P)


Germany


ln(Q) = 9.269 – 0.0816 ln(P)


Italy


ln(Q) = 9.108 – 0.163 ln(P)


Japan


ln(Q) = 10.003 – 0.106 ln(P)


South Korea


ln(Q) = 8.690 + 0.031 ln(P)


From the above table and the output from data analysis, it can be seen that only in Canada and South Korea where the demand for petroleum consumption is inelastic and that the law of demand does not apply for their cases.


Ordinary least square (OLS) is an important tool in modeling the demand function of a product. The slope obtained from the OLS out is very important as it clearly shows the elasticity of demand to the own-price of the product. At 1% increase in own-price of the product, there will be a less significant decrease in in consumer consumption hence the responsiveness will be generally low. The rate of response is estimated or determined by the slope of the OLS curves whereby for this case Japan will be more likely affected by an increase of 1% in prices, this is because Japan has the highest slope. As it can be seen from the output of OLS, the law of demand is only applying to US, UK, Japan, Italy, and Germany where demand is elastic while Canada and South Korea do not obey the law of demand


The values of‘t’ statistic, p-value, R2, adjusted-R2, and the ‘F’ test across all the countries is very low. These values are always the determinant for the relation or the correlation that exist between the parameters being measured. With low value of R-Squared, we can conclude that the quantity demanded for petroleum across the eight countries is weakly correlated with the prevailing market prices.


The scenario for the small chai in Newcastle cannot be recommended since with inelastic nature of demand in UK, the customer will respond slowly and later a stabilized market is realized. The increase in price also will shy away the customers and instead stick to the prevailing market prices.


An expectation in future shortages as announced by OPEC will automatically lead to an increase in demand so that the consumers can store for future use. When the Wall Street predict future reduction in demand due to recession , the consumers will tend to buy more at the current time and this will result into increase in price at the current time.


Estimating multivariate demand function


The output of the multivariate demand function is illustrate in the excel file attached below. With this, there is a strong correlation in the use of income as a factor affecting the demand of the petroleum across the countries


SUMMARY OUTPUT


Regression Statistics


Multiple R


0.965086173


R Square


0.931391322


Adjusted R Square


0.868891322


Standard Error


2.965610161


Observations


17


ANOVA


df


SS


MS


F


Significance F


Regression


1


1910.298517


1910.298517


217.2066495


2.49E-10


Residual


16


140.717498


8.794843627


Total


17


2051.016015


Coefficients


Standard Error


t Stat


P-value


Lower 95%


Upper 95%


Lower 95.0%


Upper 95.0%


Intercept


0


#N/A


#N/A


#N/A


#N/A


#N/A


#N/A


#N/A


99.99165


0.076989528


0.005223903


14.73793233


9.94955E-11


0.065915


0.088064


0.065915


0.088064


SUMMARY OUTPUT


Regression Statistics


Multiple R


0.999943


R Square


0.999887


Adjusted R Square


0.941063


Standard Error


0.120292


Observations


18


ANOVA


df


SS


MS


F


Significance F


Regression


1


2171.430795


2171.431


150063.8


3.28E-33


Residual


17


0.245990862


0.01447


Total


18


2171.676786


Coefficients


Standard Error


t Stat


P-value


Lower 95%


Upper 95%


Lower 95.0%


Upper 95.0%


Intercept


0


#N/A


#N/A


#N/A


#N/A


#N/A


#N/A


#N/A


ln US


1.144823


0.002955291


387.3807


5.5E-35


1.138588


1.151058


1.138588


1.151058


United Kingdom


SUMMARY OUTPUT


Regression Statistics


Multiple R


0.998621


R Square


0.997245


Adjusted R Square


0.938421


Standard Error


0.460018


Observations


18


ANOVA


df


SS


MS


F


Significance F


Regression


1


1302.086863


1302.087


6153.051


4.03E-22


Residual


17


3.597479686


0.211616


Total


18


1305.684343


Coefficients


Standard Error


t Stat


P-value


Lower 95%


Upper 95%


Lower 95.0%


Upper 95.0%


Intercept


0


#N/A


#N/A


#N/A


#N/A


#N/A


#N/A


#N/A


1.754852


0.022371509


78.44139


3.33E-23


1.707652


1.802052


1.707652


1.802052


The independent variable to be concerned with is the income as it bring a significance change in the analysis. The substitute too is important they all make sense in analysis of the product


Discussion


The model of data analysis by OLS is a critical one. The challenges with it is that the output for Bi-variate or multivariate analysis does not truly relates to the actual data in the field. The analysis work in a form of estimation manner where by a large data is confined into an equation which results into an outliers


The samples of data that would have been used or included while estimating the factors affecting demand of petroleum include: government policies on various nations, demand for complementary products of petroleum, technology, supplementary product or the substitute products.


The use of multivariate model of ordinary least square method of linear regression is more plausible than bi-variate model. This is because in multivariate, many factors and data affecting the demand are put in place and considered as compared to bi-variate where the own-price of the product is used.


Conclusion


The demand or the consumption rate of petroleum across many country is a point of concern.It can be evident from the above analysis that indeed most countries , developed countries has a significant rate of demand fo the petroleum product. It is advisable that the government of these country to step in and look into other source of energy rather than depending ion petroleum. We can also conclude that income, substitutes are significantly affecting the demand for the petroleum. Lastly, the use of OLS in data analysis is recommended in analysis of large data such as this one where multivariate model is most preferred


Part B


Answers for the case study for the book store in Newcastle


50 percent discount is a good deal for consumers because one may only be in need of one 1 time so buying at discount will be an automatic saving to them.


This is because the offer was still good but it covered the initial aim of the stock turn over. The customer are always enticed with low prices. As one come into the market, the amount of money she/he has will detect the number of items she will buy so the better the discount.


The clerk was willing to such an offer of buying one and getting the other one free because at 50% discount her profit margin that she would have made initially is getting squeezed and diminishing, the fact being that with such offer they will sale most likely 3 to 4 times of the price they bought with or even end up selling more.


The worker hired ought not to be fired and I totally disagree. From the management view, one should come to know that none of two workers can produce and perform at the same level in the working place. Firing a worker or calling his/her services to a termination is always an act that is considered as a negative remark as you hire the workers. Workers are the human resources in any organization set up, and they stand to be motivated so that they can produce quality services. Just with reason that a worker cannot perform in same level as hi/her co-principal in a work place does not qualify him/her to be incompetent or inefficient. Each and every worker learns differently and have varying rates in adapting to a system, what the management need is only time. Comparing the employers is a totally wrong and unacceptable. Organizations has a system of setting their own parameters that they can use to evaluate their workers on different levels of performance. In most instances a time span of 6 months to one year is given to employees after which their performance is evaluated after which the efficiency level of employees is arrived at. There will be no cause of alarm if a worker meets the given parameters that have set and he/she is over or under performing as compared to his/her core-worker.


Works Cited


Sadorsky, Perry. "Risk factors in stock returns of Canadian oil and gas companies." Energy economics 23.1 (2001): 17-28.


Levenberg, Kenneth. "A method for the solution of certain non-linear problems in least squares." Quarterly of applied mathematics 2.2 (1944): 164-168.


Frynas, J. George. "Royal Dutch/Shell." New Political Economy 8.2 (2003): 275-285.


Livesey, Sharon M. "Eco-identity as discursive struggle: royal Dutch/Shell, Brent Spar, and Nigeria." The Journal of Business Communication (1973) 38.1 (2001): 58-91.


El-Sharif, Idris, et al. "Evidence on the nature and extent of the relationship between oil prices and equity values in the UK." Energy Economics 27.6 (2005): 819-830.

Deadline is approaching?

Wait no more. Let us write you an essay from scratch

Receive Paper In 3 Hours
Calculate the Price
275 words
First order 15%
Total Price:
$38.07 $38.07
Calculating ellipsis
Hire an expert
This discount is valid only for orders of new customer and with the total more than 25$
This sample could have been used by your fellow student... Get your own unique essay on any topic and submit it by the deadline.

Find Out the Cost of Your Paper

Get Price