Ann’s department at a local department store has tracked the sales of a product over the last ten weeks. Forecast demand using exponential smoothing with an alpha of 0.5, and an initial forecast of 30.0 for period 1. Table 2 Period Demand 1 24 2 23 3 26 4 36 5 26 2. Jason Ltd. operates a store in the Byera area and sells a special brand of cologne to customers in the surrounding areas. The manager of the store has been tracking the sales of the cologne for the last ten years. Table 1 below gives information about the sale of this product. Table 1 Year Sales 2014 90 2015 110 2016 127 2017 165 2018 190 2019 220 2020 275 2021 390 2022 320 2023 350 (a) . Assuming a linear trend, use the tabular method to derive the values for:- the slope the intercept Formulate the linear equation for this problem. Plot the linear equation line on a graph. Develop a forecast for the store’s sales for the next year.
Q: 1. Explain three important user interface design principles.2.What are three fundamental parts of…
A: The three important user interface design principles are:1. Consistency: This principle implies that…
Q: What role does clear communication play in high-performance workplaces?
A: Clear communication is a critical component of high-performance workplaces. It ensures that all…
Q: how does effective leardership contribute to employee motivations ?
A: 1. **Clear Vision and Direction** - **Motivational Impact**: Employees are more motivated when they…
Q: Do not use ai
A: Monitoring AgentA tracking agent is a type of software program application that constantly observes…
Q: Increasing Training Hours tends to: A. increase the Needed Complement B. decrease the Needed…
A: In operations management, Training Hours refer to the amount of time dedicated to training employees…
Q: Look at either where you work currently, your homelife, or even your current journey through Post…
A: Risk can be defined as the probability of an event and its consequences. Risk management is the…
Q: Guilford Department store is a Barbadian Company that operates in Bridgetown, Barbados. The Company…
A:
Q: How do open communication and the opportunity for shared expression contribute to teambuilding and…
A: Open communication and shared expression are like the glue that holds a team together. As a tutor…
Q: 1. Determine the optimal shipment size q^∗ and the optimal cost per day for sourcing component 1from…
A: 1. Sourcing from Atlanta:Key Data:Unit Purchase Price (Atlanta): p = 50Truckload Cost (Atlanta): F =…
Q: Demand for cars is normally distributed with a mean of 2,700 and a standard deviation of 640. The…
A: To calculate predicted sales when demand is regularly distributed, we must understand the…
Q: What is the significance of Deming’s performance quality category of quality efforts in improving…
A: Deming's contribution to quality management, particularly through his performance quality category,…
Q: Hiring the Needed Complement will always eliminate A. Overtime B. worker layoffs C. a…
A: The term 'Needed Complement' in operations management refers to the number of employees required to…
Q: Plainville Hospital has three wings (A, B, and C). The newly hired nurses at the hospital are…
A:
Q: 1. Provide an example of government economic intervention designed to influence, regulate, or…
A: Let's examine the Common Agricultural Policy (CAP) of the European Union in more detail as an…
Q: Freshly painted tables are inspected for blemishes in samples of size 1. The results for inspecting…
A: Since we are dealing with the number of blemishes (a type of defect) on each table, the most…
Q: How a company in Saint Lucia can cater their business offering to both B2C and B2B Markets. Detailed…
A: With a focus on organic coconut goods, Tropical Treasures Ltd. is a Saint Lucian business that…
Q: Graph and Solve. Kindly show the probabilities and explain how to solve this question. The time…
A: Step 1: Step 2: Step 3:Graph:
Q: Don't use Ai. Answer in all options with explanation.
A: Step 1: Understanding Google Flu TrendsGoogle Flu Trends was an initiative launched by Google to…
Q: Exercise 7-1 (Algo) Accounts receivable subsidiary ledger; schedule of accounts receivable LO C1…
A: >> We'll start by posting these entries to both the General Ledger (GL) and the Accounts…
Q: Answer in step by step with explanation. Don't use Ai and chatgpt
A: To solve this problem, we need to apply the **learning curve** concept, which states that labor…
Q: Answer in step by step with explanation. Don't use Ai and chatgpt. Answer in all options.
A: Step 1: We need to get the average of each element. note: the delays are excludedGrasp and place bag…
Q: Can you answer this for me please, thanks!
A: Characteristic / System TypeTransaction Processing System (TPS)Management Information System…
Q: What are the basic components in any fire alarm system?
A: Step 1: A basic fire alarm system typically includes the following components:(1) Fire Alarm Control…
Q: A part is produced in lots of 1 comma 4001,400 units. It is assembled from 2 components worth $3030…
A: Step 1: Identify the lot size: 1,400 units. Step 2: Use the formula for average cycle inventory:•…
Q: Can you help me answer this question please How do multinational companies adapt their marketing…
A: Adaptation Strategies1. Cultural SensitivityMarket Research: MNCs invest heavily in understanding…
Q: Question 8 (Atlantic Video) Atlantic Video, a small video rental store in Philadelphia, is open 24…
A: Given Information:Arrival rate λ = 30 customers/hour = 0.5 customers/minuteMean interarrival time :…
Q: Question Viewer (B2 3 (DM) A Start 7 3 (F3) 5 E GM) G (05) Finish ☑ D. A 7 B 2 Start-9-9 F 3 D 3 5 G…
A: Further clarifications: (For letter b.) To determine the project duration along the critical path,…
Q: Do not use chatgpt.
A: To calculate the control limits for the R-chart and create the charts in Excel, follow these…
Q: A process sampled 20 times with a sample of size 9 resulted in a = 26.5 and R = 1.9. Compute the…
A: Here UCL is upper control limitsand LCL is lower control limits.
Q: A portion of the combined statement of income and retained earnings of Novak Inc. for the current…
A: Step 1: Calculate Net IncomeFrom the provided data:Income before extraordinary item: $15,040,000Loss…
Q: National Scan, Incorporated, sells radio frequency inventory tags. Monthly sales for a seven-month…
A: Step 1:4. Solution;Forecasting Using Exponential Smoothing The weights on older data points become…
Q: Do not use chatgpt.
A: Here's a detailed explanation for better understanding. a. Linear Programming (LP) Model Solution…
Q: Help please. I dont understand what I am entering wrong on the formula. Lael wants a quick way to…
A: The issue with the formula appears to be related to the reference you're using in VLOOKUP. In the…
Q: Need a five why for defficient layout in tocaco manufacturing
A: Here is a "Five Whys" analysis to identify the root causes of a deficient layout in tobacco…
Q: In its new initiatives to improve customer service Botswana Open University intends to adopt…
A: Conclusion:These four electronic payment methods—credit/debit card payments, mobile money, EFT, and…
Q: How would you go about preparing a written report as the newly appointed Chief Sustainability…
A: IntroductionPurpose of the ReportThe primary purpose of this report is to build a solid case for our…
Q: Scores on an employee performance evaluation are normally distributed with a mean of 75 and a…
A: Step 1: a) Consider a random variable is x, which defines the performance evaluation score of a…
Q: Answer in step by step with explanation. Answer in all options. Don't use Ai and chatgpt
A: I explained that marketing research is the process a business uses to collect, record, analyze, and…
Q: Answer in step by step with explanation. Don't use Ai and chatgpt
A: Step 1: Understanding Business Process Improvement (BPI)BPI is a systematic approach aimed at…
Q: Rank the appropriateness of introducing the bluethooth speaker product into the three markets from…
A: Germany stands out as the most suitable market for introducing high-end consumer electronics,…
Q: Who are all the key players in Industrial Relations, which key player has the most clout. State why
A: 1. **Employers/Management** - **Role**: Employers or management are responsible for hiring,…
Q: Explain with specific examples how Social Media and Big Data can help your organization (or an…
A: Social media and big data play a transformative role in helping organizations maintain a competitive…
Q: Examples of training initatives that foster leadership skill in a company
A: Leadership Development Programs are formal efforts that corporations establish to foster leadership…
Q: Scenario: You are an international trade consultant ranking the overall quality of various…
A: Key Economic and Political Data PointsMarket Size and Growth PotentialInsights: This data indicates…
Q: How do you give effective feedback on performance? (Both positive feedback and constructive…
A: Begin the feedback session by highlighting the positive aspects of the individual's performance.…
Q: The following table shows predicted product demand using your particular forecasting method along…
A: Approach to solving the question:Rational Detailed explanation:Period 1Deviation: −50RSFE: −50Sum of…
Q: List and describe the four primary functional components of a software application.
A: Detailed explanation:Any software application is primarily supported by four core components…
Q: Please original work Over coffee one morning Emma asks you what role you think the accounting…
A: The accounting department at CM Tech can play a pivotal role in performance management by providing…
Q: 3.3-2. Consider a problem with two decision variables, x₁ and x2, which represent the levels of…
A: To determine whether this problem satisfies the four assumptions of linear programming, let's…
Q: Designing Operations is the orchestration and optimization of people, processes, and craft in order…
A: In order to increase the company's impact and efficiency, BODi by Beachbody's Design Operations…
- Ann’s department at a local department store has tracked the sales of a product over the
last ten weeks.
an initial forecast of 30.0 for period 1.
Table 2
Period Demand
1 24
2 23
3 26
4 36
5 26
2. Jason Ltd. operates a store in the Byera area and sells a special brand of cologne to
customers in the surrounding areas. The manager of the store has been tracking the sales
of the cologne for the last ten years. Table 1 below gives information about the sale of
this product.
Table 1
Year Sales
2014 90
2015 110
2016 127
2017 165
2018 190
2019 220
2020 275
2021 390
2022 320
2023 350
(a) . Assuming a linear trend, use the tabular method to derive the values for:-
- the slope
- the intercept
- Formulate the linear equation for this problem.
- Plot the linear equation line on a graph.
- Develop a forecast for the store’s sales for the next year.
Step by step
Solved in 2 steps with 4 images
- Under what conditions might a firm use multiple forecasting methods?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?Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
- The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?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 Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
- 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?
