399408 Visual Basic Proposal

In the proposal, you should explain how you plan to solve the problem and include your paper solution of the problem. You will also provide your testing data to prove your solution works. (you will develop the solution using pseudocode, IPO diagrams, or another programming development aide. This part of the project is called the proposal. It basically tells me how you intend to solve the problem.) Scenario: You have been asked to develop a program to process a company's payroll. Payroll is paid bi-weekly. There are three phases to this task. The first is to read a series of time card records and create a file that will be used to process the payroll. The second is to process the file you created and create a file that can be used to produce the check to the employee. There are several subsidiary files that you will use in the processing of the payroll. Finally, you will develop a GUI program to display the check data. See file formats at the end of this document. Time Card Processing: There are two types of employees: (h)ourly and salary. Only (h)ourly employees get paid overtime, week-end, and shift premiums. Salaried employees get a flat rate of 80 regular hours regardless of their clock times. Each (h)ourly employee, if they worked, must have a time card. Salaried employees may or may not have a time card. Each time card record will have a place for each day's clock in and clock out. Times are recorded as hours:minutes. Hours and minutes are separated by a colon. All minutes are to be rounded to the nearest quarter hour. There are three shifts as follows: Shift 1: 8:00 am – 4:00 pm Shift 2: 4:00 pm – 12:00 am Shift 3: 12:00 am – 8:00 am Only hours worked in the shift will count as shift hours. In other words, if an employee worked 9:00 am until 5:00 pm, the employee would be paid 1 hour at shift 2 rate. The company also pays a premium to employees who work week-ends. Only hours worked on Saturday and Sunday will count as week-end hours. Week-end hours are in addition to shift hours. For example, an employee who works Friday at 4:00 pm and clocks out Saturday at 2:00 am will have 2 week-end hours, 8 shift 2 hours, and 2 shift 3 hours. All hours will be converted to decimal format with two decimal places. Only valid decimal components are .00, .25, .50, and .75 because hours are to be rounded to the nearest quarter hour. This program is to process the time_card file and produce the payroll file. For salaried employees, a constant of 80.00 is to be placed in regular hours and 0.00 is to be placed in all other hour fields. For (h)ourly employees, calculate regular hours as those hours less than or equal to 40.00 in a week. Any hours over 40.00 hours are paid as overtime hours. Calculate shift 2 hours, shift 3 hours, and week-end hours as outlined above. Not all employees may have time card records as indicated above. Employees missing a time card record should be displayed on the monitor as a list. Payroll Processing: This program is to process the payroll file and create the earnings file. Various “pays” are calculated as follows: Regular Pay = Regular Hours times (H)ourly Rate Overtime Pay = Overtime Hours times ((H)ourly Rate times 1.5) Shift 2 Pay = Shift 2 Hours times Shift 2 Rate (from shift_premium file) Shift 3 Pay = Shift 3 Hours times Shift 3 Rate (from shift_premuim file) Week-end Pay = Week-end Hours time Week-end Rate (from shift_premium file) Gross Pay = Regular Pay + Overtime Pay + Shift 2 Pay + Shift 3 Pay + Week-end Pay Deductions, both taxes and voluntary, are taken in the following order: Federal Withholding FICA Withholding Medicare Withholding State Withholding Voluntary Deduction 1 Voluntary Deduction 2 Voluntary Deduction 3 Federal Withholding is to be calculated according to IRS Publication 15 for bi-weekly payroll. FICA Withholding and Medicate Withholding is to be calculated according to IRS Publication 15. State Withholding is a percentage of Federal Withholding. Voluntary deductions are calculated one of two ways. If the deduction method is ‘P' (percentage) then the amount of the deduction is gross pay times the deduction amount/percentage. If the deduction method is ‘F' (fixed) then the amount of the deduction is equal to the deduction amount/percentage. Deductions cannot allow a paycheck to be negative, but the check can be zero. For example, an employees gross pay is $300.00 and the employee has taxes of $250.00. There will be $50.00 remaining for deductions. If an employee has requested for deduction 1 a fixed amount of $75.00, the amount of deduction will be $50.00 because the check cannot be negative. There can be no 2nd or 3rd voluntary deduction because the net pay is at zero. Check date = assignment due date Check Number: Starts with 305612 (this will be the first check number) GUI Check Display This program will display each record of the earnings file on a GUI form. All fields from the file are to be displayed.