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. Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to testtwo forecasting methods to see which method was better over this period.MONTHJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberMonthAprilMayJuneJulyAugustSeptemberACTUAL199128a. Forecast April through September using a three-month moving average.Note: Round your answers to 2 decimal places.145164155173135133136MonthAprilMayJuneJulyAugustSeptemberThree-MonthMoving Averageb. Use simple exponential smoothing with an alpha of 0.10 to estimate April through September, using the average of January throughMarch as the initial forecast for April.Note: Round your answers to 2 decimal places.ExponentialSmoothing c-1. Calculate Mean Absolute Deviation for each method.Note: Round your answers to 2 decimal places.Three-month moving averageExponential smoothingMean AbsoluteDeviationc-2. Use Mean Absolute Deviation to decide which method produced the better forecast over the six-month period.O Exponential smoothingO Three-month moving average

Exponential Smoothing:Exponential smoothing is a time-series forecasting method that assign…

Answered: Note:- Do not provide handwritten…

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.

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 26P: The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel...

See similar textbooks

Related questions

Q: Explain the principles of IT project management, including methodologies like Agile and Waterfall.

A: There are several key principles in project management that drive the successful planning,…

Q: urrently the manufacturer has eight machines that operate on a two-shift (eight hours each) basis.…

A: Year12345Forecast demand106,000123,000125,000127,000126,000

Q: Analyze the risks associated with outsourcing sensitive or confidential website projects, including…

A: Outsourcing can be defined as a process in which the company relies on the third party in order to…

Q: Mike plans to transport 30 pallets containing 53 cartons and an additional pallet containing 40…

A: For this situation, I will determine the freight cost,

Q: Find the simple exponential smoothing forecast for all the 20 weeks and also forecast the demand for…

A: The forecasting process can involve the use of different methods like the moving average, weighted…

Q: The Build-Em-Fast Company has agreed to supply its best customer with three widgets during each of…

A: Given,Maximum Production,Maximum Production,Production Cost per Unit,WeekRegular TimeOvertimeRegular…

Q: TABLE 30 Store Type Jewelry Shoe Department Book Clothing Square Footage 500 600 1,500 700 900…

A: Let x1 be the number of department stores.Let x2 be the number of specialty stores.. Let x3 be the…

Q: INCORRECT FOR Formulate a linear programming model that can be used to determine the pounds of…

A: Linear programming (LP) is a mathematical technique used for optimizing a linear objective function…

Q: Explain the role of Service Level Agreements (SLAs) in website outsourcing contracts and their…

A: Service Level Agreements are formal agreements between the service providers and their customers.…

Q: In the office relationship chart, which rating reflects the least desirability for two departments'…

A: Facility layout is the aspect of production or operation management that deals with the arrangement…

Q: Describe the concept of scalability in IT resource acquisition and how it is relevant to businesses.

A: Business management helps an organization understand the customer's needs and expectations. It helps…

Q: Predictive modeling: Task: Ambulance Demand using data collected by the NYC Traffic Data Data…

A: Predictive modeling is a process that uses data and statistics to predict outcomes with data models.…

Q: Describe the role of Service Level Agreements (SLAs) in outsourcing website maintenance and support.

A: Service Level Agreements (SLAs) are instrumental in outsourcing website maintenance and support…

Q: What is the final value of the decision tree?

A: Find the given details below:

Q: The time to deliver packaged containers by a logistics company is found from samples of size 4. The…

A: Solution :From the given data :n=4, μ = 140 hours , standard deviation = σ = 6 hours (a) Find the 2…

Q: Consider the everyday task of getting to work on time or arriving at your first class on time in the…

A: A fishbone chart, also known as an Ishikawa diagram or a cause-and-effect diagram, is a visual tool…

Q: The Northside Bank is working to develop an efficient work schedule for full-time and part-time…

A: Find the Given details below:TimeNo. ofTellers9:00 a.m. – 10:00 a.m.610:00 a.m. – 11:00 a.m.411:00…

Q: Explain qualitative forecasting methods that managers can use to predict future behavior in various…

