Scribd
Upload
5 views7 pages

November 2015 Payroll Summary

The document provides payroll information for employees of Dashy's Boutique for November 2015. It includes employee IDs, names, job categories, basic salaries, daily allowances, travel allowances, entertainment allowances, personal loan deductions, health insurance deductions, investment deductions, total allowances, total deductions, gross incomes, and net incomes. Employee categories include administrative staff, assistant managers, managers, supervisors, and sales staff. Allowances and deductions are calculated as percentages of the basic salary.

Uploaded by

AshlieghEllis
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
5 views7 pages

November 2015 Payroll Summary

The document provides payroll information for employees of Dashy's Boutique for November 2015. It includes employee IDs, names, job categories, basic salaries, daily allowances, travel allowances, entertainment allowances, personal loan deductions, health insurance deductions, investment deductions, total allowances, total deductions, gross incomes, and net incomes. Employee categories include administrative staff, assistant managers, managers, supervisors, and sales staff. Allowances and deductions are calculated as percentages of the basic salary.

Uploaded by

AshlieghEllis
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

Code Category Basic Monthly Salary

AD Admin $3,500
AM Assistant Manager $8,000
MN Manager $10,000
SP Supervisor $6,000
SS Sales Staf $4,000

Code Allowance Rate(%)


DA Daily Allowance 13.5%
TA Travel Allowance 7%
EA Entertainment Allowance 4.50%

Code Deduction Rate(%)


PL Personal Loan 8%
HL Health Insurance 2%
INV Investment 3%
D
Payrol
Allowances

#ID NUM First Name Last name Category Code Basic Salary Daily Allowance
CI124 Chelsea Isaacs AD $3,500.00 $472.50
NW114 Nico Wright AD $3,500.00 $472.50
AE113 Ashliegh Ellis AM $8,000.00 $1,080.00
NG111 Nicholas Gayle AM $8,000.00 $1,080.00
TE127 Tifany Ellis MN $10,000.00 $1,350.00
DN126 Domonic Neita MN $10,000.00 $1,350.00
MC128 Maya Curtis SP $6,000.00 $810.00
DP110 Danielle Pullen SP $6,000.00 $810.00
RT122 Ria Todd SP $6,000.00 $810.00
MW102 Makkenzi Welds SP $6,000.00 $810.00
NW107 Neah White SP $6,000.00 $810.00
DB125 David Barton SS $4,000.00 $540.00
AB115 Abigail Battick SS $4,000.00 $540.00
NB105 Naomi Blake SS $4,000.00 $540.00
KB109 Kima Blake SS $4,000.00 $540.00
AB117 Alex Boyd SS $4,000.00 $540.00
BB120 Bianca Brown SS $4,000.00 $540.00
CB130 Copper Brown SS $4,000.00 $540.00
JC104 Justine Campbell SS $4,000.00 $540.00
AC119 Alexa Critchlow SS $4,000.00 $540.00
YD116 Yohan Davis SS $4,000.00 $540.00
RD123 Raquel Demetrius SS $4,000.00 $540.00
CF121 Cece Findley SS $4,000.00 $540.00
QF106 Quadash Flowers SS $4,000.00 $540.00
KG108 Kaylie Gardener SS $4,000.00 $540.00
JL112 Jonathan Laidlaw SS $4,000.00 $540.00
DP129 Dean Patrick SS $4,000.00 $540.00
LT100 Latasha Topey SS $4,000.00 $540.00
Total $141,000.00 $19,035.00

Criteria Range
Last name Category Code
B* SS
#ID NUM First Name Last name Category Code Basic Salary Daily Allowance
DB125 David Barton SS $4,000.00 $540.00
AB115 Abigail Battick SS $4,000.00 $540.00
NB105 Naomi Blake SS $4,000.00 $540.00
KB109 Kima Blake SS $4,000.00 $540.00
AB117 Alex Boyd SS $4,000.00 $540.00
BB120 Bianca Brown SS $4,000.00 $540.00
CB130 Copper Brown SS $4,000.00 $540.00
Dashy's Boutique
Payroll for November 2015
Allowances Deductions
Entertainment
Travel Allowance Allowance Personal Loan Health Insurance Investment
$ - $ - $ 280.00 $ 70.00 $ 105.00
$ - $ - $ 280.00 $ 70.00 $ 105.00
$ 560.00 $ 360.00 $ 640.00 $ 160.00 $ 240.00
$ 560.00 $ 360.00 $ 640.00 $ 160.00 $ 240.00
$ 700.00 $ 450.00 $ 800.00 $ 200.00 $ 300.00
$ 700.00 $ 450.00 $ 800.00 $ 200.00 $ 300.00
$ - $ - $ 480.00 $ 120.00 $ 180.00
$ - $ - $ 480.00 $ 120.00 $ 180.00
$ - $ - $ 480.00 $ 120.00 $ 180.00
$ - $ - $ 480.00 $ 120.00 $ 180.00
$ - $ - $ 480.00 $ 120.00 $ 180.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ 2,520.00 1620 11280 2820 4230
Entertainment
Travel Allowance Allowance Personal Loan Health Insurance Investment
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
$ - $ - $ 320.00 $ 80.00 $ 120.00
Total Allowance Total Deductions Gross Income Net Income
$472.50 455 $3,972.50 $3,517.50
$472.50 455 $3,972.50 $3,517.50
$2,000.00 1040 $10,000.00 $8,960.00
$2,000.00 1040 $10,000.00 $8,960.00
$2,500.00 1300 $12,500.00 $11,200.00
$2,500.00 1300 $12,500.00 $11,200.00
$810.00 780 $6,810.00 $6,030.00
$810.00 780 $6,810.00 $6,030.00
$810.00 780 $6,810.00 $6,030.00
$810.00 780 $6,810.00 $6,030.00
$810.00 780 $6,810.00 $6,030.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$23,175.00 18330 $164,175.00 $145,845.00
Total Allowance Total Deductions Gross Income Net Income
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00
$540.00 520 $4,540.00 $4,020.00

You might also like