1 SCM 524 Case Assignment 2, Part 1 Value Stream Mapping This assignment is to be submitted online via Canvas by the due date and time listed on the syllabus. A single person from each group should submit one PDF file online. You should submit two files online. One file should be a PDF document containing both the Current-state Value Stream Map (CSM) and Future-state Value Stream Map (FSM) for the case. The VSMs should not contain any explanations of calculations associated with the construction of the maps. All explanations of calculations for the VSMs should be made in the second file. The second file should be an appropriately formatted PDF document containing all answers to questions 1 to 4, including explanations of calculations. The VSMs should be formatted to look professional. Points may be deducted for formatting related issues. Improvement of a transactional process at Ramsville Introduction Sarah McDougal, Manager of Disbursements at Ramsville thought to herself Just a few more days until the Kaizen event kicks off. As Manager of Disbursements, Sarah oversaw four departments in accounting: the Sales and Use Tax Department; the Payroll, Time and Expense Reporting Department; the Accounts Payable Department; and the International Accounting Department. Ramsvilles new CEO, Chris Smith, had developed and championed Ramsvilles new Lean Initiative not long after taking over. After achieving substantial improvements in cost, lead time and quality from the application of lean principles on the manufacturing floor, Chris felt it was time to apply the same principles to other functional areas. Given the importance of Accounts Payable (AP) in maintaining a smooth flow of incoming material and preserving good relationships with suppliers, Chris felt that the AP area, which had been experiencing increasing lead times for invoice payment, would be a good place to start. With the top management directive of working on improvements in the AP process, Pat Davis, the Assistant Controller and Sarahs boss, scheduled a meeting to review the current situation. Just look at this Pat said while pointing to a column of numbers in a spreadsheet. Weve got almost 18% of our accounts payable overdue, and our suppliers are not happy about it! In a few cases, its even impacting further shipments of parts, potentially causing our manufacturing plant to miss shipping due dates and impacting customers. We must get a handle on this! Walking the Process Following that meeting, Sarah met with Colleen Martin, Manager of the Accounts Payable Department, to better understand the entire AP process. Colleen provided a good overview of how the process should work, but Sarah realized that she would need to walk the process herself to truly 2 understand the current state of things. She scheduled a walk-through of both the mailroom and the AP Department, armed with a clipboard, stopwatch, calculator, paper, and pencil to create a formal current state value stream map (VSM). The AP process begins at the mailroom which processes incoming mail from all sources, including invoices from suppliers. Once there, Colleen and Sarah spoke with Bill Hoskins, the Mailroom Manager. Bill explained the process to Sarah: Weve noticed, based on the post mark of incoming mail that it takes about 5 days for most mail to get to us. After all the mail is received, it has to be opened and sorted. We are running a bit behind, so we usually open the mail the day after we get it. If it doesnt belong to AP we have to route it to the right department. We receive about 225,000 pieces of mail each year. It takes about 1 minute to open and look at each piece of mail, to determine if it is AP mail. We find that about 11% of the pieces a year do not belong to AP. Sarah: Wow, I didnt realize so many invoices came in each year. I thought that we had an automatic payment process that was supposed to reduce incoming invoices. Bill: We do get a lot of invoices coming in, but not all of those actually get sent on to AP. Other processes screen out many of the invoices. First, we have to check mail that is sorted to be AP mail to see if it has a Purchase Order (PO) listed on the document. We have about two days of backlog from the time the mail is opened until the PO check happens. It takes an average of 2 minutes for a data entry clerk to confirm the PO number since all of the invoices have different formatting and we have to enter the PO in our system. Eight data entry clerks work this process for 75% of their work day. Fortunately, we dont really get any invoices without valid PO numbers on them. As you know, the PFR (Pay From Receipt) invoices dont go through the standard AP system, since they are paid automatically when the material is received. I sure wish we could get all our suppliers on to the PFR system; and I dont understand why suppliers already set up on the PFR system still send us paper invoices its really frustrating! So after we are done checking the PO number, we have to check to see if the invoice is part of the automatic PFR process. Colleen: Youre right Bill, but the problem is that some of the suppliers are running on accounting software that forces them to generate and send an invoice. Weve talked to them about this, but its just too expensive for some of them, especially our smaller suppliers, to change their systems to meet the needs of only one customer. Still, it would be nice for both us and the suppliers if we could come up with a solution. Bill: There is an inbox for the PFR check that has about a days worth of invoices in it, on average. When we find that the invoice is part of the PFR process, we throw the invoice into the paper recycling bin, since the paper invoice isnt needed and it is just a duplicate of the automatic PFR. We use the extra money we earn from all the paper we recycle to pay for refreshments at our softball games. At this point, we throw away about 150,000 invoices per year that are really PFR. We keep exact track of 3 what we throw away, since we want to be sure that we dont throw away something that we shouldnt. Since we are really careful, it takes each person an average of 6 minutes to throw away an invoice, and we have 25 people doing it. The remaining invoices are sent to the AP department. The invoices are divided alphabetically by supplier name while we are doing the PFR check, and then sent to the assigned AP person, so that each person gets approximately the same number of invoices each year. Once we send the paper invoices on to AP, the mailroom is done with its part of the process. Sarah: Let me make sure I have this right. First you receive and sort all the mail, with about 89% identified as AP mail. Then you have to check for a PO. After confirming the PO, you then check to see if it is on the PFR system. If it is, you recycle the paper; if it isnt, you send the invoice to the assigned AP person. Does that sum it up? Bill: Yep, thats about it. Sarah: Thanks Bill, we appreciate your time and information. Colleen, lets go find out what happens after the mailroom passes the invoices along to AP. Ive asked Sam Wolf to help us with the AP part of the process, since Sam has been working as an AP analyst for about 5 years and has done a variety of different jobs in the accounting department. Colleen: Hi Sam, Sarah and I are ready to have you walk us through the AP process on this side. Weve just finished talking with Bill Hoskins, who explained the process up to the point that the mailroom sends the invoices to you. Lets start with how long it takes the invoices to get to you from the mailroom. Sam: Well, they make deliveries three times a day; at 9:30, at 1:30, and at the end of the day to clear out their area before the end of the shift. So I guess you could say that the average invoice takes 2.5 hours to get to us once the mailroom is done. The mailroom distributes the invoices to the inbox of the assigned AP analyst. Our inboxes usually have about 2 days worth of incoming material. We process the inbox on a first-in-first-out basis, and once an invoice comes up to be worked on, the first thing we do is make sure that they arent on the PFR system. Sarah: Wait a minute, didnt the mailroom already check to see if the invoices were PFR and get rid of those that are? Why are you checking for the same thing again? Sam: Yes, they do check, but we still find about 1,250 invoices per year that they missed. It really is a pain to check for PFR status, and it takes us 7 minutes per invoice because we have to be extra careful to catch ones that were missed when the mail room people checked them. Sixteen of the analysts spend about 20% of their time doing these checks. This is such a time consuming effort that we have been keeping track of how many we find each week, and I can get that data for you, if you want. Colleen: Wed like to have that data, thanks. Okay, you screen the incoming invoices for PFR and then you only work on the invoices that arent PFR, right? 4 Sam: Yes, at this point, we have only actual invoices that need to be manually processed through the AP system. Now an analyst has to determine if the invoice is ready for payment. It could be that the pay-by-date is out in the future or we have a payment schedule agreement with the supplier. It takes about 5 minutes to sort each invoice to determine if it is ready for immediate payment or should be set aside to be paid later. Sixteen of the analysts spend about 15% of their time sorting for payment readiness. Invoices that arent ready for payment are set aside, which happens to about 20 invoices each day. On average, pay later invoices arent processed for 15 working days. It takes about 1 minute (and the equivalent of of a full time person) to look at a pay later invoice and move it over to payment processing when it is due. When a payment is ready to be paid, regardless of whether it is a pay now or one of the pay later invoices that is now due, it takes about 2 minutes to enter it into the payment processing software. We take turns and have one AP person work on this all day. Sarah: So all of the invoices end up going through payment processing, although some go straight there if they are ready for payment, but some wait for a while until they are due, is that right? Sam: Yes, they all have to go through the full payment processing, eventually. After they have been entered into the payment processing system, they have to go through a batch inspection process, which runs 4 times per day so an average invoice waits 1.5 hours for processing. We want to be sure that nothing is getting paid incorrectly, so we actually spend 2 minutes per invoice doing a final inspection of the payment before the batch is released. We take turns doing this with one person working on it per day. At this point the payment should be on the way to the supplier. However, we still have to file the paper invoice along with proof of payment. It takes about 4 minutes per invoice to file the paper documents. But we usually do all the filing at the end of the day, so an average invoice waits for about day until it is filed. It would take the equivalent of 3 full time people to do all the filing, but each analyst is supposed to do their own before they leave for the day. Sarah: Okay Sam, let me make sure that I have the process straight. You get the paper invoices from the mailroom. Then an analyst does a PFR check. If the invoice is PFR, it is thrown away; if not, it moves through the system for payment processing. You have to determine if it is ready to pay now, or should be set aside to be paid later. When an invoice is ready to pay, you input it into the system, process the batch and then file the paper documents. Does that about cover it? Sam: Yes, thats about what we do. Sarah and Colleen met later in the day to review the data they had collected and to begin drawing their current state VSM. Sarah: It looks like weve gotten a lot of good data on the current process, and it seems that there are several opportunities for improvement. Lets finish up with the current VSM and then run it by Bill 5 and Sam to make sure that weve captured everything correctly. Then we can call a meeting to begin working on our future state map. Summary of Ramsville work day Number of mail room clerks: 36 Number of AP analysts: 18 Average annual vacation days: 5 Number of company holidays: 5 Work day: 7:30am to 4:30pm Breaks 2 @ 15 mins each (paid) Lunch 30 mins (unpaid) Daily Meeting 15 mins Housekeeping/5S 15 mins Case Analysis: 1. Create a Current State Map (CSM) for the transactional process at Ramsville, using seconds as the time unit. Be aware that every single invoice may not move in a perfectly linear flow through the system. Please carry out all calculations to 2 decimal places. Explain your calculations as needed and include your CSM in your submission. 2. From your VSM analysis, answer the following questions: a. What is the total lead time (MTT) for an invoice from receipt until filing? (remember that every single invoice may not move in a perfectly linear flow through the system). b. What is the total processing time for each type of invoice? c. What percentage of time does each type of invoice spend waiting? 3. Identify which activities add value and which do not. Provide explanations for your choices. 4. Identify three process improvements for the transactional process at Ramsville. Note that your improvement cannot include investing in new technology or additional resources. a. Describe each improvement separately. b. Incorporate each improvement separately into a Future State Map (FSM). c. Calculate how much MTT reduction each improvement provides. d. Calculate the total improvement in MTT. Include your FSM in your submission.