Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 670 Jun 652 Jul ??? Using a 2 month weighted moving average with weights of 80% for the previous month and 20% for two months back, what is the forecast for July. Round your answer to 1 decimal place. ??? 400 —— --

Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 670 Jun 652 Jul ??? Using a 2 month weighted moving average with weights of 80% for the previous month and 20% for two months back, what is the forecast for July. Round your answer to 1 decimal place. ??? 400 —— --

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Considering the fact that the number of students is relatively constant throughout the academic year, the college's cafeteria is planning for the second semester based of the actual sales the first semester. Month Actual Sales of Fall 2016 Forecast of Spring 2017 September 250 October 300 November 280 December 200 With the given information, can the forecast of November be obtained using a 3-month weighted moving average? Explain you answer.
Sales of tablet computers at Ted Glickman's electronicsstore in Washington, D.C., over the past 10 weeks are shownin the ta ble below: a) Forecast demand for each week, including week 10, usingexponential smoothing with a = .5 (in itial forecast = 20).b) Compute the MAD.c) Compute the tracking signal.
What is the forecast for March using a three-month moving average? Sep. Oct. Nov. Dec. Jan. Feb. 43 45 39 43 27 56 A. 44 В. 42 C. 35 D. 37 Е. 38
6. Consider the following data table. (12 Points) a) Forecast demand using exponential smoothing with an apha of 0.25, and an initial forecast of 128.0 for period 1. b) Calculate the MAD and MSE. Period Real demand 130 138 129 140 3 4 5 133
Trail Questions National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales ('000 units) Feb. 19 Mar. 18 Apr 15 May 20 Jun. 18 Jul. 22 Aug. 20 Forecast September sales volume using each of the following: (1) A linear trend equation. (2) A five-month moving average (3) Exponential smoothing with a smoothing constant equal to .20, assuming a March forecast of 19('000) (4) A weighted average using 0.60 for the most recent month, 0.30 for the next most recent, and 0.10 for the next.
Asvnch Problem - Statistical Forecasting Data Set – Eunice BC Fashion Monthly Sales, in million units. Year Total Sales Year Total Sales 2010 38 2016 43 2011 41 2017 40 2012 40 2018 45 2013 45 2019 47 2014 50 2020 42 2015 42 2021 48 Questions: a. Find the naïve forecast. b. Use the 3 years moving average forecast. c. Have a 5 years weighted moving average. d. Develop forecast using exponential smoothing with a = 0.2. e. Determine the trend line equation and present the forecast. f. Find the best forecast for year 2022. Note: Use the first 5 years as the training samples and the last 5 years as the forecasting samples. Solve it in Excel Sheet/Sheet with Equations as possible.
Use the following data to determine the tracking signal for period 4. Actual Forecast 10 16 23 16 50 49 63 59 108 106 122 118 a. 1.333 b. 1.108 c. 0.742 d. 0.429
Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——
22. Handy, Inc., produces a solar-powered electronic calculator that has experienced the following monthly sales history for the first four months of the year, in thousands of units: 23.3 March January February 30.3 72.3 April 15.5 a. If the forecast for January was 25, determine the one-step-ahead forecasts for February through May using exponential smoothing with a smoothing con- stant of a = .15. b. Repeat the calculation in part (a) for a value of a forecasts do you observe? c. Compute the MSES for the forecasts you obtained in parts (a) and (b) for February through April. Which value of a gave more accurate forecasts, based on the MSE? .40. What difference in the
Define the Following Terms: d. Break-even point e. Approaches to forecasting
Month Actual Forecast Jan 100 100 Feb 110 Mar 200 Apr 140 For the above data, calculate the exponential smoothed forecast for March. Use α = 0.8. A. 135 B. 117 C. 116 D. 108
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. June July August ACTUAL 144 184 210 a. Using a simple three-month moving average, what is the forecast for September? Note: Round your answer to 2 decimal places. Forecast for September b. Using a weighted moving average, what is the forecast for September with weights of 0.30, 0.40, and 0.30 for June, July, and August, respectively? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Forecast for September