Question: I will rate you, thanks spreadsheet Given the information provided below for the Edwin Company, use the Total Supply Chain Cost Excel template to find

I will rate you, thanks spreadsheet Given theI will rate you, thanks

spreadsheet 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 = 3,600 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) 842,400 Price per Unit (P) $13.61 Oversight Cost per Unit (0) $2.65 Transport Cost Order Cost Cost to Store One per Unit (Ct) (Co) Unit One Year (Ch) $8.00 $220 $12.90 Order Lead Time in Days (L) 34 $ 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!