As the management accountant for the Tyson Company you have been asked to construct a financial planning model for collection of accounts receivable and then to perform a what-if anaysis in terms of the assumption regarding estimated uncollectible accounts. You are provided with the following information: Collection Pattern for Crear Sales 65% of the company's credit sales are collected in the month or sale, 30% in the month following the month of sale, and 5% are uncollectible. Credit Sales January 2019,$100,000, February 2019, $120,000; March 2019, $110,000. Required 1. Prepare an estimate of bad debts for each of the three months, January through March, under the following assumptions regarding the rate of uncollectible accounts: 1%, 3%, 5% (base case), and 8%. Estimated Bad Debts Assumed Rate of B/D January February March Expense 1% 3% 5% 8%