Verified Document

Making Decision Based On Demand And Forecasting Research Paper

Parkville Maryland Parkville is located in the state of Maryland in the Baltimore metropolitan area. Parkville is mainly located in the County of Baltimore with parts of it in Baltimore City County. Parkville is bordered to the south by Carney, which is primarily in the City and to the north by Perry Hall, Hampton, Overlea, and Towson, to the west, north and east. There are several Pizza establishments in the area an indication of demand of the product. However, it is important to establish the demand of the product using statistical analysis. In conducting this analysis, it is critical to take into consideration the demographics of the area including population and income per capita.

According to the United States Census Bureau (2010), the population of Parkville had gone up to 69752 from 69100 over the past decade. The Median Household Income in Parkville is $54,373 and can be socio-economically referred to as a Middle Class area in comparison to other areas in Maryland.

Demand Analysis

The demand analysis will take into consideration other variables other than population and household income of the Parkville. This study examines the speculative demand of Pizza (Y) the other variables include price of a medium size pizza; this is the price Dominos intend to sell their pizza and not the average price of pizza in the market. The price of soda is also critical in this analysis because pizza has traditionally been bought alongside soda. In this scenario, the unit will be a 20 Ounce soda. The analysis is done inputting this relevant data in Excel to estimate the demand for Pizza under two assumptions about what changes the quantity of Pizza demanded. The study therefore is meant to analyze the quantity demanded (Y) using regression analysis to estimate the coefficients of the demand function.

Regression Equation

Y = a + b1X1 + b2X2 + b3X3 +b4X4

Where:

Y = Pizza demand

X1 = medium size Domino pizza with two toppings at 7.99

X2 = Median Household Income $54,373

X3 = average price of a 20 Oz can of soda $1.05

X4 = Population of Parkville 69752

b1, b2, b3, b4 = coefficients of the X variables '

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.516876852

R Square

0.26716168

Square
0.671209343

Standard Error

1.075986466

Observations

30

ANOVA

df

SS

MS

F

Significance F

Regression

6

1.39747

0.25792775

Residual

23

Total

29

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

36.66685004

3.278084646

8.1348876

1.73E-08

19.9155131

33.418187

19.91551

33.41819

Price of Pizza

0.087750505

0.018062008

-4.858291

5.379E-05

-0.1249499

-0.050551

-0.12495

-0.05055

Median Household Income

0.138204092

0.086646076

1.5950416

0.1232685

-0.0402467

0.3166549

-0.04025

0.316655

Price of Soda

0.07589505

0.019225627

-3.947598

0.0005667

-0.1154909

-0.0362996

-0.11549

-0.0363

Population

0.54427859

0.884620096

-0.615268

0.5439383

-2.3661865

1.27762932

-2.36619

1.277629

In the evaluation of the statistical significance of the estimated coefficients this study will examine, Coefficients; Standard Error; Confidence Intervals; T-statistic; P-value and the overall fit of the regression line R-square and F-statistic. The main objective here is to estimate the demand for pizza and soda by the population of Parkville in Maryland. Here the demand Indicator is quantity of pizza and the drivers (factors which affect demand) are price of pizza; median household income; price of soda and population.

A close examination of the above summary output, it can be deduced that there is a positive coefficient in the first independent variable, which is the price of Pizza. This shows that there is a direct relationship between the…

Sources used in this document:
Reference

Jian, S., & Yan, L. (2011). MGMT Panel. Guangdong University of Finance.

United States Census Bureau. (2010). Population Census. U.S. Population Report.

Wood, M. (2012, July 6 ). P values, confidence intervals, or confidence levels for hypotheses? Retrieved November 7, 2012, from http://arxiv.org/ftp/arxiv/papers/0912/0912.3878.pdf
Cite this Document:
Copy Bibliography Citation

Related Documents

Making Decisions Based on Demand and Forecasting
Words: 927 Length: 3 Document Type: Research Paper

Demographics of Raleigh, NC Demographic and independent variables relevant to complete a demand analysis include population size and Average income per household. An area with a high population size is most likely to have potential for demand of products, According to the U.S. Census Bureau (2010) the there are 403,892 people in Raleigh, NC. In line with this, the population must be able to have disposable income to buy these products.

Brewing: Forecasting Trends
Words: 616 Length: 2 Document Type: Case Study

Forecasting: Kentucky Swamp Brew Forecasting demand within the brewing industry is dependent upon three basic factors: "trends, cycles, and seasonal patterns" (Elfner n.d.). Trends are defined as gradual shifts in demand that permanently affect the demand for the good or service; cycles are repetitious shifts in demand that manifest themselves in cyclical and predictable patters; and seasonal shifts are changes that occur periodically (Elfner n.d.). For example, a trend for Kentucky

Forecasting Operations Management Managers Module 3 -
Words: 726 Length: 2 Document Type: Essay

Forecasting Operations Management Managers Module 3 - SLP Forecasting Consider organization selected previous SLP papers. Integrate concepts operations management principles 've studying module turn page paper addressing questions (remember references): 1) How forecasting carried organization ( level discussing)? 2) How relate product development services offers? 3) What difficulties organization faces coming accurate forecasts? Could improve forecasts methods? SLP Assignment Expectations: Research organization information find internet resources find . Forecasting: Wal-Mart Q1, How is

Management and Decision Sciences From
Words: 25680 Length: 90 Document Type: Thesis

76). As automation increasingly assumes the more mundane and routine aspects of work of all types, Drucker was visionary in his assessment of how decisions would be made in the years to come. "In the future," said Drucker, "it was possible that all employment would be managerial in nature, and we would then have progressed from a society of labor to a society of management" (Witzel, p. 76). The

How Can We Make Profit Through Investing on Stock Market
Words: 11006 Length: 33 Document Type: Dissertation

profit through investing on Stock Market Generally, all over the world financial markets exemplify a state of intricate and inscrutable situation. These marketplaces are of immense significance in the western nations, where the constituents employ their expertise to invest and generate profit whilst formulating a pool of funds, statistics, derivatives, shares and calculation intricacy. These constituents or elements are those investment maestros who are the whole and sole performers of

Behavioral Finance Human Interaction a Study of the Decision-Making...
Words: 22258 Length: 81 Document Type: Term Paper

Behavioral Finance and Human Interaction a Study of the Decision-Making Processes Impacting Financial Markets Understanding the Stock Market Contrasting Financial Theories Flaws of the Efficient Market Hypothesis Financial Bubbles and Chaos The stock market's dominant theory, the efficient market hypothesis (EMH) has been greatly criticized recently for its failure to account for human errors, heuristic bias, use of misinformation, psychological tendencies, in determining future expected performance and obtainable profits. Existing evidence indicates that past confidence in the

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now