MBUS103 Global Managerial Economics Case Study

OBJECTIVE

This case study is designed to assess students' understanding of demand theory and application of the Excel functionalities. It is to introduce the steps and quantitative methods and tools to estimate demand function which is the primary objective of managerial economics. It will involve the estimation of demand using the graphical methodology and OLS regression methodology. It will be introduced how the estimated regression model will be used for forecasting fiture demand for the subject product.

Case:

A wallet producer, The Silvan Leather Company intends to introduce a new wallet with a different style. And wishes to estimate the demand curve for the new wallet. They have conducted a questionnaire survey of 1,000 people interviewed while they are shopping for a similar wallet at different places in a month. Each people were asked whether they would actually purchase the wallet at each price level represented to them. The price and quantity demanded relationship is classified by the answers of the people. The Excel spreadsheet, Demand Model S123.xlsx, includes the demand schedule (cross-section data) collected by the consumer survey.

TASKS

1. Identify the main determinant of demand for the introduced product - the new wallet. Write the function of demand in the following form and explain the economically interpret-able relationships.
   Q-f(X1, X2, X3, X4)
   Analyze why and in which way the demand is affected by the determinants of demand for new wallet.
2. Using the graphical method estimate (drive) the demand curve by plotting the price (P) and quantity demanded (Qa) using XY chart. Comment on the relationship between P and Q
3. Apply Regression analysis. To complete the modelling of the demand function, you hypothesize that the quantity demanded of new wallet (Q)is a function of its price (P)
   For this task you are required to utilise simple regression analysis which is to be conducted using cross section data provided with the file Demand Model $123.xlsx.
   The model has he following form:
   Q= Bo+ B1P+ei
   Where
   Bo: are the intercept and estimated coefficient with the regression procedure.
   e: is the error term
   Questions
   1. Using economic theory, what are the hypothesised signs of the parameters.
   2. Estimate the regression equation using excel and write the estimated equation.
   3. Interpret the estimated ß coefficients for independent variables.
   4. Compare your hypothesized signs (question 1) with your estimated sign. If there are any discrepancies, provide an appropriate explanation
   5. Using the results from the regression analysis, are your estimated parameters statistically significant? Write mull and alternative hypothesis and apply r test procedure to justify the significance of the ? coefficients and explain.
   6. Estimate the confidence interval for ?, coefficient.
   7. Write null and alternative hypothesis to apply F test procedure to test the validity of the model you estimated and explain.
   8. Interpret the estimated adj R?2;
4. Estimated regression model can be used to forecast the demand for the next period. Assume that the expected value of the independent variable, the market price will be S11 for the next year. Estimate the value of dependent variable, quantity demanded of new wallet.
5. Conclusion Provide a brief summary of the procedures you applied, problems, limitations and other issues of estimating demand.

Are you struggling to keep up with the demands of your academic journey? Don't worry, we've got your back! Exam Question Bank is your trusted partner in achieving academic excellence for all kind of technical and non-technical subjects.

Our comprehensive range of academic services is designed to cater to students at every level. Whether you're a high school student, a college undergraduate, or pursuing advanced studies, we have the expertise and resources to support you.

To connect with expert and ask your query click here Exam Question Bank