1:46口Forecasting Assignment1. The department manager using a combination of methods has forecast sales of toasters ata local department store. Calculate the MAD for the manager's forecast. Compare themanager's forecast against a naive forecast. Which is better?Manager'sForecastMonthUnit SalesJanuaryFebruary5261March73AprilМay7966June51JulyAugustSeptember475044553052October5542November7460December125752. The last four weekly values of sales were 80, 100, 105, and 90 units. The last four forecasts(for the same four weeks) were 60, 80, 95, and 75 units. Calculate MAD, MSE, and MAPE forthese four weeks.SalesForecastErrorError squaredPct. error806020400.251008020400.201059510100.095907515225.167AAA online.saskpolytech.ca

The answer is as below: WE ARE ALLOWED TO DO ONE QUESTION ONLY AT AT TIME.

1. The department manager using a combination of methods has forecast sales of toasters at a local department store. Calculate the MAD for the manager's forecast. Compare the manager's forecast against a naive forecast. Which is better? Manager's Forecast Month Unit Sales January February 52 61 March 73 April Мay 79 66 June 51 47 50 July August September 44 55 30 52 Octobor 55 12

1. The department manager using a combination of methods has forecast sales of toasters at a local department store. Calculate the MAD for the manager's forecast. Compare the manager's forecast against a naive forecast. Which is better? Manager's Forecast Month Unit Sales January February 52 61 March 73 April Мay 79 66 June 51 47 50 July August September 44 55 30 52 Octobor 55 12

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: Using exponential smoothing with a weight ex of 0.6 on actual values: (a) if sales are $45,000 and $50,000 for 2010 and 2011, what would you forecast for 2012? (b) given this forecast and actual 2012 sales of $53,000, what would you then forecast for 20013? (a) (b)
q1- Daily highs in Sacramento for the past week (from least to most recent) were: 95, 102, 101, 96, 95, 90 and 92. Develop a forecast for today using a weighted moving average, with weights of .6, .3 and .1, where the highest weights are applied to the most recent dataq2- Consider the following demand and forecast. Period Demand Forecast 1 7 10 2 12 15 3 18 20 4 22 If MAD = 2, what is the forecast for period 4? Answer 21 22 23 none of the aboveq3- A normal distribution has a mean of 500 and a standard deviation of 50. A manager wants to simulate one value from this distribution, and has drawn the number 1.4 randomly. What is the simulated value?Q4- The local operations manager for the IRS must decide whether to hire 1, 2, or 3 temporary workers. He estimates that net revenues will vary with how well taxpayers comply with the new tax code. The following payoff table is given in thousands of dollars (e.g. 50 = $50,000). If he thinks the chances of low, medium, and high compliance are…
The Handy-Dandy Department Store had forecast sales of $110,000 for the previous week. The actual sales were $130,000.a. What is the forecast for this week, using exponential smoothing and α = .1?b. If sales this week turn out to be $120,000, what is the forecast for next week?
Using the photo attached, answer the following questions. 1. using the manual trend projection method of forecasting, show how Mr John can forecast demand for tyres for the next two years. SHOW ALL WORKING NO EXCEL SHEETS NO HAND WRITTEN ANSWERS, TYPE IT!
1 The demand for automobiles at Crescent Auto Dealers for the past 8 weeks is as follows. Week Auto Demand Weights1 9 0.12 11 0.33 8 0.64 125 106 137 78 12a Develop a 3-week moving average forecast for Weeks 4 through 9b Develop a 3-week weighted average forecast…
IN THE MID-1960S, WALT DISNEY’S DREAM was to build a family resort destination like no other. The dream became a reality when Walt Disney World Resort opened in 1971, featuring Magic Kingdom as the centerpiece. Today, millions of guests visit the Walt Disney World Resort each year to experience the world-class theme parks and hotels. Analytics feature prominently in the operations of Walt Disney World. i)Explain using illustrations how forecasting features in this company’s operations. ii)Explain at least four methods of forecasting that can be used for Disney’s purpose. Use made up worked examples.
Calculate the forecast for week 16 using - a 2-period moving avergage - a 3-period moving average
a. What do we mean by forecast?b. Can a forecast have an error? Justify your answer.
8. Calculate (a) MAD and (b) MSE for the following forecast versus actual sales figures: Forecast 100 110 120 130 Actual 95 108 123 130 Part 2 a) MAD= __________ (round your response to one decimal place).