The data shown are quarterly revenues (in Sthousands) from Roget's Books from 2013-Q1 through 2020-Q2.6.Quarter2013-12013-22013-32013-42014-12014-22014-32014-42015-12015-22015-32015-42016-12016-22016-32016-42017-12017-22017-32017-4Revenue23722740251847082392Quarter2018-12018-22018-32018-42019-12019-22019-32019-42020-12020-2Revenue2725292431185112277729491:27:042811268547952812289328484894268729032674487128442933323753503035302827915252Click here for the Excel Data File, Data file should open in a new browswer window. Select "File" then "Save As" to download the file toyour computer and be able to use it in Excel.a. Determine the regression equation.Regression equation: ŷ = |(Round to 1 decimal places.)b. Determine the specific index for each quarterplaces.)dexes should be in decimal form (e.g. 1.36 not 136). Rounded to 2 decimalQuarterQuarterly IndexQ1Q2Q3Q4c. What are the estimated sales (forecast) for the next three quarters?Values in $thousands. Round to 2 decimal places.)

Answered: The data shown are quarterly revenues…

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

Please help to solve step by step.
Year Season Sales 2018 Winter 40 2018 Spring 29 2018 Summer 31 2018 Fall 40 2019 Winter 102 2019 Spring 87 2019 Summer 96 2019 Fall 132 2020 Winter 105 2020 Spring 93 2020 Summer 105 2020 Fall 117 2021 Winter 141 2021 Spring 39 2021 Summer 114 2021 Fall 123 What is the slope of the trend equation obtained by linear regression? Round to two decimal digits. What is the intercept of the trend equation obtained by linear regression? Round to two decimal digits. What is the seasonal index for Spring? Round to two decimal digits. The quarter number for Winter of 2018 is 1. What is the quarter number for Spring of 2025? What is the trend based forecast for Spring of 2025. Round to a whole number. What is the seasonally adjusted trend based forecast for Spring of 2025? Please do not use excel to find the slope and intercept, thank you so much!
A restaurant manager with analyzing records of the last 6 weeks summarizes the daily demand figures in terms of the number of meals served as follows (Please fill the empty cells of the following table): Weeks Number of Meals 3-periods Moving Average [Actual - Forecast] (Actual - Forecast)2 1 60 -- -- -- 2 96 -- -- -- 3 103 -- -- -- 4 61 5 122 6 101 1. Which one of the following is closest to the forecast of the next week ( F7 ) for the number of meals to be served daily using the 3-periods moving average method ? a)143 b)95 c)57 d)62 2. Which one of the following is closest to the forecast error ( in terms of MAD ) for the weeks 4, 5 and 6 using the 3-periods moving average method ? a)22 b)29 c)30 d)24 3. What is the forecast error ( in terms of MSE ) for the weeks 4, 5 and 6 using the 3-periods moving average method ? a)641 b)577 c)705 d)897
Given a forecast demand and an actual demand for a certain product, calculate the tracking signal and MAD parameter. Year Forecast Demand Actual demand 1 78 71 75 80 3 83 101 84 84 5 88 60 85 73
Plot these forecasts AND the original demand data on graph paper or spreadsheet. Use a key to distinguish among your three lines. Please use the graph in the attached picture for the answer.
I posted this question and it's been 18 hours that it still hasn't been answered. I only need the last two questions please (:
A restaurant manager with analyzing records of the last 6 weeks summarizes the daily demand figures in terms of the number of meals served as follows (Please fill the empty cells of the following table): Weeks Number of Meals 3-periods Moving Average [Actual - Forecast] (Actual - Forecast)2 1 60 -- -- -- 2 96 -- -- -- 3 103 -- -- -- 4 61 5 122 6 101 1. Which one of the following is closest to the forecast of the next week ( F7 ) for the number of meals to be served daily using the 3-periods moving average method ? a)143 b)95 c)57 d)62 2. Which one of the following is closest to the forecast error ( in terms of MAD ) for the weeks 4, 5 and 6 using the 3-periods moving average method ? a)22 b)29 c)30 d)24 3. What is the forecast error ( in terms of MSE ) for the weeks 4, 5 and 6 using the 3-periods moving average method ? a)641 b)577 c)705 d)897
i need the answer quickly
Exercise 1: You are the operations manager at the company Servicios de Salud, Inc., which provides care services to the elderly. An important aspect of your job is ensuring that nursing homes have a healthy inventory of nutritional drinks for residents. Below is the historical demand for the product for one year: Month Historical demand (boxes) Forecasted demand (boxes) January 300 February 340 March 370 April 410 ¿? May 470 ¿? June 570 ¿? July 630 ¿? August 720 ¿? September 640 ¿? October 460 ¿? November 420 ¿? December 390 ¿? a. Calculate the average demand for each period from April to December using the 3-month simple moving average. Presents calculations and findings in a clear and organized manner. b. Discuss any trends or patterns observed in the calculated moving average demand values. c. Make an interpretation of the results and their implications for forecasting…
The long-term financial forecast plays a crucial part in the company's long-term strategic plan. True or False True False 25 28 étv N 4
Which are some of the things that drive variability in demand management and forecasting? 1. MOQs 2. Promotional sales on products 3. Supplier contracting 4. Order fulfillment 5. Network planning 6. None of the above Please give me answer ASAP with clear explanation.
Prepare a Demand Forecast for “Year 5” using Excel. Quarterly Data for Cars Sales Yt Year Quarter Sales (1000s) Year 1 1 4.80 2 4.10 3 6.00 4 6.50 Year 2 1 5.80 2 5.20 3 6.80 4 7.40 Year 3 1 6.00 2 5.60 3 7.50 4 7.80 Year 4 1 6.30 2 5.90 3 8.00 4 8.40 Year 5 1 2 3 4

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