Use the naïve model. Compute for MAE and MSE Use a three period moving average. Compute for the MAE and MSE Use the simple exponential smoothing to make a forecasting table. Compute the MAE and MSE of the forecasts. Alpha = 0.1

Use the naïve model. Compute for MAE and MSE Use a three period moving average. Compute for the MAE and MSE Use the simple exponential smoothing to make a forecasting table. Compute the MAE and MSE of the forecasts. Alpha = 0.1

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: Valencia Products makes automobile radar detectors and assembles two models: LaserStop and…

A: Given data is L = number of laserstop model S = number of speedbuster model Objective function: Max…

Q: firm makes a ceramic vases for a chain of department store. The output plus cost figures are below.…

A: Productivity is the measure of the number of outputs produced per unit of inputs used. Productivity…

Q: LahLa Mub Delivery a logistics operator process the packages for shipment. The items arrive at the…

A: ARRIVAL RATE= 50/hr SERVICE RATE = 1/min

Q: The "5 Why" technique is useful in identifying... Six Sigma projects that should be prioritized.…

A: 5why tecnique is a tecnique in which is used to find out the root cause of a problem in order to…

Q: Project X has the data points below. The schedule performance index (SPI) for task P is .. Task BCWS…

A: Here, we first understand the values given for each task BCWS = Budgeted Cost of work scheduled -…

Q: Are there guidelines for project management?

A: Before you start planning the project, make sure you stick to the authorized timeline and budget.…

Q: Orlando Manufacturers has decided to use a c-Chart to monitor the number of defects per file cabinet…

A: Given, Number of samples = 9 Sum of defects = 11+8+7+14+5+11+4+6+13 = 79 c-bar = 79/9 = 8.778 Alpha…

Q: Consider the following table which presents information on the returns in million pounds from a…

A: Note: - Since we can answer only up to three subparts we will answer subparts a(1, 2, and 3) here.…

Q: Jimmy uses a bowl in a microwave multiple times even though the bowl manufacturer specifically warns…

A: A user manual is nothing but detailed documents or a set of instructions stating the spectrum of…

Q: What is Direct Mapping, and how does it work?

A: Direct mapping is a procedure in a memory management system in which we are able to add a new memory…

Q: demonstrate the benefit of using the Work Breakdown Structure (WBS) concept?

A: A graphical, hierarchical, and deliverable representation of the breakdown of a project is called a…

Q: Consider why earnings management is considered important by many managers and management teams.…

A: Earning management refers to the management of the profits of the firm in an appropriate manner in…

Q: What is the process of releasing a product? Why is version control so important?

A: With the process of releasing a product, we could send this new product to the specific target…

Q: Determinetheordering, holding, andtotal inventory costs forthe currentorderquantity. Determine the…

A: EOQ stands for economic order quantity. It is a company's optimal order quantity that undervalues…

Q: Identify an appropriate inventory management strategy which Nike could implement in order to be more…

A: Strategic inventory management - it is the method of tracking the goods & providing companies…

Q: Which of the following are not one of the norms of scientific community? A. Disinterestedness B.…

A: Norms refers to the boundation which a community or a class is restricted to cross as they are…

Q: Discuss the traditional, Western management approach to quality as compared to the quality…

A: Quality Management Philosophy: Traditional Western Quality Management Approach: The product must…

Q: When it comes to Performance Testing, how fast can you go?

A: Performance testing refers to the evaluation of the performance of a system to find out…

Q: What is the importance of Data Accuracy in Operations Management?

A: Data Accuracy Data accuracy is among the most important components of data quality, it cannot be…

Q: The "5 Why" technique is useful in identifying.. Six Sigma projects that should be prioritized.…

A: The 5 why technique is used to find out the root cause of a problem in order to remove it from its…

Q: b) The data in Table 4(b) shows the number of nonconforming ties in a sample of size 500, following…

A: Find the Given details below: Given details: Day Sample size Number of Nonconformities 1 500…

Q: READING WHY PRODUCTIVITY MATTERS It is sometimes easy to overlook the importance of productivity.…

A: Productivity refers to the increase in the output without increasing the inputs by either increasing…

Q: 3. Why don't people delegate properly? What is involved in effective, respectful delegation?

A: Delegation refers to transfer of some responsibility to its subordinates by giving them authority…

Q: A luxury hotel has been receiving a lot of complaints from guests recently. The manager worries that…

A: 1. Check sheet

Q: Is there a better way to express the four P's of project management?

A: The four P's of project management are people , process, product, and project. It means that the…

Q: why is transportation planning important? 2. how do you make a transport plan? 3. how do you…

A: Transportation is the backbone of a supply chain and distribution system of an organisation because…

Q: nce of effective time management to successful study? Explain your answers and reasoning.

A: Effective time productively permits understudies to finish more significantly quicker, on the…

Q: The host of a dinner party purchases wine based on the weighted average of clarity (10%), bouquet…

A: In Weighted Average each number in the data set is multiplied by a predetermined weight arrive at…

Q: 2) forms/ types of power that a Project Manager can use to organize the fulfillment process of a…

A: BASES OF POWER

Q: Automatic dividend reinvestment is a requirement of all mutual fund companies. O compounds share…

A: Automatic dividend reinvestment refers to the investment of the company's dividends directly to buy…

Q: BRIEFLY DISCUSS AND DESCRIBE THE TERMS OPERATIONS MANAGEMENT AND SUPPLY CHAIN

A: Operations is defined as the actions and decisions taken by the participants and members of a…

Q: LahLa Mub Delivery a logistics operator process the packages for shipment. The items arrive at the…

A: ARRIVAL TIME = 50 PER HOUR SERVICE TIME = 1 PER MINUTE

Q: Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a normal…

A: Weekly demand (d) = 35 gallons per week Standard deviation (σ) = 8.48 gallons per week Expected…

Q: Find the x- intercept and y- intercept of each constraints and graph.

A: Linear programming is a mathematical technique that is also used in operations management…

Q: Do you agree with the view that, if they are established and managed carefully, strong alliances can…

A: Strategic alliance refers to a combination of two firms which joins together to perform a particular…

Q: (a) Calculate the probability that the project will be completed in 31 weeks. (Round your answer to…

A: The critical path is the path which takes the longest time among all the other paths to complete the…

Q: Describe what is meant by a learning curve. Provide a simple illustration of a 70% and an 80%…

A: Learning curves prove very important in cost analysis, cost estimation, and also efficiency studies.…

Q: Fit a linear trend curve by the least-squares method to the following data and determine trend…

A: The least-squares method is to set the data in the latest sum of the squares of the points from the…

Q: How significant is the role that software plays in the quality of products these days?

A: Nowadays using software is getting very common. Every business either small or big is using one or…

Q: How many containers are needed for gadjits? 5 containers. (Enter your response rounded up to the…

A: Given that: Average demand d =2*775 = 1550 Average waiting time per unit w 0.15 Average…

Q: Sunseel Industries produces two types of raw materials, A and B, with a production cost of $4 and $8…

Q: A) Draw the Gantt Chart B) Draw the Network Diagram C) Identify and draw the critical path using the…

A: A project schedule network diagram shows the sequence of the task that are performed to complete a…

Q: Why are Deming's 14 points important to quality management?

A: Quality management is the management that ensures the production and delivery of quality products…

Q: Why is there a need for management to review regularly the Risk Assessment?

A: Risk assesment is a process of identifying the potential risks in the organisation and understanding…

Q: ory of Constraints performance (TOC) approach to production management, namely business enhancement.…

A: WHAT IS THE THEORY OF CONSTRAINTS?

Q: What is the EOQ? How many orders should Warriors placed each year? How many units must be order…

A: EOQ stands for economic order quantity. It is a company's optimal order quantity that undervalues…

Q: outline the current quality management practices in any organization

A: Total quality management is the approach used to satisfy the customers by providing demanded…

Q: future engineering company. Explain or have a short introduction of your chosen firm scope, and…

A: The project manager takes into account the level of authority each manager has while creating the…

Q: Uberya Towing Services repair vehicles that break down at an average 7.5 vehicles per day. The…

A: Now at first we have Since there is only one server (Crew) The formulae for the M/M/1 serverwill be…

Q: What is it about the planning, monitoring, and control process that makes it seem closed? In what…

