Receipt Tracking Assistant Feasibility Presentation CS 410 Group

Receipt Tracking Assistant Feasibility Presentation CS 410 Group #3 Presenter: Wayne Yee 20 October 2004 Receipt Tracking Assistant

Team Members 20 October 2004 Receipt Tracking Assistant 2

Presentation Outline Problem Current Solutions Proposed Solution Target Markets Objectives Technical Issues Management Method issues Risk Issues Resource Issues Conclusion 20 October 2004 Receipt Tracking Assistant 3

Problem Statement Businesses and employees lose money due to lack of organization and documentation from travel. 20 October 2004 Receipt Tracking Assistant 4

Problem Characteristics Lack of expense documentation Lost or wrinkled receipts Money loss Fraudulent Spending 20 October 2004 Receipt Tracking Assistant 5

Percentage of Receipts Saved for Reimbursements Conducted by Group #3. *With the focus of survey participants being traveling employees 20 October 2004 Receipt Tracking Assistant 6

Competition Matrix 20 October 2004 Receipt Tracking Assistant 7

RTA Solution A portable PDA device or PDA attachment device that scans and organizes expense information and provides documentation for the company. 20 October 2004 Receipt Tracking Assistant 8

Solution Characteristics What the RTA will do: Digital tracking of receipts Compare employee spending trends Reduction in fraudulent spending Makes expense reports 20 October 2004 Receipt Tracking Assistant 9

Solution Characteristics What the RTA will not do: Enforce the use of RTA Prevent human error Eliminate fraudulent spending 20 October 2004 Receipt Tracking Assistant 10

Potential Markets Businesses with employees that incur traveling expenses Employees who lose money due to lost receipts for reimbursement People who want to have better documentation for taxes 20 October 2004 Receipt Tracking Assistant 11

Market Defined/Analyzed Businesses and their traveling employees Why Businesses? Why Traveling Employees? – Provide extensive reports - Reduce loss of receipts – Compare employee spending - Reduce overall paperwork - Prepare expense reports – Reduce paperwork – Reduce reimbursement fraud 20 October 2004 Receipt Tracking Assistant 12

Objectives Reduce paperwork by digitalizing receipts Decrease time for reimbursement approval Reduce fraudulent spending Track/Compare employee spending trends 20 October 2004 Receipt Tracking Assistant 13

Pros & Cons Easy access to information Maintain database/backup Organization Training employees Progress reporting on employees Employee acceptance 20 October 2004 Receipt Tracking Assistant 14

Functional Components: Hardware/Software Diagram 20 October 2004 Receipt Tracking Assistant 15

RTA Software Design 20 October 2004 Receipt Tracking Assistant 16

Software Design 20 October 2004 Receipt Tracking Assistant 17

Major Technical Issues OCR errors Unscannable receipts Compatible software/hardware Power Consumption Memory Space Durability 20 October 2004 Receipt Tracking Assistant 18

Major Management Method Issues Training for employees Scheduling of employees at their needed time of implementation Finding domain expert 20 October 2004 Receipt Tracking Assistant 19

Major Risk Issues Sensitive information (Security) Manual input errors High development cost Is the RTA user friendly 20 October 2004 Receipt Tracking Assistant 20

Major Resource Issues: Development Cost Summary Areas Cost Duration Personnel $850, 917 All Phases Legal/Marketing Fees FCC Approval/Licensing* Patent Licensing Filing Fee* Patent Application Fee* Marketing/Advertising 1 Month $1, 000 $500 $3, 000 $35, 000 2 Months Prototype Development $200. 50 Phase 1 / 6 Months Software Development $13, 524 Phase 1 / 6 Months Total Cost $904, 141. 50 *From www. patents. com 20 October 2004 Receipt Tracking Assistant 21

Survey Results Conducted by Group #3. *With the focus of survey participants being traveling employees 20 October 2004 Receipt Tracking Assistant 22

Projected Profits Total cost per unit includes software PDA attachment option: $150. 00 Full hardware: $200. 00 Return on Investment: 4941 units *Note: Numbers based on the need for different packages based on our survey and prices set based on our competition 20 October 2004 Receipt Tracking Assistant 23

Profit Projections *Profits based on the use of our product are influenced by the hardware need according to survey results on hardware commonly in use during travel 20 October 2004 Receipt Tracking Assistant 24

Recap! Problem RTA Solution Objectives – digital receipts Target Markets Technical Issues Risk Issues Cost and Resource Issues Conclusion 20 October 2004 Receipt Tracking Assistant 25

Conclusion The RTA solution is feasible because: Required technology currently exist Potential profit turnover is high Can be done in 2 years 20 October 2004 Receipt Tracking Assistant 26

Experts Consulted Mike Landis Neat. Receipts Support Mike Brelsford Frequent Traveler 20 October 2004 Receipt Tracking Assistant 27

