Collaborative Planning, Forecasting and Replenishment (CPFR) states cooperative management of demand and supply through joint visibility and replenishment of products in the SC. Select one: a. True b. False
Q: Complete the forecasting worksheets for: Naïve Average Moving Average Weighted Moving Average using…
A: Weighted Moving Average using the weights of .8, .15, and .05 ExponA use an alpha level of .75ExponB…
Q: (a) Compute four-week and five-week moving averages for the time series. 4-Week 5-Week Moving…
A: (a) (b)
Q: The demand for Krispee Crunchies, a favorite breakfast cereal of people born in the 1940s, is…
A:
Q: All forecasting methods using exponential smoothing, adaptive smoothing, and exponential smoothing…
A: Forecasting is the process of predicting future demand values based on historical data. The…
Q: TWO LAST THIS YEARS AGO UNITS YEAR UNITS 3,495 2,696 3,475 2,375 YEAR UNITS I 4,785 3,475 4,195…
A: Decomposition is a determining procedure that isolates or deteriorates verifiable information into…
Q: a. Predict the sales for Jasmine Slush using the following forecasting methods: - naïve (use simple…
A: Forecasting is to predict the uncertain future of demand and sales. There are various methods to do…
Q: (4-b). Use simple exponential smoothing with α = 0.6 to forecast the tire sales for September…
A: Forecasting sales refers to the prediction of future sales using previous data to estimate the…
Q: Explain in detail about Collaborative Planning, Forecasting and Replenishment (CPFR)?
A: Collaborative planning ,forecasting and replenishment - It is a process which combines several…
Q: Explain what is seasonality and how forecast is done using data that has seasonality
A: In time series analysis, seasonalities are regarded as repeated up / down cyclic patterns in serial…
Q: Which of the following is used to describe the degree of forecast error? a. Median and Mode b. Mean…
A: Mean absolute percent error is the method to describe the degree of relationship between errors for…
Q: Jsing trend-adjusted exponential smoothing, Forecasts (F,), Trend (T,), and Forecasts Including…
A: Given: α=0.20β=0.41(F1)=9 unitsT1=2 units Months Actual Demand (At) Forecast (Ft) Trend (Tt)…
Q: A company has an unbiased forecast for its demand. What does that mean?a. All forecast errors are…
A: Forecasting is the procedure of prediction making for the future grounded on past as well as present…
Q: The Yummy Ice Cream Company uses the exponential smoothing method. Last week the forecast was…
A:
Q: In order to increase the responsiveness (volatility) of following forecast models, what can you do?…
A: In order to increase the responsiveness of the forecast model using exponential smoothing, we need…
Q: Please show work
A: From the given data.
Q: You discovered that the forecasting error falls beyond the acceptable ranges in the past three…
A: Find the given details below: Given details: Period Actual Forecast (A-F) Error (A) (F)…
Q: a) Using a weighted moving average with three periods, determine the demand for period 13. Use 3, 2,…
A: Forecasting is the process of predicting future data based on previous or past data and information.…
Q: The following table shows the actual demand observed over the last 11 years: Year 1 2 4 7 8 10 11…
A: Given - Table for demand seen in past years- Year Actual Demand 1 6 2 9 3 4 4 9 5 13…
Q: Develop a 3-weck weighted average forecast for Week 4 through 9 with weights WI - W2 = W3 = 0.2 0.3…
A: A moving average based on weighted average puts weight on the data gathered recently, by multiplying…
Q: Which of the following concepts explain why we tend to make errors in affective forecasting?
A: Affective forecasting refers to the prediction of future events on the basis of a current emotion.
Q: Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the…
A:
Q: What method would you choose of forecasting technique, which requires subjective inputs obtained…
A: Forecasting is technique which uses past data in order to predict future trends. It is mainly used…
Q: What type of forecasting method would you recommend to a start-up retailer in terms of quantities,…
A: Demand forecasting is very important for any startup when you have an absence of resources and…
Q: 2-The correlation between rate and base are called the dynamic forecast. Select one: O True O False
A: Correlation is described as the relationship that exists between two different variables…
Q: The demand for Krispee Crunchies, a favorite breakfast cereal of people born in the 1940s, is…
A: Trend forecast is a quantitative data forecasting method where we use past data for finding out…
Q: National Standard, Inc. sells radio frequency identification (RFID) tags. Monthly demand for a…
A: Note: - Since we only answer up to 3 sub-parts, we’ll answer the first3. Please resubmit the…
Q: b. Given the forecast demand and actual demand for a fishing boat, compute the tracking signal and…
A:
Q: Here are the errors associated with a particular forecast over the past five months, in…
A: Forecasting is a methodology that uses past information as input to make well-informed predictions…
Q: The manager of a large manufacturer of industrial pumps must choose between two alternative…
A: Both techniques have been used to prepare forecasts for a six month period as follows:
Q: Forecasting plays an important role in the operations of modern management. In fact, operational…
A: Answer: Reference: Wikipedia, Operations Management book, Pearson Publication, 12e Kimberly-Clark…
Q: Qualitative forecasts and causal forecasts are not particularly useful as inputs to inventory and…
A: Qualitative forecasts and casual forecasts are not specifically helpful as inputs to the inventory…
Q: mon forecasting techniques.
A: It is possible to describe forecasting as a method of making predictions about the future based on…
Q: Explain the steps consists of Collaborative planning, forecasting, and replenishment (CPFR)?
A: collaborative planning, forecasting, and replenishment (CPFR) technique - It is a technique which…
Q: Plot these forecasts AND the original demand data on graph paper or spreadsheet. Use a key to…
A: Find the given details below: Given details: Period Original Demand 3 Months Moving average 5…
Q: Consider the following forecasting model: x^t,t+1=axt+(1-a)x^t-1,t If a decreases from 0.5 to 0.2,…
A: The given question is about exponential smoothing.
Q: sing data in columns A-C create a forecast using the Simple Moving Average method based on 10 weeks…
A: Forecasting means predicting in advance the values of future sales/demand by using different methods…
Q: Forecasts are generally wrong.a. Why are forecasts generally wrong?b. Explain the term “wrong” as it…
A: Forecasting generally means predicting or estimating something for future events. It is also about…
Q: Forecasting is critical in modern times. Business organizations manifested more concern with…
A: It is at the national, industry, and firm levels that business forecasting takes place. Forecasts…
Q: Write from your understanding the meaning of forecasting, forecasting time horizons, Seven Steps in…
A: Forecasting is a procedure that utilizations verifiable information as contributions to make…
Q: . What is the mean square error for time periods 2 through 4 using the average forecasting method?…
A: I am using the 2 periods simple moving average method to find average forecasts. It is the average…
Q: Using the latest observation in a sequence of data to forecast the next period is a. a naive…
A: Find the answer below: The Correct answer is a) a naïve forecast
Q: Use a three-period moving average method to determine forecast value for time 5 to 7. Use an…
A: THE ANSWER IS AS BELOW:
Q: In the text, the example of Walmart's collaboration with Sara Lee during hurricane season enables…
A: Demand forecasting is the method involved with utilizing prescient investigation of verifiable…
Q: The manager of a travel agency asked you to come up with a forecasting technique that will best fit…
A: Given - Smoothing constant (α) = 0.25 Period Demand F1 F2 1 115 - - 2 176 - - 3 97 146…
Q: Give a proper explanation of what is meant by the adaptive forecasting
A: To be determined: a proper explanation of what is meant by the adaptive forecasting
Q: A company which installs swimming pools has recently merged with another regional installer. It is…
A: Forecasting in advance helps to estimate the sales that could be generated in the future period.…
Step by step
Solved in 2 steps
- Under what conditions might a firm use multiple forecasting methods?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. 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 does the Institute of Supply Management code of ethics say about financial conflicts of interest?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 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. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
- 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 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?1 demand of cotton(intones) by Westham textile S.C are shown below 1 2 3. 4 6 7 8 year Actual 10 11 13 15 14 16 18 20 demand a) What is the nave forecast value of cotton for year 9? b) Compare a 5 year moving average to forecast demand for year 9? c) Using a weight of 50% for the most recent data, 30% of the next, and 20% of the oldest, forecast 3 years moving average demand of cotton in year 9? d) Forecast the demand of cotton for year 9 using exponential smoothing(a=0.2), if the actual demand in year 8 is 22. 00