Preview

Memo: Improving Ramsville Accounts Payable

Powerful Essays
Open Document
Open Document
2472 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Memo: Improving Ramsville Accounts Payable
Team Lean 1
Memorandum

Date: November 13th, 2013
From: Team Lean: Carina Tricaso, Diana Hauptman, Mannan Kohli, Matt Arthur, Thomas Young
To: Dr. Andrea Prud’homme
Subject: Improving Ramsville Accounts Payable
Key Issues
The key problem encountered by Ramsville is that 6.5% of the accounts payable (AP) are overdue, causing
Ramsville’s relationships with their suppliers to deteriorate. In a few cases, it is impacting further shipment of parts, potentially causing Ramsville’s manufacturing plant to miss shipping due dates and negatively impacting customers. Ramsville’s irregular distribution of workers and the inefficient accounts payable process has led to over-utilization in some processes and superfluous capacity in others and several non-value add segments of the process, which results in a lot of waste. These issues have led to defects such as late payments and sending payments to the wrong company, which have inevitably led to a conflict between Ramsville and their suppliers. Ramsville requires an improved accounts payable process that decreases the total lead-time while eradicating the errors that they have been making.
Analysis
The present process comprises ten steps and has five different takt times. It first receives 300,000 pieces of mail in the mailroom but 35,000 of those mails do not belong to AP, so have to be sorted out first. The remaining 265,000 invoices then go through a Purchase Order check and then move them to the Pay From
Receipt (PFR) Check. The first PFR check removes 200,000 of the PFR receipts. The remaining 65,000 receipts then go through an additional PFR checks from accounts payable analysts that further removes 1,250 receipts on average. After this final PFR check, 63,750 invoices are moved to the sorting process which determines if the invoices are “pay now” or “pay later”. The “pay later” invoices are queued for fifteen days before moving to the payment processing process where the

You May Also Find These Documents Helpful

  • Satisfactory Essays

    4. $9500 in services was preformed, with $4100 paid for in cash, and $5400 billed through Accounts Receivable…

    • 683 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    4.1 At Proactive Personnel we always use Royal Mail to send out our mail our packages. The options we use to send out our outgoing mail are 1st class, 2nd class and special delivery. The way we are able to tell what mail needs to go 1st, 2nd or special delivery is by our employees placing the mail in the specific trays to which they need, where as special delivery is known by ‘rec’ been wrote on the mail.…

    • 446 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Mat 540 Quiz

    • 649 Words
    • 3 Pages

    | Uncollectible accounts receivable in the amount of $22,000 were written off against the Allowance for Doubtful Accounts.No change…

    • 649 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Simpson Case ACL

    • 651 Words
    • 10 Pages

    The number of IN sales invoices totals $1,525,763,83. This is consistent with what IT has said.…

    • 651 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Current State VSM

    • 1062 Words
    • 6 Pages

    Team 5 identified the key issues by creating a Current Value Stream Mapping (Table 1, Page 3). Ramsville’s pay now invoices have a total lead time of 196,200 seconds (54.5 hours) and a total processing time of 1,740 seconds. As shown in the comparison of Pay Now and Pay Later Invoices on Table 2 (Page 4), pay now invoices spend 99.12% of the time waiting. Pay later invoices have a total lead time of 628,200 seconds (174.5 hours) and a total processing time of 1,800 seconds. Pay late invoices spend 99.71% of the time waiting.…

    • 1062 Words
    • 6 Pages
    Good 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
  • Better Essays

    ops final

    • 1186 Words
    • 10 Pages

    By analyzing the current value stream, several non-value adding steps were discovered. We recommend that you eliminate the PFR check in Accounts Payable. This step only catches 1,250 of the 65,000 errors (1.92%), and it will save you 420 seconds (7 minutes) in processing time. When checked twice, the first group relies on the second group to catch any errors they may have missed, which creates an inefficient system. Additionally, by eliminating this step, one of the employees will be able to spend 25% of his or her time in the batch process and the final inspection step. This will decrease utilization from 106.25% to 85%. Another employee from the PFR check, in the Accounts Payable Department, can be used to elevate the bottleneck. In this case, the bottleneck is the “Enter Into Pay Now Process” step. By moving one person here for 25% of his or her time, the utilization decreases from 106.22% to 84.97%. Likewise, we recommend that you eliminate the check for the PO step in the mailroom, because Bill has stated that, “Fortunately, we don’t really get any invoices without valid PO numbers on them.” This will decrease total processing time by two minutes and lead to a leaner system.…

    • 1186 Words
    • 10 Pages
    Better Essays
  • Good Essays

    | 5. Batches checks 6. Sends checks to cashier 7. Uses payments stub to enter payments into computer…

    • 787 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Finance - Finding Errors

    • 563 Words
    • 3 Pages

    ∑ The bank statement shows a check written by the company for $255 was erroneously paid (cleared the account) as $225.…

    • 563 Words
    • 3 Pages
    Satisfactory Essays
  • Better Essays

    Unit 4 P7

    • 948 Words
    • 4 Pages

    “An invoice is a legal document, which can be used as evidence of an incurred debt”.…

    • 948 Words
    • 4 Pages
    Better Essays
  • Good Essays

    Business & Admin Level 2

    • 2181 Words
    • 9 Pages

    1. Explain the purpose of correctly receiving, checking and sorting mail and packages (both incoming and outgoing).…

    • 2181 Words
    • 9 Pages
    Good Essays
  • Better Essays

    Medical Billing Process

    • 790 Words
    • 4 Pages

    The sixth step is the checkout process, which the medical codes were given, checked, and the bill amounts have been established. The charges are added and then explained to the patient, and this is when the payment for the charge is collected (deductibles, copayments). If any payments were made then a receipt is prepared and any additional work will be scheduled (Valerius, J., Bayes, N., Newby, C., & Blochowiak, A., 2014).…

    • 790 Words
    • 4 Pages
    Better Essays
  • Good Essays

    National Air Express

    • 461 Words
    • 2 Pages

    Smith and Lewis have found that they have been unable to meet their customers’ requests for a scheduled pickup on many occasions in the past quarter. Although, on average, drivers are not handling any more business, they are unable on some days to arrive at each…

    • 461 Words
    • 2 Pages
    Good Essays
  • Best Essays

    In a voucher system, the sum of all unpaid vouchers in the voucher register equals the firm’s total voucher payable balance.…

    • 4756 Words
    • 20 Pages
    Best Essays
  • Good Essays

    Julian Eastheimer & Co

    • 1169 Words
    • 5 Pages

    - Converting invoices to cash - instead of them having to collect cash after 60-day period,…

    • 1169 Words
    • 5 Pages
    Good Essays