Question: 2. Using the four month moving average forecast method what would the forecast be for February 2019? (4 marks) year month 2018 Jan 2018 Feb

2. Using the four month moving average forecast method what would

2. Using the four month moving average forecast method what would the forecast be for February 2019? (4 marks) year month 2018 Jan 2018 Feb 2018 Mar 2018 Apr 2018 May 2018 Jun 2018 Jul 2018 Aug 2018 Sep 2018 Oct 2018 Nov 2018 Dec 2019 Jan period actual demand 1 15,300 2 15,075 3 15,975 4 16,200 5 15,120 6 16,650 7 18,000 8 19,800 9 17,550 10 12,600 11 10,800 12 9,000 13 15,837

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Plot the actual demand, the simple exponential smoothing (SES) forecast, and trend-adjusted exponential smoothing (FIT) forecast on the same graph. Briefly comment on the observed difference(s)...

The following table lists the month-end prices from May 2017 to July 2018 of the Spider S&P 500 Index ETF (SPY) and iShares 20+ Treasury Bond ETF (TLT), respectively. During this time period the...

I am working on this assignment and got stacked. I am suppose to select the right data to produce a chart in excel. I will attach a screenshot of the data and how the chart should look like. This is...

The monthly Sales in your shop for Type CRO2 Batteries for last year were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec 20 115 Sales 14 13 18 20 20 21 23 21 16 17 In the month of...

The first three images include all needed info, i got an email saying it is incompelete. But that is all thats given to us. 75% Required: Prepare a comprehensive 6 month budget, including supporting...

1. How are revenues growing? Which clients are most important? 2. What is the biggest factor in cost of goods sold? Do you think that this is realistic? Why or why not? 3. Do any part of the...

Hello please answer all parts to this question sufficiently to receive a positive thumbs up rating. No Excel please. Thanks in advance! Question 1: The monthly sales for Telco Batteries, Inc. in a...

The monthly sales for Yazid Batteries, Inc., were as follows Month Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 20 23 17 12 15 16 17 18 22 22 21 22 b) The forecast for the next month Jan)...

I would like some assistance with following Linnear Programming and Quantitative Analysis (b) MONTH ACTUAL SALE Jan 15 Feb 16 Mar 14 Apr 18 May 21 Jun 20 Jul 19 Aug 22 Sep 24 (a) Use the three-month...

Use data in worksheet Time Series. Plot the data for each store. Develop a sales forecast for each of the 10 stores for the month of December, using: A three month moving average A 2- month weighted...

Suppose a bet is placed on the outcome of the flip of a coin if the coin comes up heads, you get $25 and if it turns up tails, you lose $25. If you accepted this bet, does it imply that you are risk...

The stockholders equity of ARCOS, Ltd. at January 1 st , 2021 is as follows: ARCOS, Ltd Stockholders equity 1 January 2021 Common stock, $10 par value 3.000.000 Additional paid in capital common...

Would a tariff imposed on U.S. oil imports promote energy development and conservation for the United States?

Learner outcome measurements in the program evaluation process

Explain the benefits of a health and wellness strategy

Critique management strategies for health and safety in the workplace

Describe the components of a workplace wellness programme