The University of the West Indies GLOBAL CAMPUS MGMT 2026 Production and Operations Management - Problem Sheet Assignment Semester II 2024/2025 Note: Although this assignment is being currently assessed out of 100 marks it would be prorated to Contribute a maximum of 40% towards your final course marks. M&H company ltd. sells television sets and has collected monthly sales data (in units) for the past 12 months as shown in table 1below: TABLE 1 Month Sales (Units) 1 120 2 135 3 150 165 5 180 200 7 195 8 210 225 10 240 11 255 12 270 This Assignment is comprised of four (4) Questions - All questions must be attempted Using the data provided, answer the following questions: a. Using a 3-month weighted moving average with weights 0.5, 0.3, and 0.2 (most recent month having the highest weight), calculate the forecast for month 13. [2 marks] Screens 5-7 of 7

The University of the West Indies GLOBAL CAMPUS MGMT 2026 Production and Operations Management - Problem Sheet Assignment Semester II 2024/2025 Note: Although this assignment is being currently assessed out of 100 marks it would be prorated to Contribute a maximum of 40% towards your final course marks. M&H company ltd. sells television sets and has collected monthly sales data (in units) for the past 12 months as shown in table 1below: TABLE 1 Month Sales (Units) 1 120 2 135 3 150 165 5 180 200 7 195 8 210 225 10 240 11 255 12 270 This Assignment is comprised of four (4) Questions - All questions must be attempted Using the data provided, answer the following questions: a. Using a 3-month weighted moving average with weights 0.5, 0.3, and 0.2 (most recent month having the highest weight), calculate the forecast for month 13. [2 marks] Screens 5-7 of 7

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?
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?
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?
The Global Sourcing Wire Harness Decision Sheila Austin, a buyer at Autolink, a Detroit-based producer of subassemblies for the automotive market, has sent out requests for quotations for a wiring harness to four prospective suppliers. Only two of the four suppliers indicated an interest in quoting the business: Original Wire (Auburn Hills, MI) and Happy Lucky Assemblies (HLA) of Guangdong Province, China. The estimated demand for the harnesses is 5,000 units a month. Both suppliers will incur some costs to retool for this particular harness. The harnesses will be prepackaged in 24 12 6-inch cartons. Each packaged unit weighs approximately 10 pounds. Quote 1 The first quote received is from Original Wire. Auburn Hills is about 20 miles from Autolinks corporate headquarters, so the quote was delivered in person. When Sheila went down to the lobby, she was greeted by the sales agent and an engineering representative. After the quote was handed over, the sales agent noted that engineering would be happy to work closely with Autolink in developing the unit and would also be interested in future business that might involve finding ways to reduce costs. The sales agent also noted that they were hungry for business, as they were losing a lot of customers to companies from China. The quote included unit price, tooling, and packaging. The quoted unit price does not include shipping costs. Original Wire requires no special warehousing of inventory, and daily deliveries from its manufacturing site directly to Autolinks assembly operations are possible. Original Wire Quote: Unit price = 30 Packing costs = 0.75 per unit Tooling = 6,000 one-time fixed charge Freight cost = 5.20 per hundred pounds Quote 2 The second quote received is from Happy Lucky Assemblies of Guangdong Province, China. The supplier must pack the harnesses in a container and ship via inland transportation to the port of Shanghai in China, have the shipment transferred to a container ship, ship material to Seattle, and then have material transported inland to Detroit. The quoted unit price does not include international shipping costs, which the buyer will assume. HLA Quote: Unit price = 19.50 Shipping lead time = Eight weeks Tooling = 3,000 In addition to the suppliers quote, Sheila must consider additional costs and information before preparing a comparison of the Chinese suppliers quotation: Each monthly shipment requires three 40-foot containers. Packing costs for containerization = 2 per unit. Cost of inland transportation to port of export = 200 per container. Freight forwarders fee = 100 per shipment (letter of credit, documentation, etc.). Cost of ocean transport = 4,000 per container. This has risen significantly in recent years due to a shortage of ocean freight capacity. Marine insurance = 0.50 per 100 of shipment. U.S. port handling charges = 1,200 per container. This fee has also risen considerably this year, due to increased security. Ports have also been complaining that the charges may increase in the future. Customs duty = 5% of unit cost. Customs broker fees per shipment = 300. Transportation from Seattle to Detroit = 18.60 per hundred pounds. Need to warehouse at least four weeks of inventory in Detroit at a warehousing cost of 1.00 per cubic foot per month, to compensate for lead time uncertainty. Sheila must also figure the costs associated with committing corporate capital for holding inventory. She has spoken to some accountants, who typically use a corporate cost of capital rate of 15%. Cost of hedging currencybroker fees = 400 per shipment Additional administrative time due to international shipping = 4 hours per shipment 25 per hour (estimated) At least two five-day visits per year to travel to China to meet with supplier and provide updates on performance and shipping = 20,000 per year (estimated) The international sourcing costs must be absorbed by Sheila, as the supplier does not assume any of the additional estimated costs and invoice Sheila later, or build the costs into a revised unit price. Sheila feels that the U.S. supplier is probably less expensive, even though it quoted a higher price. Sheila also knows that this is a standard technology that is unlikely to change during the next three years, but which could be a contract that extends multiple years out. There is also a lot of hall talk amongst the engineers on her floor about next-generation automotive electronics, which will completely eliminate the need for wire harnesses, which will be replaced by electronic components that are smaller, lighter, and more reliable. She is unsure about how to calculate the total costs for each option, and she is even more unsure about how to factor these other variables into the decision. Calculate the total cost per unit of purchasing from Original Wire.
The Global Sourcing Wire Harness Decision Sheila Austin, a buyer at Autolink, a Detroit-based producer of subassemblies for the automotive market, has sent out requests for quotations for a wiring harness to four prospective suppliers. Only two of the four suppliers indicated an interest in quoting the business: Original Wire (Auburn Hills, MI) and Happy Lucky Assemblies (HLA) of Guangdong Province, China. The estimated demand for the harnesses is 5,000 units a month. Both suppliers will incur some costs to retool for this particular harness. The harnesses will be prepackaged in 24 12 6-inch cartons. Each packaged unit weighs approximately 10 pounds. Quote 1 The first quote received is from Original Wire. Auburn Hills is about 20 miles from Autolinks corporate headquarters, so the quote was delivered in person. When Sheila went down to the lobby, she was greeted by the sales agent and an engineering representative. After the quote was handed over, the sales agent noted that engineering would be happy to work closely with Autolink in developing the unit and would also be interested in future business that might involve finding ways to reduce costs. The sales agent also noted that they were hungry for business, as they were losing a lot of customers to companies from China. The quote included unit price, tooling, and packaging. The quoted unit price does not include shipping costs. Original Wire requires no special warehousing of inventory, and daily deliveries from its manufacturing site directly to Autolinks assembly operations are possible. Original Wire Quote: Unit price = 30 Packing costs = 0.75 per unit Tooling = 6,000 one-time fixed charge Freight cost = 5.20 per hundred pounds Quote 2 The second quote received is from Happy Lucky Assemblies of Guangdong Province, China. The supplier must pack the harnesses in a container and ship via inland transportation to the port of Shanghai in China, have the shipment transferred to a container ship, ship material to Seattle, and then have material transported inland to Detroit. The quoted unit price does not include international shipping costs, which the buyer will assume. HLA Quote: Unit price = 19.50 Shipping lead time = Eight weeks Tooling = 3,000 In addition to the suppliers quote, Sheila must consider additional costs and information before preparing a comparison of the Chinese suppliers quotation: Each monthly shipment requires three 40-foot containers. Packing costs for containerization = 2 per unit. Cost of inland transportation to port of export = 200 per container. Freight forwarders fee = 100 per shipment (letter of credit, documentation, etc.). Cost of ocean transport = 4,000 per container. This has risen significantly in recent years due to a shortage of ocean freight capacity. Marine insurance = 0.50 per 100 of shipment. U.S. port handling charges = 1,200 per container. This fee has also risen considerably this year, due to increased security. Ports have also been complaining that the charges may increase in the future. Customs duty = 5% of unit cost. Customs broker fees per shipment = 300. Transportation from Seattle to Detroit = 18.60 per hundred pounds. Need to warehouse at least four weeks of inventory in Detroit at a warehousing cost of 1.00 per cubic foot per month, to compensate for lead time uncertainty. Sheila must also figure the costs associated with committing corporate capital for holding inventory. She has spoken to some accountants, who typically use a corporate cost of capital rate of 15%. Cost of hedging currencybroker fees = 400 per shipment Additional administrative time due to international shipping = 4 hours per shipment 25 per hour (estimated) At least two five-day visits per year to travel to China to meet with supplier and provide updates on performance and shipping = 20,000 per year (estimated) The international sourcing costs must be absorbed by Sheila, as the supplier does not assume any of the additional estimated costs and invoice Sheila later, or build the costs into a revised unit price. Sheila feels that the U.S. supplier is probably less expensive, even though it quoted a higher price. Sheila also knows that this is a standard technology that is unlikely to change during the next three years, but which could be a contract that extends multiple years out. There is also a lot of hall talk amongst the engineers on her floor about next-generation automotive electronics, which will completely eliminate the need for wire harnesses, which will be replaced by electronic components that are smaller, lighter, and more reliable. She is unsure about how to calculate the total costs for each option, and she is even more unsure about how to factor these other variables into the decision. Calculate the total cost per unit of purchasing from Happy Lucky Assemblies.
The Global Sourcing Wire Harness Decision Sheila Austin, a buyer at Autolink, a Detroit-based producer of subassemblies for the automotive market, has sent out requests for quotations for a wiring harness to four prospective suppliers. Only two of the four suppliers indicated an interest in quoting the business: Original Wire (Auburn Hills, MI) and Happy Lucky Assemblies (HLA) of Guangdong Province, China. The estimated demand for the harnesses is 5,000 units a month. Both suppliers will incur some costs to retool for this particular harness. The harnesses will be prepackaged in 24 12 6-inch cartons. Each packaged unit weighs approximately 10 pounds. Quote 1 The first quote received is from Original Wire. Auburn Hills is about 20 miles from Autolinks corporate headquarters, so the quote was delivered in person. When Sheila went down to the lobby, she was greeted by the sales agent and an engineering representative. After the quote was handed over, the sales agent noted that engineering would be happy to work closely with Autolink in developing the unit and would also be interested in future business that might involve finding ways to reduce costs. The sales agent also noted that they were hungry for business, as they were losing a lot of customers to companies from China. The quote included unit price, tooling, and packaging. The quoted unit price does not include shipping costs. Original Wire requires no special warehousing of inventory, and daily deliveries from its manufacturing site directly to Autolinks assembly operations are possible. Original Wire Quote: Unit price = 30 Packing costs = 0.75 per unit Tooling = 6,000 one-time fixed charge Freight cost = 5.20 per hundred pounds Quote 2 The second quote received is from Happy Lucky Assemblies of Guangdong Province, China. The supplier must pack the harnesses in a container and ship via inland transportation to the port of Shanghai in China, have the shipment transferred to a container ship, ship material to Seattle, and then have material transported inland to Detroit. The quoted unit price does not include international shipping costs, which the buyer will assume. HLA Quote: Unit price = 19.50 Shipping lead time = Eight weeks Tooling = 3,000 In addition to the suppliers quote, Sheila must consider additional costs and information before preparing a comparison of the Chinese suppliers quotation: Each monthly shipment requires three 40-foot containers. Packing costs for containerization = 2 per unit. Cost of inland transportation to port of export = 200 per container. Freight forwarders fee = 100 per shipment (letter of credit, documentation, etc.). Cost of ocean transport = 4,000 per container. This has risen significantly in recent years due to a shortage of ocean freight capacity. Marine insurance = 0.50 per 100 of shipment. U.S. port handling charges = 1,200 per container. This fee has also risen considerably this year, due to increased security. Ports have also been complaining that the charges may increase in the future. Customs duty = 5% of unit cost. Customs broker fees per shipment = 300. Transportation from Seattle to Detroit = 18.60 per hundred pounds. Need to warehouse at least four weeks of inventory in Detroit at a warehousing cost of 1.00 per cubic foot per month, to compensate for lead time uncertainty. Sheila must also figure the costs associated with committing corporate capital for holding inventory. She has spoken to some accountants, who typically use a corporate cost of capital rate of 15%. Cost of hedging currencybroker fees = 400 per shipment Additional administrative time due to international shipping = 4 hours per shipment 25 per hour (estimated) At least two five-day visits per year to travel to China to meet with supplier and provide updates on performance and shipping = 20,000 per year (estimated) The international sourcing costs must be absorbed by Sheila, as the supplier does not assume any of the additional estimated costs and invoice Sheila later, or build the costs into a revised unit price. Sheila feels that the U.S. supplier is probably less expensive, even though it quoted a higher price. Sheila also knows that this is a standard technology that is unlikely to change during the next three years, but which could be a contract that extends multiple years out. There is also a lot of hall talk amongst the engineers on her floor about next-generation automotive electronics, which will completely eliminate the need for wire harnesses, which will be replaced by electronic components that are smaller, lighter, and more reliable. She is unsure about how to calculate the total costs for each option, and she is even more unsure about how to factor these other variables into the decision. Based on the total cost per unit, which supplier should Sheila recommend?
The Global Sourcing Wire Harness Decision Sheila Austin, a buyer at Autolink, a Detroit-based producer of subassemblies for the automotive market, has sent out requests for quotations for a wiring harness to four prospective suppliers. Only two of the four suppliers indicated an interest in quoting the business: Original Wire (Auburn Hills, MI) and Happy Lucky Assemblies (HLA) of Guangdong Province, China. The estimated demand for the harnesses is 5,000 units a month. Both suppliers will incur some costs to retool for this particular harness. The harnesses will be prepackaged in 24 12 6-inch cartons. Each packaged unit weighs approximately 10 pounds. Quote 1 The first quote received is from Original Wire. Auburn Hills is about 20 miles from Autolinks corporate headquarters, so the quote was delivered in person. When Sheila went down to the lobby, she was greeted by the sales agent and an engineering representative. After the quote was handed over, the sales agent noted that engineering would be happy to work closely with Autolink in developing the unit and would also be interested in future business that might involve finding ways to reduce costs. The sales agent also noted that they were hungry for business, as they were losing a lot of customers to companies from China. The quote included unit price, tooling, and packaging. The quoted unit price does not include shipping costs. Original Wire requires no special warehousing of inventory, and daily deliveries from its manufacturing site directly to Autolinks assembly operations are possible. Original Wire Quote: Unit price = 30 Packing costs = 0.75 per unit Tooling = 6,000 one-time fixed charge Freight cost = 5.20 per hundred pounds Quote 2 The second quote received is from Happy Lucky Assemblies of Guangdong Province, China. The supplier must pack the harnesses in a container and ship via inland transportation to the port of Shanghai in China, have the shipment transferred to a container ship, ship material to Seattle, and then have material transported inland to Detroit. The quoted unit price does not include international shipping costs, which the buyer will assume. HLA Quote: Unit price = 19.50 Shipping lead time = Eight weeks Tooling = 3,000 In addition to the suppliers quote, Sheila must consider additional costs and information before preparing a comparison of the Chinese suppliers quotation: Each monthly shipment requires three 40-foot containers. Packing costs for containerization = 2 per unit. Cost of inland transportation to port of export = 200 per container. Freight forwarders fee = 100 per shipment (letter of credit, documentation, etc.). Cost of ocean transport = 4,000 per container. This has risen significantly in recent years due to a shortage of ocean freight capacity. Marine insurance = 0.50 per 100 of shipment. U.S. port handling charges = 1,200 per container. This fee has also risen considerably this year, due to increased security. Ports have also been complaining that the charges may increase in the future. Customs duty = 5% of unit cost. Customs broker fees per shipment = 300. Transportation from Seattle to Detroit = 18.60 per hundred pounds. Need to warehouse at least four weeks of inventory in Detroit at a warehousing cost of 1.00 per cubic foot per month, to compensate for lead time uncertainty. Sheila must also figure the costs associated with committing corporate capital for holding inventory. She has spoken to some accountants, who typically use a corporate cost of capital rate of 15%. Cost of hedging currencybroker fees = 400 per shipment Additional administrative time due to international shipping = 4 hours per shipment 25 per hour (estimated) At least two five-day visits per year to travel to China to meet with supplier and provide updates on performance and shipping = 20,000 per year (estimated) The international sourcing costs must be absorbed by Sheila, as the supplier does not assume any of the additional estimated costs and invoice Sheila later, or build the costs into a revised unit price. Sheila feels that the U.S. supplier is probably less expensive, even though it quoted a higher price. Sheila also knows that this is a standard technology that is unlikely to change during the next three years, but which could be a contract that extends multiple years out. There is also a lot of hall talk amongst the engineers on her floor about next-generation automotive electronics, which will completely eliminate the need for wire harnesses, which will be replaced by electronic components that are smaller, lighter, and more reliable. She is unsure about how to calculate the total costs for each option, and she is even more unsure about how to factor these other variables into the decision. Are there any other issues besides cost that Sheila should evaluate?
The Global Sourcing Wire Harness Decision Sheila Austin, a buyer at Autolink, a Detroit-based producer of subassemblies for the automotive market, has sent out requests for quotations for a wiring harness to four prospective suppliers. Only two of the four suppliers indicated an interest in quoting the business: Original Wire (Auburn Hills, MI) and Happy Lucky Assemblies (HLA) of Guangdong Province, China. The estimated demand for the harnesses is 5,000 units a month. Both suppliers will incur some costs to retool for this particular harness. The harnesses will be prepackaged in 24 12 6-inch cartons. Each packaged unit weighs approximately 10 pounds. Quote 1 The first quote received is from Original Wire. Auburn Hills is about 20 miles from Autolinks corporate headquarters, so the quote was delivered in person. When Sheila went down to the lobby, she was greeted by the sales agent and an engineering representative. After the quote was handed over, the sales agent noted that engineering would be happy to work closely with Autolink in developing the unit and would also be interested in future business that might involve finding ways to reduce costs. The sales agent also noted that they were hungry for business, as they were losing a lot of customers to companies from China. The quote included unit price, tooling, and packaging. The quoted unit price does not include shipping costs. Original Wire requires no special warehousing of inventory, and daily deliveries from its manufacturing site directly to Autolinks assembly operations are possible. Original Wire Quote: Unit price = 30 Packing costs = 0.75 per unit Tooling = 6,000 one-time fixed charge Freight cost = 5.20 per hundred pounds Quote 2 The second quote received is from Happy Lucky Assemblies of Guangdong Province, China. The supplier must pack the harnesses in a container and ship via inland transportation to the port of Shanghai in China, have the shipment transferred to a container ship, ship material to Seattle, and then have material transported inland to Detroit. The quoted unit price does not include international shipping costs, which the buyer will assume. HLA Quote: Unit price = 19.50 Shipping lead time = Eight weeks Tooling = 3,000 In addition to the suppliers quote, Sheila must consider additional costs and information before preparing a comparison of the Chinese suppliers quotation: Each monthly shipment requires three 40-foot containers. Packing costs for containerization = 2 per unit. Cost of inland transportation to port of export = 200 per container. Freight forwarders fee = 100 per shipment (letter of credit, documentation, etc.). Cost of ocean transport = 4,000 per container. This has risen significantly in recent years due to a shortage of ocean freight capacity. Marine insurance = 0.50 per 100 of shipment. U.S. port handling charges = 1,200 per container. This fee has also risen considerably this year, due to increased security. Ports have also been complaining that the charges may increase in the future. Customs duty = 5% of unit cost. Customs broker fees per shipment = 300. Transportation from Seattle to Detroit = 18.60 per hundred pounds. Need to warehouse at least four weeks of inventory in Detroit at a warehousing cost of 1.00 per cubic foot per month, to compensate for lead time uncertainty. Sheila must also figure the costs associated with committing corporate capital for holding inventory. She has spoken to some accountants, who typically use a corporate cost of capital rate of 15%. Cost of hedging currencybroker fees = 400 per shipment Additional administrative time due to international shipping = 4 hours per shipment 25 per hour (estimated) At least two five-day visits per year to travel to China to meet with supplier and provide updates on performance and shipping = 20,000 per year (estimated) The international sourcing costs must be absorbed by Sheila, as the supplier does not assume any of the additional estimated costs and invoice Sheila later, or build the costs into a revised unit price. Sheila feels that the U.S. supplier is probably less expensive, even though it quoted a higher price. Sheila also knows that this is a standard technology that is unlikely to change during the next three years, but which could be a contract that extends multiple years out. There is also a lot of hall talk amongst the engineers on her floor about next-generation automotive electronics, which will completely eliminate the need for wire harnesses, which will be replaced by electronic components that are smaller, lighter, and more reliable. She is unsure about how to calculate the total costs for each option, and she is even more unsure about how to factor these other variables into the decision. Based on this case, do you think international purchasing is more or less complex than domestic purchasing? Why? Is it worth the additional effort?
The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
Avion, Inc. Susan Dey and Bill Mifflin, procurement managers at Avion, Inc., sat across from each other and reviewed a troubling performance report concerning a key supplier, Foster Technologies. The report detailed the deteriorating performance of Foster Technologies in the areas of material quality and on-time delivery. At this point, Kevin ODonnell, another procurement manager, entered the room. Explain the role of performance measurement in managing supply chain activities.
Avion, Inc. Susan Dey and Bill Mifflin, procurement managers at Avion, Inc., sat across from each other and reviewed a troubling performance report concerning a key supplier, Foster Technologies. The report detailed the deteriorating performance of Foster Technologies in the areas of material quality and on-time delivery. At this point, Kevin ODonnell, another procurement manager, entered the room. What parts of the supply chain are most closely involved with the situation in this case? What is the responsibility of each part in order to maintain a smooth flow of material?