Final Paper

profilerskotha
fraud_management_budget_summarhy.xlsx

Sheet1

Operating Budget Summary 2000 - 2005
2000 Actual 2001 2002 2003 2004
Personnel
Salaries 365000 369096 375000 374519 375000 379000 380000 385000 380000 379550
Fringe Benefits 50,000 49,789 50000 49789 50000 50000 50000 50000 50000 50000
Travel 150000 123,210 140000 138674 140000 139777 140000 124569 140000 139458
Training/Tuition 15000 18000 20000 23000 25000 34000 33000 30000 3000 27000
Professional Conference Fees 4,000 4000 4000 4000 4000 1000 0
Total Personnel 584,000 564,095 589000 589982 594000 603777 573000 589569 573000 596008
Equipment and Supplies
General Office 10000 14694 15000 17750 20000 34598 35000 39950 40000 43000
Lap Top Computers 5000 1000 5000 2000 5000 1000 5000 0 3000 1000
LAN Update 10,000 8992 5000 4398 5000 4950 5000 1000 2000 500
Printers 5000 5000 5000 0 0 1000
Photo Co;pier 3,000 3000 3000 3000 2000 0 2000 2000 5000 3500
Office Equipment Lease 5000 4500 5000 5000 5000 5000 5000 5000 5000 5000
Fleet Replacement 25,000 24000 25000 19946 20000 0 20000 22349 20000 23086
Total Equipment 63,000 61,186 63000 52094 57000 45548 62000 71299 75000 76086
Utilities
Electricity 12,000 12000 12000 12000 12000 12000 12000 12000 12000 12000
Gas 16,000 17000 16000 16000 16000 16000 16000 16000 16000 16000
Water 5,000 4000 5000 5000 5000 5000 5000 5000 5000 5000
Total Utilities 33,000 33,000 33000 33000 33000 33000 33000 33000 33000 33000
Total Operating Budget 680,000 658281 685000 675-76 684000 682325 703000 693868 705000 704094

Sheet2

Sheet3