Payroll

» waterblue_ism - hi nice people can you help me please

i hope this doesn't sound rude but i found this competition in my weekly magazine where i can win a car or £5000 depend what place i'm in or how good the program works the top prize is the car however, i know nothing of visual basic and i found this site through a search engine so please can you help me with it ----if i win this i am personally sending £1000 to you if you leave your address i'll send you a cheque --i am that dessperate to win-----i wrote down exactly what it said:

An analyst has identified the requirements for a simple personnel and payroll system. you are required to design and build a system that meets these requirements.
The system will use three files to store information. Employee details will be stored in a random access file called employees, Tax and National Insurance (NI) details will be stored in a sequential file called deductions, and timesheet information will be stored in a sequential file called TimeSheets.

The system will provide facilities to maintain details of each employee and to calculate gross and net wages for weekly paid employees.

Employees file -record details

Field Name Type

EmpNo Integer
EmpFirstName String*15
EmpSurname string*20
EmpAddr1 string*20
EmpAddr2 string*20
EmpTown string*20
EmpPostCode string*8
EmpTelephone string*13
EmpJoined Date
EmpLeft Date
EmpTaxCode Integer
EmpGrossYTD currency
EmpTaxYTD currency
EmpNIYTD currency

Timesheets file - record details

Field Name Type

TSEmpNo Integer
TSHours Integer

Deductions file

- record 1 (Tax) details

Field name Type

TaxRate Single

- record 2 (NI) details

Field Name Type

NILowerLimit Long
NIUpperLimit Long
NI Rate Single

- record 3 (YTD) details

Field Name Type

HourlyRate Single
WeekNo Integer
TaxYTD currency
NIYTD currency

Wage calculation rules:

-an employee's gross wage is calculated by multiplying their TSHours by Hourly Rate. Tax and NI contributions are deducted from the gross figure to give the net wage.

-every employee is given a tax code, base upon the employee's tax allowance. To do this, they first calculate the employee's tax allowance and then divide by 10 and round down. Every time that an employee is paid, their tax code is used to calculate their tax-free pay. for weekly paid employees, this would be:

Tax code X 10 / 52 x weekNo

- Tax is calculated on the gross figure less any tax free pay as defined by the tax code. the year to date (YTD) tax free pay is subtracted from the total gross YTD salary to give the taxable pay. the tax liability is then calculated on this. The difference between the previous Tax YTD and this new calculation is the amount of tax payable or refundable this week. (where an employee's wages fall during the year, the calculation often results in a negative amount, i.e. a refund of tax.)

-NI is calculated on the amount of the gross figure that lies between the lower and upper limits. Again these limits are adjusted by dividing by 52 and multiplying by the weekNo

Requirements:

- Allow the amendment of all details of record 1 & 2 of the deductions file at any time
- Annual clear down of record 3 of the deductions file.
- Add a new employee, automatically allocating the next available employee number
- Amend all details for an employee except the employee number
- Add , as reuired, timesheets (hours worked) for any employee that has not left. these to be stored in the TimeSheet file . For each employee, this proccess will print a payslip showing details of the current calculation and year-to-date (YTD) figures, and update the YTD figures in the employee's Employees record. at the end of the process, it will update the overall YTD figures stored in record 3 of the TimeSheets file and print a summary report.

few i just finished typing please help me as it took me ages to type all this in. i will personally send you a thank you message even if i don't win this.

-- posted by waterblue_ism

Permalink Print Discussion Join the latest discussions