Anne Teak, the financial manager of a furniture manufacturer, is considering operating a lock-box system. She forecasts that 500 payments a day will be made to lock boxes with an average payment size of $2,500. The bank's charge for operating the lock boxes is $0.30 a check. The interest rate is 0.011% per day. a. If the lock box makes the cash available 2 days earlier, calculate the net daily advantage of the system. (Do not round intermediate calculations.) Net daily advantage 191

1. Now change all of the dollar amounts in the data area of your worksheet so that it looks like this: 1 2 3 Data 4 Sales Variable costs: 5 67 00 8 A Chapter 1: Applying Excel 9 10 11 Cost of goods sold Variable selling Variable administrative Fixed costs: Fixed selling Fixed administrative $ $ $ $ $ $ B 32,000 16,000 1,600 1,400 2,500 1,500

n 0 1 2 3 4 5 6 7 8 9 10 A -$250 $60 $970 B -$200 $90 $90 $60 $60 Net Cashflow с -$70 $20 $10 $5 -$50 $60 $50 $40 $30 $20 $10 D -$300 $270 $250 -$129 -$20 $120 $40 E -$90 -$100 -$50 $0 $150 $150 $100 $100

What advantage does the fixed charge coverage ratio offer over simply using times interest earned?