Exhibit 18

question 87

Short Answer

Exhibit 18.7.The following table shows the annual revenues (in millions of dollars)of a pharmaceutical company over the period 1990-2011. The autoregressive models of order 1 and 2, and ,were applied on the time series to make revenue forecasts.The relevant parts of Excel regression outputs are given below.
Model AR(1): Model AR(2): Refer to Exhibit 18.7.Compare Excel outputs for AR(1)and AR(2)and choose the forecasting model that seems to be better.

---

Definitions:

Factory Labor Costs

Expenses related to employees who directly engage in the manufacturing process of a company's products.

Overapplied Overhead

A situation where the allocated manufacturing overhead costs for a period exceed the actual overhead costs incurred.

Underapplied Overhead

A scenario where the estimated costs for manufacturing overhead are lower than the overhead costs that were actually encountered.

Predetermined Overhead Rate

An estimated charge per labor hour or machine hour used to allocate overhead costs to products or services.