Kansas City Castings (KCC) is attempting to obtain the maximum loan possible using accounts receivable as collateral. The firm extends net-30-day credit. The amounts that are owed KCC by its 12 credit customers, the average age of each account, and the customer's average payment period are as shown in the following table:
a. If the bank will accept all accounts that can be collected in 45 days or less as long as the customer has a history of paying within 45 days, which accounts will be acceptable? What is the total dollar amount of accounts receivable collateral?
b. In addition to the conditions in part a, the bank recognizes that 5% of credit sales will be lost to returns and allowances. Also, the bank will lend only 80% of the acceptable collateral (after adjusting for returns and allowances). What level of funds would be made available through this lendingsource?