The sales of XYZ company for the previous three periods are 45, 42, and 43 respectively. Estimate the sales of the fourth period by exponential smoothing with 0.5. Use naïve as a starting/initial forecast (Round to 2 decimals) O a. None is correct O b. 43.25 O c. 41 O d. 41.92 O e. 42.8

The sales of XYZ company for the previous three periods are 45, 42, and 43 respectively. Estimate the sales of the fourth period by exponential smoothing with 0.5. Use naïve as a starting/initial forecast (Round to 2 decimals) O a. None is correct O b. 43.25 O c. 41 O d. 41.92 O e. 42.8

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: 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: a) Is there a strong linear trend in sales over time? b) Fill in the table with what Bob and Sherry…

A: Using excel for performing regression with Sales as the dependent variable and period as independent…

Q: 12. Under the bottom-up approach, a central person or persons take the responsibility for…

A: The method of predicting future outcomes based on past and present data by analyzing the trends is…

Q: The demand for Krispee Crunchies, a favorite breakfast cereal of people born in the 1940s, is…

Q: a. Predict the sales for Jasmine Slush using the following forecasting methods: - naïve (use simple…

A: Forecasting is to predict the uncertain future of demand and sales. There are various methods to do…

Q: New Accounts Period New Accounts Period 200 6 232 11 214 248 12 3 211 250 13 4 228 253 14 235 10 267…

A: Given data is

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

A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…

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

A: Given: α=0.20β=0.41(F1)=9 unitsT1=2 units Months Actual Demand (At) Forecast (Ft) Trend (Tt)…

Q: It is a common saying that the only thing certain about a forecast is that it will be wrong. What is…

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

Q: nformation, What will be - forecast of June, using month weighted moving erage with the following…

A: Given Information:

Q: The following table shows the past two years of quarterly sales information. Assume that there are…

Q: The sales of XYZ company for the previous three periods are 45, 42, and 43 respectively. Estimate…

A: Forecasting is the method of estimating future occurrences with the help of previous data and…

Q: The Yummy Ice Cream Company uses the exponential smoothing method. Last week the forecast was…

Q: Given the following historical data, what is the moving-average forecast for period 6 based on the…

A: Calculation of moving average forecast for period 6 based on the last three periods:The formula for…

Q: What is the value of your forecast? PX If instead the weights were 20, 15, 15, and 10, respectively,…

A: ANSWERS ARE GIVEN BELOW:

Q: a) Using a weighted moving average with three periods, determine the demand for period 13. Use 3, 2,…

A: Forecasting is the process of predicting future data based on previous or past data and information.…

Q: 20- Forecasting is very important in predicting the future sales of a company. Can you identify the…

A: Below is the solution;-

Q: Consider the following actual (At) and forecast(Ft) demand levels for a commercial multiline…

Q: We have a new chief sales officer who is proposing that we should forecast in dollars, not in…

A: Salespeople are inexperienced with estimate exactness measures. They have no real excuse to be on…

Q: (Round your answers to 2 decimal places.) Complete the table above, filling in the "Forecast for…

A: Forecast refers to the estimation of the future happening according to the previous and current data…

Q: Consider the data below which includes sales data and the forecasts that would have been made using…

A: Given data is

Q: 2-The correlation between rate and base are called the dynamic forecast. Select one: O True O False

A: Correlation is described as the relationship that exists between two different variables…

Q: can I ask some help about our assignment where we are tasked to find a case study in a manufacturing…

A: Trend Forecasting is the process to know the future buying habits of consumers by researching and…

Q: How are you going to make your forecast more effective? Give a concrete example.

A: Forecasting is a decision-making tool used by many businesses to help in budgeting, planning, and…

Q: Period 1 2 3 4 5 6 1. Compute the four period moving average forecast for period 6 and 7. Assume the…

Q: When a new business is started, or a patent idea needs funding, venture capitalists or investment…

A: With the inception of any new enterprise or business, there exists a requirement for the funding and…

Q: B). Using exponential smoothing, calculate the forecasts for months 2, 3, 4, 5, and 6. The smoothing…

A: Find the Calculations below: Formulas:

Q: Here are the errors associated with a particular forecast over the past five months, in…

A: Forecasting is a methodology that uses past information as input to make well-informed predictions…

Q: Consider the monthly sales data of a company for last year as well as first six-month data for…

A: Given information:

Q: My question is: How do you Calculate a moving average forecast using the last 2 and 4 dates of stay.…

A: A moving average, which is the average of any subset of values, is a method for gaining a general…

Q: All forecasts are subject to error. Do you think topmanagers would be concerned about the effectson…

A: Forecasting is described as a tool that will allow the businesses in the budgeting process and also…

Q: Sales of tablet computers at Ted Glickman's electronicsstore in Washington, D.C., over the past 10…

A: Given data is

Q: Plot the demand data. What do you observe? Forecast XR-42S demand for month 7, using a weighted…

A: Given data - Month Number of lenses sold 1 12 2 17 3 15 4 20 5 18 6 23

Q: 1. What is the tracking signal for the forecast?

A: Forecasting is the process of predicting future demand according to the previous information or…

Q: sing data in columns A-C create a forecast using the Simple Moving Average method based on 10 weeks…

A: Forecasting means predicting in advance the values of future sales/demand by using different methods…

Q: Serena just visited a restaurant for dinner. During the dinner time, she overheard two customers…

A: It's a case where employees have leaked the confidential information unknowingly in the public. It's…

Q: b) Use exponential smoothing with a smoothing constant of 0.30 to forecast the sales. Assume that…

