National Imports, Inc. is a medium-size national auto repair shop for company of
ID: 2734275 • Letter: N
Question
National Imports, Inc. is a medium-size national auto repair shop for company of fleet cars with its corporate headquarters located in Orlando, Florida. The company operates in five states in the Northeastern United States. As the chief cash manager for the company; one of your responsibilities is to effectively manage the firm’s cash collection system. Your firm receives an average of 2,000 remittances per month with a total face value of $10,000. Under your current collection system, your customers remit their invoice payments directly to the corporate headquarters in Orlando. Therefore, the typical mail delay is 4 days and remittances remain at corporate headquarters for 3 days. As chief the cash manager, you have been informed that the average deposit receives good funds in 3 days. Assume that there is 365 days in a year. Complete parts a. through c. below and show all calculation.
A. Calculate the monthly total cost for your company's cash collection system if your firm's opportunity cost is 5% and your bank charges $0.25 per item deposited plus a monthly fixed cost of $300. For purposes of performing this calculation, refer to the Cost Analysis calculation process on page 327 in your text.
B.The bank is interested in selling you on their lockbox service, reducing your mail float days by 4 days, processing float days by 1 day, and availability float by 1 day. If the bank raises its bank charge per item to $0.40 and the monthly fixed cost from $300 to $400. All other items remain the same, including the opportunity cost of 5%.
C. Based upon your calculations and analysis, should you change to the lockbox service? Why or why not?
Explanation / Answer
A) The monthly total cost for your company's cash collection system:-
= Total Variable costs + Fixed costs
= Number of remittances * [(Face value * total float days * opportunity cost) + Bank charges] + Fixed costs
= 2000 * [ 10000 * 10(NOTE 1) * 0.05 / 365 + 0.25 ] + 300
= 2000 * [ 10000 * 10 * 0.0001369863 + 0.25 ] + 300
= 2000 * [13.69863 + 0.25 ] + 300
= 2000 * 13.94863 + 300
= $ 28197.26 (approx)
(NOTE 1):- Total Float Days = 4 + 3 + 3 = 10 Days
B) The monthly total cost for your company's cash collection system if you opt fot lock box service:
= Total Variable costs + Total Fixed costs
= Number of remittances * [(Face value * total float days * opportunity cost) + Bank charges] + Fixed costs
= 2000 * [ 10000 * 4(NOTE 2) * 0.05 / 365 + 0.40 ] + 400
= 2000 * [ 10000 * 4 * 0.0001369863 + 0.40 ] + 400
= 2000 * [5.479452 + 0.40 ] + 400
= 2000 * 5.879452 + 400
= $ 12158.90 (approx)
(NOTE 2):- Total Float Days = [10 - (4 + 1 +1) ] = 4 Days.
C) Yes, I will opt for the Lockbox service as the total cost for optiong lockbox service ($ 12158.90) is less than that the total cost computed in part A ($ 28197.26).
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.