hello I need help with B 3,4,5 in excel please 2. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month periodwere as follows:MonthSales (000 units)Feb.19Mar.18Apr.15May20Jun.18Jul.22Aug.20a. Plot the monthly data on a sheet of graph paper.b. Forecast September sales volume using each of the following:(1) The naive approach(2) A five month moving average(3) A weighted average using .60 for August, .30 for July, and .10 for June(4) Exponential smoothing with a smoothing constant equal to .20, assuming a a March forecast of19(000)(5) A linear trend equationWhich method seems least appropriate? Why? (Hint: Refer to your plot from part a.)What does use of the term sales rather than demand presume?

Forecasting is the process of prediction in which sales demand is estimated using historic…

(3) A weighted average using.60 for August, .30 for July, and .10 for June (4) Exponential smoothing with a smoothing constant equal to .20, assuming a a March forecast of 19(000) (5) A linear trend equation

(3) A weighted average using.60 for August, .30 for July, and .10 for June (4) Exponential smoothing with a smoothing constant equal to .20, assuming a a March forecast of 19(000) (5) A linear trend equation

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 42P: The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars)...

See similar textbooks

Related questions

Q: a. Obtain the linear trend equation for the following data on new checking accounts at Fair…

Q: Use a three-period weighted-moving average forecast to determine a forecast for the 8th week using…

A: THE ANSWER IS AS BELOW:

Q: hat are the benefits of exponential smoothing as a forecasting method over running averages

A: The advantages of the exponential smoothing over moving averages with respect to the forecasting…

Q: Consider the following set of time series sales data for a growing company over the past 8 months:…

A: The time series plot shows a horizontal pattern.

Q: Monthly sales for a six month period are as follows: Month Sales Jan 18,000 Feb 22,000 Mar 16,000…

A: 1). Four-month moving average:

Q: Sales for the past 6 months at Computer Success are given here. Month Sales $ January 150 February…

A: Given data is

Q: All forecasting methods using exponential smoothing, adaptive smoothing, and exponential smoothing…

A: Forecasting is the process of predicting future demand values based on historical data. The…

Q: Using the data set below, what would be the forecast for period 5 using the exponential smoothing…

A: Forecasting is the process of estimating future sales or demand using previous data and information.…

Q: Which of the following smoothing constant would make an exponential smoothing forecast equivalent to…

A: alpha of 1.0 leads to an exponential smoothing forecast similar to a naive forecast.

Q: Sales volume of July was 390. Use exponential smoothing with a smoothing constant o.2 to find the…

Q: A check-processing center uses exponential smoothing to forecast the number of incoming checks each…

A: Given Forecast S(June) = 42 million Checks in June X(June) = 40 million Smoothing constant α=0.2

Q: Explain the basic assumptions made when using time series forecasting techniques as opposed to…

A: The Time Series Initial Phase makes a variety of assumptions.

Q: Period Actual 1 12 2 15 16 4 16 Given the information in the following table, Use exponential…

A: Note: - Since the actual data for period 5 is not given, the trend-adjusted forecast can be made by…

Q: A company has an unbiased forecast for its demand. What does that mean?a. All forecast errors are…

A: Forecasting is the procedure of prediction making for the future grounded on past as well as present…

Q: Compute a 3-month weighted average forecast for months 4 through 9. Assign weights of 0.55, 0.33 and…

A: Forecasting is a technique used to predict future outcomes on the basis of past data. There are…

Q: If the tracking signal for your forecast was consistently positive, you could then say this about…

A: Tracking signal, as the name suggests, is a way to evaluate the forecast in comparison to actual…

Q: Using trend-adjusted exponential smoothing, Forecasts (F₂), Trend (T₂), and Forecasts Including…

A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…

Q: a. Forecast the sales for the month of July using a 3-week moving average b. Forecast the sales for…

A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…

Q: a) Forecast the demand for the week of October 12 using a 3-week moving average. b) Use a 3-week…

A: Forecasting is the process of estimating the future demand according to previous or historic…

Q: Forecasts based on averages. Given the following data:PeriodNumber ofComplaints1 602 653 554 585…

A: Formula: Answer:

Q: exponential functions for trend data. Assume an initial exponential Forecast of 620 units in period…

A: Below is the solution:-

Q: Forecasting time horizons include:a) long range. b) medium range.c) short range. d) all of the…

A: Forecasting is that of the method by that managers make estimates about future events. It's…

