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

A-F please show excel equations  A-F please show excel equations Packard Electric Co., a wire harness

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

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 Accounting Questions!