Question

IM.75 TechYes is a growing business that sells a variety of high tech accessories that work with computers, cell phones, and other mobile devices. Their highest volume product is a 6-foot USB extension cable. Between online and in-store locations they sell on average 425 of these cables every quarter (i.e., every three months). They pay $30.39 for each box of cables which contains 40 individual cables for sale. Their ordering costs are $7.47. Holding costs are negligible but they do pay 7.37% annually on the money they borrow to make such purchases.

What is the annual demand for cables in terms of boxes of cables? (Display your answer to the nearest whole number.)- Answer is 43

What is the economic order quantity (EOQ) for individual cables? (Display your answer to the nearest whole number.) - Answer is 673

Based on the annual demand and this order quantity (computed for the previous question), how many times per year would they place an order? (Display your answer to two decimal places.) - I need this one please with a formula to excel.

Answer 1