The following tabulations are actual sales of units for six months. (assume F1 = A1) a. Calculate forecasts for the remaining five months using simple exponential smoothing with α = 0.2 b. Calculate MAD for the forecasts Actual (At) Forecast (Ft) Jan 110 Feb 104 March 116 April 110 May 98 June 124

The following tabulations are actual sales of units for six months. (assume F1 = A1) a. Calculate forecasts for the remaining five months using simple exponential smoothing with α = 0.2 b. Calculate MAD for the forecasts Actual (At) Forecast (Ft) Jan 110 Feb 104 March 116 April 110 May 98 June 124

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.6: Moving Averages Models

Problem 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...

See similar textbooks

Related questions

Q: A production process consists of a three-step operation. The scrap rate is 14 percent for the first…

A: The production process is a series of steps or activities that are involved in the manufacturing of…

Q: The Friendly Neighbor Grocery Store has a single checkout stand with a full-time cashier. Customers…

A: Find the Calculation methods below: P0 = 1-λμLq = λ2(μ*(μ-λ))L = Lq + λμWq = LqλW = Wq + 1μPw =…

Q: Procurement and Inventory management at Nestle The procurement life cycle followed by Nestle is…

A: The above inquiry begs for an analysis of the strategic value of inventory management and buying to…

Q: 2. Complete Network Table Activity Predecessor Normal time Normal cost Crash time Crash cost…

A: Forward Pass:Early Start (ES) = Max EF value from immediate Predecessor(s)Early Finish (EF)= ES +…

Q: Is there a difference between managing quality and making sure it's good?

A: Yes, there is difference between managing quality and making sure it's good. Managing quality is…

Q: Every project has some level of risks, and a Project Manager must plan for these risks, whether…

A: ANSWER:1 Our organization's OPS (Operations Performance System) initiative, which aims to improve…

Q: Do you know what a good project manager needs to do?

A: A project manager is essential to the planning, execution, supervision, management, and closure of…

Q: Derive the values for the intercept and slope. Derive the linear regression equation. Plot the…

A: Here, for each month, I have been given the clinic attendance data, I would determine the intercept…

Q: When rationalizing about downsizing, many managers will rely on economic, accounting, and…

A: Downsizing can be done for a variety of reasons, such as cost-cutting, restructuring, or changes in…

Q: Suppose that the queueing system under consideration fits the M/M/s model with λ = 8 customers per…

A: Find the Calculation methods below: ρ (Single server) = λμρ (multiple server) = λ(μ*s)Total cost =…

Q: Please answer this question 1. Which of the following is not included in the staffing plan? A. The…

A: Staffing plan indicating all the processes related with identifying a job role and filling the role…

Q: a) What was its weeks of supply last year? b) What is its weeks of supply this year? c) Is Mattress…

A: Here, given the data stated below, From the above dataset, I would answer all the given questions,…

Q: how can project manager assess the performance of a specific within a project team

A: Project manager can access the performance of a specific team member within a project team, a…

Q: Competitor Analysis in Monjorino Jewellery Industry Monjorino is a small country in Europe, however,…

A: Below are the detailed explanations for the given questions in the article:

Q: Complete a PESTEL-DC analysis for samsung

A: Pestel analysis is the study of key external factors that helps to evaluate business and environment

Q: What constitutes an "undue hardship" according to the current law? Is it based solely on cost?

A: The concept of "undue hardship" typically arises in the context of disability discrimination laws,…

Q: time available for the month. What combination of printers should be produced to maximize profits?

A: For this problem, I would setup the LP formulation, Assembly time: 2.9×X1+3.7×X2+3×X3≤3600 Decision…

Q: In order for a goal to lead to improved task performance, it should be specific, challenging,…

A: Goal setting theory: In accordance with goal-setting theory, productivity can be increased by…

Q: Write SWOT and PESTLE analysis for TerryWhite Chemmart in Australia with at least 5 recent…

A: Below we are going to discuss SWOT and PESTLE analysis for TerryWhite Chemmart. SWOT analysis is a…

Q: a) Using the point drawing tool, plot all the corner points for the feasible area. The optimum…

A: Here, for the LP formulation, I would use the graphical method, from the REF of the graph data, I…

Q: Launching a New Product in the Beverage Industry Background: ABC Beverage Company is a leading…

A: Introducing a new product in the beverage sector can be complex and demanding. To guarantee that the…

Q: The term “sales representative” covers a broad range of positions. We call a sales representative…

A: Option a = Missionary is incorrect option because it is used for spreading awareness about product…

Q: What is the role of the project leader in a predictive project team vs an agile project team? What…

A: Project managers are essential in directing project teams toward practical project completion and…

Q: 5. A product has an average daily demand of 400 units with standard deviation of 10.0 units.…

A: The reorder point is the lowest quantity of stock that a company should keep on hand to guarantee…

Q: First, read a Content on Data and How Information Supports Decision Making, paying particular…

A: One example of decision that a manager at regional level in a retail business might make is…

Q: An electric switch manufacturing company has to choose one of three different assembly methods.…

A: To Determine An electric switch manufacturing company has to choose one of three different assembly…

Q: The Loebuck Grocery must decide how many cases of milk to stock each week to meet demand. The…

