Case Study OverviewSourcing of a new sub-componentYour company, based near Wilmington, N.C., needs to source a new sub-component that will be a key element in a new product that is due to start production next year. Your boss contacted three producers of the sub-component and obtained the cost information below.Your boss has asked you to provide a detailed spreadsheet of the cost and provide a recommendation on which firm would be able to provide the sub-component at the best price. She needs to brief the CEO next week. Since your firm has worked with all three of the producers before, and all have a good record of providing sub-components, the decision will be solely based on the lowest cost.Additional Shipping Information10,000 units of the sub-component will fit into a 40-foot shipping container, so to keep the shipping cost down; all three firms will ship full containers each time an order is placed.Details on the Producer FirmsProducer AProducer A is located in Nashville, Tennessee, and can provide the sub-component for $3.25 each. The producer’s warehouse is 600 miles from your production facility, and truck transportation will cost $1.25 per mile. There is a container-handling fee of 1% of the total product cost that is assessed by the shipping company, as well as a required $200 insurance policy.Producer BProducer B is located in Europe and can provide the sub-component for $2.00 each. The producer’s warehouse is 100 KMs from the port and the truck transportation will be $1.50 per kilometers. The trucking cost from the United States port to your production facility is 35 miles and the transportation will cost $1.25/mile. From Europe to the United States, the sea shipping will run $2,000 with a handling fee of 1.25% of the total product cost. Since the sub-component must be imported into the United States, there is a 10% import duty assessed on the total cost of the product. Finally, there will be a fee of $850 for sea and surface transportation insurance.Producer CProducer C is located in Asia, the furthest away from your facility however; their cost per unit is the lowest at $1.50. The factory for Producer C is located 150 kilometers from the closest port and costs $0.20 per KM to move the container to the port. Sea shipping runs $2,500, with a handling cost of 1.25% of the total cost of the product. As with Producer B, once the container reaches the United States, it will be assessed import duties of 10%. Final transportation to your facility will run $43.75. Finally, there will be a fee of $900 for sea and surface transportation insurance.ConsiderationsAdditional information to ConsiderWhile both Producer B and C have a lower cost per unit, they have a higher shipping cost. Also, since both Producer B and C are so far away, and delivery time is uncertain, then your firm will want to hold $3,000 worth of safety stock. Finally, part of the reason that Producers B and C sub-components are cheaper is that some additional work will be needed on their components once they are received. Your production office has determined that it will cost $.50 each to finish off the sub-component for Production B and $1.10 each to finish the sub-component from Producer C.DeliverablesInclude the following in your submissionProvide a professional looking detailed spreadsheet with all of the costs outlined.Provide a professional looking (not APA formatted), one-page summary (double-spaced) of your findings that your boss can give to the CEO. In your initial task, you were told that the lowest cost would be the winner, but oftentimes the lowest price is not always the best solution. Therefore, in your memo, provide some information on sourcing that you would want your boss and the CEO to consider before making the final decision.