BILKENT UNIVERSITY
DEPARTMENT OF COMPUTER TECHNOLOGY AND PROGRAMMING
FALL 1996-1997

CTP 108
COMPUTER PROGRAMMING FOR BUSINESS
LAB GUIDE 3
Week 6


1. A Payroll Report is to be prepared. The format of the Payroll Disk Record is illustrated below. 

		Personnel ID Number 			1-8
		Personnel Name 				10-19
		Daily Pay				22-24
		Workdays worked				26-28
		Overtime hours worked within month 	30-32
With above raw data, a payroll report is to be generated using the following logic :

a) Total monthly income is calculated as the monthly salary plus the overtime payment.
b) Overtime payment is calculated as

If total monthly overtime hours <= 40, hourly overtime payment is 20 % higher than normal payment. (One month has 200 regular work hours)
If total monthly overtime hours > 40, hourly overtime payment is 40 % higher than normal payment.

c) The Social Security fee is calculated as 14 % of total monthly income.
d) The Income Tax is calculated as 25 % of remaining amount. (after the Social Security Fee is deduced.)

The payroll report should look something like : 
 ID      PERSONNEL  MONTHLY  OVERTIME  TOTAL  SOC. SEC.  INCOME  NET
NUMBER    NAME      SALARY    PAYMENT  INCOME     FEE       TAX   AMOUNT
------	---------- --------  --------  ------   --------   ----- --------
46869    DIZICI     1500      600     2100      294.00     451.00   1355.00
445      AKSOY       700       80      780      109.20     167.70    503.10
Back to first page...