TABLE 16-12 A Local Store Developed a Multiplicative Time-Series Model to Forecast

question 92

Short Answer

TABLE 16-12
A local store developed a multiplicative time-series model to forecast its revenues in future quarters, using quarterly data on its revenues during the 4-year period from 2005 to 2009. The following is the resulting regression equation:
log₁₀ = 6.102 + 0.012 X - 0.129 Q₁ - 0.054 Q₂ + 0.098 Q₃
where is the estimated number of contracts in a quarter.
X is the coded quarterly value with X = 0 in the first quarter of 2005.
Q₁ is a dummy variable equal to 1 in the first quarter of a year and 0 otherwise.
Q₂ is a dummy variable equal to 1 in the second quarter of a year and 0 otherwise.
Q₃ is a dummy variable equal to 1 in the third quarter of a year and 0 otherwise.
-Referring to Table 16-12, using the regression equation, what is the forecast for the revenues in the fourth quarter of 2011?

---

Definitions:

Ending Inventory

The total value of all inventory a company has on hand at the end of its financial period.

Perpetual System

A perpetual system is an inventory management approach that continuously tracks inventory levels and costs, updating records with each purchase and sale.

Inventory Cost

Inventory cost includes all expenses associated with acquiring, holding, and processing goods that are to be sold, including the costs of materials, labor, and overhead.

Customer Demand

The desire and willingness of consumers to purchase goods and services at given prices.