Cost Management 6th Edition by Edward Blocher,David Stout ,Paul Juras,Gary Cokins

Exercise 47

Accounts Receivable Collections and Sensitivity Analysis Papst Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable:

The firm writes off all uncollectible accounts at the end of the second month after the month of sale.
Required Create an Excel spreadsheet and determine for Papst Company for the month of May:
1. The estimated cash receipts from accounts receivable collections.
2. The gross amount of accounts receivable at the end of the month.
3. The net amount of accounts receivable at the end of the month.
4. Recalculate requirements (1) and (2) under the assumption that estimated collections in the month of sale 5 60% and in the first month following the month of sale = 25%.
5. What are the benefits and likely costs of moving to the situation described above in (4)