Making Decision Based on Demand and Forecasting Research Paper

Total Length: 974 words ( 3 double-spaced pages)

Total Sources: 4

Page 1 of 3

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.

Stuck Writing Your "Making Decision Based on Demand and Forecasting" Research Paper?

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

Adjusted R. 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.....

Show More ⇣

Latest APA Format (6th edition)

Copy Reference

"Making Decision Based On Demand And Forecasting" (2012, November 07) Retrieved May 17, 2024, from
https://www.aceyourpaper.com/essays/making-decision-based-demand-forecasting-107544

Latest MLA Format (8th edition)

Copy Reference

"Making Decision Based On Demand And Forecasting" 07 November 2012. Web.17 May. 2024. <
https://www.aceyourpaper.com/essays/making-decision-based-demand-forecasting-107544>

Latest Chicago Format (16th edition)

Copy Reference

"Making Decision Based On Demand And Forecasting", 07 November 2012, Accessed.17 May. 2024,
https://www.aceyourpaper.com/essays/making-decision-based-demand-forecasting-107544

Making Decision Based on Demand and Forecasting Research Paper

Cite This Resource:

Latest APA Format (6th edition)

Latest MLA Format (8th edition)

Latest Chicago Format (16th edition)

Essay Tutorials

Student Questions

Presentations