Scribd
Upload
12 views4 pages

.Practical Exercise 1.4

The document contains sales data for a stationery supplies company, detailing sales by individual salespersons and their respective totals. It also includes overtime details for employees, listing hours worked and amounts earned, culminating in a total overtime amount. Additionally, it provides a summary of employee salaries, including basic pay and net salary calculations.

Uploaded by

skill
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
12 views4 pages

.Practical Exercise 1.4

The document contains sales data for a stationery supplies company, detailing sales by individual salespersons and their respective totals. It also includes overtime details for employees, listing hours worked and amounts earned, culminating in a total overtime amount. Additionally, it provides a summary of employee salaries, including basic pay and net salary calculations.

Uploaded by

skill
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

mon tue wed thur fri TOTAL

Breakfast 3560 3186 2952 3395 3436 16529


Lunch 20163 21416 19912 19681 18628 99800
Bar 9873 12172 12642 12711 18846 66244
Snacks 2405 3544 2694 3120 3712 15475 0
TOTAL 36001 40318 38200 38907 44622 198048
A B C D E
1 Stationery supplies ltd
2
3 Date sales person item receipt no amount
4 21-Nov carl toys 1238 1782.1
5 26-Nov carl stationery 1255 4853.55
6 26-Nov carl toys 1395 51.35
7 carl's Total 6687
8 21-Nov john cards 1141 91.15
9 24-Nov john books 1982 442.6
10 26-Nov john toys 1885 561.5
11 21-Nov john toys 1885 62.75
12 john's total 1158
13 22-Nov judy books 1032 234.5
14 26-Nov judy sports goods 1920 472.6
15 judy's total 707.1
16 25-Nov mary toys 1774 364.15
17 mary's total 364.15
18 22-Nov susan electronics 1160 52.95
19 23-Nov susan cards 1075 81.6
20 23-Nov susan others 1745 132.95
21 24-Nov susan sports goods 1662 2580.1
22 Susan's total 2847.6
23
24 Grand Total 11763.85
25
Services company ltd
Overtime Details
Date Name Hours Worked rate Amount
26-Nov Kennedy 5 70 350
26-Nov Kennedy 5 100 500
26-Nov mary 5 100 500
26-Nov lewis 4 100 400
30-Nov judy 3 100 300
30-Nov Kennedy 6 70 420
30-Nov judy 5 100 500
30-Nov Kennedy 4 70 280
30-Nov judy 5 100 500
30-Nov lewis 5 100 500
1-Jan judy 4 70 280
Total amount 4530
statonery supplies ltd

Name Basic pay allowances gross salary deduction net salary


lewis 17500
francis 19800
edwin 45200
franco 17500
john 45200
amina 17500
Totals

You might also like