Q: A production company was able to hit the following sales order for the past 3 months: 45% of 420pcs…

A: Given data is

Q: The accompanying dataset provides data on the monthly usage of natural gas (in millions of cubic…

A: Given data is Alpha = 0.6 Gamma = 0.8

Q: hillip Cane, the managing editor of Your Life Magazine, needs to develop a forecasting system for…

A: Month (2020) Sales May 50…

Q: With a = 0.1 and the initial forecast for October of $1.83, using exponential smoothing, the…

A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…

Q: All forecasting methods using exponential smoothing, adaptive smoothing, and exponential smoothing…

A: Forecasting is the process of making assumptions of the future on the basis of past and present…

Q: a. Compare a three-month moving average forecast with an exponential smoothing forecast. Use a = .1.…

A: Forecasting is the process of predicting the future demand based on the previous data or demand.

Q: c. Using simple exponential smoothing, what would your forecast be for this month if the…

Q: our manager is trying to determine what forecasting method to use. Based upon the following…

A: first we put the value on excel sheet then applying weighted moving average formula which shown in…

Q: a) Using a weighted 3-month moving average with weights of 0.60, 0.30, and 0.10, Find the July…

A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…

Q: exponential smoothing superior to moving averages

A: Remarkable smoothing is a general guideline method for smoothing time arrangement information…

Q: Your manager is trying to determine what forecasting method to use. Based upon the following…

A: In exponential smoothing, the smoothing constant is used to forecast the demand for the next period…

Q: What effect does the number of cycles in a moving average have on the forecast's responsiveness?

A: In order to estimate potential demand, the Moving Average (MA) projection method uses the MA formula…

Q: Exponential Smoothing gives always better results than any other similar method used for time-series…

A: Forecasting in the business management is described as the process through the probable demand in…

Q: snip

A: A moving average forecast becomes less responsive to change in a data series when more data points…

Q: The following set of data represents the quarterly changes in demand for an item over the next 3…

A: When determining the direction of future trends, forecasting is a technique that makes educated…

Q: Forecasts are generally wrong.a. Why are forecasts generally wrong?b. Explain the term “wrong” as it…

A: Forecasting generally means predicting or estimating something for future events. It is also about…

Q: a) Use a 2-month moving average on all the data and plot the averages and the prices. b) Use a…

A: The mean absolute deviation(MAD) shows the errors in the forecasted values from the actual values.…

Q: 2. Simple moving average using Excel: Calculate demand forecast for weeks 6-20 using 5 week simple…

A: Forecasting is predicting the demand/sales in advance for future periods. Moving average forecast is…

Q: Sales volume of July was 390 Use exponential smoothing with a smoothing constant to find the…

A: Forecasting is the process of making assumptions of future events based on past and present…

Q: Using the latest observation in a sequence of data to forecast the next period is a. a naive…

A: Find the answer below: The Correct answer is a) a naïve forecast

Q: Use a three-period moving average method to determine forecast value for time 5 to 7. Use an…

A: THE ANSWER IS AS BELOW:

Q: a) Calculate the forecasted registrations for years 2 through 12 using exponential smoothing, with a…

A: ANSWER IS AS FOLLOWS:

Q: A)- Explain the calculation method for the Naive Forecast model. B) If at the end of every month…

A: Forecasting the values in advance helps to reduce the cost, and increase profits by reducing wastage…

Q: b) Use a 3-week weighted moving average, with weights of.1, .3, and .6, using.6 for the most recent…

A: Forecasting is the process of determining the estimated future demand using historical information…

Q: Use trend-adjusted exponential smoothing to forecast the firm’s August income. Assume that the…

A: Trend-adjusted exponential smoothing is a method that uses measurable, historical data observations,…

Q: a. Calculate the simple three-month moving average forecast for periods 4 to 12.

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: It has been said that forecasting using exponential smoothing is like driving a car by looking in…

A: Exponential smoothing is a time series forecasting technique for univariate data that can be…

Question

hello I need help with B 3,4,5 in excel please

