Question: Please show your work in excel. (with the formulas) IM.75 Tech Yes is a growing business that sells a variety of high tech accessories that

Please show your work in excel. (with the formulas)
IM.75 Tech Yes 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 525 of these cables every quarter (i.e., every three months). They pay $23.55 for each box of cables which contains 16 individual cables for sale. Their ordering costs are $6.03. Holding costs are negligible but they do pay 9.83% 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.) Nmero What is the economic order quantity (EOQ) for individual cables? (Display your answer to the nearest whole number.) Nmero 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.) NmeroStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
