Please see the attached instructions. I believe it needs to be an Excel submission. Thank you!
5.3 Supplier Selection
Assignment: Case Study
Case Study Overview
Sourcing of a new sub-component
Your 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 Information
10,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.
Producer A
Producer 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 B
Producer 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 C
Producer 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.
Additional information to Consider
While 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.
Include the following in your submission
1. Provide a professional looking detailed spreadsheet with all of the costs outlined, including calculations for the total landed cost.
2. 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.
Submission
Save your spreadsheet and document using a naming convention that includes your first and last name and the activity number (or description). Do not add punctuation or special characters.
Your assignment will automatically be evaluated through Turnitin when you submit your assignment to this activity. Ensure your work is entirely your own and cite your sources! Refer to the
Academic Integrity
page.
Review the evaluation rubric for detailed grading criteria.