A: Forecasts are indispensable tools for companies to plan, allocate resources, manage risks, and make…

Q: Develop a concept paper outlining the ITS planning process you will follow to mitigate a critical…

A: Intelligent Transportation Systems Planning (ITC Planning) is the strategic organization and…

Q: A company using a kanban system has an inefficient machine group. For example, the daily demand for…

A: The sum of all the inventory items a company wants to store or maintain at a particular time is…

Q: Discuss the concept of software product management and its significance in the success of software…

A: Software products are computer programs, systems, or computer applications that have been developed…

Q: A 16 8 Ο Α. Η OB. F OC. G OD. E OE. C B 14 Which is the critical activity? 5 E 4 H 6 G 15 F 10 End

A: In project management, the critical path is the sequence of tasks or activities that, when combined,…

Q: In the initial solution of a transportation problem, the only restriction is that there should be…

A: The transportation problem has a main focus on the effective movement of a good from multiple…

Q: Organization size has an effect on structure. If a structure is organic, what can we guess about the…

A: There are multiple factors that can influence the organization's structure, and one of the important…

Q: Cost management is used to analyze the cost consequences of different design choices and to measure…

A: Cost management is an integral process that involves planning the costs that are related with the…

Q: What ar

A: A comprehensive system management strategy involves various components and activities to efficiently…

Q: Waldo sells pre-packaged lunches to construction workers at a Peachtree Street construction site…

A: Order quantity refers to the number of goods that a company should order at a given point in time to…

Q: Discuss

A: Linear programming is a mathematical method that optimizes resource allocation to achieve a specific…

Q: Give typed full explanation Industrial Products, Inc. has two alternatives for manufacturing…

A: Unit produced = 12,000In house,Fixed cost = $2,100,000Variable cost per unit = $6,800Outsourcing…

Q: Define system management and its significance in information technology.

A: Information technology is a combination of computer system, software, and other computer languages.…

Q: Hau Lee Furniture, Inc., spends 50% of its sales dollars in the supply chain and finds its current…

A: Find the given details below:

Q: STAR Co. provides paper to smaller companies with volumes that are not large enough to warrant…

A: Linear programming helps us to find the optimal solution/best outcome, with the given…

Q: d. Balance this line using sequential restrictions and the longest operating time rule. e. What is…

A: Here, each task has the task time and the predecessor data, The cycle time can be calculated using…

Q: Find the EVPI for the below Payoff table: State of nature 1 2 3 Probabilit y 0.3 0.4 0.3 Acts B A C…

Q: Tyler Apiaries sells bees and beekeeping supplies. Bees (including a queen) are shipped in special…

A: Upper Specification Limit (USL) = 2.1 KgLower Specification Limit (LSL) = 1.3 KgThe standard…

Q: Discuss the challenges and strategies associated with disaster recovery and business continuity…

A: Effective disaster recovery and business continuity planning are more important than ever in today's…

Q: Schedule the Following Activities using CPM: 15 Duration of the project is: ID A B C D E F G H None…

A: The critical path is a fundamental concept in project management, It refers to the longest sequence…

Q: why is it important for firms to collect intelligence about their competitors.can you give the…

A: For any organization, competitive intelligence is an essential tool. Here, we will first gather the…

Q: A janitorial service, Mother’s Helpers, provide workers to clean office buildings during late…

A: Workers with 2 skill levels are available:Level 1 Level 2Level 1Level 2Wages…