References www. docupen. com - competition www. neatreceipts. com - competition www. patents. com - patent quotes www. salary. com - Salary quotes based on statistics of salaries in a particular area http: //www. bls. gov/cex/csxanthol 03. pdf - statistics of travel expenses with various factors http: //www. asap. com/ - software price quotes 20 October 2004 Receipt Tracking Assistant 28

Appendix A Datasets and Charts 20 October 2004 Receipt Tracking Assistant 29

Resource Issues: Hardware Costs for Attachment Option Internal Hardware Part External Hardware Cost Part Cost Processor $20. 00/unit LED Indicator $0. 50/unit Built-in Memory (8 MB) $10. 00/unit Battery $2. 50/unit Scanner Light $15. 00/unit USB Extension Wire $5. 00/unit USB Port $7. 00/unit Housing Case $3. 00/unit Total Cost $52. 00/unit Total Cost $11. 00/unit Total Cost : $63. 00/unit 20 October 2004 Receipt Tracking Assistant 30

Resource Issues: Hardware Costs for PDA Option Internal Hardware Part External Hardware Cost Part Cost Processor $30. 00/unit LED Indicator $0. 50/unit Built-in Memory (16 MB) $10. 00/unit Battery (2) $5. 00/unit Scanner Light $15. 00/unit Small Keypad $5. 00/unit LCD Display $50. 00/unit USB Extension Wire $5. 00/unit USB Port $7. 00/unit Housing Case $10. 00/unit Total Cost $25. 50/unit Total Cost $112. 00/unit Total Cost : $137. 50/unit 20 October 2004 Receipt Tracking Assistant 31

Resource Issues: Software Production Costs Items Cost Computers (5) $1, 500/unit Visual Studio. NET Enterprise Architect* $27 Software Licenses (5)* $1, 178/unit Total Cost $13, 524 *Pricing quoted from ASAP software. 20 October 2004 Receipt Tracking Assistant 32

Resource Issues: Phase 1 -- Design & Planning Staff Budget Positions Duration Cost -- Mid Cost -- Max Project Lead 6 Months $37, 389 $41, 147 $45, 043 Associate General Counsel 6 Months $88, 743 $109, 820 $124, 004 Hardware Engineer II 6 Months $24, 836 $27, 627 $30, 387 Software Engineer II 6 Months $31, 684 $35, 404 $39, 772 $182, 652 $213, 998 $239, 206 Total Cost **All Data was taken from www. Salary. com with the assumption of the location 23601 zip code area 20 October 2004 Receipt Tracking Assistant 33

Resource Issues: Phase 2 -- Development Staff Budget Positions Duration Cost -- Mid Cost -- Max Project Lead 12 Months $74, 777 $82, 293 $90, 087 Software Engineering Manager 10 Months $84, 458 $87, 858 $101, 023 Hardware Engineer III (2) 10 Months $50, 654 (each) $56, 317 (each) $61, 089 (each) Software Engineer Level 2 Level 3 (2) 10 Months $44, 118 $52, 806 (each) $48, 858 $59, 006 (each) $54, 447 $66, 287 (each) $410, 273 $449, 655 $500, 309 Total Cost **All Data was taken from www. Salary. com with the assumption of the location 23601 zip code area 20 October 2004 Receipt Tracking Assistant 34

Resource Issues: Phase 3 -- Testing Staff Budget Positions Duration Cost -- Mid Cost -- Max Project Lead 3 Months $18, 694 $20, 573 $22, 522 Programmer IV 3 Months $17, 440 $19, 366 $21, 634 Software Engineer IV 3 Months $18, 535 $20, 309 $22, 406 $52, 669 $60, 248 $66, 562 Total Cost **All Data was taken from www. Salary. com with the assumption of the location 23601 zip code area 20 October 2004 Receipt Tracking Assistant 35

Resource Issues: Phase 4 -- Maintenance Staff Budget Positions Duration Cost -- Mid Cost -- Max Project Lead 12 Months $74, 777 $82, 293 $90, 087 Programmer IV 12 Months $69, 761 $77, 463 $86, 535 Hardware Engineer III 12 Months $60, 785 $67, 580 $73, 307 $205, 323 $227, 336 $249, 929 Total Cost *Duration values are minimum values. Values for duration could range from 1 to 3 years. **All Data was taken from www. Salary. com with the assumption of the location 23601 zip code area 20 October 2004 Receipt Tracking Assistant 36

Appendix B Some Statistics 20 October 2004 Receipt Tracking Assistant 37

Travel Expenses By Age Data taken from U. S. Department of Labor: http: //www. bls. gov/cex/csxanthol 03. pdf 20 October 2004 Receipt Tracking Assistant 38

Travel Expenses By Income Data taken from U. S. Department of Labor: http: //www. bls. gov/cex/csxanthol 03. pdf 20 October 2004 Receipt Tracking Assistant 39

Travel Expenses By Family Size Data taken from U. S. Department of Labor: http: //www. bls. gov/cex/csxanthol 03. pdf 20 October 2004 Receipt Tracking Assistant 40