Re: Need help with FBLA PROGRAM



So...you want us to write this for you? I think you misunderstand the point
of this forum. The idea is you write your own code, and if you get stuck,
post your specific problem with the code that doesn't work and someone will
more than likely help you with it. If you want someone to actually write
the app for you, I'm sure you can get some descent quotes on an hourly
basis.

<realvampirelestat@xxxxxxxxx> wrote in message
news:f2154de1-4419-4c11-8db5-2a39d6248786@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
|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

  • Need help with FBLA PROGRAM
    ... You have been hired by Widget's Incorporated to write a payroll ... The program will read an employee pay file containing term code, ... 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)