The following is the forecasted demand for Olives Company over the next few months. Month Forecasted Demand Jan 9025 Feb 9000 Mar 9450 Apr 9830 May 9630 10100 Jun Olives Company plans on using a constant production of 9,250 units a month at a $941 per unit cost. The company has an inventory balance of 300 units at the beginning of January. Stockout cost due to loss sale is estimated to be $202 per unit. Monthly inventory holding cost are $20 per unit. Olives Company can produce an additional 10% of its' regular production in overtime at the cost of $80 more per unit. Assume that Olives Company will avoid stockout if possible Under this plan how much will will Olives Company spend on inventory holding cost (answer to the nearest whole number)

The following is the forecasted demand for Olives Company over the next few months. Month Forecasted Demand Jan 9025 Feb 9000 Mar 9450 Apr 9830 May 9630 10100 Jun Olives Company plans on using a constant production of 9,250 units a month at a $941 per unit cost. The company has an inventory balance of 300 units at the beginning of January. Stockout cost due to loss sale is estimated to be $202 per unit. Monthly inventory holding cost are $20 per unit. Olives Company can produce an additional 10% of its' regular production in overtime at the cost of $80 more per unit. Assume that Olives Company will avoid stockout if possible Under this plan how much will will Olives Company spend on inventory holding cost (answer to the nearest whole number)

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?
The following is the forecasted demand for Olives Company over the next few months. Month Forecasted Demand Jan 9025 Feb 9000 Mar 9450 Apr 9830 May 9630 Jun 10100 Olives Company plans on using a constant production of 9,250 units a month at a $958 per unit cost. The company has an inventory balance of 300 units at the beginning of January. Stockout cost due to loss sale is estimated to be $177 per unit. Monthly inventory holding cost are $12 per unit. Olives Company can produce an additional 10% of its' regular production In overtime at the cost of $80 more per unit. Assume that Olives Company will avoid stockout if possible Under this plan how much will will Olives Company spend on inventory holding cost (answer to the nearest whole number)
The following is the forecasted demand for Olives Company over the next few months. Month Forecasted Demand Jan 9025 Feb 9000 Mar 9450 Apr 9830 May 9630 Jun 10100 Olives Company is considering using a pure chase strategy. The company has an inventory balance of 300 units and a work force capable of making 9000 units at the beginning of January. Stockout cost due to loss sale is estimated to be $800 per unit. Monthly inventory holding cost are $20 per unit. Olives estimates that adding capacity will cost $75 per unit and firing capacity will cost $50 per unit. Under this plan which of the following is true. O Olives will have inventory cost at the end of January of $5500 O Olives will spend $500 on hiring at the beginning of January O Olives will spend $13,750 on firing at the beginning of January Olives will need to use overtime in April, May and June O Olives holding cost will be be a total of $11000 for the entire plan O None of the other answers are correct
Over the past 12 months, Super Toy Mart has experienced a demand variance of 10,250 units and has produced an order variance of 12,050 units. Part 2 a) The bullwhip measure for Super Toy Mart is ______ (round your response to two decimal places). Part 3 b) If Super Toy Mart had made a perfect forecast of demand over the past 12 months and had decided to order 1/12 of that annual demand each month, the bullwhip measure would have been ______ (round your response to the nearest whole number.)
Table 1. Demand of Hairdryer from January to July [Jadual 1. Permintaan Pengering Rambut dari Januari 2021 hingga Julai 2021] Month Demand January February 2800 2870 March 2968 April Мay 3000 3100 Jun 3150 July 3400 a) Calculate forecast future demand for May, June, July and August by using 3 months simple moving average.[hitung ramalan permintaan masa depan untuk bulan Mei, Jun, Julai dan Ogos dengan menggunakan purata bergerak sederhana 3 bulan.] *
Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips. The market has been declining during the past three years because of the dual-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year. The task is unpleasant because the firm has not been able to find replacement chips for its production lines. Here is demand over the past 12 quarters: LAST THIS YEAR TWO YEARS AGO UNITS YEAR UNITS UNITS 4,785 3,495 2,696 3,475 3,210 2,078 2,705 1,695 I I I II 3,475 4,195 II II III III III IV 2,995 IV 2,375 IV Use the decomposition technique to forecast demand for the next four quarters. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Period Forecast (Units I II III IV
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…
Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips. The market has been declining during the past three years because of the dual-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year. The task is unpleasant because the firm has not been able to find replacement chips for its production lines. Here is demand over the past 12 quarters: TWO LAST THIS YEARS AGO UNITS YEAR UNITS YEAR UNITS 4,805 3,505 4,305 3,005 3,505 2,705 3,490 2,405 3,195 2,105 2,705 1,705 II II II II IV IV IV Use the decomposition technique to forecast demand for the next four quarters. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Period Forecast (Units) II II IV · = = >
Q2: A company has seasonal demand, with the forecast for the next 12 months as given below. The current labor force can produce 500 units per month. Each employee can produce 20 units per month, and is paid $2,000 per month. The inventory carrying cost is $50 per unit per period. It costs $100 to hire or layoff an employee. Assume 200 units of initial inventory and we would like to keep the similar level at the end of the year. Month 1 3 4 7 8 9 10 11 12 Demand 660 700 840 700 660 500 600 840 80 900 700 600 Please use level and chase strategy to calculate the total cost of two plans (please show your work).
Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips. The market has been declining during the past three years because of the dual-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year. The task is unpleasant because the firm has not been able to find replacement chips for its production lines. Here is demand over the past 12 quarters: TWO YEARS AGO UNITS 4,815 3.515 4,315 3,015 I || III IV || III IV Period I LAST YEAR I III IV UNITS Forecast (Units) 3,510 2,715 3,515 2,415 THIS YEAR I || III IV Use the decomposition technique to forecast demand for the next four quarters. (Do not round intermediate calculations. Round your answers to 2 decimal places.) UNITS 3,215 2,116 2,695 1,695
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…
m6