Greenfield's Tannery supplies leather to the South Fork Boot Company on a monthly basis for manufacturing western style boots. South Fork does not keep a large stock of inventory on hand, thus the tannery must provide sufficient leather to meet demand on a timely basis. Furthermore, the quality of the leather must be of the highest grade. The demand for western boots is lowest in the late winter, increases during the summer and fall and reaches its peak during the holiday season. The demand for leather follows the same general pattern. Greenfield's Tannery has experienced the following monthly demand for the past fourteen months. |Month January | February Demand (in sq yards) 1300 1100 March 900 April May 1600 1500 June 2100 July August September October November 2400 2000 2900 3200 3700 December 2400 January February 1600 1000 1. Calculate a forecast of the above demand using a three-month and a five-month moving average in a table. 2. In your table, include a column for computing the forecast errors for each of the moving average forecasts. Compute the error per period and then be sure to include the cumulative forecast error for each. You can find help with this in the instructor video in Content for the week.

Greenfield's Tannery supplies leather to the South Fork Boot Company on a monthly basis for manufacturing western style boots. South Fork does not keep a large stock of inventory on hand, thus the tannery must provide sufficient leather to meet demand on a timely basis. Furthermore, the quality of the leather must be of the highest grade. The demand for western boots is lowest in the late winter, increases during the summer and fall and reaches its peak during the holiday season. The demand for leather follows the same general pattern. Greenfield's Tannery has experienced the following monthly demand for the past fourteen months. |Month January | February Demand (in sq yards) 1300 1100 March 900 April May 1600 1500 June 2100 July August September October November 2400 2000 2900 3200 3700 December 2400 January February 1600 1000 1. Calculate a forecast of the above demand using a three-month and a five-month moving average in a table. 2. In your table, include a column for computing the forecast errors for each of the moving average forecasts. Compute the error per period and then be sure to include the cumulative forecast error for each. You can find help with this in the instructor video in Content for the week.

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.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January February 4,100 4,200 March 3,900 April 4,300 May 4,900 June 4,600 July 5,200 August 4,800 September 5,300 October 5,600 November 6,200 December 5,900
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,120 February 4,220 March 3,920 April 4,320 May 4,920 June 4,620 July 5,220 August 4,820 September 5,320 October 5,620 November 6,220 December 5,920 a. Using linear regression analysis, what would you estimate demand to be for each month next year? (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round…
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,000 February 4,100 March 3,800 April 4,200 May 4,850 June 4,500 July 5,150 August 4,750 September 5,250 October 5,550 November 6,150 December 5,850 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.7. (picture below)(Do not round intermediate calculations. Round your answers to 2 decimal places.) Month Forecast january february march april may june july august september october november december
Green Gardens' owner has asked your advice about a possible problem at his business. Over the last 6 months the large-sized lawn and garden inventory (ie, tables, chairs, planters, etc.) has appeared to be short. The inventory records that employees use to determine what is on hand show that more inventory is available than can actually be located. This has cause frustration and mis-trust in the inventory records for the sales employees. The owner realizes that the problem is bigger than just frustrated employees. He is afraid that inventory is being stolen, a problem he didn't think possible given that these are large items that are not easily moved. Requirements: Provide the owner with two internal controls that he could implement to reduce the likelihood of theft of the lawn and garden inventory.
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,000 February 4,100 March 3,800 April 4,200 May 4,850 June 4,500 July 5,150 August 4,750 September 5,250 October 5,550 November 6,150 December 5,850 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.7. (picture below)(Do not round intermediate calculations. Round your answers to 2 decimal places.) Month Forecast january february march april may june july august september october november december b. To…
Demand for portable music players for joggers has caused Nancy Industries (Nancy) to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nancy expects demand for music player to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demands for the players for last year was as follows : Month Demand (units) Jan 4200 Feb 4300 Mar 4000 Apr 4400 May 5000 Jun 4700 Jul 5300 Aug 4900 Sep 5400 Oct 5700 Nov 6300 Dec 6000 Question : From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate to Nancy Industries? Why?
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,220 February 4,320 March 4,020 April 4,420 May 5,020 June 4,720 July 5,320 August 4,920 September 5,420 October 5,720 November 6,320 December 6,020 Using linear regression analysis, what would you estimate demand to be for each month next year? (Round two decimal places) To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units…
South African rapper, Cassper Nyovest, has launched a business venture manufacturing his very own clothing and shoes. Cassper wishes to ensure the highest levels of customer satisfaction. Argue the importance of accurate demand forecasting as a principle of an inventory management system for Cassper. Note: Provide at least two application points.
What is the distinction between simulated and anticipated average demand:
“The ABC Supply company is currently experiencing with an inventory rotation problem. This difficulty stems from the fact that some supplies must be used prior to a stated expiration date. Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates.” Required: Explain the DMAIC methodology that can be used by the “ABC” company to implement Six Sigma Process for the above scenario. 800 words