As part of its initiative to implement just-in-time (JIT) manufacturing at the motorcycle assembly plant in Exercise 1, Harley has reduced the number of engines loaded on each truck to 100. If each truck trip still costs $1,000, how does this decision impact annual inventory costs at Harley? What should the cost of each truck be if a load of 100 engines is to be optimal for Harley? Exercise 1 - Harley-Davidson has its engine assembly plant in Milwaukee and its motorcycle assembly plant in Pennsylvania. Engines are transported between the two plants using trucks, with each trip costing $1,000. The motorcycle plant assembles and sells 3000 motorcycles a year. Each engine costs $500. Harley incurs a holding cost of 20 percent per year. How many engines should Harley load onto each truck? What is the cycle inventory of engines at Harley?(Please show all steps in EXCEL)

As part of its initiative to implement just-in-time (JIT) manufacturing at the motorcycle assembly plant in Exercise 1, Harley has reduced the number of engines loaded on each truck to 100. If each truck trip still costs $1,000, how does this decision impact annual inventory costs at Harley? What should the cost of each truck be if a load of 100 engines is to be optimal for Harley? Exercise 1 - Harley-Davidson has its engine assembly plant in Milwaukee and its motorcycle assembly plant in Pennsylvania. Engines are transported between the two plants using trucks, with each trip costing $1,000. The motorcycle plant assembles and sells 3000 motorcycles a year. Each engine costs $500. Harley incurs a holding cost of 20 percent per year. How many engines should Harley load onto each truck? What is the cycle inventory of engines at Harley?(Please show all steps in EXCEL)

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 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,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
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…
Amy lives in Papar but works in Kota Kinabalu. After struggling for years with public transport such as mini-buses and the train and receiving many complaints from fellow travelers, she has decided to look into providing several upgraded bus services in and around Kota Kinabalu which would provide more comfort and hygiene. The busses will be modern, air-conditioned and either hybrids or electrical. Amy is using the public transport busses as used in KL as a model. The prices charged to the customer would be somewhat above the current mini-bus prices but Amy believes that many commuters will be more than willing to pay a bit extra for a comfortable and safe alternative. Prepare Porter’s Five Forces for Amy’s planned bus services.
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,240 February 4,340 March 4,040 April 4,440 May 5,040 June 4,740 July 5,340 August 4,940 September 5,440 October 5,740 November 6,335 December 6,030 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 4 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…
Problem #1 Divan Incorporated sells preassembled furniture. Divan Inc buys module materials from its suppliers, who has now offered Divan a discount of $2 off all units if Divan will make a purchase greater than 500 or $5.00 off if the firm will make a purchase of at least 750 units. Current data for the company is: annual demand is 20,000 units per year; setup costs are $50, and I = 20% per year. Original price is $30 (e.g. if Divan purchases between 500 and 749, the price is $28, and if Divan purchases more than 750 units, the price is $25). (a) What is the optimal purchase quantity? (b) What are the annual product costs? (c) What are the annual setup costs? (d) What are the annual holding costs? (e) What is the annual total costs? ===== Problem #2 Hren Electronics is in process of setting a new office building. The following tables show the number of expected communications among the four departments and two possible layouts for considerations (tables 2 and 3 show the…
Problem #1 Divan Incorporated sells preassembled furniture. Divan Inc buys module materials from its suppliers, who has now offered Divan a discount of $2 off all units if Divan will make a purchase greater than 500 or $5.00 off if the firm will make a purchase of at least 750 units. Current data for the company is: annual demand is 20,000 units per year; setup costs are $50, and I = 20% per year. Original price is $30 (e.g. if Divan purchases between 500 and 749, the price is $28, and if Divan purchases more than 750 units, the price is $25). (a) What are the annual setup costs? (b) What are the annual holding costs? (c) What is the annual total costs?
A Southern Georgia school district is considering ordering 58 propane-fueled school buses. "They're healthier, they're cleaner burning, and they're much quieter than the diesel option," said a school administrator. Propane-powered buses also reduce greenhouse gasses by 25% compared to gasoline-powered buses and 8% compared to diesel ones. But they come at a premium—$97,000 for a propane model, $17,000more than the diesel equivalent. The propane bus operating cost (above and beyond fuel cost) is 40 cents/mile, compared to 49cents for the diesel. Diesel fuel costs about $4/gallon in Georgia, about $1 more than propane. Bus mileage is 9 mpg for the propane model vs. 7 mpg for diesel. The life of a school bus in the district averages 10 years, and each bus travels an average of 34,000 miles per year because the district is so large and rural. Which bus is the better choice based on a life-cycle analysis? Use the obtained value to calculate the total cost of using…
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…
Spark Ltd has two divisions, assembly and electrical. The assembly division transfers partially completed components to the electrical division at a predetermined transfer price. The assembly division's standard variable production cost per unit is $550. This division has spare capacity, and it could sell all its components to outside buyers at $680 per unit in a perfectly competitive market. Required: a) Determine a transfer price using the general rule b) How would the transfer price change if the assembly division had no spare capacity? c) What transfer price would you recommend if there was no outside market for the transferred component and the assembly division had spare capacity? d) Explain how negotiation between the supplying and buying units may be used to set transfer prices. How does this relate to the general transfer pricing rule?
Butch (Stinky) Rose's counterfeit Chanel No. 22.5 racket has run into difficulties: It seems that the authentic Chanel No. 22.5 perfume is selling for less than his counterfeit perfume. However, he has managed to reduce his fixed costs to zero, and his overall costs are now $800 per gram plus $30 per gram transportation costs and commission. (The perfume's smell is easily detected by specially trained Chanel Hounds, and this necessitates elaborate packaging measures.) He therefore decides to sell the perfume for $820 per gram to undercut the competition. Specify Stinky's profit function, P(x), where x is the quantity (in grams) of perfume he buys and sells. P(x) = Calculate how much perfume should pass through his hands per day in order that he break even. g: