Answered: Using the following, forecast the sales…

Using the following, forecast the sales for the months up January the following year iii. Exponential Smoothing when α= .6 and the forecast for March is 350.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.7: Exponential Smoothing Models

Problem 28P: The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present...

See similar textbooks

Related questions

Q: Activities' estimated duration and the time intervals at which the actual progress is analyzed…

A: An activity's estimated duration can be defined as the approximated time that will be taken by a…

Q: Planning for quality is necessary but often forgotten or dismissed function on a project. Discuss…

A: A project quality plan is a set of documented standards or procedures that are followed during a…

Q: A passenger aircraft is composed of several millions of parts and requires thousands of persons to…

A: The primary distinction between creating an airplane, a bridge, or software is that when we create…

Q: Projects are different from operations, state any Five (5) project attributes.

A: Projects are one of the most important aspects of any organization. They are temporary, and they…

Q: Bindley Corporation has a one-year contract to supply motors for all washing machines produced by…

A: Build transportation grid as follows.

Q: UCLc= _______ (round your response to two decimal places). LCLc= _______ (round your response…

A: Control charts are also known as process-behaviour charts. It is a statistical process that helps in…

Q: Sales Cost of supply chain purchases Other production costs Fixed costs Profit 280,000 182,000…

A: Profit = Sales - Fixed costs - Other production costs - Cost of supply chain purchases Given, Profit…

Q: Discuss the role of the Literature Review in a scholarly article. What is it? Why are writing…

A: The goal of a literature review is to increase understanding of current research and conversations…

Q: What type of control chart should be used to monitor the process dispersion?

A: a. p-chart:- This chart is used to control the fraction of defectives. b. range chart:- In this…

Q: Explanation of how the capacity analysis reacts to several processes running in simultaneously.

A: Capacity analysis is the difference between actual output and possible output in any process. The…

Q: Give an account of the capacity analysis's behavior when several processes run in parallel.

A: Capacity analysis is the difference between actual output and possible output in any process. The…

Q: c. Prepare a naive forecast for periods 2 through 11 using the given sales data. Compute each of the…

A: Formulae used: For Error = Actual Sales – Forecast For Abs = Absolute value of | Actual Sales –…

Q: CRISIS IT In May 2007, Frontier Airlines Holdings hired Gerry Coady as chief information officer…

A: 1. Too many projects and too few resources: The airline had accepted too many projects. As the…

Q: Explain the concept of Liquidation Strategy?

A: Liquidation Strategy Define - it is the type of strategy in which businesses sell their assets in…

Q: 4. It takes Susan 30 minutes to solder 10 circuit boards to fill a container and 2 minutes to…

A: NOTE: We are allowed to do one question only. Ans 4. Given: no.of kanbans K 5 processing…

Q: You have several tables here. What is the final 3×3 table solution that is asked for in the proem?

A: Working notes: There are two weather condition given i.e. near freezing tempratture and deep…

Q: In an M/M/1 queueing system, the arrival rate is 5 customers per hour and the service rate is 7…

A: Given data: In an M/M/1 queueing system Arrival rate ( λ) = 5 customer per hour Service rate (μ) =…

Q: Consider the following LP problem developed at Zafar Malik's Carbondale, Illinois, optical…

Q: Webster Chemical’s nominal weight for filling tubes of caulk is 8.00 ounces ± 0.60 ounces. The…

A: Find the Calculations methods below: Given details: Nominal Weight 8 ± 0.6 Ounces Upper…

Q: The objective of inventory management is to minimize inventory costs while A.having only enough…

A: Ans) Inventory is usually maintained if they are supply shortages or increase in demand. It helps in…

Q: Sales representatives sell two products A and B. Based on historical data there is an average 20…

A: a) Maximize Z = 20 A + 10 B subject to 3A + 2B <= 165 hours A >= 25 atleast 25…

Q: ow do the ACT and SAT affect high school students?

A: As per a review directed by the Princeton Review; "The reason for the SAT is to gauge a high school…

Q: An operations planner, Lovell Bradley, is developing a sales and operations plan that involves back…

A: If production plus beginning inventory is greater than the demand of period, then ending inventory…

Q: Identify the sampling techniques used in each scenario. To ensure the quality of its products,…

A: There are basically two kinds of sampling techniques which are : Probability techniques Non -…

Q: Daniel Tracy, owner of Martin Manufacturing, must expand by building a new factory. The search for a…

A: Initial calculation:

Q: The table below shows the sales figures for a brand of shoe over the last 12 months. Months Sales…

A: (i) (ii)

Q: Planning for quality is necessary but often forgotten or dismissed function on a project. Discuss…

A: A project quality plan is one of the important component of the project management. At the…

Q: How can you manage your expectations in your relationship?

A: Converse with your partner about the thing you're both anticipating from the relationship. It will…

Q: Which of the following is likely to be data rather than information? a. Top 3 suppliers with the…

A: Data: Data is a collection of unprocessed, raw facts and information, such as text, observations,…

Q: Prior to conducting double exponential smoothing a simple linear regression is conducted and the…

A: Double exponential smoothing computes a trend equation through the data using a special weighting…

Q: chain analysis. Critically discuss the primary value chain activities ( Inbound logistics,…

A: The systems that a business or organization employs to generate revenue are combined into a value…

Q: How does the insurance grievance redressal mechanism works in your country ?

A: Insurance Grievance Redressal Mechanism :Having a complaint or a grievance with the insurance…

Q: Solve the following Assignment Problem using Hungarian method. PERSON 1 3x N W TASK 2 3 8 20 15 17 X…

A: The number of rows = 4 and columns = 4 1 2 3 4 W 8 20 15 17 X 15 16 12…

Q: Identify and explain four assumptions of the economic order quantity

A: Economic order quantity : Economic order quantity is necessary to minimize order-related and the…

Q: Mr. Jack is in the process of expanding his manufacturing business. He decided to open a plant in…

A: i) Total Cost (Location A) = 60000+30x Total Cost (Location B) = 80000+20x Total Cost (Location C) =…

Q: Quality control in a factory pulls 40 parts with paint, packaging, or electronic defects from an…

A: Quality control in a factory pulls 40 parts with paint, packaging, or electronic defects from an…

Q: The units of Manganese Plus available for sale during the year were as follows: Mar. 1 June 16 Nov.…

A: Given data: Unit Cost per unit Amount 1-Mar Inventory 23 29 667 16-Jun Purchases 32 30…

Q: Briefly elaborate the importance of Quality control department for the national and international…

A: Quality is an important factor with regards to any item or service. With the high market…

Q: Should tipping in restaurants be mandatory?

A: In the United States, almost every restaurant expects a tip after a meal, despite the fact that it…

Q: Mrs. Crabapple has a class with three students, and she has had four quizzes so far this semester.…

A: A control chart is a statistical process control tool that is used to monitor and analyze the…

Q: Explain in details what you understand by this statement ''Managing for impact '' requires…

A: Management in simple words is an individual or group of people accepting challenges in various kind…

Q: How many units should you hold in finished-goods in a Replenishment Pull System if the daily demand…

A: Container required = Total requirement during lead time / Units per container Total requirement…

Q: M&D Chemicals produces two products that are sold as raw materials to companies that manufacture…

A: Objective Functions and Constraints: Based on the given details, the objective…

Q: Please answer part D to the below four part question. I've included the answers for the first three…

A: Please note that the provided answers are not relevant to the actual questions. here I have solved…

Q: Inquiries of warehouse personnel concerning possibly obsolete or slowmoving inventory items provide…

A: Answer (A) is incorrect because inquiries of warehouse personnel concerning possible obsolete or…

Q: The goal of supply chain management is to ensure that the right product is delivered to the right…

A: Today, the world has become a global market. Anything can be bought from any corner of the world.…

Q: With respect to identifying and documenting lessons learned from a project: it is important to…

A: The idea of lessons learnt is crucial to project management. It speaks of the knowledge obtained…

Q: The table below shows the sales figures for a brand of shoe over the last 12 months. Months January…

A: Formulae used: 1. Simple Moving Average = (A1 + A2 + …… + An)n 2. Weightage Moving Average = (A1×W1…

Q: 2. Consider the transportation problem having the following parameter table (M is a big positive…

A: NWCM rule means assignment from top left corner first. Let M = 50 (randomly taken positive…

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

A: Formulae used: Part(a) Regression equation: Y =a + bX Slope(b) =N∑XY - ∑X∑YN∑X2-∑X2 Intercept (a)…

Concept explainers

Cash Outflow

The term "cash flow" basically means the flow of money in and out of business. The cash flow usually takes place from operational, investing, and financing activities. The cash flow normally denotes the amount of cash that is transferred either into the business as positive cash flows or out of business as expenses with regards to operating, investing, and financing activities.

Question

The table below shows the sales figures for a brand of shoe over the last 12 months.
Months Sales
January 69
February 75
March 86
April 92
May 95
June 100
July 108
August 115
September 125
October 131
November 140
December 150
a. Using the following, forecast the sales for the months up January the following year
iii. Exponential Smoothing when α= .6 and the forecast for March is 350.

Leveraging special tenchniques in analyzing historical data to predict future trends. Forecasting covers the methods and types of forecasting and their application to case studies.

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 Introduction:

VIEW

Step 2 Answer:

VIEW

Step by step

Solved in 2 steps with 3 images

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

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 file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building materials (which includes retail sales of building materials, hardware and garden supply stores, and mobile home dealers). a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?
The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?
The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b?
The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?
The file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. a. Explain briefly whether the plot of the series visually supports the companys suspicion. b. By what percentage are sales increasing each month? c. What is the MAPE for the forecast model in part b? In words, what does it measure? Considering its magnitude, does the model seem to be doing a good job? d. In words, how does the model make forecasts for future months? Specifically, given the forecast value for the last month in the data set, what simple arithmetic could you use to obtain forecasts for the next few months?
The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?
Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.
A small computer chip manufacturer wants to forecast monthly ozperating costs as a function of the number of units produced during a month. The company has collected the 16 months of data in the file P13_34.xlsx. a. Determine an equation that can be used to predict monthly production costs from units produced. Are there any outliers? b. How could the regression line obtained in part a be used to determine whether the company was efficient or inefficient during any particular month?
The file P13_25.xlsx contains the quarterly numbers of applications for home mortgage loans at a branch office of Northern Central Bank. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b? Is it guaranteed to produce better forecasts for the future?
The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a supermarket for a one-year period. a. Using a span of 3, forecast the sales of this product for the next 10 weeks with the moving averages method. How well does this method with span 3 forecast the known observations in this series? b. Repeat part a with a span of 10. c. Which of these two spans appears to be more appropriate? Justify your choice.