Need help with FBLA PROGRAM

Tech-Archive recommends: Fix windows errors by optimizing your registry

I am a highschool student and I have to do a payroll program for a
FBLA competition and I have no idea how to even begin doing the things
they want me to do with this .dat file. Please help if you can, Here
is the prompt:
Desktop Application Programming
You have been hired by Widget's Incorporated to write a payroll
processing system that will process hourly payroll every week.

You will need to:
1. Generate an updated file with current payroll information.
2. Create a check and check stub based on the information
provided in this problem.
3. Produce a payroll journal.

The program needs to have a user interface that will offer menu
choices to:
1. Change the default hours worked (40 hours) for the pay
period.
2. Process the payroll for every nonterminated employee in the
file.
3. End program.

The program will read an employee pay file containing term code,
employee ID, pay rate, hours worked, dependents, and insurance amount
among other fields. The gross pay is calculated based on hours worked,
times pay rate, with overtime calculated at time and one half for any
hours worked over 40. From this gross amount, subtract:
1. Federal Insurance Contributions Act (FICA) at 7.65 percent.
2. Federal Income Tax at $65.38 times number of dependents
resulting balance times 15 percent (e.g., gross-$65.38 times
dependents times 15 percent).
3. Insurance payment amount.
4. Calculate net pay to write the check.
5. Update the year-to-date (YTD) totals in the employee pay
file.

The check must contain check number, name, amount of check in numbers
(no words), and date of check. The check stub must contain name,
employee ID, hours worked, gross pay, withholdings (breakdown), net
pay, YTD taxes withheld, YTD gross, and date. No check should be
printed for a zero or negative amount. If a calculation should result
in a zero or negative amount, the insurance deduction should not be
taken.

There is also a printed detail report for the entire payroll and a
summary of final totals for each of the withholding amounts and that
calculates the employer contribution for FICA at 7.65 percent, and
Federal Unemployment Tax Act (FUTA) at 6.25 percent.

The terms used in the program assignment must be researched and
correct data types must be chosen. The file data as presented is the
data at the beginning of the payroll process. All codes and amounts
should be treated as such. The file should be a fixed length file
named PAYFIL.DAT and must contain the fields:

Field Len Description and valid values
TermCode 1 Values are Blank, R, T (Blank is active, R is
retired, T is terminated)
EmplID 6 Any number from 1 to 999999
FName 15 First name
MName 1 Middle name
LName 15 Last name
Suffix 5 Suffix (e.g., Jr, Sr)
HourRT 4 Hourly Rate of pay (should be able to hold 99.99)
HourWK 2 Hours Worked (should be able to hold 99)
Dep 2 Number of dependents claimed (should be able to
hold 99)
Insur 5 Insurance amount (max amount is 999.99)
YTDGR 8 Must be large enough to hold rate of pay times
hours worked for the year
YTDFICA 7 Must be large enough to hold the amount of FICA paid
in for the year
YTDFED 7 Must be large enough to hold the amount of federal
income tax paid in for the year


Sample Data
Payroll Journal

EmpID Name Gross Pay
FICA FED Insur Net Pay
987678 Min E. Mouse
290.00 22.19 14.08
125.50 128.24
234843 John Doe Jr
631.25 48.29 94.69
65.00 423.27
432345 Mary H. Lamb
171.00 13.08 15.84
65.00 77.08
234123 Lisa Juno
636.00 48.65 95.40
0.00 491.95

Final Totals
$1,728.25 $132.21 $220.01
$475.50 $1,120.53

Total Payroll Liability for: FICA--$264.42, FUTA--$108.02, and FED--
$220.01.
.

Relevant Pages

  • Re: Need help with FBLA PROGRAM
    ... | You have been hired by Widget's Incorporated to write a payroll ... | employee ID, pay rate, hours worked, dependents, and insurance amount ... The gross pay is calculated based on hours worked, ... From this gross amount, subtract: ...
    (microsoft.public.vb.general.discussion)
  • Re: OT Boobs smashed
    ... TV licences pay for BBC TV where advertising is not allowed. ... Here there is a special State insurance stamp for self employed ... >negligible amount of local tax on cable or satellite but never on ... >> well as any private pension from their employment. ...
    (rec.crafts.textiles.quilting)
  • Re: More news from the cartoon front
    ... "There was no amount permanently fixed for it, ... of moderate wealth, and 12 for craftsmen and manual laborers. ... It's worth noting that dhimmi did not have to pay the Zakat, ... region (this may be wheat, dates or rice, depending on the place) paid ...
    (rec.arts.sf.fandom)
  • Re: Calculating mortgage payments
    ... mortgage, which looks like being only a few years before I switch. ... Both assume that you actually pay ... One method assumes that if, say, the amount outstanding at ... them back, taking into account the time at which each payment is made, ...
    (uk.finance)
  • Re: Auto Number
    ... I have a table for employee records, with the pay rate and other personal ... Income tax and the result is then stored in another table, called SALARIES ... is stored in a field - data type -number and primary key. ... If the database is first used at mid year, then the old payroll data (not ...
    (microsoft.public.access.tablesdbdesign)