A: The Exponentially Weighted Moving Average (EWMA) is a quantitative or factual measure used to…

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: (3) A weighted average using.60 for August, .30 for July, and .10 for June (4) Exponential smoothing…

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

Q: 2. Using the same table above, compute the weighted moving average forecast for demand for four…

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

Q: Develop a three-week moving average. A.What is the forecast for week 5? (Make sure no decimal place…

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

Q: IST STATEMENT: Forecast that are too low mean the company has not allocated enough resources that…

A: “Hi and thanks for your questions as you have asked for multiple questions at a time we will be…

Q: Which one of the following is considered a disadvantage of sales force composite method of…

A: The Sale Force Composite Method is a sale forecasting method wherein the sales specialists forecast…

Q: Use the following information to compute a single exponential smoothing model forecast with a…

A: From the above information, Let, Forecast for period 1 =f1 =115 Actual value for period 1 =a1…

Q: Let's say you are playing the stock market and below period 2020 data was provided. For "stock A"…

A: The answer is as below

Q: Herman Hahn is attempting to set up an integrated forecasting and inventory controlsystem for his…

A: Time-series forecasting and seasonality factors in it:

Q: All forecasts are built on one of three information bases: what people say, what people do, or what…

A: The рrосess оf gаthering infоrmаtiоn fоr а better understаnding оf the tаrget mаrket is…

Q: Calculate and answer parts a through d. Include all calculations and spreadsheets in your post.…

A: Formula: Answer:

Question

The sales of XYZ company for the previous three periods are 45, 42, and 43 respectively. Estimate the sales of the
fourth period by exponential smoothing with 0.5. Use naïve as a starting/initial forecast (Round to 2 decimals)
O a. None is correct
O b. 43.25
O c. 41
O d. 41.92
O e. 42.8

Expert Solution

This question has been solved!

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

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

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.
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Year Sales 1 450 2 502 3 520 4 570 5 575 a) Forecasted sales for year 6 using the trend projection (linear regression) method aresales (round your response to one decimal place). b) The MAD for a linear regression forecast is nothing sales (round your response to one decimal place).
Historical sales data is shown below. Week Actual Forecast 1 328 300 2 272 3 245 4 223 5 205 6 Using alpha (α) = 0.2, what is the exponential smoothing forecast for period 6? Note: Round your answer to 2 decimal places. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Amazon finds that sales in July are much greater relative to other months because of the Amazon Prime days in that month. Assuming that an exponential smoothing model is used for forecasting sales, what should the company best do to make the forecast for the next month (Aug) more reflective of reality? Please pick from the provided options. F t+1 = αDt + (1-α) Ft increase value of alpha decrease value of alpha stay with the same alpha decrease the expected forecast for the current month (Ft) On hearing our forecast, our clients probe - how sure are we about the forecast? Which measure of errror (among those stated below) should we best use to respond? a. Root MSE (RMSE) b. Mean absolute percentage error (MAPE) c. Mean forecast error (Avg. error) d. Cumulative forecast error (CFE)
In each of the following, name the term defined or answer the question. Answers are listed at the bottom. Assume you are using exponential smoothing with an adjustment for trend. Demand is increasing at a very steady rate of about five units per week. Would you expect your alpha and delta parameters to becloser to one or zero? Your forecast is, on average, incorrect by about 10 percent. The average demand is 130 units. What is MAD? If the tracking signal for your forecast was consistently positive, you could then say this about your forecasting technique. What would you suggest to improve the forecast described in question 10?12. You know that sales are greatly influenced by theamount your firm advertises in the local paper. Whatforecasting technique would you suggest trying?13. What forecasting tool is most appropriate when closelyworking with customers dependent on your products?
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Year Sales 1 455 2 510 3 518 4 570 5 590 a) Forecasted sales for year 6 using the trend projection (linear regression) method are 627.6627.6 sales (round your response to one decimal place). b) The MAD for a linear regression forecast is nothing sales (round your response to one decimal place).
*** Can you please demonstrate how to do parts d, e, f? Given: Year Demand 1 7 2 9 3 5 4 9 5 Predict the value for Year 5: 2 year moving average What is MSE for 2 year moving average? 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period Exponential smoothing, =0.2 and forecast for Year 1 = 5 Linear trend Which forecast method has the least amount of error using MAD? What is the coefficient?
-Please answer part iv. which is related to the three part question posted some moments ago that has been answered already. iv. Determine which of the three forecasting technique is the most accurate usingMAD. -Also, please answer the below two parts to this new question. The following table shows the number of televisions sold over the last ten years at a local electronic store. Year TV Sales 1 150 2 300 3 480 4 600 5 630 6 640 7 700 8 825 9 900 10 980 i) Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all working. You will need to develop a table to calculate the slope and the intercept.ii) Use that formula to forecast television sales for years 11 and 12.
(Use excel to show formulas used) Use regression or simple exponential smoothing with the following data. For exponential smoothing, assume the forecast for year 1 was the same as the actual and use an alpha of 0.7. Year Sales 1 290 2 340 3 400 4 410 5 400 Forecast Year 6 sales. Compute MAD.
Clinic administrator Marc Schniederjans wants you to forecastpatient demand at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this fore-cast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.25 one period ago, 0.25 two peri-ods ago, and 0.167 three periods ago. a) What is the value of your forecast? PXb) If instead the weights were 20, 15, 15, and 10, respectively, howwould the forecast change? Explain why. c) What if the weights were 0.40, 0.30, 0.20, and 0.10, respec-tively? Now what is the forecast for week 7?