A: Project management is described as the means through which a project is driven from its initiation…

Question

DFC Company has recorded the past years sales for the company:

Year(t)

Sales(x)

(in Million Pesos)

2011(1)

2012(2)

2013(3)

2014(4)

2015(5)

2016(6)

2017(7)

2018(8)

2019(9)

2020(10)

219

224

268

272

253

284

254

278

282

298

Use the naïve model. Compute for MAE and MSE
Use a three period moving average. Compute for the MAE and MSE
Use the simple exponential smoothing to make a forecasting table. Compute the MAE and MSE of the forecasts. Alpha = 0.1
Use the least square method to make the forecasting table. Compute the MAE and MSE

*** Use excel or r programming

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 Introduction

VIEW

Step 2 Naïve (ANSWER 1)

VIEW

Step 3 3 period moving average (ANSWER 2)

VIEW

Step 4 Simple exponential smoothing (ANSWER 3)

VIEW

Step 5 (NOTE)

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 7 images

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

DFC Company has recorded the past years sales for the company:

Year(t)

Sales(x)

(in Million Pesos)

2011(1)

2012(2)

2013(3)

2014(4)

2015(5)

2016(6)

2017(7)

2018(8)

2019(9)

2020(10)

219

224

268

272

253

284

254

278

282

298

Use the least square method to make the forecasting table. Compute the MAE and MSE

*** Use excel or r programming

Solution

by Bartleby Expert

SEE SOLUTION

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?
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.
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?
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.
Under what conditions might a firm use multiple forecasting methods?
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?
year quarterly sales (000 units) Q1 Q2 Q3 Q4 2016 1300 1500 1200 2000 2017 1600 1800 1100 2200 2018 1700 1900 1300 2300 2019 1800 2100 1400 2500 Using a simple regression analysis, determine the trend equation of the sales and use it to estimate the number of units of clothing sold throughout the fiscal year 2020. Assume that Q1 of 2016 is 1, Q2 of 2016 is 2, etc. Show all relevant cakculation detail
Explain the compromise between responsiveness and stability in a predictive system using data from time series.
3. Quarterly sales of a car dealer exhibit an almost constant mean over time, but sales fluctuate depending on the quarter of the year (exhibits seasonality). Quarter Q1 - Spring Q2 - Summer Q3 - Fall Q4 - Winter Mean Year 1 32 74 53 22 45.25 Year 2 30 71 63 15 44.75 Year 3 35 83 45 19 45.5 (a) Using three years' worth of quarterly data that is provided, develop a set of seasonal factors that could be used to forecast car sales (b) Forecast car sales in each of the four quarters (Q1-Q4) of the following year (Year 4), using these seasonal factors.
Quarterly sales of a local department store over a 4-year period are given below: Quarters 2016 Q1 Sales (in millions) 500 Quarters 2018 Q1 Sales (in millions) 560 2016 Q2 490 580 2018 Q2 2018 Q3 2018 Q4 2019 Q1 2019 Q2 2016 Q3 570 630 2016 Q4 2017 Q1 2017 Q2 750 720 480 540 500 590 2017 Q3 580 2019 Q3 620 2017 Q4 740 2019 Q4 790 The data shows sign of seasonality. By computing seasonal indices for each quarter, forecast the sales for each quarter in year 2020, given that the estimated sales in 2020 is
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: a) The forecasted demand for the week of October 12 using a 3-week moving average = Week Of August 31 September 7 September 14 September 21 September 28 October 5 pints (round your response to two decimal places). Pints Used 345 389 408 381 371 374
The following table shows the three-period moving average and five-period moving average for monthly sales of Budget Furniture's during 2019. Moving averages of Budget Furniture's Time period Months Sales Three-period moving average (rounded off to Five-period moving average four decimals) R'millions 1 Jan 7 5.0000 6.2 February 5.6667 6.6 March 5 7.0000 B 4 April 8.3333 8.2 May 7 9.3333 8.4 June 8.3333 9.6 7 July 12 8.6667 9.6 August 4 A 9.2 September 10 10.6667 10 October 13 10.6667 11 November 9 12 December 10 The seasonal index for the month of February in 2019 is: LO