1 / 20

Modeling Demand

Modeling Demand . Module 7. Conceptual Structure of SIMQ Market Model. Firm Demand = Total Industry Demand * Share of Market. Firm Demand = Average Firm Demand * n * Share of Market . Firm Demand = Average Firm Demand * Normalized Share of Market. Macro-economic Influences

flann
Download Presentation

Modeling Demand

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Modeling Demand Module 7

  2. Conceptual Structure of SIMQ Market Model Firm Demand = Total Industry Demand * Share of Market Firm Demand = Average Firm Demand * n * Share of Market Firm Demand = Average Firm Demand * Normalized Share of Market Macro-economic Influences Seasonal Patterns Stage of Life Cycle Exogenous Demand AFD Industry Activity Pricing, Promotion, Quality Endogenous Demand FD NSOM Competitive Profile Relative Pricing, Promotion, Quality, and Loyalty Relative Demand

  3. Normalised Share of Market NSOM = Firm Demand / Avg Firm Demand Relative Price (current) Pricing Relative Advertising (current, t-1, t-2 ) NSOM Promotion Loyalty NSOM (t-1) Quality Relative R&D (t-1, t-2) NSOM is firm specific and a measure of relative demand, the predictor variables should also be relative to industry averages. For example, relative price of the firm is PREL = Firm’s Price / Industry Avg. Price

  4. Calculating NSOM 11) Use a multiple regression to estimate NSOM.

  5. Average Firm Demand • How many units will any firm sell on the average. • AFD = Exogenous demand + Endogenous demand • Exogenous demand = “Base demand” X Seasonal effects • Endogenous demand = Influence of aggregate industry behavior Error Endog Exog

  6. Average Firm Demand AFD Exogenous Demand Endogenous Demand Macro-Economic Influences - Seasonality - Stage of Life Cycle Estimate Trend and Seasonality using Time Series Analysis Industry Behavior - Pricing (Avg Price) - Promotion (Avg. Advertising) - Product Quality (Avg. R&D) Estimate weights of these factors using Regression Analysis AFD = {(T*S) + (B0+B1*Avg P+..)}

  7. AFD: Exogenous Demand • Base demand • Population, Income, Tastes, Product life cycle, Substitutes and complements (Macro-economic influences) • Seasonal demand • Weather, Customs, Holidays • Not all products are affected • Estimation is done using: Time Series Decomposition

  8. Calculating Exogenous AFD 1) Use Statpro to generate Seasonal Indices

  9. Calculating Exogenous AFD 2) Use Seasonal Indices to De-seasonalize observations. 1438 / .895 = 1607

  10. Calculating AFD 3) Fit a simple regression line to the de-seasonalized observations.

  11. Calculating AFD 4) Use the regression line to create a ‘de-seasonalized’ forecast. 11 * 65.213 + 1237.9 = 1955.2

  12. Calculating AFD 5) Re-seasonalize the predicted forecast. This is the exogenous portion of demand. 1.093 * 2150.9 = 2350.3

  13. Calculating AFD 6) Calculate the residual error from the forecast. This is the endogenous portion of demand. 2839 – 2350.3 = 488.7

  14. Calculating AFD 7) Fit a multiple regression with the residuals as the dependent variable and the firm data as the independent variables.

  15. Calculating AFD 8) Use the new regression equation to forecast residuals. These are estimated of endogenous demand. 15688.25 + (-43.885) * 371.9 + (.0032) * 97960 + (.0127) * 25610 = 4.2

  16. Calculating AFD 9) Add the exogenous forecast to the endogenous forecast to create a composite forecast. 2350.3 + 204.2 = 2554.6

  17. Calculating AFD 10) Subtract the composite forecast from the observations to find a total error. 2839 – 2554.6 = 284.4

  18. Calculating AFD 11) Calculate the standard deviation of the residuals. Because there may be more explanation that can be squeezed out of the trend and attributed to the dependent variables, repeat the process. For subsequent iterations, Raw AFD – Estimated Endogenous as starting data for time series. Continue till error stops decreasing.

  19. Conceptual Structure of SIMQ Market Model With Average Firm Demand and Normalized Share of Market modeled, we can now create a decision support system for any individual firm. Exogenous Demand AFD Endogenous Demand FD NSOM Relative Demand

  20. Example DSS

More Related