The following data are for calculator sales in units at an electronics store over the past nine weeks:WeekSalesWeekSales145532507593448.59451964557Use trend projection with regression to forecast sales for weeks 10 - 13. What are the error measures (CFE, MSE, o, MAD, and MAPE) for this forecasting procedure? How about ?Obtain the trend projection with regression forecast for weeks 10 – 13. (Enter your responses rounded to two decimal places.)PeriodForecast, F,1064.811167.061269.311371.56Obtain the error measures. (Enter your responses rounded to two decimal places.)CFEMSEMADМАРЕ

To compare the fits of various forecasting and smoothing approaches, we must employ the MAPE, MAD,…

Obtain the trend projection with regression forecast for weeks 10 - 13. (Enter your responses rounded to two decimal places.) Forecast, F; Period 10 64.81 11 67.06 12 69.31 13 71.56 Obtain the error measures. (Enter your responses rounded to two decimal places.) CFE MSE MAD МАРЕ %

Obtain the trend projection with regression forecast for weeks 10 - 13. (Enter your responses rounded to two decimal places.) Forecast, F; Period 10 64.81 11 67.06 12 69.31 13 71.56 Obtain the error measures. (Enter your responses rounded to two decimal places.) CFE MSE MAD МАРЕ %

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: Маx 1x 2x2 s.a. - 4х, + 3х, — 3 1x, — 1х, — 3 X1, X2 2 0

Q: plant has sufficient capacity to manufacture any combination of four different products (A, B, C, D)...

A: given,

Q: Each breakdown of a graphic plotter table at AirbusIndustries costs $50. Find the expected daily bre...

A: The expected daily breakdown cost can be calculated as follows:

Q: Describe how to improve system reliability

A: Reliability can be stated as the probability that a system carry out accurately during a particular ...

Q: Q#2: Define “TIIMWOOD” and explain any one of them with example. (Do not exceed 125 words) Q#3: Di...

A: Business Process Reengineering involves the extremist overhaul of center business processes to accom...

Q: Define the seven wastes and the 5Ss. The seven wastes are ___ , ___ , ___ _ ___ . and , and the 5Ss ...

A: The seven wastes refers to the manufacturing practices that are unproductive in nature.

Q: Borges Machine Shop, Inc., has a 1-year contract for the production of 250,000 gear housings for a...

A: The question given is for finding the breakeven quantity between each pair of options and then final...

Q: 10. Who takes care of roadblocks? Product Owner Scrum Master pigs chickens

A: 10. Product owner is the person who represent the needs of many stakeholders in case of product bac...

Q: Summarizes the learnings about project management?

A: Manufacturing is the process of developing finished products using the raw materials and resources f...

Q: a. The minimum project duration b. The amount of slack for each activity c. The total cost for compl...

A: D(duration)=given in the question as normal time ES (Early start)= The first activity from where the...

Q: Find the probability that the employee is idle?

A: The probability of finding idle employees can be found as follows:

Q: Problem 2 Consider the following problem: max 2r1 + 7r2 + 4.r3 s.t. rį + 2x2 +x3 0. Use the dual of...

A: Given- MAX 2x1 + 7x2 + 4x3Subject to-x1+ 2x2+ x3≤103x1+ 3x2+ 2x3 ≤10x1, x2, x3≥0

Q: Suds and Duds Laundry washed and pressed the following num of dress shirts per week. Week Work Crew ...

A: given,

Q: 7. Describe the factors that impact the supply of the Samsung company’s main products/services

A: The capability to analyze, procure, & strengthen the resources needed to run a business efficien...

Q: Refer to the Value Stream Map. What does the arrow beneath the letter B represent? Group of answer...

A: Value stream mapping can be stated as the lean management technique that permits the professionals t...

