Q3 The following table contains the sale of water pumps for the last 10 months in a retail outlet. Week No. Actual Demand Week No. Actual Demand 1 31 36 34 7 38 33 8 40 4 35 9 40 37 10 41 i) Forecast for 11th week using exponential smoothing method for these data using a (alpha) of 0.3, and an initial forecast of 32. ii) Use 3 weeks moving average to forecast 11th month. iii) Identify the best method using Mean Absolute Deviation (MAD). iv) Justify your decision. 2.

Q3 The following table contains the sale of water pumps for the last 10 months in a retail outlet. Week No. Actual Demand Week No. Actual Demand 1 31 36 34 7 38 33 8 40 4 35 9 40 37 10 41 i) Forecast for 11th week using exponential smoothing method for these data using a (alpha) of 0.3, and an initial forecast of 32. ii) Use 3 weeks moving average to forecast 11th month. iii) Identify the best method using Mean Absolute Deviation (MAD). iv) Justify your decision. 2.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section: Chapter Questions

Problem 56P

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.
Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?
Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?
Q1 Given the Supply chain cost for a service is PKR 195 and the customer value is PKR 225. Determine supply chain surplus and consumer surplus. Q2 PizzaHut is a franchise based model which serves customers a variety of pizzas and related products. The service is purely customized. Identify whether the model is push-based supply chain or pull based supply chain. Can we a have push-pull boundary in PizzaHut case? How? Q3 Discuss Qualitative forecasting technique. Explain the situations where we use Qualitative methods. Discuss Delphi forecasting method and its challenge.
q1(a)Imagine that you need to introduce a new gadget such as the Apple Watch. Determine which forecasting method is appropriate for projecting the future demand of such this gadget. b)ARIMA is mostly used to forecast future values using historical time series data, as we all know. Its primary use is in short-term forecasting with at least 38-40 historical data points and a small number of outliers. If we don't have at least 38 data points, we should consider using another strategy.
QUESTION 2:The manager of YTL Computers wants to develop next year’s quarterly forecasts of salesrevenue for its brand laptops. The sales are seasonal and the company believes that thefollowing most recent eight quarters of sales should be representative of next year’ssales: Year Quarter Sales (millions of dollars) 1 1 9.2 1 2 5.4 1 3 4.3 1 4 14.1 2 1 10.3 2 2 6.4 2 3 5.4 2 4 16.0 Determine the forecast of next year’s quarterly sales revenue for this line of laptops.Show all your workings.
q. 15 Calculate the accuracy of your MA forecasts using MAD. What does the result tell you? Group of answer choices a. There is a bias towards over forecasting b. There is a bias towards under forecasting c. On average forecasts miss by 15% d. On average forecasts miss by 2 e. MAD does not provide any useful information without a CFE calculation to compare with
Q 6 Identify two business situations where the Delphi method might be used to generate forecasts. Can you think of any difficulties and pitfalls associated with using the Delphi method?
Question 03 Suppose you sell stylish leather bags targeting young office going people who can use your bags to carry laptops and necessary stuff. You have already launched leather bags in February of this year and now based on the demand results of last 7 months, you want to predict the demand for your bags for the month of September. Hence, you want to select the right forecasting techniques and you are considering 2 period Moving Average, Naive technique and Exponential Smoothing (use any value between .10 - .15 as the value of alpha). Now figure out the better forecasting technique among 2 period Moving Average, Naive technique and Exponential Smoothing by doing the error calculation with the help of MAD, MSE, MAPE. Period Demand 2period Moving Average (Demand forecast) Naive technique (Demand forecast) Exponential Smoothing (Demand forecast) February 70 75 ** ** March 74 78 ** ** April 80 ** ** ** May 88 ** ** ** June…
If the forecasted value of the time series variable for one period is 28.5 and the actual value observed for the same period is 32, what is the forecast error for that period? Question 19 options: 3.5 2 -3.5 4
q. 14 Given the same data, calculate the CFE for when using a MA for this data. Tip: You will need to calculate the MA forecast for as many periods as possible before calculating the CFE. Group of answer choices a. 0 b. -1 c. 1 d. 2 e. -2