Refer again to Collegiate’s cash receipts budget in schedule 7. Apply the financial planning concept to perform Decision sensitivity analysis on the implications of different estimates of the rate of uncollectible accounts expense. MEN Clg

a. Prepare a table with a row for each of the following estimates of the rate of uncollectible accounts: 1, 2, 3, and 4 percent. Also include a row for the budgeted sales revenue. Your table should have five columns, one for each quarter and one for the entire year. The entries in the table will be the budgeted uncollectible accounts expense. (If you have access to spreadsheet software, prepare the table as a spreadsheet.)

b. How could this financial planning model help Collegiate Apparel to manage its uncollectible accounts expense?