TECH 50800 Project Title Payroll Fund Measure Phase

1. TECH 50800 ProjectTitle Payroll FundMeasure Phase Date:20 Oct, 2013 Team members: Matt Unger

2. Brief Review of Project • Business case • The payroll fund is in a negative status. Funds in Indiana government entities cannot be negative. The town has received several bad audits for this reason. It is threatening to put the town in very bad financial position. • Problem Statement • The payroll fund is used by the town to pay employees using resources from the town and 2 utilities. The fund is a net zero account. What comes in must go out or at least be tracked to know what account owes the fund. This problem has be ongoing for several years. It is currently adding about $20K to $40K of debit a year to this account that is difficult to track to the source. • Goal • Is to control inputs and accurately identify accounts that owe the payroll fund

3. SIPOC

4. Critical To Quality points

5. Process Map Calculate employee weekly pay Pay Employee Pay weekly payroll expenses Pay Monthly payroll expenses Calculate percent account breakdown Transfer from Town fund to payroll fund Pay from Sewage to payroll fund Pay from Water to payroll fund Ensuring the employee pay calculations and percent breakdown each account owes are critical to the process. To keep the account at a zero balance it is important that all accounts pay their portion or at least track that they owe this account

6. Data slides • This process is a transactional process • The data is calculated using excel calculations • Most issues are with funds not being paid (input) • The critical points of the project is the process • The Process observation worksheet, Checksheets, Spaghetti Diagram, Data collection plans and Data charts were not used in this process.

7. Next Steps • Work on cause an effect of process • Work on future process state • Review accounting processes