Preview

Quick Stab Collection Agency: a Regression Analysis

Powerful Essays
Open Document
Open Document
1082 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Quick Stab Collection Agency: a Regression Analysis
Quick Stab Collection Agency: A Regression Analysis
Gerald P. Ifurung
04/11/2011
Keller School of Management

Executive Summary Every portfolio has a set of delinquent customers who do not make their payments on time.
The financial institution has to undertake collection activities on these customers to recover the amounts due. A lot of collection resources are wasted on customers who are difficult or impossible to recover. Predictive analytics can help optimize the allocation of collection resources by identifying the most effective collection agencies, contact strategies, legal actions and other strategies to each customer, thus significantly increasing recovery at the same time reducing collection costs. A random sample of accounts closed out during the month of January through June will be used in determining if the size of the bill has an effect on the number of days the bill is late. The statistical analysis of the data involves the application of regression analysis. Based on the calculated value of correlation coefficient, there is no relationship between the size of the bill and the number of days to collect. .

Introduction The author was hired by the Quick Stab Collection Agency (QSCA) on a contractual basis to assist the company in auditing potential business in buying the rights to collect debts from its original owners. QSCA is a collection agency that specializes in very profitable small accounts and avoids risky collections. Profitability at QSCA depends critically on the number of days to collect the payment and the amount of bill, as well as on the discount rate offered. A random sample of accounts closed out during the month of January through June will be used in determining if the size of the bill has an effect on the number of days the bill is late. The statistical analysis of the data will involve the application of regression analysis. The analysis will determine if the size of the bill



References: Weaver, B. (2004) Online Source. http://www.angelfire.com/wv/bwhomedir/notes/linreg.pdf

You May Also Find These Documents Helpful

  • Good Essays

    Haefren-Baum Case

    • 1082 Words
    • 5 Pages

    A major issue that Haefren needs to address is the delinquency of their customers accounts. From 1993 to 1995, days sales outstanding have increased to 77 days, which is dramatically higher than the 30-day monthly installment terms. This delay in collection is…

    • 1082 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    determines if the invoices are “pay now” or “pay later”. The “pay later” invoices are queued for fifteen days…

    • 2472 Words
    • 23 Pages
    Powerful Essays
  • Powerful Essays

    Monforte Dairy Case Summary

    • 4077 Words
    • 17 Pages

    debt. It is becoming increasingly difficult to pay her debt due to the fact that her receivables are collected…

    • 4077 Words
    • 17 Pages
    Powerful Essays
  • Powerful Essays

    Math533

    • 558 Words
    • 3 Pages

    Credit Balance was the next variable to be listed and analyzed. This is a quantitative…

    • 558 Words
    • 3 Pages
    Powerful Essays
  • Better Essays

    When it comes to preparing journal entries, there are different methods that are used with accounts receivable and bad debts such as the percentage of sales and the percentage of receivable methods. The percentage of sales estimates what percentage of credit sales will be uncollectible. This percentage is based on past experience and projected credit policy. The company applies this percentage to either the credit sales or the net credit sales of that current year. The percentage of receivables estimates what percentage of receivables will result in losses from the uncollectible accounts. The company uses an aging schedule in which classifies customer balances by the length of time they have been unpaid. After the company arranges the accounts by age, it determines the expected bad debt losses. The longer a receivable is past due, the less likely that it will be collected.…

    • 1283 Words
    • 6 Pages
    Better Essays
  • Satisfactory Essays

    M1 Unit 5

    • 441 Words
    • 2 Pages

    When a customer purchases a product without paying, it will lead the customer to a debt as he/she owes the company money. Very often it takes a long time for the customer to pay the company back. Its income is reduced, while its expenditure increases.…

    • 441 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Gm533 Aj Davis Part a

    • 654 Words
    • 3 Pages

    The 3rd individual variable considered is Credit Balance. It is a quantitative variable. The methods of central tendency, variation and other descriptive statistics have been analyzed for this variable…

    • 654 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Healthcare Finance

    • 292 Words
    • 2 Pages

    Less days of collection period is cost-effective for a company as less funds are tied up.…

    • 292 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Task3 Sec2

    • 293 Words
    • 2 Pages

    For example, a business may be experiencing cash flow problems. The business owner believes that his customers are taking too long to settle their accounts. By calculating their debtors days and recording the results, it will be possible not only to establish what the current position is, but also to set targets for the future. This may be to reduce the debtor days from thirty five to twenty five days. A reduction in debtor days will help ease cash flow and reduce the risk of bad debts.…

    • 293 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Math 533 Part C

    • 1123 Words
    • 5 Pages

    This scatter plot graph is a representation of combining income and credit balance. It shows the income increasing as the credit balance increases. As a result of this data it can be inferred that there is a positive relationship between the two variables. Because of the positive relationship between income and credit balance the best fit line or linear regression line fits the data quite well. The speculation can be strongly made that the customer with the largest income will, more than likely, have the largest credit balance.…

    • 1123 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Read each transaction and record the appropriate journal entry for Morrison Consultants, which has a June 30 year end. Explanations are NOT required. 1. On June 30 2011, Morrison prepares an aging schedule of accounts receivable that shows estimated uncollectible accounts of $5,200. Before journal entries, the Allowance for Doubtful accounts has a debit balance of $300 and Accounts Receivable has a balance of $85,000. 2. On July 5, Morrison was notified that Sperry Ltd has declared bankruptcy and Morrison writes off its A/R of $800. 3. On September 12, Sperry notifies Morrison that it can pay its $800 debt and includes a cheque for the entire amount. Date Account Debit Credit…

    • 1412 Words
    • 6 Pages
    Satisfactory Essays
  • Powerful Essays

    Fa Trial

    • 27881 Words
    • 112 Pages

    | Failure to record amounts earned for services provided to customers but not yet paid results in which of the followingAnswer…

    • 27881 Words
    • 112 Pages
    Powerful Essays
  • Satisfactory Essays

    Percentage of sales: It is based on prior experience of the business. It is computed as a percentage of credit sales. It ignores the current balance of the allowance account.…

    • 435 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Blozis

    • 2730 Words
    • 11 Pages

    It’s my job to solve this problem. The late payments are being caused by a lack of process and controls in place, both when orders are placed, and when goods are received. In some cases, people are performing tasks of others in order to satisfy the needs of their internals customer, but neglecting their own tasks which are equally important.…

    • 2730 Words
    • 11 Pages
    Powerful Essays
  • Powerful Essays

    Challenges: [Describe the key challenges the Department faces in serving these customers, e.g., long processing times; high call volume; low awareness of service; high error rates in providing service]…

    • 1252 Words
    • 6 Pages
    Powerful Essays