USING VISUAL BASIC

A Small logging company in Illinois, Indiana, and Missouri is expanding and needing to automate the payroll process. Currently Ting-ting the payroll specialist that works in the state of IL, receives the worker's paper time cards by UPS. She uses Excel to calculate the payroll. She types in the number of hours the employee worked each day and looks up their hourly rate. She then applies any overtime based on business rules, and then calculates and deducts appropriate taxes based on state and federal rules for each of the three states. She keeps a record of the gross pay, taxes, and net pay for each employee. She also keeps track of the payroll by state (for management reporting) and taxes by state (to set aside monies to pay quarterly taxes). She then hand-writes the checks one at a time for each employee.. This process can be streamlined and much of it automated. This portion of the project sets up the business rules and data calculations. A future project will create the database structure, storage and upsert processes.

Project requirements:

- Create a web page that can calculate gross pay based on number of hours worked. Use a textbox for entry of number of hours worked Monday to Friday. Use a separate textbox for number of hours worked on Saturday (the logging company never works on Sunday). Hourly pay is $20 per hour in IL, $18 per hour in IN, and $16 per hour in MO. Hourly pay is time and a half for weekday hours in excess of 40 hours per week, and Saturday pay is double but the hours are restricted to 8 hours maximum.

- Ensure the data entry for each user entry control is validated.

- Tax rates can be found online and applied. You can combine state and federal taxes into one tax category. Use a flat tax for the payroll not a graduated tax % (so tax rate does not change depending on gross pay).

- Your job is to calculate the gross pay (which includes overtime) and then the taxes and net pay for any one employee. This is considered one payroll transaction. Also keep a running total of the Gross pay and taxes for each state. This running totals are a part of managerial accounting. (a future project will store these values in a database for business performance analysis.

Add other functionality as you see fit.

P.S. The tax rates were not given