Question: To understand if demand for a customer segment is changing over time the company tracked historical demand for one of its products as follows: Demand

To understand if demand for a customer segment is changing over time the company tracked historical demand for one of its products as follows:

Demand Demand April 60 July 60 May 55 August 80 June 75 September 75

a. Using a simple four-month moving average, calculate a forecast for October. b. Using single exponential smoothing with a=0.2 and a September forecast =65, calculate a forecast for October. c. Using simple linear regression, calculate the trend line for the historical data. Lets say the X axis is April=1, May=2, and so on, while the Y axis is demand. d. Calculate a forecast for October using your regression formula.

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!

To understand if demand for a customer segment is changing over time the company tracked historical demand for one of its products as follows: Demand Demand April 60 July 60 May 55 August 80 June 75...

To understand whether demand for a customer segment is changing over time, the company tracked historical demand for one of its products as follows: Using a simple 4-month moving average, calculate a...

MBA695 Strategic Management Assignment: After reading the article by Michael Porter on his Diamond of National Advantage (in addition to Dyer et al, (2020), Chapter 9, p.164, Figure 9.5), apply...

DC Location Mean Lead Time in Days Standard Deviation of Lead time in Days Albany 10 2 Brooklyn 2 0 Syracuse 10 3 The Brooklyn RDC orders the SKU weekly from the Kansas City plant. These orders are...

Liza Davis ana tne bargann Funting custonner Retailers form the link between the producer of goods and the consumer. Getting the merchandise that customers want to buy is critical to their success....

1. - Expain the motivations of Unilever in acquiring Inmarko. - Identify the risks Unilever faces in using acquisition as a mode for growth, as opposed to other modes discussed in the chapter. 2....

A person standing between two parallel hills fires a gun. He hears the first echo after 1.5 sec, and the second echo after 2.5 sec. If the speed of sound is 332 m/s, calculate the distance between...

1. How does the court explain the relationship between First Amendment rights to free speech and trademark infringement law? Between free speech and trademark dilution law? Between trademark...

1 . An unmarried taxpayer with gross income lower than his / her available standard deduction amount will never berequired to file a Form 1 0 4 0 for the year in question. true or false

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...