A Company Wants to Generate a Forecast for Unit Demand

question 13

Multiple Choice

A company wants to generate a forecast for unit demand for year 2014 using exponential smoothing.The actual demand in year 2013 was 120.The forecast demand in year 2013 was 110.Using these data and a smoothing constant alpha of 0.1, which of the following is the resulting year 2014 forecast value?

• A)100
• B)110
• C)111
• D)114
• E)120

---

Definitions:

Access Database

A Microsoft database management system that provides a user-friendly environment for database creation and management.

Excel Workbook

An Excel workbook is a file that contains one or more spreadsheets, enabling users to organize data, perform calculations, and analyze information.

Is Null

A condition or expression used in databases and programming to check if a variable or data field has no value or is empty.

Action Query

A type of query in database systems that performs actions on the data, such as inserting, updating, or deleting records, based on certain criteria.