Making Decision Based On Demand And Forecasting Research Paper

PAGES
4
WORDS
974
Cite

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 Documents:

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:

"Making Decision Based On Demand And Forecasting" (2012, November 07) Retrieved April 16, 2024, from
https://www.paperdue.com/essay/making-decision-based-on-demand-and-forecasting-107544

"Making Decision Based On Demand And Forecasting" 07 November 2012. Web.16 April. 2024. <
https://www.paperdue.com/essay/making-decision-based-on-demand-and-forecasting-107544>

"Making Decision Based On Demand And Forecasting", 07 November 2012, Accessed.16 April. 2024,
https://www.paperdue.com/essay/making-decision-based-on-demand-and-forecasting-107544

Related Documents

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.

The second factor is the independent variable being evaluated. The coefficient for determination of the population of the area is 46%. This correlation indicates that there is a high correlation between time and population. However, the correlation is this case is negative, as can be seen in the chart below. The correlation coefficient for the overall amount spent on building and development of the community is 15%. The correlation between

Chapter 8: Sales and Operations Planning1. The relationships among manufacturing, logistics, service, and marketing plansThis concept refers to the interconnected planning processes that ensure a company\\\'s manufacturing schedules, logistics operations, service delivery, and marketing strategies are aligned and working cohesively towards the overall business objectives.In a business setting, these relationships are crucial for balancing supply and demand, optimizing resource use, and making sure the product or service delivery meets customer

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 - 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

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