Quantitative methods Research Assignment

Quantitative methods
Quantitative methods

Quantitative methods

Complete assignment instructions in document

MGMT 6108

Forecasting Assignment II

Excel is the best tool for calculations

Answer the questions in this document

Attach tables with calculations as appendixes

Be sure to know how to do the problems by hand also.  In the Final test you will be solving small but similar versions of this problem.

Name

  1. The table below shows monthly sales of a motorcycle store during the last two years.

Month Sales              Month             Sales

1          195                 13        155

2          210                 14        120

3          190                 15        135

4          170                 16        110

5          180                 17        122

6          156                 18        97

7          134                 19        85

8          155                 20        110

9          145                 21        85

10        165                 22        78

11        128                 23        66

12        135                 24        45

Compute an exponential smoothing and an adjusted exponential smoothing for the data using:

a = 0.2 and  fl = 0.6

  •  Calculate MSE for Ft and Aft
  • Identify the best method to forecast the motorcycle sales using MSE.
  1. Table below shows monthly beer sales at Gordonís Liquor Store in 2017.

Month Sales

Jan     900

Feb     725

Mar     1000

Apr      800

May     750

Jun     1200

Jul       1000

Aug     1100

Sep     1250

Oct      1050

Nov     1400

Dec     1600

Jan

We can write this or a similar paper for you! Simply fill the order form!

Unlike most other websites we deliver what we promise;

  • Our Support Staff are online 24/7
  • Our Writers are available 24/7
  • Most Urgent order is delivered with 6 Hrs
  • 100% Original Assignment Plagiarism report can be sent to you upon request.

GET 15 % DISCOUNT TODAY use the discount code PAPER15 at the order form.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: