MICROSOFT EXCEL

Microsoft Excel

Microsoft Excel

Spreadsheet No. 1

Payroll for Employees

Employee Name

Occupation

Standard Wage

Bonus

Total Pay

Tax On Scale

Additional Tax

Total Tax

Net Pay

Wally Burden

Nurse

250

100

350

0

7.4

7.4

342.6

Fred Waller

Manager

500

250

750

12.94

7.4

20.34

729.6562

Silly Person

Doctor

300

150

450

7.40

7.4

14.80

435.2035

Anterior Parts

Driver

150

80

230

0.00

7.4

7.40

222.6

Superior Items

Police Officer

200

120

320

0.00

7.4

7.40

312.6

Likeable One

Farmer

400

200

600

7.40

7.4

14.80

585.2035

Spreadsheet No. 2

Payroll for Employees

Employee Name

Occupation

Standard Wage

Bonus

Total Pay

Total Tax

Net Pay

Wally Burden

Nurse

250

100

350

7.40

342.60

Fred Waller

Manager

500

250

750

20.34

729.66

Silly Person

Doctor

300

150

450

14.80

435.20

Anterior Parts

Driver

150

80

230

7.40

222.60

Superior Items

Police Officer

200

120

320

7.40

312.60

Likeable One

Farmer

400

200

600

14.80

585.20

Spreadsheet No. 3

Payroll for Employees

Employee Name

Occupation

Standard Wage

Superannuation

Employer

Bonus

Total Pay

Total Tax

Net Pay

Wally Burden

Nurse

250

15

22.5

100

387.5

7.40

380.10

Fred Waller

Manager

500

25

45

250

820

20.34

799.66

Silly Person

Doctor

300

18

27

150

495

14.80

480.20

Anterior Parts

Driver

150

8

13.5

80

251.5

7.40

244.10

Superior Items

Police Officer

200

11

18

120

349

7.40

341.60

Likeable One ...