Problem 3-14 (Algo)Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the pastyear. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safetylaws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows:MONTHDEMAND (UNITS)4,1504,25e3,9504, 3504,95e4,6505,25e4,8505,35e5,65e6,25e5,95eJanuaryFebruaryMarchАprilМayJuneJulyAugustSeptemberOctoberNovemberDecembera. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow thegeneral format in Exhibit 3.8. (Do not round Intermedlate calculatlons. Round your answers to 2 decimal places.)MonthForecastJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberb. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additionalunits should be held to meet this level of confidence? (Do not round Intermedlate calculatlons. Round your answer to the nearestwhole number.)Additional units

Answered: a. Using linear regression analysis,…

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

1. Favors Distribution Company purchases small imported trinkets in bulk, packages them, and sells them to retail stores. They are conducting an inventory control study of all their items. The following data for the year 2006 are for one such item, which is not seasonal. [10 Points] Month Sales Jan Feb 18 19 Mar Apr May Jun 17 21 20 19 Jul 20 Aug 23 a. Use trend projection to estimate the relationship between time and sales (state the trend line equation in this problem). b. Calculate forecasts for February 2007, April 2007, and February 2008
discuss the strategic importance of forecasting for Disney and demonstrate how Disney World systematically uses the first seven steps in the forecasting process to initiate, design and implement forecasting systems
The most naive forecast can is quite valuable in leading to an organization’s success because it is most widely understood by senior managers. True or False
Dic 2 - Time Series Analysis and F eBook Problem 6-01 (Algorithmic) Consider the following time series data. Thm Week 1 2 3 4 5 6 Value 20 13 15 11 19 13 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. a. Mean absolute error. If required, round your answer to one decimal place. b. Mean squared error. If required, round your answer to one decimal place. c. Mean absolute percentage error. If required, round your intermediate calculations and final answer to two decimal places. % d. What is the forecast for week 7? If required, round your answer to two decimal place.
a. What is your forecast for December of Year 4, making period 1 as the starting period for the regression? b. The actual demand for period 48 was just learned to be 5,100. Add this demand to the Inputs file and change the starting period for the regression to period 2 so that the number of periods in the regression remains unchanged. How much or little does the forecast for period 49 change from the one for period 48? The error measures? Are you surprised?c. Now change the time when the regression starts to period 25 and repeat the process. What differences do you note now? What forecast will you make for period 49?
Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows. Week 1 2 3 4 5 6 Value 17 12 15 12 18 13 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. (a) mean absolute error MAE = (b) mean squared error MSE = (c) mean absolute percentage error (Round your answer to two decimal places.) MAPE = % (d) What is the forecast for week 7?
Can you please solve all parts of the question manually. Thank you!
The Yummy Ice Cream Company projects the demand for ice cream by using first-order exponential smoothing. Last week the forecast was 100,000 gallons of ice cream, and 90,000 gallons was actually sold. Using alpha=.1, prepare a forecast for next week. Calculate the forecast using Alpha=.2 and Alpha=.3 for this problem. Which values of Alpha gave the best forecast, assuming actual demand for next week ends up being 95,000 gallons?
Hi, I need help with solving for the following values (boxed). Thank you.
The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 5 6 7 8 9 10 11 Demand 6 8 4 7 11 7 13 12 10 13 8 This exercise contains only parts b, c, and d. Part 2 b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Part 3 c) Using the 3-year weighted moving average with weights 0.10, 0.30, and 0.60, using 0.60 for the most recent period, provide the forecast from periods 4 through 12 (round your responses to two decimal places). Part 4 d) Mean absolute deviation for the forecast developed…
MSE answer for part a = 5.95 is incorrect. Please do recalculations with the correct answer. also the rest of the question was not answered so here it is: Use ? = 0.2 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (Round your answer to two decimal places.) Use ? = 0.4 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15
Respond to each of the items using the following time series data. Period Demand 144 2 172 3 157 4 160 144 181 7 160 8 176 9. 149 10 183 11 182 12 149 13 153 14 164 15 153 16 104 Click here for the Excel Data File b. Compute all possible forecasts using a five-period moving average. (Round your answers to 1 decimal place.) Absolute Period Demand 5-period SMA Errors 1 144 172 3 157 4. 160 5 144 181 7 160 8 176 9 149 10 183 11 182 12 149 13 153 14 164 LO

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