Question: 1. Evaluate the forecasting model using a 3-month moving average, and 3 month moving weighted average, and exponential. The weights are .5 for the most

1. Evaluate the forecasting model using a 3-month moving average, and 3 month moving weighted average, and exponential. The weights are .5 for the most recent demand, .25 for the other months. Alpha = .3. Use the weighted moving average for January Forecast.

	Actual Demand
Oct	300
Nov	360
Dec	425
Jan	405
Feb	430
March	505
April	550
May	490

2. Calculate MAD and MAPE for each and compare. Which method is a better forecast and why?

Step by Step Solution

★★★★★

3.44 Rating (144 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Formulae to be used Absolute deviation Forecast Actual Percent error absolute ... View full answer

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 Mathematics Questions!

It turns out to track the spending of individuals in of income. It also turned out that he was a disagreement single person. Required 1- Write down the type of spending of these individuals 2- How...

The exponentially weighted moving average is a one-sided moving average of the time series. The smoothed value St is an average of Yt and prior values. The regular moving average is two sided,...

The moving average model of order q has the form where et is a serially uncorrelated random variable with mean 0 and variance 2e. a. Show that E(Yt) = 0. b. Show that the variance of Yt is c. Show...

Information for Questions 1-2: The Instant paper Clip Company sells and delivers office supplies to various companies, schools, and agencies within a 30-mile radius of its warehouse. The office...

MGMT2026 - Production & Operations Management-UWI QUESTIONS ON FORECASTING Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of...

1) The following gives the number of pints of type B blood used at Woodlawn Hospital in the past 6 weeks. Week of Demand August 31 360 September 7 389 September 14 410 September 21 381 September 28...

Chapter 4 Internet Homework Problems 4.50 Registration numbers for an accounting seminar over the past 10 weeks are shown below: Week 1 2 3 4 5 6 7 8 9 10 22 Registrations 21 25 27 35 29 33 37 41 37...

Chapter 151. The manager of the Carpet City outlet needs to make an accurate forecast of the demand for SoftShag carpet (its biggest seller). If the manager does not order enough carpet from the...

CASE 7.1 Tires for You, Inc Tires for You, Inc. (TFY), founded in 1987, is an automotive repair shop specializing in replacement tires. Located in Altoona, Pennsylvania, TFY has grown successfully...

01 9 10 11 12 13 14 15 A product has a consistent year round demand. You are responsible for the forecast and have been tasked with experimenting with some time series analysis. Using this previous...

If the resultant internal moment acting on the cross-section of the aluminium strut has a magnitude of M= 520NM and is directed as shown in Figure 3, determine the bending stress at Points A and B....

Rodriguez Company pays $395,380 for real estate with land, land improvements, and a building. Land is appraised at $157,040; land improvements are appraised at $58,890; and the building is appraised...

urgent! urgent please! business law, case study, Amit and Amita were husband and wife and was always quarrelling amongst each other amit promises to pay Rs. 50,000 to Amita as monthly expenses and...

Consider the following table for this question. 2 4 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 This array was declared with this statement: int colors = new int[4][5]; Write a single line of...

1) If Bellevue was using Class B private addresses for internal computers and they had 16 departments where each department had their own subnet, how many computer hosts could be in each department...

1-25 Strategic decisions and management accounting. A series of independent situations in which a firm is about to make a strategic decision follow. Decisions: a. Roger Phones is about to decide...

P21-12B (L02,4) (Lessee-Lessor Entries, Balance Sheet Presentation, Finance and Sales-Type Lease) Gotham Enterprises and Marvel Inc, enter into an agreement that requires Marvel Inc. to build ten...

Accounting policies and practices that are most important to the portrayal of the companys financial condition and results, and require managements most difficult, subjective, or complex judgments...

This table summarizes the number of game consoles sold in three areas as of the end of 2010. The numbers are in millions. (a) Present pie charts that show the market share within each geographic...

A monitoring system records the production of an assembly line each hour. The design calls for output to be four units per hour. Current policy calls for stopping the line to check for flaws if fewer...

Rather than create five dummy variables to represent a categorical variable C with five labels, an analyst defined the variable X by converting the categories to the numbers 1, 2, 3, 4, and 5. Does...

Using the stock adjustment model (why?), estimate the short- and long-run elasticities of expenditure on new plant and equipment with respect to sales. Compare your results with those for Exercise...

Consider a process that attempts to prepare tyrosine using a HellVolhardZelinski reaction: (a) Identify the necessary starting carboxylic acid. (b) When treated with Br2, the starting carboxylic acid...

In this problem, you will solve for the total energy eigenfunctions and eigenvalues for an electron in a finite depth box. We first go through the calculation for the box parameters used in Figure...