A company has five remittances for the typical month as listed below. Assume the typical month has 30 days. The day of mail, processing, and availability float for each remittance are also shown. Under the firm's current system, remittances of $1 million or more receive expedited processing, while all other remittances receive standard processing.
Remittance Mail Float Processing Float Availability Float
$ 500,000 5 1 2
$ 100,000 2 2 1
$ 50,000 5 1 2
$1,000,000 3 0.5 0
$ 25,000 1 2 2
a. Calculate the total dollar-day float for the month.
b. Calculate the average dollar-day float.
c. Calculate the average collection float in days.
b. If the annual opportunity rate is 5%, calculate the annual cost of float.
The solution calculate total and average dollar day float; average collection float, annual cost in excel sheet.