Question: A-F please show excel equations Packard Electric Co., a wire harness manufacturing plant in Warren, OH uses 124,460 plastic connectors annually. The supplier of this
Packard Electric Co., a wire harness manufacturing plant in Warren, OH uses 124,460 plastic connectors annually. The supplier of this part is nearby, such that immediately upon receiving an order, the supplier begins delivery at the rate of 1,200 connectors per day. Packard Electric operates 254 days per year. Packard Electric Co. has estimated that the ordering cost is $55 every time they place a new order, and the cost of carrying connectors in inventory before they are processed is $0.55 per connector on an annual basis. Determine the following: a) The optimal order size b) The maximum level of inventory held for this part c) The number of operating days required to receive a complete order. d) The number of operating days between orders e) The cost of holding inventory per year f) The total annual inventory cost associated with the optimal order quantity
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
