Actual demand for a product for the past three months was Three months ago Two months...
Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 330 285 February 450 385 March 455 355 April 455 410 May 410 440 June 435 350 July 400 390 August 310 300 September 355 395 October 480 November 555 December 540 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33 2 32 3 31 4 38 5 42 6 38 7 42 8 42 9 43 10 43 a. Calculate the single exponential smoothing forecast for these data using an α of 0.20 and an initial forecast (F1) of 33. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5 6 7 8 9 10
A company has observed the following demand during the past 10 months for one of its popular products. Month Demand 1 60 2 80 3 40 4 80 5 120 6 70 7 110 8 120 9 80 10 100 a plot these data on a graph. Do you observe any pattern such as trend, seasonal, cyclical, or random variations in the data? b Compute 3-month moving average forecasts from Month 4 to Month 11. Plot the forecast in the...
Below are the forecasts and actual demands for the first three months. What is the Mean Absolute Deviation (MAD) for these three months? Forecast Actual Month 1 Month 2 Month 3 14 14 11 10 16 13 O 1.00 2.67 1.33 1.67
Below are the forecasts and actual demands for the first three months. What is the Mean Absolute Deviation (MAD) for these three months? Forecast Actual Month 1 Month 2 Month 3 14 14 13 11 16 13 1.00 O 1.67 O 1.33 2.67
Below are the forecasts and actual demands for the first three months of the year. Calculate the Mean Squared Error (MSE) for the first three months Forecast Actual Month 1 Month 2 Month 3 14 14 13 12 12 13 4.33 2.67 1.67 8
1. The demand for a product of Carolina Industries varies greatly from month to month. Based on the past two years of data, the following shows the monthly demand at Carolina Industries. # Months Unit Demand 300 400 500 600 a. If the company places monthly orders equal to the expected value of the monthly demand, what should Carolina's monthly order quantity be for this product? b. What are the variance and the standard deviation for the number of units...
The following are historical demand data: YEAR SEASON ACTUAL DEMAND 2 years ago Spring 200 Summer 143 Fall 385 Winter 575 last year Spring 468 Summer 272 Fall 684 Winter 960 Use regression analysis on deseasonalized demand to forecast next summer’s demand. (Round your answer to the nearest whole number.) Forecast for next summer’s demand 236
The following are historical demand data: YEAR SEASON ACTUAL DEMAND 2 years ago Spring 204 Summer 148 Fall 380 Winter 565 last year Spring 482 Summer 265 Fall 680 Winter 966 Use regression analysis on deseasonalized demand to forecast next summer’s demand. (Round your answer to the nearest whole number.) Forecast for next summer’s demand
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33 2 29 3 32 4 33 5 35 6 32 7 35 8 42 9 44 10 45 a. Calculate the single exponential smoothing forecast for these data using an α of 0.10 and an initial forecast (F1) of 33. (Round your answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.10, a...