BUSINESS

Business Information System Concepts



Business Information System Concepts

Employee surname

Employee First Name

Employee ID

Role

Hours Worked

Hourly Rate

Chung

Kristiana

51073

Sales Assistant

185

6.5

Chen

Paige

51182

Sales Assistant

165

6.5

Melton

Sherri

51451

Sales Assistant

148

6.5

Hill

Gretchen

51407

Supervisor

185

9.08

Pucket

Karen

52862

Sales Assistant

148

6.5

Song

Patrick

51066

Sales Assistant

56

6.5

Hamilton

Elsie

51289

Sales Assistant

111

6.5

Bendor

Hazel

51242

Sales Assistant

32

6.5

Wagner

Malcolm

51986

Sales Assistant

80

6.5

Mclaughlin

Dolores

51932

Supervisor

183

9.08

Chung

Kristina

51104

Manager

200

13.5

Policies sold

commission

Gross Salary

Tax

Net Salary

DOB

540

378

£ 1,580.50

£ 79.03

£ 1,501.48

12/2/1943

520

364

£ 1,436.50

£ 71.83

£ 1,364.68

8/7/1947

850

935

£ 1,897.00

£ 94.85

£ 1,802.15

19/05/1939

60

£ 1,679.80

£ 83.99

£ 1,595.81

11/2/1949

720

792

£ 1,754.00

£ 87.70

£ 1,666.30

18/02/1942

150

£ 364.00

£ 18.20

£ 345.80

10/10/1946

0

£ 721.50

£ 36.08

£ 685.43

10/6/1941

110

£ 208.00

£ 10.40

£ 197.60

3/10/1946

270

81

£ 601.00

£ 30.05

£ 570.95

18/10/1940

970

1067

£ 2,728.64

£ 136.43

£ 2,592.21

12/3/1943

£ 2,700.00

£ 135.00

£ 2,565.00

24/02/1941

Formulas for calculating Gross Salary

Gross Salary= Hours worked* rate per hour + commission

Commission = policies * commission rate

Tax= Gross Salary - 5 percent

Net Salary = Gross salary - tax

The above table provides clear information about employees that are working in the organization, and it ...