2. 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
a. Plot the monthly data on a sheet of graph paper.
b. Forecast September sales volume using each of the following:
(1) The naive approach
(2) A five month moving average
(3) A weighted average using .60 for August, .30 for July, and .10 for June
(4) Exponential smoothing with a smoothing constant equal to .20, assuming a a March forecast of
19(000)
(5) A linear trend equation
Which method seems least appropriate? Why? (Hint: Refer to your plot from part a.)
What does use of the term sales rather than demand presume?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Under what conditions might a firm use multiple forecasting methods?
The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
The table shows the values found in the error analysis. What method of forecasting would be best to use? What is the forecasted value? MSE forecast for week 13 Time Series 1.08 14.76 3-week MA 3.04 13.67 exp smoothing 11.04 9.5 Group of answer choices A.) Time Series, forecasted value = 14.76 B.) 3-week MA, forecasted value = 13.67 C.) exp smoothing, forecasted value = 9.5 D.) Time Series, forecasted value = 1.08 E.) 3-week MA, forecasted value = 3.04 F.) exp smoothing, forecasted value = 11.04
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000 units)Feb. 19Mar. 18Apr. 15May 20Jun. 18Jul. 22Aug. 20 Forecast September sales volume using each of the following: (1)The naive approach. (2)A five-month moving average. (3)A weighted average using .60 for August, .30 for July, and .10 for June.
Plot the table and give at least three observations from the plot according to the given data Weeks Calls 3 month Weighted Moving Average Error =Abs (Actual -Forecasted) (Sum of Absolute percent error) 1 50 2 35 3 25 4 40 31.42857143 8.571428571 21.42857143 5 45 35 10 22.22222222 6 35 40.71428571 5.714285714 16.32653061 7 20 38.57142857 18.57142857 92.85714286 8 30 27.85714286 2.142857143 7.142857143 9 35 27.85714286 7.142857143 20.40816327 10 20 31.42857143 11.42857143 57.14285714 11 15 25.71428571 10.71428571 71.42857143 12 40 19.28571429 20.71428571 51.78571429 13 55 30 25 45.45454545 14 35 45 10 28.57142857 15 25 41.42857143 16.42857143 65.71428571 16 55 32.14285714 22.85714286 41.55844156 17 55 43.57142857 11.42857143 20.77922078 18 40 50.71428571…
Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with alpha = 0.5 Forecast the number of calls for week 6, which is next week. Week Actual service calls 1 28 2 36 3 38 4 25 5 25 The forecast for week 6 is ___ service calls (round to two decimals and show your work)
Exercise # 2 –Calculating MADt, Revised MADt,Error,and the Revised Error :Has the Forecast Improved ? How much has it improved in % terms ? Franklin Henry forecasts demand for an auditing and accounting services group, for an estate planning group ,and a business consulting group.His group forecasts for the preceding six-month(M) period, which were made six months prior to that time, are each based on a level, patternless projection.The following data table shows these forecasts(F) and the actual demand (AD) for each group : Estate Planning Auditing and Accounting Business Consulting (Client –days) (Client –days) (Client –days) M AD F M AD F M AD F 1 120 130 1 260 230 1 120 120 2 80 130…
2)Auto sales over a 4-month period were forecasted as follows: 89, 98, 105, and 97. The actual results over the 4-month period were as follows: 92, 96, 101, and 100. What was the MAD of the 4-month forecast? (use an excel sheet to make all calaculations and show formulas used in excel)
Handy, Inc., produces a solar-powered electronic calculator that has experiencedthe following monthly sales history for the first four months of the year, inthousands of units:January 23.3 March 30.3February 72.3 April 15.5a. If the forecast for January was 25, determine the one-step-ahead forecasts forFebruary through May using exponential smoothing with a smoothing constant of a=.15.b. Repeat the calculation in part (a) for a value of a= .40. What difference in theforecasts do you observe?c. Compute the MSEs for the forecasts you obtained in parts (a) and (b) forFebruary through April. Which value of a gave more accurate forecasts, basedon the MSE?
Q5) Monthly sales for a six month period are as follows: Month SalesJan 18,000Feb 22,000Mar 16,000Apr 18,000May 20,000June 24,000 Compute the sales forecast for July using the following approaches: (1) Four-month moving average; (2) Weighted three-month moving average using .50 for June, .30 for May and .20 for April;(3) Exponential smoothing with α (smoothing constant) equal to .40, assuming a February forecast of 18,000
Given November actual demand of 61, November forecast of 58, and an alpha of 0.4, November trend value +1.03, Beta of 0.3 what would the forecast including trend (FIT) for the December period be using exponential smoothing model 2? Select one: a. 62.03 b. cannot be found c. 68.76 d. 65.72