Question

In January, a car dealer predicted February demand for 142 Ford Mustangs. Actually February demand was...

In January, a car dealer predicted February demand for 142 Ford Mustangs. Actually February demand was 153 autos. Using a smoothing constant of alpha = 0.20 forecast the March demand using exponential smoothing

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Using the exponential smoothing method

F(March) = 0.2*Actual(February) + (1-0.2)*F(February)

= 0.2*153 + 0.8*142

= 144.2

Please provide up votes, if you are satisfied with the response. Comment in case of any issue regarding the same.

Add a comment
Know the answer?
Add Answer to:
In January, a car dealer predicted February demand for 142 Ford Mustangs. Actually February demand was...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The historical demand for a product is as follows: Month Demand January 12 February 11 March...

    The historical demand for a product is as follows: Month Demand January 12 February 11 March 15 April 12 May 16 June 15 Stating any assumptions that you make answer the following questions. (i) Using a weighted moving average with weights of 0.60 for June; 0.30 for May and 0.10 for April, find the July forecast. (4 marks) (ii) Using a simple three-month moving average, find the July forecast. (4 marks) (iii) Using simple exponential smoothing with α=0,2 and a...

  • b) In your opinion, which one is most critical in a retail sales environment and why?...

    b) In your opinion, which one is most critical in a retail sales environment and why? (3.5 marks) Q 2 (10 marks) A car parts manufacturer has had monthly sales for a five-month period as follows: Sales (000 units) Month January February March April May Forecast June's sales volume, using cach of the following: i. A four-month moving average (2 Marks) ii. Exponential smooth with a smoothing constant of 0.10, assuming a February forecast of 19(000). (2 Marks) iii. The...

  • Here are the actual tabulated demands for an item for a nine-month period (January through September)....

    Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 110 February 130 March 150 April 170 May    160 June      180 July    140 August 130 September 140 A. Forecast April through September using a three-month moving average. B. Use simple exponential smoothing with an alpha of 0.3 to estimate April through...

  • Actual sales of TV's for the first six month in 2021 were as follows: January      60           ...

    Actual sales of TV's for the first six month in 2021 were as follows: January      60            February     80          March   42 April           68            May             44           June     72 Use this information and determine in whole numbers: 1 The average actual monthly sales for that period          2 Trends: Reduce this average by 6% per month for the next three months    3 Simple Moving Average (SMA): make a forecast for July using a three months simple moving average.        4 Weighted Moving Average (WMA): make...

  • Name 1. Observations of the demand for a certain part stocked at a parts supply depot during the ...

    Name 1. Observations of the demand for a certain part stocked at a parts supply depot during the calendar year 1999 were Month Janua Demand 89 57 144 221 Februa March ril Ma June Jul August September October November December 280 223 286 212 275 188 312 Determine the forecasts for July though December of the year 1999 considering 2, 3, and 6- month moving averages Compute the MAD for the obtained forecasts. Which method gave you better results? Determine...

  • Month Price per Chip Month Price per Chip January $1.80 July 1.80 February 1.67 August 1.83...

    Month Price per Chip Month Price per Chip January $1.80 July 1.80 February 1.67 August 1.83 March 1.70 September 1.70 April 1.85 October 1.65 May 1.90 November 1.70 June 1.87 December 1.75 Use a 3-month moving average and add the 3-month plot to the graph created in part (a). Which is better (using the mean absolute deviation): the 2-month average or the 3-month average? Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of...

  • Use the following sales data to answer the questions. Month                              Sales January&nbsp

    Use the following sales data to answer the questions. Month                              Sales January                              $250,000 February                            $200,000 March                               $300,000 April                                  $350,000 May                                   $450,000 Using a two month moving average, what are the expected sales for June? Using a three month moving average, what are the expected sales for June? Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six months are shown below, along with the results of two different...

  • DEMAND FORECASTING CASE STUDY You have been hired as a demand planning intern for the Maui...

    DEMAND FORECASTING CASE STUDY You have been hired as a demand planning intern for the Maui Jim Inc. They want you to develop a forecast for their Longboard style of sunglasses. The goal is to determine how many pair they will produce to meet vendor demand ir first meeting, you were handed some data to work with and e about the company's upcoming promotional blitz to support Spring Break '19 in major vacation destinations. 9. During your am talked Month...

  • Examples 1,2,3 1. Beyond Tea Inc. wants to forecast sales of its menthol green tea. The...

    Examples 1,2,3 1. Beyond Tea Inc. wants to forecast sales of its menthol green tea. The company is considering either using a simple mean or a three-period moving average to forecast monthly sales. Given sales data for the past 10 months use both forecasting methods to forecast periods 7 to 10 and then evaluate each. Which method should they use? Use the selected method to make a forecast for month 11. (Show all calculations .... Please read Examples1, 2, 3...

  • CASE 7.1 Tires for You, Inc Tires for You, Inc. (TFY), founded in 1987, is an automotive repair shop specializing in re...

    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 over the past few years because of the addition of a new general manager, Ian Overbaugh. Since tire replacement is a major portion of TFY's business (it also performs oil changes, small mechanical repairs, etc.), Ian was surprised at the lack of forecasts for tire consumption for the company....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT