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
- Slides: 40