EXECUTIVE SUMMARY
I worked with a local company called Let There Be Light. This is a window cleaning company based here in Utah Valley. They were having some trouble as they grew with regard to creating a database for their customers. They did not have an electronic database. They scanned in their customer’s receipts, saved as PDF files, and those constituted their records. As management, they had some repetitive tasks to perform each week. They would print out a template each week and manually lookup payroll taxes for their employees and manually calculate how much to withhold in FICA, FUTA, and State Unemployment. They also had to calculate how much to maintain in Retained Earning and how much each partner would receive. This took a considerable amount of time each week.
I began this project by entering in all of their current clients to create a database. I then created a three-step process by which they could enter in all of their data at the end of each week and the program calculates the taxes, including looking up the taxes from the state and federal tax tables.
These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience
Thursday, December 10, 2009
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2009
(62)
-
▼
December
(61)
- Anthony WhiteProject Write-UpProjectBusiness Backg...
- Utah County Property Search
- Inventory Tracker and Exporter
- Final Project Journal Entries
- Piano Technician Customer Database
- Band Manager VBA Application
- Student Hours Report for the Political Science Dep...
- Final Project ISYS 520
- Jeremy Heckaman - Viking Pest And Plant Customer/C...
- Student Teacher Database - Alexander Ivanov
- Statistical Research Program - Matthew NelsonExecu...
- Inventory Tracking System
- Route Y Registration
- BOb Transaction Report Analysis Project
- PBC Report Project
- Finding the Area of a Cutter
- APX Licensing Reporting Tool
- iTunes Playlist Generator
- Tracking Days-in-Inventory
- Textbook Pricer
- Aircraft Part Measurement Analysis
- Income For Life
- Extracting Email Data & Small Business Accounting
- Adwords Report Automation
- Inventory and Sales Manager
- Jaxon Physical Therapy
- Faculty Profile System Report
- Refund Reconcilation and Stale Dated Checks
- The Drakinator by Drake Allsop
- Automated Year-on-Year Sales Report by Rand Blair
- Nate Smith VBA Project
- Contract Threshold Matrix
- Stock Picker
- Pricing Monitor
- Waddingham & Peterson Law Firm Database
- Josh Caplin VBA Final Project
- VBA Project Pope Weston
- VBA Project- Customer/Supplier Database
- Classroom/Grade Management
- Negotiation Scoring System
- Financial Analysis Automation
- Green Light Films Set List Database
- Nine Fingers Sharpening
- Internal Audit Purchasing Card Applications
- A VBA Project for Health Equity
- Client Billing Manager
- Ward Membership Data Viewer
- Ebay Data Extraction
- Nonprofit Financial Management
- Winder Farms
- Reconcile G/L Accounts: A VBA Application
- Let There Be Light
- The Board List--Text Message Sender Tool
- Oil Volume Auditing Add-In
- Security Analyzer
- Expense Report Analysis
- QB Interface 1.0
- Google Analytics Report Runner
- Wind Loads per ASCE 7-05
- Product Manager Dashboard
- Bathroom Remodel Estimator
-
▼
December
(61)
No comments:
Post a Comment