Question: Given the information provided below for the Edwin Company, use the Total Supply Chain Cost Excel template to find the costs associated with the supply
Given the information provided below for the Edwin Company, use the Total Supply Chain Cost Excel template to find the costs associated with the supply chain. The order size is Q = 1,000 units and the supply chain operates 250 days a year. Do not round intermediate calculations. Round your answer to the nearest dollar.
| Annual Demand (D) | Price per Unit (P) | Oversight Cost per Unit (O) | Transport Cost per Unit (Ct) | Order Cost (Co) | Cost to Store One Unit One Year (Ch) | Order Lead Time in Days (L) |
| 225,000 | $7.21 | $2.86 | $5.90 | $435 | $14.60 | 37 |
| Total procurement cost: | $ |
| Total management oversight cost: | $ |
| Total annual transportation cost: | $ |
| Annual order cost: | $ |
| Annual holding cost: | $ |
| Average annual pipeline invenory cost: | $ |
| Total supply chain costs: | $ |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
