Question 1 The monthly demand of a company is showed below, please use the static method to forecast the demand for Year 6. Sales Year 1 Year 2 Year 3 Year 4 Year 5 JAN 2,000 3,000 2,000 5,000 5,000 FEB 3,000 4,000 5,000 4,000 2,000 MAR 3,000 3,000 5,000 4,000 3,000 APR 3,000 5,000 3,000 2,000 2,000 MAY 4,000 5,000 4,000 5,000 7,000 JUN 6,000 8,000 6,000 7,000 6,000 JUL 7,000 3,000 7,000 10,000 8,000 AUG 6,000 8,000 10,000 14,000 10,000 SEP 10,000 12,000 15,000 16,000 20,000 OCT 12,000 12,000 15,000 16,000 20,000 NOV 14,000 16,000 18,000 20,000 22,000 DEC 8,000 10,000 8,000 12,000 8,000 Total 78,000 89,000 98,000 115,000 113,000

Question 1 The monthly demand of a company is showed below, please use the static method to forecast the demand for Year 6. Sales Year 1 Year 2 Year 3 Year 4 Year 5 JAN 2,000 3,000 2,000 5,000 5,000 FEB 3,000 4,000 5,000 4,000 2,000 MAR 3,000 3,000 5,000 4,000 3,000 APR 3,000 5,000 3,000 2,000 2,000 MAY 4,000 5,000 4,000 5,000 7,000 JUN 6,000 8,000 6,000 7,000 6,000 JUL 7,000 3,000 7,000 10,000 8,000 AUG 6,000 8,000 10,000 14,000 10,000 SEP 10,000 12,000 15,000 16,000 20,000 OCT 12,000 12,000 15,000 16,000 20,000 NOV 14,000 16,000 18,000 20,000 22,000 DEC 8,000 10,000 8,000 12,000 8,000 Total 78,000 89,000 98,000 115,000 113,000

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?
QUESTION 1The table below shows the sales figures for a brand of shoe over the last 12 months.Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average
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
Question 1: Kimji Company is engaged in the business of export of garments. In the past, the performance of the company had been up to the expectations. In line with the latest technology, the company decided to upgrade its machinery. For this, the Finance Manager, Abdullah estimated the amount of funds required and the timings. This will help the company in linking the investment and the financing decisions on a continuous basis. Abdullah therefore, began with the preparation of a sales forecast for the next four years. He collected the relevant data about the profit estimates in the coming years. By doing this, he wanted to be sure about the availability of funds from the internal sources of the business. For the remaining funds he is trying to find out alternative sources from outside like loan from bank etc Answer the following question based on the case study in 500-1000 words. a. What is the role of Financial Management and what are the financial decisions Involved in the above…
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 1The table below shows the sales figures for a brand of shoe over the last 12 months. Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 a. Using the following, forecast the sales for the months up to January the following year:- ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data.
Question (4): Answer the following problem: Cover Me, Inc. sells umbrellas in two cities. Management assumes that annual rainfall is the primary determinant of umbrella sales, and it wants to generate a linear regression equation to estimate potential sales in another city. Use the table below to develop a linear regression equation to find out what sales might be if the rainfall is 12 inches in City C. Show your work in the below table Rainfall X Sales Y X2 XY City A 36 inches 200 City B 30 inches 250 City C 12 inches Total 66 450
Question 4An investor is to purchase one of three types of real estate, as illustrated in Figure below. Theinvestor must decide among an apartment building, an office building, and a warehouse. Thefuture states of nature that will determine how much profit the investor will make are goodeconomic conditions and poor economic conditions. The profits that will result from eachdecision in the event of each state of nature are shown in Table below: a) Find the optimal act using Maxi-Max criteriab) Find the optimal act using Mini-Max criteria c) Find the optimal act using Maxi-Min criteria d) Find the optimal act using Min-Max regret table
QUESTION ONE (a) The actual demand of a product for six months are summarized in the table below: Month ( ) t Demand t D 1 2 3 4 5 6 80 90 70 100 70 90 i. Find three months weighted moving averages by assuming the weights, 1 0.1 W = , 2 0.4W = and 3 0.5 W =
Operations Management CH 3 Question 14 Harlen Industries has a simple forecasting model: Take the actual demand for the same month last year and divide that by the number of fractional weeks in that month. This gives the average weekly demand for that month. This weekly average is used as the weekly forecast for the same month this year. This technique was used to forecast eight weeks for this year, which are shown in the following tables along with the actual demand that occurred. The following eight weeks show the forecast (based on last year) and the demand that actually occurred: WEEK FORECAST DEMAND ACTUAL DEMAND 1 135 132 2 135 128 3 135 150 4 134 160 5 134 180 6 144 170 7 155 185 8 156 205