Scribd
Upload
45 views9 pages

Expenses For The Month of January vs. Budget: Budget Actual Saving Saving%

The document shows overtime calculations for employees at Brick Court Investment for the month of November. It lists each employee's name, date worked, hours worked, day of the week, hourly rate, and amount owed. The highest overtime amounts were earned by Albert, Bernard, and Carl, ranging from $50 to $500 each. Martin also earned $200 and $100 for overtime worked on different dates.

Uploaded by

Ranjit
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
45 views9 pages

Expenses For The Month of January vs. Budget: Budget Actual Saving Saving%

The document shows overtime calculations for employees at Brick Court Investment for the month of November. It lists each employee's name, date worked, hours worked, day of the week, hourly rate, and amount owed. The highest overtime amounts were earned by Albert, Bernard, and Carl, ranging from $50 to $500 each. Martin also earned $200 and $100 for overtime worked on different dates.

Uploaded by

Ranjit
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/ 9

Expenses for the Month of

January vs. Budget

Budget Actual Saving Saving%


Salaries and Wages 156675.00 145200.00 11475.00 7.32%
Rent 4300.00 4300.00 0.00 0.00%
Electricity 1000.00 1207.00 -207.00 -20.70%
Telephone 200.00 142.00 58.00 29.00%
Advertisements 20000.00 18550.00 1450.00 7.25%
Freight and clearing 15650.00 13400.00 2250.00 14.38%
Securiry 3800.00 3800.00 0.00 0.00%

Total 201625.00 186599.00 15026.00 7.45%


Employee
Details

Tax Deductons
Allowances

Gross Pay
Basic Pay
Category
Emp No

Net Pay
Name

E8 Cornel Assistant 4600 300 4900 588 4312


E9 John Assistant 3500 450 3950 474 3476
E2 Francis Supervisor 6508 500 7008 841 6167.04
E3 Edwin Manageme 8006 1801 9807 1177 8630.16
E10 Carl Assistant 4200 100 4300 516 3784
E4 Bernard Manageme 7917 1775 9692 1163 8528.96
E5 George Supervisor 5500 850 6350 762 5588
E1 Lewis Manageme 8291 2500 10791 1295 9496.08
E6 Albert Supervisor 5700 760 6460 775 5684.8
E7 Edward Supervisor 7151 1545 8696 1044 7652.48

Tax Rate
12%

Employee's Salary Details

Edward 1545
7151

Albert
760
5700

Lewis 2500
8291

George 850
7151

Albert
760
5700

Lewis
2500
8291

George
850
5500

Bernard
1775
7917
Employee Names

Carl
100
4200
Basic Pay
Edwin Allowances
1801
8006

Francis
500
6508

John
450
3500

Cornel
300
4600

0 1000 2000 3000 4000 5000 6000 7000 8000 9000


Thousands (kshs)
Raw Material Energy
0.2 14
0.5 14
0.5 18
0.2 16
0.2 16
0.5 13
0.2 12
0.35 15 Energy
0.5 9 20
0.35 15 18
0.5 11 16
0.5 16 f(x) = - 5x + 17.0833333333
14 R² = 0.0610859729
0.5 18 12
0.5 13 10
0.35 19 8
0.35 19 6
0.2 17 4
0.2 18 2
0.2 15 0
0.2 16 0.15 0.2 0.25 0.3 0.35 0.4 0.45 0.5 0.5
0.35 18
0.35 16
0.35 14
0.35 16
Energy

0833333333
729
Energy
Linear (Energy)

0.35 0.4 0.45 0.5 0.55


Brick Court Investment
Overtime calculations for the month of November
Date Name Hours WorDay of Week Rate Amount
27-Oct Albert 4 Sun 100 400
8-Nov Albert 3 Fri 50 150
9-Nov Albert 4 Sat 50 200
12-Nov Albert 3 Tue 50 150
15-Nov Albert 4 Fri 50 200
19-Nov Albert 1 Tue 50 50
19-Nov Albert 4 Tue 50 200
20-Nov Albert 2 Wed 50 100
21-Nov Albert 4 Thu 50 200
5-Nov Bernard 4 Tue 50 200
7-Nov Bernard 5 Thu 50 250
26-Oct Bernard 2 Sat 50 100
28-Oct Bernard 4 Mon 50 200
30-Oct Bernard 3 Wed 50 150
2-Nov Bernard 1 Sat 50 50
9-Nov Bernard 4 Sat 50 200
14-Nov Bernard 1 thu 50 50
27-Oct Carl 5 Sun 100 500
28-Oct Carl 3 Mon 50 150
18-Nov Martin 4 Mon 50 200

11-Nov Martin 4 Mon 50 200

22-Nov Martin 2 Fri 50 100


Date Name Hours Worked Day of Week Rate Amount

Average

Average

Average
Average

Average

Average

Average
Average

Average

You might also like