Microsoft Excel Was Used to Obtain the Following Quadratic Trend

question 23

Short Answer

Microsoft Excel was used to obtain the following quadratic trend equation:
Sales = 100 - 10X + 15X².
The data used was from 2001 through 2010 coded 0 to 9. The forecast for 2011 is ________.

---

Definitions:

Merchandise Return

The process of a customer returning previously purchased merchandise to the seller, usually for a refund, store credit, or an exchange.

Periodic Inventory System

A method of inventory accounting where updates to inventory levels are made on a periodic basis rather than after each transaction.

Gross Method

An accounting method for recording purchases at their gross price without deducting any cash discounts.

Merchandise Return

The process of a customer returning previously purchased merchandise back to the retailer or company.