In an effort to cut costs and improve profits, many U.S. companies have been turning to outsourcing. In fact, according to Purchasing magazine, 54% of companies surveyed outsourced some part of their manufacturing process in the past two to three years. Suppose 560 of these companies are contacted. Appendix A Statistical Tables a. What is the probability that 336 or more companies outsourced some part of their manufacturing process in the past two to three years? b. What is the probability that 287 or more companies outsourced some part of their manufacturing process in the past two to three years? c. What is the probability that 51% or less of these companies outsourced some part of their manufacturing process in the past two to three years?
Q: Given the Actual Demand from January to June of 2021, along with the forecasts based on three (3)…
A: Find the Given details below: Given details: Jan Feb Mar Apr May Jun Actual 960 1230 1520…
Q: Given an actual demand of 103, a previous forecast value of 99, and an alpha of .4, the exponential…
A: Forecast using the exponential smoothing method: Demand for current period = 103 Forecast for…
Q: Given the following demand data, Period Demand 57 1 2 55 3 59 4 56 5 60 a. Compute a weighted…
A: Forecasting is the process of estimation in which future demand is determined using the previous and…
Q: Given current demand in this period of 103, a forecast for this current period of 99, and an alpha…
A: Exponential smoothing is a forecasting model which helps to identify the forecasting value based on…
Q: he 2-month SMA forecast for Month 6 would be: * 565 haircuts 574 haircuts 578 haircuts 584…
A: THE ANSWER IS AS BELOW:
Q: Problem 4 - do both a three period moving average and an exponential smoothing forecast with an…
A: Forecasting is the process of predicting the future demand based on the previous data and demand.
Q: Identify and post the secanrio and rationale of the cultural scenario that is seen as the most…
A: The given case is based on the cultural scenario Cultural scenario - there are a variety of…
Q: Week 1 2 3 4 5 6 7 8 9 10 Demand 20 21 27 37 26 29 36 20 25 28 The forecast for weeks 2 through 10…
A: Forecasting is the procedure of doing estimations of upcoming activities on the basis of past and…
Q: Zeus Computer Chips Inc. used to have major contracts to produce the Centrino-type chips. The market…
A:
Q: This a 4 part question that am confused about. Please show the work by hand not excel. 4-1 Sales of…
A: Note: I have answered for 4-1 only. Kindly post the other question separately. Hence, the sales in…
Q: Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips. The…
A: Two years ago Units Last Year Unit This Year Units I 4805 I 3505 I 3195 II 3505 II 2705 II…
Q: Over past 4 weeks, KAMM (Kuwait Arab Malls Monitor) reported a severe decline in French products…
A: Here, we could see that declination in the french products consumption, we would apply trend…
Q: 1 demand of cotton(intones) by Westham textile S.C are shown below 1 2 3 4 7 8 year Actual 10 11 13…
A: Note: Since you have posted multiple parts in the same questions, we will be answering the first…
Q: a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.55 and a week 1…
A: Exponential smoothing formula : Ft = At-1*α + (1- α)*Ft-1 Error = Actual value - Forecasted value…
Q: Given the following demand data, Period Demand 1 44 2 42 3 44 4 42 5 47 a. Compute a weighted…
A: Given data is
Q: When a new busines is startered, or a patent idea needs fundig, venture capitalst or investment…
A: Whenever a new business is initiated, funding forms the pre-requisite and approaching to the venture…
Q: What forecasting approaches do you know? How is this being applied in your work? Or from your past…
A: Forecasting is an important tool that helps managers in effective and efficient planning. However,…
Q: Do you think that hard rock cafe makes use of time horizons when forecasting explain with 3 points.
A: The three types of forecasting time horizons are, 1. Long range forecasting: A long range…
Q: For the last 2 years, the Homes-r-US company has experienced a fixed cost of $850,000 per year and…
A: Given that: Current FC $8,50,000 Current(r-v) 1.25 Used FC= Fixed cost
Q: 5. (a) When a new business is started, or a patent idea needs funding, venture capitalists or…
A: The process used to predict future data and analysis of the trend is known as forecasting. With the…
Q: Calculate the mean square error, mean absolute deviation and the Period Year Call Volume forecast…
A: Find the given details below: Given Details: Period Year Call Volume forecast Error 1 1 30 45…
Q: why forecasting is needed in business a. to ascertain resource requirements b. to project profit…
A: Forecasting is a form of making knowledgeable predictions by utilizing historical data as the major…
Q: Omar has heard from some of his customers that they will probably cut back on order sizes in the…
A: The business move should be done in a realistic scenario and after considering varied impacts.
Q: How can the Forecast technique be improved?
A: Forecasting is a tool or technique which is used to predict future demand, risk and to analyze the…
Q: Rosa's Italian restaurant wants to develop forecasts of daily demand for the next week. The…
A:
Q: A resort cum restaurant spot in the area of Gazipur is open on the days of the week. The manager…
A: Given,
Q: 1. How does long term capacity strategy affect the stability of business organization, give an…
A: Capacity strategy is an approach to increasing and decreasing business capacity to fulfill needs.…
Q: Assume that the actual sales volume were 1,800; 2,000; 1,700; 1,600; 1,900; and 2,100 for Days 1 to…
A:
Q: What sorts of risks do you see in reliance on the Internet in the use of Collaborative Planning,…
A: Collaborative Planning, Forecasting, and Replenishment is a methodology that expects to upgrade…
Q: Exotic Wines, Inc. wants to use exponential smoothing with α = 0.35 to forecast demand in bottles…
A: The detailed solution of the question is given in Step 2.
Q: Using exponential smoothing with a weight ex of 0.6 on actual values: (a) if sales are $45,000 and…
A: Therefore, the forecast in 2012 is $48,000.
Q: The least squares regression method question - rounds your answer to two decimal points.please find…
A: Using least squares method regression method means we need to fit a line where number of accidents…
Q: 4. A major bank is considering installing ATMs at all locations of a grocery store chain. What…
A: Inventory management is a tool used to sourcing and distributing both raw materials and finished…
Q: Of the following, which is a major drawback to using production contracts as part of a vertically…
A: Vertical integration is an approach whereby an organization owns or controls its suppliers,…
Q: hundred bolts. Workers can be assigned to other jobs if production is less than regular. The…
A: given,
Q: Prepare a Demand Forecast for “Year 5” using Excel.
A: The provided quarterly data for year 5 can be predicted in excel as follows: 1- In a worksheet, the…
Q: Explain how might an executive comments to wall street analyst affect demand forecast, and what are…
A: Wallstreet is a neighborhood in New York City that is home to investment banks and The us investment…
Q: a. Using linear regression analysis, what would you estimate demand to be for each month next year?…
A: THE ANSWER IS AS BELOW:
Q: State the Common features that describe principles of forecasting. The lost Paradise of Dilmun Park…
A: (1) Principles of forecasting states that any forecasting technique that is being used must be such…
Q: The manager of XYZ carpet cleaning company needs a weekly forecast of the number of customers…
A: Find the Given details below: Given Details: Demand Year 1 Year 2 Year 3 Week 1 102 114…
Q: a) Calculate the 3-month Moving Average Forecast for sales from April/2019 to Januar enter them in…
A: Below is the solution:-
Q: Use regression or simple exponential smoothing with the following data. For exponential smoothing,…
A: Below is the solution-
Q: Situation 1 You want to start an online clothing store and need information about the size of the…
A: Case: I want to start an online clothing store, and need information regarding size of the market…
Q: Enrollment in a particular class for the last four semesters has been 122, 128, 100, and 155 (listed…
A: Below is the solution-
Q: Forecast based on averages. Given the following data: Period Number of Complaints 1 70 2 75 3…
A: Forecast for Period 6 using weighted average = 0.5*Demand of Period 5 + 0.3*Demand of Period 4 +…
Q: 1 demand of cotton(intones) by Westham textile S.C are shown below year 1 2 3 4 6 7 8 Actual demand…
A: Given information, Year Actual Demand 1 10 2 11 3 13 4 15 5 14 6 16 7 18 8 20
Q: The following table shows a tool and die company's quarterly sales for the current year. What sales…
A: Quarter 1 Sales = 84.6 SR1=0.94 Deseasonalized = 84.60.94 = 90
Q: KTOC/ Kuwait-Tunis Oil Co. started 4 months ago. KTOC noticed that its production increased…
A: Month Production Weights 1 5 0.2 2 7 0.3 3 20 0.1 4 90 0.4 Forecast production for the…
Q: The number of internal disk drives (in millions) made at a plant in Taiwan during the past 5 years…
A: Regression is a statistical technique used in finance, investing, and other fields to identify the…
Q: 5-17 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply…
A: Forecasting is the process of determining the estimated forecast for the future using the previous…
In an effort to cut costs and improve profits, many U.S. companies have been turning to outsourcing. In fact, according to Purchasing magazine, 54% of companies surveyed outsourced some part of their manufacturing process in the past two to three years. Suppose 560 of these companies are contacted.
a. What is the probability that 336 or more companies outsourced some part of their manufacturing process in the past two to three years?
b. What is the probability that 287 or more companies outsourced some part of their manufacturing process in the past two to three years?
c. What is the probability that 51% or less of these companies outsourced some part of their manufacturing process in the past two to three years?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- 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?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?
- 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. 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. 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. Are there any other issues besides cost that Sheila should evaluate?Use the following sales data to answer the questions. Month Sales January $250,000 February $200,000 March $300,000 April $350,000 May $450,000 1. Using a two-month moving average, what are the expected sales for June? 2. Using a three-month moving average, what are the expected sales for June?
- Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an average price of $0.5 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR QUANTITY (UNITS) QUARTER THIS YEAR QUANTITY (UNITS) 1 12 1 16 2 18 2 24 3 26 3 28 4 16 4 18 Find a line using regression in Excel. Note: Round your answers to 3 decimal places. Find the trend and seasonal indexes. Note: Round your answers to 3 decimal places. Forecast sales for next year. Note: Round your answers to 2 decimal places.Consider the following financial data from the past year for Midwest Outdoor Equipment Corporation. Annual sales $24,324,000 Net income 2,975,000 Cost of goods sold 12,600,000 Total assets 10,550,000 Inventory 2,875,000 Receivables 3,445,000 The Midwest Outdoor Equipment Corporation has entered into a new contract with a major supplier of raw materials used in the manufacturing process. Under the new arrangement, called vendor managed inventory, the supplier manages its raw material inventory inside the manufacturer’s plant and bills only the manufacturer when the manufacturer consumes the raw material. This is expected to reduce total assets by $2 million. What is the expected change in return on assets? Note: Round your answer to 2 decimal places.During the economic downturn arising from the COVID -19 pandemic in South Africa the government created the Covid-19 Loan Guarantee Scheme which provided loans, substantially guaranteed by government, to eligible businesses to assist them Funds borrowed from this scheme, through the banking industry, can be used for operational expenses, such as salaries, rent and lease agreements and contracts with suppliers. The scheme however has not been as great a success as had been envisaged. a) Describe how the scheme works; b) Analyse the reasons why the uptake has been so poor; c) Identify the losses which are being guaranteed by government; and d) Propose changes which could be introduced to improve the scheme.