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...
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 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...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36 2 38 3 40 4 41 5 43 6 42 7 43 8 45 9 46 10 48 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 36. (Round your intermediate calculations and answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34 2 37 3 38 4 37 5 40 6 37 7 42 8 44 9 41 10 42 a. Calculate the single exponential smoothing forecast for these data using an ? of 0.20 and an initial forecast (F1) of 34. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5 6 7 8 9 10 b....
Two debts, the first of $1900 due three months ago and the second of $1300 borrowed two years ago for a term of four years at 8.6% compounded annually, are to be replaced by a single payment one year from now. Determine the size of the replacement payment if interest is 7.5% compounded quarterly and the focal date is one year from now. The size of the replacement payment is $ (Round to the nearest cent as needed. Round all...