A: Find the Given details below: Given details: Demand (Cases) Probability 15 0.2 16 0.25 17…

Q: Of the three factors affecting the control of labour costs, comment on which factor you believe has…

A: NOTE: THIS IS ANSWERED IN GENERIZED WAY. Since labor is frequently one of an organization's…

Q: d. What is the theoretical minimum number of workstations using the cycle time computed in” b “…

A: Project schedule helps in calculating different values related to the production cycle like the…

Q: Malvine manages manuscripts and has developed a CPM analysis of her current one. Sadly, she spilled…

A: An activity forward and backward passing operations will helps to identify the opening and closing…

Q: Follow the instructions given, and solve this LP problem using graphical linear programming. Max Z =…

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

Q: ompare and contrast SCOR model and PCF model

A: Two well-known frameworks are used in supply chain management and business process management,…

Q: Tulip MMC produces doors in different regions and has 5 shops across the country. Given the…

A: Find the Given details below: Given details: Warehouse Location Customer Shop 1 Shop 2 Shop…

Q: Suppose you constructed control charts for the time spent by customers in a retail checkout lane,…

A: A control chart is a tool which helps to identify whether a process in control or not. There are…

Q: Successful Public Private Partnerships (PPP's) can deliver high-quality services at lower cost than…

A: Public Private Partnership (PPP) is a collaborative approach to delivering public services or…

Q: What are the key characteristics of a negotiable instrument?

A: A negotiable instrument is a written document.It is represents a promise to pay a certain amount of…

Q: Considering car industries, give the three levels of management and identify their roles in…

A: Marketing management includes all those activities that are important for selling goods and services…

Q: a) What is its weeks of supply? weeks (round your response to two decimal places). b) What…

A: As per the instructions, the first three sub-parts are taken for answering purposes, here, given the…

Q: Draw network diagram neatly with the information below

A: Here, for each activity, I have been given the normal duration and immediate predecessor…

Q: What are Manufacturing Decision Patterns and How Do They Work?

A: Below is a detailed explanation on what are Manufacturing Decision Patterns and how do they Work:

Q: For what type of project is a line-of-balance schedule particularly suited? Identify specific…

A: The line-of-balance (LOB) is a kind of linear scheduling techniques that keeps a project's…

Q: What exactly do you mean when you refer to "automation" in the setting of the workplace?

A: Automation refers to the use of technology and machines to accomplish certain tasks or processes…

Q: The SurveyMonkey firm has been contracted to conduct a survey on the party preference in the coming…

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

Q: At Taste of Thyme coffee shop a dirty chai latte creates a profit point of $2.85 for a small and…

A: The profit maximisation function is a mathematical equation that is used to determine the best mix…

Q: A Work Breakdown Structure (WBS) identifies deliverables, activities, and tasks. Which statement…

A: A work breakdown structure (WBS) is a business phenomenon where a complex project and its related…

Q: Can you distinguish inherent from controllable risks

A: From the standpoint of operations management, there are two basic categories of hazards: inherent…

Q: From a global perspective, what are some of the factors that will impact the extent to which Nike’s…

A: Nike, Inc. is a global company that creates, develops, and sells sportswear, footwear, and equipment…

Q: A manufacturing company uses 25,000 components at an even rate during a year. Each order placed with…

A: Given the data stated below, The annual demand is 25000 components, The order quantity or EOQ…

Q: What are some of the telltale signals that a system's useful life is nearing to an end, and how may…

A: Business management includes all those activities that help the business in taking good or…

Q: How could a quality management system be put into place

A: An organized and methodical approach to controlling quality is required when establishing a quality…

Concept explainers

Forecasting in Business

Forecasting is the process of predicting the future based on the past and the present data and circumstances. In other words, forecasting is the act of making a detailed analysis of future events based on the decisions made in the past as well as the present. Forecasting plays a very important role in operational management as it helps in planning and decision-making. It is not only important for the success of a business but also contributes to individual growth and success. Many business organizations or companies have failed due to the shortcomings of their forecasting.

Question

The following tabulations are actual sales of units for six months. (assume F₁ = A₁)

a. Calculate forecasts for the remaining five months using simple exponential smoothing with α = 0.2

b. Calculate MAD for the forecasts

	*Actual (A_t)*	*Forecast (F_t)*
Jan	110
Feb	104
March	116
April	110
May	98
June	124

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.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Formula for exponential smoothing

VIEW

Step 2: Calculate Forecast

VIEW

Step 3: Explain MAD

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 4 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

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?
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 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_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_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_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_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 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_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.
Do the sales prices of houses in a given community vary systematically with their sizes (as measured in square feet)? Answer this question by estimating a simple regression equation where the sales price of the house is the dependent variable, and the size of the house is the explanatory variable. Use the sample data given in P13_06.xlsx. Interpret your estimated equation, the associated R-square value, and the associated standard error of estimate.
Management of a home appliance store wants to understand the growth pattern of the monthly sales of a new technology device over the past two years. The managers have recorded the relevant data in the file P13_05.xlsx. Have the sales of this device been growing linearly over the past 24 months? By examining the results of a linear trend line, explain why or why not.