Given the following demand numbers, create a forecast for April through January of the following year....

Given the following demand numbers, create a forecast for April through January of the following year. The forecast demand for a time period is the average of the previous three time periods. This is called a three-period moving average. For example, the April Forecast of 101 is the average of the Demand for January through March. The following table contains the demand numbers and the forecast. Use Excel to calculate the values in the Forecast column. A spreadsheet without formulas will not receive any credit. Month Demand Forecast January 119 February 72 March 113 April 82 101 May 82 89 June 131 92 July 111 98 August 116 108 September 89 119 October 95 105 November 88 100 December 90 91 January 91

Expert Solution

Month	Demand	Forecast
January	119
February	72
March	113
April	82	101
May	82	89
June	131	92
July	111	98
August	116	108
September	89	119
October	95	105
November	88	100
December	90	91
January	91	91

WORKINGS

jeff jeffy answered 11 months ago

Develop a three-period moving average forecast for April 2019 through January 2020. Calculate the MFE, MAD,...

Develop a three-period moving average forecast for April 2019 through January 2020. Calculate the MFE, MAD, and MAPE values for April through December 2019. LOADING... Click the icon to view the time series data. Develop a three-period moving average and fill-in the table below (enter your responses rounded to one decimal place). Month Demand Forecast January 2019 123123 February 7474 March 114114 April 7777 103.66103.66 May 9898 88.3388.33 June 136136 96.3396.33 July 103103 103.66103.66 August 106106 112.33112.33 September 100100 103103...

The sales forecast is based on projected levels of demand. All the numbers are expressed in...

The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. Price per bus $220,000 Units sold per year 12,250 Labor cost per bus $32,500 Components & Parts $86,500 Selling General & Administrative $200,000,000 The average warranty cost per year per bus for the first five years is $2,000. The present value of this cost will be used as a cost figure for each bus. Afterwards, the bus operator will become responsible the...

. Using only the New York sales data: 1a. Forecast sales for January 5th through January...

. Using only the New York sales data: 1a. Forecast sales for January 5th through January 30th using exponential smoothing with alpha set to 0.6. Assume the sales forecast for January 4th was 456. 1b. Using your forecasts from 1a, find the mean absolute deviation of the sales forecasts for January 5th through January 29th. Again, you should not include the forecast for January 30 since there is no corresponding sales figure for that date. 1c. Using your forecasts from...

As for the sales forecast for Year 1 through Year 3, these are some important variables...

As for the sales forecast for Year 1 through Year 3, these are some important variables I will go to consider for sales: Economy: The economic condition of the city, the province and the country are variables I need to consider for a sales forecast. If conditions are poor, people will spend less money on consumption. If economic conditions are great, then more people will have extra money to spend. Competition: I need to consider the level of competition I...

Consider monthly demand for the ABC Corporation as shown below. Forecast the monthly demand for Year...

Consider monthly demand for the ABC Corporation as shown below. Forecast the monthly demand for Year 6 using the 3-period moving average and 4-period moving average. Evaluate the bias, TS, MAD, MAPE and MSE. Evaluate the quality of the forecast Sales Year 1 Year 2 Year 3 Year 4 Year 5 JAN 2000 3000 2000 5000 5000 FEB 3000 4000 5000 4000 2000 MAR 3000 3000 5000 4000 3000 APR 3000 5000 3000 2000 2000 MAY 4000 5000 4000 5000...

Historical demand for a product is: DEMAND January 20 February 19 March 23 April 20 May...

Historical demand for a product is: DEMAND January 20 February 19 March 23 April 20 May 24 June 23 a. Using a weighted moving average with weights of 0.40 (June), 0.40 (May), and 0.20 (April), find the July forecast. (Round your answer to 1 decimal place.) July forecast b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) July forecast c. Using single exponential smoothing with ? = 0.30 and a June...

Historical demand for a product is DEMAND January 15 February 12 March 16 April 15 May...

Historical demand for a product is DEMAND January 15 February 12 March 16 April 15 May 17 June 16 a. Using a weighted moving average with weights of 0.60 (June), 0.20 (May), and 0.20 (April), find the July forecast. (Round your answer to 1 decimal place.) b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) c. Using single exponential smoothing with ? = 0.30 and a June forecast = 11, find...

A company has developed a forecast using the Delphi method for January through June 1. Using...

A company has developed a forecast using the Delphi method for January through June 1. Using the data provided, what is the Mean Absolute Deviation for the forecast method? 2. Using the data provided, what is the MAPD? Month Demand Forecast January 232 234 February 225 222 March 239 240 April 260 261 May 234 231 June 260 262

A manager receives a forecast for next year. Demand is projected to be 528 units for...

A manager receives a forecast for next year. Demand is projected to be 528 units for the first half of the year and 960 units for the second half. The monthly holding cost is $2 per unit, and it costs an estimated $55 to process an order. a. Assuming that monthly demand will be level during each of the six-month periods covered by the forecast (e.g., 88 per month for each of the first six months), determine an order size...

Prepare a monthly cash budget for January through April. Be sure to clearly show the surplus...

Prepare a monthly cash budget for January through April. Be sure to clearly show the surplus (deficit) of cash. Based on the deficit cash shown on your cash budget, what is the dollar amount that Bond Private Security should have for a line of credit over this 4-month period? Note: don’t add a “cushion”, just base this amount off of the cash budget. Collections during month of sale 35% Collections during month after sale 50% Collections during second month after...

Question