Question: Using the data set below: (total of 5 marks) a. Calculate the three-period simple moving average forecast for month 4. (show the details of your

Using the data set below: (total of 5 marks) a. Calculate the three-period simple moving average forecast for month 4. (show the details of your calculations) (2 marks) b. Calculate the three-period weighted moving average forecast for month 4 using weights of 0.2, 0.3, and 0.5 from the earliest period to the latest period, respectively. (show the details of your calculations) (2 marks) C. Which forecast is more accurate and why is it more accurate? (1 mark) Month 1. 23 4 Demand 120 100 150 180 D

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 General Management Questions!

A local caf, the Cool Caf, keeps record of its demand for blueberry muffins to help with the demand forecasting. The following table provides demand figures and forecasts for a six-week period. The...

Overtech Sdn. Bhd has four products that need to be run the production this morning. Fortunately, four machines are available. However, cach product is not identical and operates in different speed....

Solve the following problem using Microsoft Excel. Copy your answers from Excel into the Table provided on the next page. Upload only this Word file; do not upload Excel file on Blackboard. This...

The CEO of the Overtech Sdn. Bhd wants to forecast the demand of laptop so that the proper number of raw material can be orders from the suppliers. The company has accumulated the following data...

Deloitte is a firm that conducts an annual survey that gauges consumer spending expectations during the year-end holiday season. The following data show the percentage of respondents who indicated...

Instructions Respond to the following questions, and provide as much detail as possible. You will submit this assignment as a Microsoft Excel report. The first title tab must include your name and...

Operations Management BUSI414 Individual Assignment 2 Question 1 (a) The monthly sales for Summer Fresh juices for the year 2016 were as follows Month January February March April May June July...

answer only question 3 AutoSave C - Glos Demand forecasting Fire Exercise NEF (1) Excel Scarch Rajesh Dip File Home Insert Page Layout Formulas Data Review View Help Share Comments Calibri AutoSum 12...

Develop the pseudocode for desk-check and test the following programs. As in lecture slides you should allow the user to provide the number of elements and initialize the array according to their...

Select at least two of the following types of organizations and describe what type of standards may be used: 1. Hospitals 2. Law firms 3. Accounting firms 4. Auto repair shops Additionally, explain...

Inc. uses packing machines to prepare its products for shipping. One machine costs $ 1 5 0 , 0 0 0 and can operate for five years before it needs to be replaced. The operating cost per year is $ 2 0...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...