Question
Complete in Excel using Excel Solver with Screenshots. Please show formulas. Having trouble with getting this problem to work in Excel. Collecting Credit Card Debt:
Complete in Excel using Excel Solver with Screenshots. Please show formulas. Having trouble with getting this problem to work in Excel.
Collecting Credit Card Debt: A bank offers a credit card that can be used in various locations. The bank's analysts believe that the percentage P of accounts receivable collected by t months after credit is issued increases at a decreasing rate. Historical data suggest the following function:
P(t)=0.9[1-exp(-0.6t)]
The average credit issued in any 1 month is $125 million, and historical experience suggests that for new credit issued in any month, collection efforts cost $1 million/month.
- (a) Determine the number of months that collection efforts should be continued if the objective is to maximize the net collections (dollars collected minus collection costs). Allow for fractional months.
- (b) Under the optimal policy in (a), what percentage of accounts receivable should be collected?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started