Exhibit 18

question 10

Short Answer

Exhibit 18.8.Quarterly sales of a department store for the last 7 years are given in the following table. The Excel scatterplot shown above indicates that the quarterly sales have an increasing trend and seasonality.Therefore,the linear regression model,Sales = β₀ + β₁Qtr1 + β₂Qtr2 + β₃Qtr3 + β₄t + ε with three seasonal dummy variables Qtr1,Qtr2 and Qtr3,and the decomposition method are proposed to make sales forecasts.For the regression model,the following Excel partial output is available. Refer to Exhibit 18.8.Using the regression equation for the linear trend model with seasonal dummy variables,what is the sales forecast for the first quarter of Year 8?

---

Definitions:

Job Analysis

The process of gathering, documenting, and analyzing information about job tasks, responsibilities, and the required skills, knowledge, and abilities for a specific role.

Midpoint Method

A technique for calculating the percent change in which changes in a variable are compared with the average, or midpoint, of the starting and final values.

Price Elasticity

A measure of how much the quantity demanded of a good responds to a change in the price of that good, reflecting the sensitivity of consumers to price changes.

Quantity Demanded

The total amount of a good or service that consumers are willing and able to purchase at a specific price level, at a given time.