Question

Which of the following statements best describes the reason for applying the Excel ‘Solver’ to a forecasting model:

A. Solver is used to determine the accuracy of a given forecasting model compared to past demand.

B. Solver is used for projecting future demand based on past demand.

C. Solver is used to determine the best way to measure forecast error compared to past demand.

D. Solver is used to determine weighting parameters that would give lowest error based on past demand.
​

Answer 1

Answer:

Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet.

Explanation:

I hope it will help you