Forecasting with Linear RegressionThe company VID-CO-19 has manufactured swim suits for men, women, and children for 10 years. The company is located in Boston, Massachusetts. Swim suits have always had a higher demand during the monthsof April, May, June, July, August, and September. The demand has always been lower during the months of October, November, December, January, February, and March.TETTThe real demand, based on sales of year 20X1 is the following (it starts with December of the previous year):PeriodBimesterDemandSeason AverageDecember-JanuaryFebruary-March11009022001803April-MayJune-JulyAugust-September90091043,0002,1004,0004,900October-November300350VID-CO-19 has hired you as an Operations Management expert to help them to forecast demand for year 20X2 using the Linear Regression Method.What is the TOTAL "seasonalized" or "deseasonalized' forecasted demand for Quito-Ecuador in year 20X2? (write your answer rounded to two decimals)

Let me state the given data, PeriodBimesterDemandSeasonal…

Answered: The company VID-CO-19 has manufactured…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Medium-term forecasts are used for making medium-term decisions related to planning for new products, capital expenditures, facility location or expansion, and research and development. True False
You have been pricing Samsung-Galaxy SmartWatch in several stores. Three stores have the identical price of $600. Each store charges 12 percent APR, has a 30-day grace period, and sends out bills on the first of the month. On further investigation, you find that store A calculates the finance charge by using the average daily balance method, store B uses the adjusted balance method, and store C using the previous balance method. Assume you purchased the SmartWatch on May 5 and made a $100 payment on June 15. What will the finance charge for June be if you made your purchase from store A? From store B? From store C?
Spring 2019 Credit Card Products Collections DFD At Columbia Southern Bank, credit card accounts are booked and serviced at Individualized BankCard Services(IBS). If such accounts become delinquent, their information is sent to the collection system via the IBS FILE (see appendix D). This file is sent to the collection system on a daily basis. Besides being used to update the collection history database it is used to generate the IBS new accounts report. Recall that the predictive dialer software is used as part of the collection process. It involves using packaged software to contact delinquent borrowers. Using a file of telephone and account numbers the software takes into consideration how many collection agents are working at the given time and paces the calls accordingly. This will assure that an agent will be available to take the call if a delinquent customer answers the telephone when the dialer places the call. When a customer answers the…
You have the data on the application during the 8 consecutive year period below Wanted / Find the forecast demand for the year 2008 using the simple moving average method and on a 4-period basis the years 2000 2001 2002 2003 2004 2005 2006 2007 2008 Order quantity 24 48 50 68 60 66 70 90
Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following table: Maroon 5 TV Appearances 3 4 8 6 7 7 Demand for Guitars 4 6 7 5 10 6 This exercise contains only parts b, c, and d. Part 2 b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): Y = enter your response here + enter your response herex
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014. Year Period (t) Revenue ($ billions) 2009 1 23.8 2010 29.2 2011 37.9 2012 4 50.3 2013 59.8 2014 6 66.6 (a) Construct a time series plot. 80 80 70 70 70 70 60 60 50 50 50 30 30 30 30- 20 20 20 20 10 10 10 - 10- 4. 6 7 4 6 4 5 6 7 1 2. 4 6 7 Period Period Period Period What type of pattern exists in the data? O The time series plot shows an upward linear trend. O The time series plot shows a downward curvilinear trend. O The time series plot shows a downward linear trend. O The time series plot shows an upward curvilinear trend. (b) Develop a linear trend equation for this time series to forecast revenue (in billions of dollars). (Round your numerical values to three decimal places.) T = (c) What is the average revenue increase per year (in billions of dollars) that this company has been realizing? (Round your answer to three decimal places.) billion Revenue ($ billions) Revenue ($ billions)…
In opposition to causal technology, what are the fundamental assumptions when using time series predictions?
In comparison to causal techniques, what are the fundamental assumptions when utilizing predictive time series techniques?
ou have been pricing Samsung-Galaxy SmartWatch in several stores. Three stores have the identical price of $400. Each store charges 18 percent APR, has a 30-day grace period, and sends out bills on the first of the month. On further investigation, you find that store A calculates the finance charge by using the average daily balance method, store B uses the adjusted balance method, and store C using the previous balance method. Assume you purchased the SmartWatch on May 5 and made a $100 payment on June 15. What will the finance charge for June be if you made your purchase from store A? From store B? From store C?
The quarterly demand for smartphones at a retailer is as show. Year Quarter Demand 1 I 513 1 II 932 1 III 1509 1 IV 1902 2 I 693 2 II 1163 2 III 1857 2 IV 2469 Forecast the quarter 1 demand for year 3 using the following models: 4-quarter simple moving average. Simple exponential smoothing with α = 0.1. We assume that the forecasted value of quarter 1 is 500. Which method is the most accurate and why?
Please do not give solution in image formate thanku. The Willow River Mining Company mines and ships coal. It has experienced the following demand for coal during the past eight years: Year Coal Sales (tonnes) 1 4260 2 4510 3 4050 4 3720 5 3900 6 3470 7 2890 8 3100 Develop an adjusted exponential smoothing model (α=0.30, β=0.20) and a linear trend line model, and compare the forecast accuracy of the two using MAD. Indicate which forecast seems to be most accurate.
Apple's stock price has performed very well over the last decade. In May 2016, Apple stock dropped below $90 but it recovered and reached $153.57 on May 26, 2017. The “Apple Price Data” has data on Apple stock price weekly (before the stock split) for 53 weeks starting May 30, 2016 and ending May 26, 2017. Use this data file to build a model to forecast Apple's stock price for the following week (week 54).

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS