shipped and total shipping costs: Number of Units Shipped 75 Month January February March April May June July 60 40 20 70 80 50 Required: 3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. 4. Perform a least-squares regression analysis on Odessa's data. 5. sing the regression output, create a linear equation (y=a+bx) for estimating Odessa's shipping costs. Complete this question by entering your answers in the tabs below. Required 3 Required 4 Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. Fixed cost Variable cost per unit Total Shipping Cost $3,250 2,300 1,700 1,200 2,300 2,700 2,000 Required 5 Complete this question by entering your answers in the tabs below. Required 3 Required 4 Intercept X Variable Perform a least-squares regression analysis on Odessa's data. Note: Use Microsoft Excel or a statistical package to find the coefficients using to 2 decimal places. Required 5 Required 3 Required 4 Coefficients Complete this question by entering your answers in the tabs below. < Required 3 Required 5 Required 5 Using the regression output, create a linear equation (y = a + bx) for estimating Odessa's ship Note: Round your answers to 2 decimal places. Total shipping cost= Number of units shipped
Q: Wheat, corn and rice are to be planted on 10800 acres of farmland. Each acre can produce 35 bushels…
A: Let, W = Acres of land to produce wheat C = Acres of land to produce corn R = Acres of land to…
Q: Demand Medium $40 $45 Decision Manufacture component Purchase component a. Determine the best…
A: The expected value of perfect info.= expected value with perfect info.- expected value without…
Q: Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550…
A: Given data; Month Actual Jan 600 Feb 475 Mar 550 Apr 575 May 670 Jun 652 Jul -
Q: Mariah Enterprises make product A, which sells for $130 per unit, and product B, which sells for…
A: Multifactor productivity is output per unit of combined input unit. In Input include labor,…
Q: Is cooperation or information sharing more important for businesses involved in a supply chain?
A: Sharing information is a crucial strategy for business sustainability and enables supply chain…
Q: I need to get the maximum value instead of the minimum value. Can you please solve the liner…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: 8.6 Using exponential smoothing, calculate the forecasts for months 2, 3, 4, 5, and 6. The smoothing…
A: Smoothing constant = 0.2 F1 =Forecast for period 1 =245 The formula is, Ft+1 = α×yt + 1-αft ,…
Q: A retail catalog operation employs a bank of six telephone operators who process orders using…
A:
Q: 1. Machine Tool Production Planning. King City Inc. manufactures machine tools. The production…
A: Note: - As we can answer up to three subparts we will answer the first three subparts here. If an…
Q: (a) Use Excel Solver to solve the problem. (b) Reformulate this problem so all variables have…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Identify any additional information that is optionally available when performing a Linear…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: What is the break-even point for option A?
A: Breakeven point = fixed cost / (selling price - variable cost)
Q: Determine the best crop to plant, using the following decision criteria: a) Maximax b) Maximin c)…
A: NOTE: We are allowed to do the first three sub-parts only. Maximin:This is the most conservative…
Q: The following table lists the components needed to assemble an end item, lead times (in weeks), and…
A: FORMULA TO BE USED Gross requirement = Required Item Quantity * Usage Rate Net requirement…
Q: three benefits of using project management techniques in mobile app development.
A: The complexity of creating a mobile app stems from the fact that there are multiple phases involved…
Q: The current level of resources is or is not Sufficient to satisfy a demand of 8 orders per hour…
A: Process capacity is the bottleneck capacity of the operation. In simpler words, process capacity is…
Q: what are the strategies used by coca-cola in their supply chain processes?
A: For an enormously long period of time, Coca-Cola has competed on a global basis. The supply chain…
Q: Webster Chemical Company produces mastics and caulking for the construction industry. The product is…
A: A control chart is a statistical tool which helps to identify the process controllability using…
Q: Describe a normal probability distribution that can be used to approximate the demand distribution.…
A: Expected selling price = $24 Cost = $16 Salvage value = $5
Q: EZ-Windows, Inc., manufactures replacement windows for the home remodeling business. In January, the…
A: Objective function: Minimize Z = 1I1+1I2+1I3+0.65D1+0.65D2+0.65D3 Constraints: 1. February demand:…
Q: Company Ajax has the following information from its financial statements in 2021. The annual sales…
A: Cash to cash cycle time refers to the period between paying cash to the supplier or receiving cash…
Q: 8.11 The average demand for January has been 80, and the average annual demand has been 1800.…
A: Seasonal Index refer to the percentage of each season and mean of that value is Seasonal index. It…
Q: You are suppose to bid for building 50 units of a special-purpose robot. It is expected that the…
A: Find the given data below: Given details: Total Units 50 Building units First robot time 120…
Q: I think there is an error with a when multiplying 12 by 600
A: Given- Monthly Demand (d) = 50 bagsAnnual Demand (D) = 50×12 = 600 bagsFixed Ordering Cost (S) =…
Q: Which of the following consists of real-time collaborative technology capabilities that enable…
A: In order to achieve supply chain excellence, there are four enablers. These enablers are capable…
Q: any, its suppliers, and oth
A: Supply chain management, which controls the flow of goods and services, includes all procedures used…
Q: An employee arrives to work at 8:00 AM and is scheduled to conduct blood specimen testing. The…
A: Employees at certain organizations are paid the hourly wage rate. This method is much simple and…
Q: Describe any project of your choice then provide four (4) SOW activities applicable to the project…
A: A Request for proposal is a supply chain document that outlines a project, requests proposals for…
Q: Adidas is an athletic company designs and manufactures several athletic things. Football is one of…
A: Given data: Selling price = 40 Fixed cost = 150000 Variable cost = 15 Target profit = 30000
Q: project scheduling, the critical route approach is crucial, but what does it really do?
A: Critical path is the longest path on a project network diagram. In critical route approach, the…
Q: If the Edwards production plan for the next period includes 800 units of component 1 and 600 units…
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: what are the various other factors which can equally affect productivity apart from the…
A: Productivity is defined as the efficiency of work.
Q: ost your responses to the following discussion questions: 1. What advantages are gained by…
A: SKU- a stock keeping unit is a number that is assigned to the product by the retailers. It is used…
Q: Checkers Sixty60 is now South Africa’s Number One Grocery App On-demand grocery delivery service…
A: Operations management is a field where we get to familiarise ourselves with the organization's most…
Q: Sushow Inc. is a show company that makes an average of $400,000 from a good show and loses an…
A:
Q: This exercise contains only parts a and b. a) For the given data, the x = hours (round your response…
A: NOTE: We are allowed to do the first three sub-parts only. UCL(x-DOUBLE BAR) = X-DOUBLE BAR+A2*R-BAR…
Q: What is strategic change?
A: The movement of a business from its current condition toward a targeted future state in order to…
Q: a) Kathleen wants you to graph the eight points (x₁, y₁),i=1,2,..., 8. She has been concerned…
A: The graphical presentation is one of the most effective and common tools used in data analysis…
Q: Discuss the importance of the expected benefits and risks in a Project Proposal,
A: A project proposal is a document used to brief a company's board or management team on the plan's…
Q: Is decision tree based on a linear combination of parameters ?
A: Many popular machine learning algorithms are based on decision trees. In both classification and…
Q: Describe the various phases of project with its relative importance?
A: Project management is challenging regardless of the size or scope. There is a lot that may go wrong,…
Q: mid west university is installing a high speed intranet System. The following Netwerk shows a…
A: The shortest route problem helps to find the path that will have the minimum distance or cost or any…
Q: Cost Classification Discussion Question The table below shows monthly data collected on production…
A: Add the given data in excel as follows.
Q: What distinguishes the agile project management approach from the waterfall approach?
A: Both the Waterfall approach & the Agile approach are - identified by their project management…
Q: How can the most responsible financial choices be made using linear programming?
A: Linear programming is a problem solving approach developed in helping the management for making…
Q: Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550…
A: Weighted moving average forecasting -Ft= W1 × At-1 + W2 × At-2W1+W2Where-Ft = Forecast value of…
Q: Business transactions taking place within geographical boundaries of a nation is known as
A: Internal commerce is the buying and selling of commodities and services within the borders of a…
Q: up to $23,000. They can p bands yielding a municipal bonds yielding They want to invest at least as…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Max Z= 6x, + 8x₂ s.t. 2X₁ X₂ ≤ 50 3x₂ +4x₂ < 180 - X₁ +2x₂ ≤ 40 X₁, X₂ ≥ 0
A: As per Bartleby guidelines, we can only solve one question at a time...Kindly upload the other…
Q: Compute labor productivity under each system. Use carts per worker per hour as the measure of labor…
A: Productivity is the relationship between the volume of the input and output that is calculated in…
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images
- 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?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. 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?Lenovo uses the ZX-81 chip in some of its laptopcomputers. The prices for the chip during the past 12 monthswere as follows: a) Use a 2-month moving average on all the data and plot theaverages and the prices.b) Use a 3-month moving average and add the 3-month plot tothe graph created in part (a).c) Which is better (using the mean absolute deviation): the2-month average or the 3-month average?d) Compute the forecasts for each month using exponentialsmoothing, with an initial forecast for January of $1.80. Use a= .1, then a = .3, and finally a = .5. Using MAD, which ais the best?
- Sales of Volkswagens have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Year Sales 1 450 2 495 TIT 3 520 4 575 5 580 sales (round your response to one decimal place). a) Forecasted sales for year 6 using the trend projection (linear regression) method areQ3) You work for BMW as a planner. BMW sold 1,081,000 of its BMW-X5 cars in 2019 and sold 1,189,100 of its BMW-X5 cars in 2020. BMW is expecting to increase its annual sales for BMW- X5 in year 2021 by 10% compared to year 2020 (total sales volume = 1,308,010). Find the monthly forecast and seasonal indices for year 2021, given the following data: (Please considers the monthly seasonal effect) MONTH Actual Car Sales (2019) Actual Car Sales (2020) Forecasted Car Sales (2021) Jan 80,000 88,000 Feb 85,000 93,500 Mar 86,000 94,600 Apr 90,000 99,000 May 92,000 101,200 June 100,000 110,000 July 120,000 132,000 Aug 90,000 99,000 Sept 86,000 94,600 Oct 85,000 93,500 Nov 84,000 92,400 Dec 83,000 91,300Q2: An economist who estimated the Keynesian money demand function in logarithmic form using data from Sri Lankan economy, obtained the graph on the left by using predicted and actual money demand. While the model was very successful in predicting money demand until 2010 (small forecast errors), it predicts a consistently higher money demand than actually occurred since then (growing forecast errors each period). 48 Ln(M) 4.75 4.7 4.65 4.6 4.55 Actual 4.5 Predicted ...... 4.45 Help this economist who has trouble explaining this situation, even if you do not know anything about the economy in question. Can you answer this question with details please? 6toz Stor