Exhibit 11.14 The Following Questions Use the Data Below

question 93

Essay

Exhibit 11.14
The following questions use the data below.
The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs help analyzing the data using a 2-month moving average.
-Refer to Exhibit 11.14. What formulas should go into cells B15:B18 and cells C15:C18 of the spreadsheet if a 2-month moving average forecasting model is used?

---

Definitions:

Dividends

Monies disbursed by a business to its owners, often coming from the profit the company makes.

Costs

The monetary valuation of effort, material, resources, time, and opportunity foregone in production and delivery of a good or service.

Retention Ratio

The proportion of a company's net income that is retained rather than paid out as dividends, indicating reinvestment back into the company.

Return on Assets

A financial ratio that indicates how profitable a company is relative to its total assets.