Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What are the monthly indexes for months 1-12, I put the numbers I got in the chart below but it shows up as incorrect Forecast

What are the monthly indexes for months 1-12, I put the numbers I got in the chart  below but it shows up as incorrect

Forecast sales for January, February, March, and April of 2019.


PeriodMonth-YearMonthSales ($ Million)TrendIndexForecastAbsolute Error
1Jan-2017135,03036,409.8000.960
2Feb-2017233,37236,828.6000.906
3Mar-2017338,02237,247.4001.020
4Apr-2017438,37337,666.2001.019
5May-2017540,13938,085.0001.054
6Jun-2017639,40938,503.8001.024
7Jul-2017739,19738,922.6001.007
8Aug-2017840,61739,341.4001.032
9Sep-2017940,74639,760.2001.025
10Oct-20171041,11740,179.0001.023
11Nov-20171139,58640,597.8000.975
12Dec-20171239,44641,016.6000.962
13Jan-2018138,62341,435.4000.932
14Feb-2018236,77741,854.2000.879
15Mar-2018342,04842,273.0000.995
16Apr-2018442,50942,691.8000.996
17May-2018547,44943,110.6001.101
18Jun-2018646,94643,529.4001.078
19Jul-2018747,39143,948.2001.078
20Aug-2018848,23344,367.0001.087
21Sep-2018944,98544,785.8001.004
22Oct-20181047,74245,204.6001.056
23Nov-20181142,63945,623.4000.935
24Dec-20181239,02646,042.2000.848
MAD=

Step by Step Solution

3.38 Rating (151 Votes )

There are 3 Steps involved in it

Step: 1

To forecast sales for January February March and April of 2019 you need to continue the index calcul... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost management a strategic approach

Authors: Edward J. Blocher, David E. Stout, Gary Cokins

5th edition

73526940, 978-0073526942

More Books

Students also viewed these Finance questions