Q: Explore the challenges of integrating CRM with other enterprise systems like ERP (Enterprise…

A: The seamless integration of customer relationship management (CRM) and enterprise resource planning…

Q: Eagle Electronics must expand by building a second facility. The search has been narrowed down to…

A: The factor rating method is a decision-making tool that helps to evaluate and compare different…

Q: What are the key factors organizations consider when deciding to outsource their website development…

A: Organisations frequently have to choose whether to outsource their website creation and maintenance…

Q: How does system management help in minimizing downtime and enhancing system reliability?

A: System management plays a crucial role in minimizing downtime and enhancing system reliability by…

Q: The monthly sales for Otter Batteries, Inc., were as follows: Plot the monthly sales data. Forecast…

A: XSales13025033046657066576087098010991111012120

Q: Explain the significance of conducting a feasibility study during the planning phase.

A: Feasibility study plays an integral role in the projects. It can be defined as an analysis that…

Q: How does persuasive technology differ from manipulative design, and what ethical considerations…

A: Persuasive technology and manipulative design are two concepts that are often used interchangeably…

Q: Under what circumstances is believed that the top-down market sizing approach would be more…

A: Market sizing is the critical aspect of business planning and the operations management. It involves…

Q: Discuss the concept of predictive maintenance in the context of system management. How can…

A: In the world of system management, predictive maintenance is a game changer. This proactive method…

Q: Question type: Project Management Three Estimate A renovation of the gift shop at Orlando Amway…

A: Expected Time (TE) = (a + 4m + b) / 6Standard Deviation (σ) = (b - a) / 6Let's calculate TE and σ…

Q: To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total…

A: For this question, first, I will formulate the Linear programming model, Then, I will solve this LP…

Question

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.

Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test
two forecasting methods to see which method was better over this period.
MONTH
January
February
March
April
May
June
July
August
September
Month
April
May
June
July
August
September
ACTUAL
199
128
a. Forecast April through September using a three-month moving average.
Note: Round your answers to 2 decimal places.
145
164
155
173
135
133
136
Month
April
May
June
July
August
September
Three-Month
Moving Average
b. Use simple exponential smoothing with an alpha of 0.10 to estimate April through September, using the average of January through
March as the initial forecast for April.
Note: Round your answers to 2 decimal places.
Exponential
Smoothing

c-1. Calculate Mean Absolute Deviation for each method.
Note: Round your answers to 2 decimal places.
Three-month moving average
Exponential smoothing
Mean Absolute
Deviation
c-2. Use Mean Absolute Deviation to decide which method produced the better forecast over the six-month period.
O Exponential smoothing
O Three-month moving average

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: Define key term:

VIEW

Step 2: Calculate the forecasts:

VIEW

Step 3: Calculate MAD:

VIEW

Solution

VIEW

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 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 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_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 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_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_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?
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.
i need this to study stop canceling my questions A check-processing center uses exponential smooth- ing to forecast the number of incoming checks each month. The number of checks received in June was 40 million, while the fore- cast was 42 million. A smoothing constant of .2 is used. a) What is the forecast for July?b) If the center received 45 million checks in July, what would be the forecast for August?c) Why might this be an inappropriate forecasting method for the situation
It wouldnt let me take a screenshot of the table so I had to copy and paste it in here. My question is: How do you Calculate a moving average forecast using the last 2 and 4 dates of stay. What is the prediction for 7/1/2021 for each technique? Discussion Question 1 - 200 room hotel Forecasts MA 2 Errors MA 4 Errors ES (0.8) Errors ES (0.5) Errors Date Day of Week Rooms Sold MA 2 MA 4 ES (0.8) ES (0.5) AE APE AE APE AE APE AE APE 6/1/2021 Tuesday 123 6/2/2021 Wednesday 109 6/3/2021 Thursday 140 6/4/2021 Friday 199 6/5/2021 Saturday 179 6/6/2021 Sunday 140 6/7/2021 Monday 117 6/8/2021 Tuesday 132 6/9/2021 Wednesday 108 6/10/2021 Thursday 151…
The following gives the number of pints of type B blood used at Woodlawn Hospital in the past 6 weeks: Week Of Pints Used August 31 360 September 7 389 September 14 410 September 21 381 September 28 368 October 5 374 a. Forecast the demand for the week of October 12 using a 4-week moving average. [Select] b. What is the MAD? [Select] c. Use a 4-week weighted moving average, with weights of .1, .3, .6, and .8 using .8 for the most recent week. Forecast demand for the week of October 12. [Select] d. What is the MAD? [Select] e. Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 363 and a = .47 [Select] f. What is the MAD? [Select] g. Based on evaluating all three forecasting models, which forecast should be chosen? [Select]