Usage Lead Time Parent (weeks) Inventory Immediate per Beginning Component Parent A none 1 B A 2 250 C A 1 6 500 D A 3 3 750 E A 2 2 750 F B 4 2 3000 G B 2 4 1000 H. D 2 5000 I D 2 4 5000 E 1 8 1000 K E 1 5000 L E 2 4 2500 M F 3 250 N F 2560 H 2 K 1 500 Q K 2 1000 334 23

Usage Lead Time Parent (weeks) Inventory Immediate per Beginning Component Parent A none 1 B A 2 250 C A 1 6 500 D A 3 3 750 E A 2 2 750 F B 4 2 3000 G B 2 4 1000 H. D 2 5000 I D 2 4 5000 E 1 8 1000 K E 1 5000 L E 2 4 2500 M F 3 250 N F 2560 H 2 K 1 500 Q K 2 1000 334 23

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

Similar questions

The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a supermarket for a one-year period. a. Using a span of 3, forecast the sales of this product for the next 10 weeks with the moving averages method. How well does this method with span 3 forecast the known observations in this series? b. Repeat part a with a span of 10. c. Which of these two spans appears to be more appropriate? Justify your choice.
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?
The file P13_27.xlsx contains yearly data on the proportion of Americans under the age of 18 living below the poverty level. 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. Create a chart of the series with the forecasts superimposed from this optimal smoothing constant. Does it make much of an improvement over the model in part b? d. Write a short report to summarize your results. Considering the chart in part c, would you say the forecasts are good?
Demand forecasting helps a company to respond quickly to market changesgiving the firm a competitive advantage. The process of forecasting establishesthe link between planning and control for the company, and facilitates theeffective output of the firm’s goods and services. A common quantitativemethod of forecasting is time series. Explain what is involved in time seriesanalysis and its significance to demand forecasting.
Explain the term Forcasting. Why forcasting are Forecasting is one of the important functions of management. It is a part and parcel of planning function. Forecasting means prediction about future. Forecasting means analysis of future about the operations of an enterprise. It involves looking ahead for future event. Forecasting means a process of providing the details supported by budget. Forecasting means drawing a conclusion about production, sales, profit on the basis of research, study & survey.
Engage: Inventory Planning: Forecasting during Uncertainty Inventory Planning: Forecasting During Uncertainty COVID-19 has unleashed unprecedented consumer demand and exposed fractures in the just-in-time supply chain model. In the span of just a few months, your supply chain may have changed drastically. Supplier shutdowns in China. Increased shipping demands. Decreased working capital. These evolving conditions impact your go-forward inventory strategy. Forecasting inventory requirements have always included a mix of past trends, sound predictions, and supplier relationships. But the uncertainties we are facing right now make this process more challenging. This includes Evolving consumer demands Product availability, and Predictable transportation Let's look at these inputs and how they may impact inventory planning. Uncertainties in Consumer Demand Consumer demand is on a roller coaster and the ride doesn’t seem to be slowing down soon. Shelter at home requirements have led…
Engage: Inventory Planning: Forecasting during Uncertainty Inventory Planning: Forecasting During Uncertainty COVID-19 has unleashed unprecedented consumer demand and exposed fractures in the just-in-time supply chain model. In the span of just a few months, your supply chain may have changed drastically. Supplier shutdowns in China. Increased shipping demands. Decreased working capital. These evolving conditions impact your go-forward inventory strategy. Forecasting inventory requirements have always included a mix of past trends, sound predictions, and supplier relationships. But the uncertainties we are facing right now make this process more challenging. This includes Evolving consumer demands Product availability, and Predictable transportation Let's look at these inputs and how they may impact inventory planning. Uncertainties in Consumer Demand Consumer demand is on a roller coaster and the ride doesn’t seem to be slowing down soon. Shelter at home requirements have led…
40 ________ is a planning tool that relies on past data to predict the future demand: Select one: a. Forecasting b. Market analysis c. Supply planning d. Demand flow strategy
Please help with correct answers in details: Step by step Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Week Sales (1,000sof gallons) 1 17 2 21 3 20 4 24 5 18 6 17 7 21 8 19 9 22 10 21 11 16 12 22 (a) Compute four-week and five-week moving averages for the time series. Week Time SeriesValue 4-WeekMovingAverageForecast 5-WeekMovingAverageForecast 1 17 2 21 3 20 4 24 5 18 6 17 7 21 8 19 9 22 10 21 11 16 12 22 b) Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.) c) Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.) d) What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? MSE for the three-week moving average is 9.65.…
To better plan for future growth of the restaurant, Karen needs to develop a system that will enable her to forecast food and beverage sales by month for up to one year in advance. Table shows the value of food and beverage sales ($1000s) for the first three years of operation. Food and Beverage Sales for the Vintage Restaurant ($1000s) Month First Year Second Year Third Year January 242 263 282 February 235 238 255 March 232 247 265 April 178 193 205 May 184 193 210 June 140 149 160 July 145 157 166 August 152 161 174 September 110 122 126 October 130 130 148 November 152 167 173 December 206 230 235 Managerial Report Perform an analysis of the sales data for the Vintage Restaurant. Prepare a report for Karen that summarizes your findings, forecasts, and recommendations. Include the following: A time series plot. Comment on the underlying pattern in the time series.…
. Suppose that you are working as an analyst. Your task is to value company XYZ based on financial data available for this company. Discuss how you would go about doing this using themultiple growth rate Gordon growth model. Critically evaluate your approach by discussing any assumptions you make (about forecasts, discount rate etc.). What data is needed to value XYZ?
A strategic planning that include decisions such as market trends, behaviour and shifts in competitive markets, emerging competition, and long-term expansions could be classified as_______. a. Mid, long, short term forecast b. Short-term forecast c. Mid-term forecast d. Long-term forecast