Q: Wolfgang is a typical producer in a perfectly competitive piano industry (e all other producers of p...

Q: pleqse solve the question 2 here using the information in question 1

A: as per your instruction, we are solving the second question. given,

Q: The credit card issuing process at Atlanta Bank's VISAprogram consists of 10 steps performed in seri...

A: as figure given before

Q: . As the project management team responsible for the successful implementation of the youth developm...

A: The stakeholders management plan can be built as follows:

Q: Multinational companies increasingly capitalized on their resources and capabilities in enhancing th...

A: The various categories of the capabilities are as under, 1. Strategic : These capabilities would...

Q: D1 D2 D3 D4 demand 2 2- S00 2// This table is the solution of the problem S1 500 Me XS Find the opti...

A: We have to understand that Stepping Stone Method is used to verify the optimality of such an initial...

Q: These days, cloud computing is being used in many enterprises' information systems. Briefly describe...

A: Cloud computing is described as a means of delivering hosted through the internet. It is important t...

Q: Which of the following is not a threat to the expenditure cycle receiving process? A. Accepting uno...

A: The threats in receiving and storing goods include: - Receiving goods that are not ordered. So one ...

Q: If you are given a chance to be a leader, what kind of leader you would be?

A: If the corporate leaders are to be capable or effective in their respective roles, it is very import...

Q: Because projects are time sensitive, meeting activity finish dates is a common characteristic of qua...

A: A company of electronic components decides to expand its operations and needs to hire and train fift...

Q: In making squash soup, what are the tests to quantify certain parameters as indicators of quality?

A: Quality control can be defined as the process by which the product quality is ensured, maintained as...

Q: are needed within a compa

A: Inventory management, customer demand, forecasting technique and lead time, and review period durati...

Q: LE INC offer?

A: Consumer gadgets, computer software, and personal computers are all part of Apple Inc.'s product lin...

Q: Automobile Alliance, a large automobile manufacturing com- pany, organizes the vehicles it manufactu...

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

Q: Determine the board measure (BF) and the cost 2x4 = $1700 MBM MBM or FBM = Thousand Board Measure...

A: The board measures/board foot and the cost are computed as follows:

Q: Explain the notion of "infant mortality" in the context ofproduct reliability.

A: Reliability - is based on the probability that an item or product or tool will perform adequately fo...

Q: The history of existence of APPLE INC

A: Apple Inc., formerly Apple Computer, Inc., American manufacturer of personal PCs, smartphones, table...

Q: Distinguish between preventive and breakdown maintenance

A: Breakdown maintenance works by running hardware until it breaks down, in which case repairs and supp...

Q: Part 1: For the activities, duration, and sequence shown in the table below, prepare a Gantt chart w...

A: A Gantt chart is a project management device that illustrates a project plan. It typically includes ...

Q: The Beta II computer's electronic processing unitcontains 50 components in series. The average relia...

A: given, contains 50components reliability =99% using detail earlier provide in 17.2

Q: What are the advantages of understanding the development of Process Flow Diagram? Is it necessary f...

A: Flowcharts make visual portrayals of processes. For this explanation, they are famous among develope...

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

A: Estimated total cost implies the total cost of the provisions or administrations to be given or atte...

Q: A Jack-in-the-box toy includes two components, the jester (part A) and the box (part B). The followi...

A: From the given data, it can be observed that processes A and B are in series. After completing one s...

Q: g the factors that must be considered as it progresses through the stages.

A: When it comes to the world of business, products and services have a four-stage lifecycle. Find out ...

Q: Find decision variables, objective function, constraints and non-negativity constraints An auto com...

A: Decision variable: Suppose-T be the no. of trucks to be manufactureC be the no. of cars to be manufa...

Q: A university has three professors who each teach four courses per year. Each year, four sections of...

A: A Small Introduction about Production Management Production management alludes to the method invo...

Q: Question 2 Mr. Ferdinand is a well known entrepreneur who sells fresh organic beef to persons in the...

A: A Small Introduction about Forecast Forecasting is a procedure that involves authentic information ...

Q: A Company is in the process of preparing a budget for launching a new product. The following table p...

A: A forward pass is a strategy to push ahead through a network diagram to determine project duration a...

Q: A _____ is a cost reimbursable contract that includes an additional incentive payment if the contrac...

A: The detailed solution is given in Step 2.

Q: When discussing JIT in services, the text notes that suppliers,layout, inventory, and scheduling are...

A: As case study was provided earlier so the answer is as follows: When discussing JIT in services, the...

Q: What is meant by value added and why is that important? Provide an example of at least two value ad...

A: Value addition is the extra value created over and above the original value of the something. This c...

Q: 1. As the project management team responsible for the successful implementation of the youth develop...

A: A Small Introduction about Project Management Project management gives construction and control of ...

Q: Companies A, B, and C supply components to three plants (F, G, and H) via two crossdocking facilitie...

A: Cross-docking is training in coordinated factors of dumping materials from a producer or method of t...

Q: What is the difference between family grouping and A-B-C Categorization?

A: Inventory management is the management in which raw materials and finished products are stored and m...

Q: CANON produces printers for sale in northern Europe in its Taiwan factory. Printers sold in differen...

A: Given, Country Mean Weekly Demand Standard Deviation Germany 3,000 2,000 Norway ...

Question

The following data are for calculator sales in units at an electronics store over the past nine weeks:
Week
Sales
Week
Sales
1
45
53
2
50
7
59
3
44
8.
59
4
51
9
64
5
57
Use trend projection with regression to forecast sales for weeks 10 - 13. What are the error measures (CFE, MSE, o, MAD, and MAPE) for this forecasting procedure? How about ?
Obtain the trend projection with regression forecast for weeks 10 – 13. (Enter your responses rounded to two decimal places.)
Period
Forecast, F,
10
64.81
11
67.06
12
69.31
13
71.56
Obtain the error measures. (Enter your responses rounded to two decimal places.)
CFE
MSE
MAD
МАРЕ

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

VIEW

Excel Working

VIEW

Answers

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

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_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_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?
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 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_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?
Under what conditions might a firm use multiple forecasting methods?
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?
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.