Use a three-period moving average method to determine forecast value for time 5 to 7. Use an averaging all data point method to determine forecast value for time 5 to 7. Compare the above methods based on MAD values. Which one you prefer? Why?

Use a three-period moving average method to determine forecast value for time 5 to 7. Use an averaging all data point method to determine forecast value for time 5 to 7. Compare the above methods based on MAD values. Which one you prefer? Why?

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

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

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

ChapterC: Cases

Section: Chapter Questions

Problem 5.3SD: Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling...

See similar textbooks

Similar questions

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?
Q. 13 Weekly demand for cases of canned food at a local grocery outlet is shown. Using a 2 period moving average, what is the forecast for week 6? Group of answer choices a. 5 b. 6 c. 7 d. 8 e. 9
QUESTION 1 Sales of Fat Lips Burgers for 2012 are shown in the table below. 1. Do the 2 month SMA forecast 2. Do 2 month WMA forecast using the information below WMA – 2: last month, 1 – last 2 months 3. For the month of January 2012, the forecast was 438. Do the EMA forecast with the smoothing constant = 0.3. What is the forecast for Jan 2013? 4. Compare the forecasts above using MAD, MSE and MAPE. Which forecast method gives the least errors? Month Actual Sales Forecast Jan 2012 438 Feb 420 March 414 Apr 318 May 306 June 240 July 240 Aug 216 Sep 198 Oct 225 Nov 270 Dec 315 Jan 2013 - QUESTION 2Dayang sells 5 kg bags of fertilizer to local farmers in Tg Karang. The sales data for the past 11 months is shown below. Month Demand (10s of bags) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 1. Find the forecast for the month 12 using the methods below: a. Simple 4 month moving average (SMA) b.…
QUESTION ONE (b) The forecast of a product for the first week of January was 200 units, whereas the actual demand turned out to be 220 units. i. Find the forecast for the week of January assuming the smoothing constant 0.2 α = ii. Find the forecast for the third week of third week of January if the actual demand of the second week is 210 units
TOPIC 3 FORECASTING, SALES & OPERATIONS PLANNING| What do you understand by; I.qualitative and quantitative forecast method . ii. the role of forecasting in supply chain management iii. short range and Long range forecastsElaborate clearly for each answer.b. Given the demand and forecast values shown in the following Table Q3b, i.Determine the three-period moving average forecast for November. ii. Analyze the exponential smoothing forecast for November using a = 0.35. iii. Evaluate the forecast error for September. C. Elaborate the purpose of sales & operation planning, and describe the S&OP process.d. Calculate the available-to-promise for periods 1,3 and 5 for the Table Q3d below
TOPIC 3 FORECASTING, SALES & OPERATIONS PLANNING| What do you understand by;i.qualitative and quantitative forecast method .ii. the role of forecasting in supply chain managementiii. short range and Long range forecastsElaborate clearly for each answer. C. Elaborate the purpose of sales & operation planning, and describe the S&OP process.
Q.No.04. What does BOM stands for? Why it is necessary for any firm to have correct forecast of BOM?
Period Actual Forecast Error Abs Error 1 35 40 -5 5 2 38 37 1 1 3 45 41 4 4 4 39 43 -4 4 5 44 42 2 2 6 49 45 4 4 7 46 48 -2 2 8 46 48 -2 2 9 52 47 5 5 10 57 52 5 5 Sum 451 443 8 34 Average 45.1 44.3 0.8 3.4 Calculate the Tracking Signal to two decimal places.
Question #2 Month Demand 1 45 2 48 3 43 4 48 5 49 6 54 7 47 8 50 9 46 10 47 Using the table above, calculate two forecasts using the following method:- First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. ii. Calculate the weighted moving average for periods 4 through 10, using weights of .70, .20, and .10, with 0.70 applied to the most recent data. iii. Calculate the mean absolute deviation (MAD) for each forecasting procedure. Which forecasting procedure would you select? Why?
Give typed answer Question: Use an exponential smoothing model with a =.4 to forecast issues remediated for periods 6-10. (Assume a beginning forecast of 320 for period 5). 1. Forecast Period 6 (August) : ? 2. Forecast Period 7 (September) : ? 3. Forecast Period 8 (October) : ? 4. Forecast Period 9 (November) : ? 5. Forecast Period 10 (December) : ?