Preview

Statistical Analysis for Quick Stab Collection Agency

Powerful Essays
Open Document
Open Document
1796 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Statistical Analysis for Quick Stab Collection Agency
Statistical Analysis for Quick Stab Collection Agency

Executive Summary The purpose of the paper is to provide a statistical analysis of overdue bills for Quick Stab Collection Agency (QSCA). The data will be taken from accounts closed over a six month period. The goal is to determine if a correlation between the type of account, the amount of the bill and the days to collection exists. To determine the existence of a correlation, regression analysis of several variables was completed. This regression analysis also included predictions. Further study also included descriptive statistical analysis, together with graphs. This analysis will show that the correlation exists between the type of account and the days to collection. It will also show that the dollar amount the bill did not play a significant role in the days until collection.
Introduction
Quick Stab Collection Agency (QSCA) is a bill collection agency specializing in small less risky accounts. QSCA buys the rights to collect debts from the original owner of the debt at a significant discount. The right to collect a $50 debt may be purchased for as little as $10. This example would indicate a profit of $40 not accounting for costs of doing business. Based on this example QSCA will need to be selective when purchasing debt as there the potential for profit loss with non-payment. In order for QSCA to remain successful they must collect the greatest amount of payments in the shortest number of days. In an effort to accomplish this task, a review of 96 accounts which were closed out in the months of January through June was completed. This review provided the data set which will be used in this analysis. This statistical analysis will attempt to answer the following questions:
 What is the average dollar amount for each account type over the six month period?
 What is the average collection time for each bill type?
 Is there a correlation between the size of bill and the number of days

You May Also Find These Documents Helpful

  • Satisfactory Essays

    The biggest red flag was that the allowance for bad debt expense dropped from 7.7 percent to 2.5 percent after the accounts receivable increased. In order to prove this theory, it is necessary to collect data on the allowance of bad debt from previous years, including the percentage of debt that was uncollectable. A review of the significant accounting estimates from last year is also required. This will assess whether or not…

    • 463 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Many medical organizations with average patient accounts receivable that are greater than a specified amount, not including the allowance, must compute and record an Allowance for Doubtful Accounts on their balance sheet. This accounts receivable balance should be re-evaluated on an annual basis to determine reporting status. Often, it is not known which specific accounts receivable invoices will be uncollectible. An allowance is therefore established to estimate the value of those receivables believed to be uncollectible. This entry should be “recorded so the income statement and balance sheet are fairly stated at the amount expected to be collected in receivables, thus satisfying the matching principle. The entry creates a contra accounts receivable balance. When netted against the gross total of accounts receivable, the true value of the receivables is reported” (FMS,…

    • 780 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Acct 505 Course Project

    • 596 Words
    • 3 Pages

    The 3rd individual variable considered is CREDIT BALANCE which is also a quantitative variable. The measures of central tendency and variation have also been calculated as follows:…

    • 596 Words
    • 3 Pages
    Good 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
  • Powerful Essays

    Tno Inc Audit Case

    • 12792 Words
    • 52 Pages

    Inquiry with key persons as to how and when overdue balances are classified as bad debts.…

    • 12792 Words
    • 52 Pages
    Powerful 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

    1st Individual Homework

    • 609 Words
    • 10 Pages

    3. What is the average Total $ spent, the average Total # of purchases, and the average number of months since last purchase?…

    • 609 Words
    • 10 Pages
    Satisfactory Essays
  • Satisfactory Essays

    On September 1, the balance of the Accounts Receivable control account in the general ledger of Montgomery Company was $10,960. The customers’ subsidiary ledger contained account balances as follows: Hurley $1,440, Andino $2,640, Fowler $2,060 and Sogard $4,820. At the end of September, the various journals contained the following information. Sales journal: Sales to Sogard $800, to Hurley $1,260, to Giambi $1,330, and to Fowler $1,600.…

    • 302 Words
    • 6 Pages
    Satisfactory Essays
  • Good Essays

    The following report presents the detailed statistical analysis of the data collected from a sample of credit customers in the department chain store AJ DAVIS.…

    • 964 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    In this memorandum, I’ll discuss strengths and weaknesses of using FIFO versus LIFO as the cost flow assumption in the accountant’s process of inventory valuation for financial statement reporting to a company’s external stakeholders.…

    • 314 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Target Asset Utilization

    • 430 Words
    • 2 Pages

    Asset Utilization measures a company’s efficiency in managing its assets to generate sales. Receivable Turnover Ratio tells how quickly Target customers are paying. A high turnover ratio is generally a good thing since it means that customers are paying their bills. It also shows that the Target is very responsive in its credit and collection policies and extending credit to enough customers. Average collection period measures the timeframe of which Target customers are paying their debt. The lower this number is the better because it means payments are being made faster. Applying the effects of the economy, the fluctuation in the receivable turnover ratio over time can indicate that customers have less disposable income and are still inclined…

    • 430 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Software Configuration

    • 410 Words
    • 2 Pages

    Date Jun 1 Description Opening balance Withdrawals ($) 3.90 3.90 Closing balance Deposits ($) Balance ($) $5,096.80 5,092.90 5,096.80 $5,096.80…

    • 410 Words
    • 2 Pages
    Satisfactory Essays
  • Best Essays

    " Edmonton Journal: B.6.FRO. Banking Information Source; Canadian Newsstand Major Dailies. Dec 13 2004. Web. 15 Feb. 2012 .…

    • 4142 Words
    • 17 Pages
    Best Essays
  • Good Essays

    Jones Electrical Distribution is electrical supplying company. Since it was established in 2004, the sales have been growing steadily on a year to year basis from $1624000 in 2004 to $2224000 in 2006, and furthermore a projected $2.7 million in sales for the current financial year of 2007.In the same time profit has been inadequate for the quantity of sales. This data is backed by the very low Profit Margins experienced by the company, most recently only 1,3% (and only 0.8% for the first quarter of 2007).As of late, the company has faced a cash shortage and the results of that are becoming evident on its financial statements. Accounts payable have increased dramatically comparing 2006 and 2007. The same situation is with accounts receivables, showing that less of Jones’ clients are willing to pay cash for goods delivered. As a result the use of a discount thanks to fast payment to suppliers has become improbable. Further study of the increase in important components such as accounts receivables and inventory will be discussed in the 3rd section of this case analysis.…

    • 2408 Words
    • 10 Pages
    Good Essays
  • Powerful Essays

    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.…

    • 1082 Words
    • 5 Pages
    Powerful Essays