A9_-_LakehurstCustodial_Excel_Labor_Spreadsheet_20171127.xlsx

XLSX spreadsheet 62 KB Posted

Attached to
JB MDL Lakehurst Custodial
Solicitation number
FA4484-18-R-0001
Issued by

About this file

Excel Labor Spreadsheet

View the file

Other files

Show all 13

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

BASE YR

Contract No.:
Contract Title:Lakehurst Custodial
Date:
Instructions:Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act for each CLIN. Round to two decimal places.
Note:The numbers below are a sample. Offerors should propose their rates.
Fringe Benefit AdjustmentTaxes
ABCDEFGHIJKLOQRSTUVWXY
CLINLabor CategoreyHourly Wage RateProductive HoursSubtotalOT HoursSubtotalPaid Vacation and holiday HoursOther CBA-required Paid LeaveTotal Paid non-Productive hoursSubtotalTotal Hours WorkedTotal Gross Annual Wages**Fringe Benefits (FB) Paid "Per Hour"Non Taxable SubtotalAdditional "Cash Payment" of FBTotal " Wages" and "FB Paid in Cash"****% FICACap $7,000 / % FUTINJ Cap 33,500/ %SUTIW/C %Sub TOTALG&AProfitTOTAL (V+W+X)
0.07650.00080.0240.17291%1%
000211150 Janitor$15.702035$31,949.5010$235.5040040$628.002085$32,813.00$4.41$9,150.75$0.00$32,813.00$2,510.19$5.60$787.51$5,673.37$50,940.42$509.40$509.40$51,959.23
000311150 Janitor$15.70200$3,140.000$0.00000$0.00200$3,140.00$4.41$882.00$20.00$3,160.00$241.74$2.51$75.84$546.36$4,908.46$49.08$49.08$5,006.63
000411150 Janitor$15.702000$31,400.000$0.0080080$1,256.002080$32,656.00$4.41$9,172.80$0.00$32,656.00$2,498.18$5.60$783.74$5,646.22$50,762.55$507.63$507.63$51,777.80
000511150 Janitor$15.702000$31,400.000$0.0080080$1,256.002080$32,656.00$4.41$9,172.80$0.00$32,656.00$2,498.18$5.60$783.74$5,646.22$50,762.55$507.63$507.63$51,777.80
000611150 Janitor$15.702000$31,400.001$23.5580080$1,256.002081$32,679.55$4.41$9,172.80$1.00$32,680.55$2,500.06$5.60$784.33$5,650.47$50,793.81$507.94$507.94$51,809.69
000711150 Janitor$15.702000$31,400.002$47.1080080$1,256.002082$32,703.10$4.41$9,172.80$2.00$32,705.10$2,501.94$5.60$784.92$5,654.71$50,825.07$508.25$508.25$51,841.58
000811150 Janitor$15.702000$31,400.003$70.6580080$1,256.002083$32,726.65$4.41$9,172.80$3.00$32,729.65$2,503.82$5.60$785.51$5,658.96$50,856.34$508.56$508.56$51,873.46
000911150 Janitor$15.702000$31,400.005$117.7580080$1,256.002085$32,773.75$4.41$9,172.80$5.00$32,778.75$2,507.57$5.60$786.69$5,667.45$50,918.86$509.19$509.19$51,937.24
001011150 Janitor$15.702000$31,400.007$164.8580080$1,256.002087$32,820.85$4.41$9,172.80$7.00$32,827.85$2,511.33$5.60$787.87$5,675.94$50,981.38$509.81$509.81$52,001.01
001111150 Janitor$15.702000$31,400.009$211.9580080$1,256.002089$32,867.95$4.41$9,172.80$9.00$32,876.95$2,515.09$5.60$789.05$5,684.42$51,043.91$510.44$510.44$52,064.79
001211150 Janitor$15.702000$31,400.0010$235.5080080$1,256.002090$32,891.50$4.41$9,172.80$10.00$32,901.50$2,516.96$5.60$789.64$5,688.67$51,075.17$510.75$510.75$52,096.67
001311150 Janitor$15.702000$31,400.0011$259.0580080$1,256.002091$32,915.05$4.41$9,172.80$11.00$32,926.05$2,518.84$5.60$790.23$5,692.91$51,106.43$511.06$511.06$52,128.56
001411150 Janitor$15.702000$31,400.0012$282.6080080$1,256.002092$32,938.60$4.41$9,172.80$12.00$32,950.60$2,520.72$5.60$790.81$5,697.16$51,137.69$511.38$511.38$52,160.45
001511150 Janitor$15.702000$31,400.0013$306.1580080$1,256.002093$32,962.15$4.41$9,172.80$13.00$32,975.15$2,522.60$5.60$791.40$5,701.40$51,168.96$511.69$511.69$52,192.34
001611150 Janitor$15.702000$31,400.0014$329.7080080$1,256.002094$32,985.70$4.41$9,172.80$14.00$32,999.70$2,524.48$5.60$791.99$5,705.65$51,200.22$512.00$512.00$52,224.22
001711150 Janitor$15.702000$31,400.0015$353.2580080$1,256.002095$33,009.25$4.41$9,172.80$15.00$33,024.25$2,526.36$5.60$792.58$5,709.89$51,231.48$512.31$512.31$52,256.11
001811150 Janitor$15.702000$31,400.0016$376.8080080$1,256.002096$33,032.80$4.41$9,172.80$16.00$33,048.80$2,528.23$5.60$793.17$5,714.14$51,262.74$512.63$512.63$52,288.00
001911150 Janitor$15.702000$31,400.0017$400.3580080$1,256.002097$33,056.35$4.41$9,172.80$17.00$33,073.35$2,530.11$5.60$793.76$5,718.38$51,294.00$512.94$512.94$52,319.88
002011150 Janitor$15.702000$31,400.0018$423.9080080$1,256.002098$33,079.90$4.41$9,172.80$18.00$33,097.90$2,531.99$5.60$794.35$5,722.63$51,325.27$513.25$513.25$52,351.77
002111150 Janitor$15.702000$31,400.0020$471.0080080$1,256.002100$33,127.00$4.41$9,172.80$20.00$33,147.00$2,535.75$5.60$795.53$5,731.12$51,387.79$513.88$513.88$52,415.55
002211150 Janitor$15.702000$31,400.0022$518.1080080$1,256.002102$33,174.10$4.41$9,172.80$22.00$33,196.10$2,539.50$5.60$796.71$5,739.61$51,450.31$514.50$514.50$52,479.32
002311150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
002411150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
002511150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
002611150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
002711150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
002811150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
* If this is H&W hours only are for 2080 if paid in a plan, the prices are not taxable.
** Use this figure to Calculate Added Tax if FB is paid in H&W benefits only.
*** No tax increase is considered on this amount because benefits for H & W are deducted before taxes.
**** Used this figure to calculate added tax if FB are paid in cash to employee.

Page &P

Opt Yr 1

Contract No.:
Contract Title:Lakehurst Custodial
Date:
Instructions:Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act for each CLIN. Round to two decimal places.
Note:The numbers below are a sample. Offerors should propose their rates.
Fringe Benefit AdjustmentTaxes
ABCDEFGHIJKLOQRSTUVWXY
CLINLabor CategoreyHourly Wage RateProductive HoursSubtotalOT HoursSubtotalPaid Vacation and holiday HoursOther CBA-required Paid LeaveTotal Paid non-Productive hoursSubtotalTotal Hours WorkedTotal Gross Annual Wages**Fringe Benefits (FB) Paid "Per Hour"Non Taxable SubtotalAdditional "Cash Payment" of FBTotal " Wages" and "FB Paid in Cash"****% FICACap $7,000 / % FUTINJ Cap 33,500/ %SUTIW/C %Sub TOTALG&AProfitTOTAL (V+W+X)
0.07650.00080.0240.17291%1%
100111150 Janitor$15.702035$31,949.5010$235.5040040$628.002085$32,813.00$4.41$9,150.75$0.00$32,813.00$2,510.19$5.60$787.51$5,673.37$50,940.42$509.40$509.40$51,959.23
100211150 Janitor$15.70200$3,140.000$0.00000$0.00200$3,140.00$4.41$882.00$20.00$3,160.00$241.74$2.51$75.84$546.36$4,908.46$49.08$49.08$5,006.63
100311150 Janitor$15.702000$31,400.000$0.0080080$1,256.002080$32,656.00$4.41$9,172.80$0.00$32,656.00$2,498.18$5.60$783.74$5,646.22$50,762.55$507.63$507.63$51,777.80
100411150 Janitor$15.702000$31,400.000$0.0080080$1,256.002080$32,656.00$4.41$9,172.80$0.00$32,656.00$2,498.18$5.60$783.74$5,646.22$50,762.55$507.63$507.63$51,777.80
100511150 Janitor$15.702000$31,400.001$23.5580080$1,256.002081$32,679.55$4.41$9,172.80$1.00$32,680.55$2,500.06$5.60$784.33$5,650.47$50,793.81$507.94$507.94$51,809.69
100611150 Janitor$15.702000$31,400.002$47.1080080$1,256.002082$32,703.10$4.41$9,172.80$2.00$32,705.10$2,501.94$5.60$784.92$5,654.71$50,825.07$508.25$508.25$51,841.58
100711150 Janitor$15.702000$31,400.003$70.6580080$1,256.002083$32,726.65$4.41$9,172.80$3.00$32,729.65$2,503.82$5.60$785.51$5,658.96$50,856.34$508.56$508.56$51,873.46
100811150 Janitor$15.702000$31,400.005$117.7580080$1,256.002085$32,773.75$4.41$9,172.80$5.00$32,778.75$2,507.57$5.60$786.69$5,667.45$50,918.86$509.19$509.19$51,937.24
100911150 Janitor$15.702000$31,400.007$164.8580080$1,256.002087$32,820.85$4.41$9,172.80$7.00$32,827.85$2,511.33$5.60$787.87$5,675.94$50,981.38$509.81$509.81$52,001.01
101011150 Janitor$15.702000$31,400.009$211.9580080$1,256.002089$32,867.95$4.41$9,172.80$9.00$32,876.95$2,515.09$5.60$789.05$5,684.42$51,043.91$510.44$510.44$52,064.79
101111150 Janitor$15.702000$31,400.0010$235.5080080$1,256.002090$32,891.50$4.41$9,172.80$10.00$32,901.50$2,516.96$5.60$789.64$5,688.67$51,075.17$510.75$510.75$52,096.67
101211150 Janitor$15.702000$31,400.0011$259.0580080$1,256.002091$32,915.05$4.41$9,172.80$11.00$32,926.05$2,518.84$5.60$790.23$5,692.91$51,106.43$511.06$511.06$52,128.56
101311150 Janitor$15.702000$31,400.0012$282.6080080$1,256.002092$32,938.60$4.41$9,172.80$12.00$32,950.60$2,520.72$5.60$790.81$5,697.16$51,137.69$511.38$511.38$52,160.45
101411150 Janitor$15.702000$31,400.0013$306.1580080$1,256.002093$32,962.15$4.41$9,172.80$13.00$32,975.15$2,522.60$5.60$791.40$5,701.40$51,168.96$511.69$511.69$52,192.34
101511150 Janitor$15.702000$31,400.0014$329.7080080$1,256.002094$32,985.70$4.41$9,172.80$14.00$32,999.70$2,524.48$5.60$791.99$5,705.65$51,200.22$512.00$512.00$52,224.22
101611150 Janitor$15.702000$31,400.0015$353.2580080$1,256.002095$33,009.25$4.41$9,172.80$15.00$33,024.25$2,526.36$5.60$792.58$5,709.89$51,231.48$512.31$512.31$52,256.11
101711150 Janitor$15.702000$31,400.0016$376.8080080$1,256.002096$33,032.80$4.41$9,172.80$16.00$33,048.80$2,528.23$5.60$793.17$5,714.14$51,262.74$512.63$512.63$52,288.00
101811150 Janitor$15.702000$31,400.0017$400.3580080$1,256.002097$33,056.35$4.41$9,172.80$17.00$33,073.35$2,530.11$5.60$793.76$5,718.38$51,294.00$512.94$512.94$52,319.88
101911150 Janitor$15.702000$31,400.0018$423.9080080$1,256.002098$33,079.90$4.41$9,172.80$18.00$33,097.90$2,531.99$5.60$794.35$5,722.63$51,325.27$513.25$513.25$52,351.77
102011150 Janitor$15.702000$31,400.0020$471.0080080$1,256.002100$33,127.00$4.41$9,172.80$20.00$33,147.00$2,535.75$5.60$795.53$5,731.12$51,387.79$513.88$513.88$52,415.55
102111150 Janitor$15.702000$31,400.0022$518.1080080$1,256.002102$33,174.10$4.41$9,172.80$22.00$33,196.10$2,539.50$5.60$796.71$5,739.61$51,450.31$514.50$514.50$52,479.32
102211150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
102311150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
102411150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
102511150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
102611150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
102711150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
* If this is H&W hours only are for 2080 if paid in a plan, the prices are not taxable.
** Use this figure to Calculate Added Tax if FB is paid in H&W benefits only.
*** No tax increase is considered on this amount because benefits for H & W are deducted before taxes.
**** Used this figure to calculate added tax if FB are paid in cash to employee.

Opt Yr 2

Contract No.:
Contract Title:Lakehurst Custodial
Date:
Instructions:Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act for each CLIN. Round to two decimal places.
Note:The numbers below are a sample. Offerors should propose their rates.
Fringe Benefit AdjustmentTaxes
ABCDEFGHIJKLOQRSTUVWXY
CLINLabor CategoreyHourly Wage RateProductive HoursSubtotalOT HoursSubtotalPaid Vacation and holiday HoursOther CBA-required Paid LeaveTotal Paid non-Productive hoursSubtotalTotal Hours WorkedTotal Gross Annual Wages**Fringe Benefits (FB) Paid "Per Hour"Non Taxable SubtotalAdditional "Cash Payment" of FBTotal " Wages" and "FB Paid in Cash"****% FICACap $7,000 / % FUTINJ Cap 33,500/ %SUTIW/C %Sub TOTALG&AProfitTOTAL (V+W+X)
0.07650.00080.0240.17291%1%
200111150 Janitor$15.702035$31,949.5010$235.5040040$628.002085$32,813.00$4.41$9,150.75$0.00$32,813.00$2,510.19$5.60$787.51$5,673.37$50,940.42$509.40$509.40$51,959.23
200211150 Janitor$15.70200$3,140.000$0.00000$0.00200$3,140.00$4.41$882.00$20.00$3,160.00$241.74$2.51$75.84$546.36$4,908.46$49.08$49.08$5,006.63
200311150 Janitor$15.702000$31,400.000$0.0080080$1,256.002080$32,656.00$4.41$9,172.80$0.00$32,656.00$2,498.18$5.60$783.74$5,646.22$50,762.55$507.63$507.63$51,777.80
200411150 Janitor$15.702000$31,400.000$0.0080080$1,256.002080$32,656.00$4.41$9,172.80$0.00$32,656.00$2,498.18$5.60$783.74$5,646.22$50,762.55$507.63$507.63$51,777.80
200511150 Janitor$15.702000$31,400.001$23.5580080$1,256.002081$32,679.55$4.41$9,172.80$1.00$32,680.55$2,500.06$5.60$784.33$5,650.47$50,793.81$507.94$507.94$51,809.69
200611150 Janitor$15.702000$31,400.002$47.1080080$1,256.002082$32,703.10$4.41$9,172.80$2.00$32,705.10$2,501.94$5.60$784.92$5,654.71$50,825.07$508.25$508.25$51,841.58
200711150 Janitor$15.702000$31,400.003$70.6580080$1,256.002083$32,726.65$4.41$9,172.80$3.00$32,729.65$2,503.82$5.60$785.51$5,658.96$50,856.34$508.56$508.56$51,873.46
200811150 Janitor$15.702000$31,400.005$117.7580080$1,256.002085$32,773.75$4.41$9,172.80$5.00$32,778.75$2,507.57$5.60$786.69$5,667.45$50,918.86$509.19$509.19$51,937.24
200911150 Janitor$15.702000$31,400.007$164.8580080$1,256.002087$32,820.85$4.41$9,172.80$7.00$32,827.85$2,511.33$5.60$787.87$5,675.94$50,981.38$509.81$509.81$52,001.01
201011150 Janitor$15.702000$31,400.009$211.9580080$1,256.002089$32,867.95$4.41$9,172.80$9.00$32,876.95$2,515.09$5.60$789.05$5,684.42$51,043.91$510.44$510.44$52,064.79
201111150 Janitor$15.702000$31,400.0010$235.5080080$1,256.002090$32,891.50$4.41$9,172.80$10.00$32,901.50$2,516.96$5.60$789.64$5,688.67$51,075.17$510.75$510.75$52,096.67
201211150 Janitor$15.702000$31,400.0011$259.0580080$1,256.002091$32,915.05$4.41$9,172.80$11.00$32,926.05$2,518.84$5.60$790.23$5,692.91$51,106.43$511.06$511.06$52,128.56
201311150 Janitor$15.702000$31,400.0012$282.6080080$1,256.002092$32,938.60$4.41$9,172.80$12.00$32,950.60$2,520.72$5.60$790.81$5,697.16$51,137.69$511.38$511.38$52,160.45
201411150 Janitor$15.702000$31,400.0013$306.1580080$1,256.002093$32,962.15$4.41$9,172.80$13.00$32,975.15$2,522.60$5.60$791.40$5,701.40$51,168.96$511.69$511.69$52,192.34
201511150 Janitor$15.702000$31,400.0014$329.7080080$1,256.002094$32,985.70$4.41$9,172.80$14.00$32,999.70$2,524.48$5.60$791.99$5,705.65$51,200.22$512.00$512.00$52,224.22
201611150 Janitor$15.702000$31,400.0015$353.2580080$1,256.002095$33,009.25$4.41$9,172.80$15.00$33,024.25$2,526.36$5.60$792.58$5,709.89$51,231.48$512.31$512.31$52,256.11
201711150 Janitor$15.702000$31,400.0016$376.8080080$1,256.002096$33,032.80$4.41$9,172.80$16.00$33,048.80$2,528.23$5.60$793.17$5,714.14$51,262.74$512.63$512.63$52,288.00
201811150 Janitor$15.702000$31,400.0017$400.3580080$1,256.002097$33,056.35$4.41$9,172.80$17.00$33,073.35$2,530.11$5.60$793.76$5,718.38$51,294.00$512.94$512.94$52,319.88
201911150 Janitor$15.702000$31,400.0018$423.9080080$1,256.002098$33,079.90$4.41$9,172.80$18.00$33,097.90$2,531.99$5.60$794.35$5,722.63$51,325.27$513.25$513.25$52,351.77
202011150 Janitor$15.702000$31,400.0020$471.0080080$1,256.002100$33,127.00$4.41$9,172.80$20.00$33,147.00$2,535.75$5.60$795.53$5,731.12$51,387.79$513.88$513.88$52,415.55
202111150 Janitor$15.702000$31,400.0022$518.1080080$1,256.002102$33,174.10$4.41$9,172.80$22.00$33,196.10$2,539.50$5.60$796.71$5,739.61$51,450.31$514.50$514.50$52,479.32
202211150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
202311150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
202411150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
202511150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
202611150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
202711150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
* If this is H&W hours only are for 2080 if paid in a plan, the prices are not taxable.
** Use this figure to Calculate Added Tax if FB is paid in H&W benefits only.
*** No tax increase is considered on this amount because benefits for H & W are deducted before taxes.
**** Used this figure to calculate added tax if FB are paid in cash to employee.

Opt Yr 3

Contract No.:
Contract Title:Lakehurst Custodial
Date:
Instructions:Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act for each CLIN. Round to two decimal places.
Note:The numbers below are a sample. Offerors should propose their rates.
Fringe Benefit AdjustmentTaxes
ABCDEFGHIJKLOQRSTUVWXY
CLINLabor CategoreyHourly Wage RateProductive HoursSubtotalOT HoursSubtotalPaid Vacation and holiday HoursOther CBA-required Paid LeaveTotal Paid non-Productive hoursSubtotalTotal Hours WorkedTotal Gross Annual Wages**Fringe Benefits (FB) Paid "Per Hour"Non Taxable SubtotalAdditional "Cash Payment" of FBTotal " Wages" and "FB Paid in Cash"****% FICACap $7,000 / % FUTINJ Cap 33,500/ %SUTIW/C %Sub TOTALG&AProfitTOTAL (V+W+X)
0.07650.00080.0240.17291%1%
300111150 Janitor$15.702035$31,949.5010$235.5040040$628.002085$32,813.00$4.41$9,150.75$0.00$32,813.00$2,510.19$5.60$787.51$5,673.37$50,940.42$509.40$509.40$51,959.23
300211150 Janitor$15.70200$3,140.000$0.00000$0.00200$3,140.00$4.41$882.00$20.00$3,160.00$241.74$2.51$75.84$546.36$4,908.46$49.08$49.08$5,006.63
300311150 Janitor$15.702000$31,400.000$0.0080080$1,256.002080$32,656.00$4.41$9,172.80$0.00$32,656.00$2,498.18$5.60$783.74$5,646.22$50,762.55$507.63$507.63$51,777.80
300411150 Janitor$15.702000$31,400.000$0.0080080$1,256.002080$32,656.00$4.41$9,172.80$0.00$32,656.00$2,498.18$5.60$783.74$5,646.22$50,762.55$507.63$507.63$51,777.80
300511150 Janitor$15.702000$31,400.001$23.5580080$1,256.002081$32,679.55$4.41$9,172.80$1.00$32,680.55$2,500.06$5.60$784.33$5,650.47$50,793.81$507.94$507.94$51,809.69
300611150 Janitor$15.702000$31,400.002$47.1080080$1,256.002082$32,703.10$4.41$9,172.80$2.00$32,705.10$2,501.94$5.60$784.92$5,654.71$50,825.07$508.25$508.25$51,841.58
300711150 Janitor$15.702000$31,400.003$70.6580080$1,256.002083$32,726.65$4.41$9,172.80$3.00$32,729.65$2,503.82$5.60$785.51$5,658.96$50,856.34$508.56$508.56$51,873.46
300811150 Janitor$15.702000$31,400.005$117.7580080$1,256.002085$32,773.75$4.41$9,172.80$5.00$32,778.75$2,507.57$5.60$786.69$5,667.45$50,918.86$509.19$509.19$51,937.24
300911150 Janitor$15.702000$31,400.007$164.8580080$1,256.002087$32,820.85$4.41$9,172.80$7.00$32,827.85$2,511.33$5.60$787.87$5,675.94$50,981.38$509.81$509.81$52,001.01
301011150 Janitor$15.702000$31,400.009$211.9580080$1,256.002089$32,867.95$4.41$9,172.80$9.00$32,876.95$2,515.09$5.60$789.05$5,684.42$51,043.91$510.44$510.44$52,064.79
301111150 Janitor$15.702000$31,400.0010$235.5080080$1,256.002090$32,891.50$4.41$9,172.80$10.00$32,901.50$2,516.96$5.60$789.64$5,688.67$51,075.17$510.75$510.75$52,096.67
301211150 Janitor$15.702000$31,400.0011$259.0580080$1,256.002091$32,915.05$4.41$9,172.80$11.00$32,926.05$2,518.84$5.60$790.23$5,692.91$51,106.43$511.06$511.06$52,128.56
301311150 Janitor$15.702000$31,400.0012$282.6080080$1,256.002092$32,938.60$4.41$9,172.80$12.00$32,950.60$2,520.72$5.60$790.81$5,697.16$51,137.69$511.38$511.38$52,160.45
301411150 Janitor$15.702000$31,400.0013$306.1580080$1,256.002093$32,962.15$4.41$9,172.80$13.00$32,975.15$2,522.60$5.60$791.40$5,701.40$51,168.96$511.69$511.69$52,192.34
301511150 Janitor$15.702000$31,400.0014$329.7080080$1,256.002094$32,985.70$4.41$9,172.80$14.00$32,999.70$2,524.48$5.60$791.99$5,705.65$51,200.22$512.00$512.00$52,224.22
301611150 Janitor$15.702000$31,400.0015$353.2580080$1,256.002095$33,009.25$4.41$9,172.80$15.00$33,024.25$2,526.36$5.60$792.58$5,709.89$51,231.48$512.31$512.31$52,256.11
301711150 Janitor$15.702000$31,400.0016$376.8080080$1,256.002096$33,032.80$4.41$9,172.80$16.00$33,048.80$2,528.23$5.60$793.17$5,714.14$51,262.74$512.63$512.63$52,288.00
301811150 Janitor$15.702000$31,400.0017$400.3580080$1,256.002097$33,056.35$4.41$9,172.80$17.00$33,073.35$2,530.11$5.60$793.76$5,718.38$51,294.00$512.94$512.94$52,319.88
301911150 Janitor$15.702000$31,400.0018$423.9080080$1,256.002098$33,079.90$4.41$9,172.80$18.00$33,097.90$2,531.99$5.60$794.35$5,722.63$51,325.27$513.25$513.25$52,351.77
302011150 Janitor$15.702000$31,400.0020$471.0080080$1,256.002100$33,127.00$4.41$9,172.80$20.00$33,147.00$2,535.75$5.60$795.53$5,731.12$51,387.79$513.88$513.88$52,415.55
302111150 Janitor$15.702000$31,400.0022$518.1080080$1,256.002102$33,174.10$4.41$9,172.80$22.00$33,196.10$2,539.50$5.60$796.71$5,739.61$51,450.31$514.50$514.50$52,479.32
302211150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
302311150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
302411150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
302511150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
302611150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
302711150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
* If this is H&W hours only are for 2080 if paid in a plan, the prices are not taxable.
** Use this figure to Calculate Added Tax if FB is paid in H&W benefits only.
*** No tax increase is considered on this amount because benefits for H & W are deducted before taxes.
**** Used this figure to calculate added tax if FB are paid in cash to employee.

Opt Yr 4

Contract No.:
Contract Title:Lakehurst Custodial
Date:
Instructions:Fill out highlighted areas. Include total hours of all proposed employees covered under the Service Contract Act for each CLIN. Round to two decimal places.
Note:The numbers below are a sample. Offerors should propose their rates.
Fringe Benefit AdjustmentTaxes
ABCDEFGHIJKLOQRSTUVWXY
CLINLabor CategoreyHourly Wage RateProductive HoursSubtotalOT HoursSubtotalPaid Vacation and holiday HoursOther CBA-required Paid LeaveTotal Paid non-Productive hoursSubtotalTotal Hours WorkedTotal Gross Annual Wages**Fringe Benefits (FB) Paid "Per Hour"Non Taxable SubtotalAdditional "Cash Payment" of FBTotal " Wages" and "FB Paid in Cash"****% FICACap $7,000 / % FUTINJ Cap 33,500/ %SUTIW/C %Sub TOTALG&AProfitTOTAL (V+W+X)
0.07650.00080.0240.17291%1%
400111150 Janitor$15.702035$31,949.5010$235.5040040$628.002085$32,813.00$4.41$9,150.75$0.00$32,813.00$2,510.19$5.60$787.51$5,673.37$50,940.42$509.40$509.40$51,959.23
400211150 Janitor$15.70200$3,140.000$0.00000$0.00200$3,140.00$4.41$882.00$20.00$3,160.00$241.74$2.51$75.84$546.36$4,908.46$49.08$49.08$5,006.63
400311150 Janitor$15.702000$31,400.000$0.0080080$1,256.002080$32,656.00$4.41$9,172.80$0.00$32,656.00$2,498.18$5.60$783.74$5,646.22$50,762.55$507.63$507.63$51,777.80
400411150 Janitor$15.702000$31,400.000$0.0080080$1,256.002080$32,656.00$4.41$9,172.80$0.00$32,656.00$2,498.18$5.60$783.74$5,646.22$50,762.55$507.63$507.63$51,777.80
400511150 Janitor$15.702000$31,400.001$23.5580080$1,256.002081$32,679.55$4.41$9,172.80$1.00$32,680.55$2,500.06$5.60$784.33$5,650.47$50,793.81$507.94$507.94$51,809.69
400611150 Janitor$15.702000$31,400.002$47.1080080$1,256.002082$32,703.10$4.41$9,172.80$2.00$32,705.10$2,501.94$5.60$784.92$5,654.71$50,825.07$508.25$508.25$51,841.58
400711150 Janitor$15.702000$31,400.003$70.6580080$1,256.002083$32,726.65$4.41$9,172.80$3.00$32,729.65$2,503.82$5.60$785.51$5,658.96$50,856.34$508.56$508.56$51,873.46
400811150 Janitor$15.702000$31,400.005$117.7580080$1,256.002085$32,773.75$4.41$9,172.80$5.00$32,778.75$2,507.57$5.60$786.69$5,667.45$50,918.86$509.19$509.19$51,937.24
400911150 Janitor$15.702000$31,400.007$164.8580080$1,256.002087$32,820.85$4.41$9,172.80$7.00$32,827.85$2,511.33$5.60$787.87$5,675.94$50,981.38$509.81$509.81$52,001.01
401011150 Janitor$15.702000$31,400.009$211.9580080$1,256.002089$32,867.95$4.41$9,172.80$9.00$32,876.95$2,515.09$5.60$789.05$5,684.42$51,043.91$510.44$510.44$52,064.79
401111150 Janitor$15.702000$31,400.0010$235.5080080$1,256.002090$32,891.50$4.41$9,172.80$10.00$32,901.50$2,516.96$5.60$789.64$5,688.67$51,075.17$510.75$510.75$52,096.67
401211150 Janitor$15.702000$31,400.0011$259.0580080$1,256.002091$32,915.05$4.41$9,172.80$11.00$32,926.05$2,518.84$5.60$790.23$5,692.91$51,106.43$511.06$511.06$52,128.56
401311150 Janitor$15.702000$31,400.0012$282.6080080$1,256.002092$32,938.60$4.41$9,172.80$12.00$32,950.60$2,520.72$5.60$790.81$5,697.16$51,137.69$511.38$511.38$52,160.45
401411150 Janitor$15.702000$31,400.0013$306.1580080$1,256.002093$32,962.15$4.41$9,172.80$13.00$32,975.15$2,522.60$5.60$791.40$5,701.40$51,168.96$511.69$511.69$52,192.34
401511150 Janitor$15.702000$31,400.0014$329.7080080$1,256.002094$32,985.70$4.41$9,172.80$14.00$32,999.70$2,524.48$5.60$791.99$5,705.65$51,200.22$512.00$512.00$52,224.22
401611150 Janitor$15.702000$31,400.0015$353.2580080$1,256.002095$33,009.25$4.41$9,172.80$15.00$33,024.25$2,526.36$5.60$792.58$5,709.89$51,231.48$512.31$512.31$52,256.11
401711150 Janitor$15.702000$31,400.0016$376.8080080$1,256.002096$33,032.80$4.41$9,172.80$16.00$33,048.80$2,528.23$5.60$793.17$5,714.14$51,262.74$512.63$512.63$52,288.00
401811150 Janitor$15.702000$31,400.0017$400.3580080$1,256.002097$33,056.35$4.41$9,172.80$17.00$33,073.35$2,530.11$5.60$793.76$5,718.38$51,294.00$512.94$512.94$52,319.88
401911150 Janitor$15.702000$31,400.0018$423.9080080$1,256.002098$33,079.90$4.41$9,172.80$18.00$33,097.90$2,531.99$5.60$794.35$5,722.63$51,325.27$513.25$513.25$52,351.77
402011150 Janitor$15.702000$31,400.0020$471.0080080$1,256.002100$33,127.00$4.41$9,172.80$20.00$33,147.00$2,535.75$5.60$795.53$5,731.12$51,387.79$513.88$513.88$52,415.55
402111150 Janitor$15.702000$31,400.0022$518.1080080$1,256.002102$33,174.10$4.41$9,172.80$22.00$33,196.10$2,539.50$5.60$796.71$5,739.61$51,450.31$514.50$514.50$52,479.32
402211150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
402311150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
402411150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
402511150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
402611150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
402711150 Janitor$15.702000$31,400.0024$565.2080080$1,256.002104$33,221.20$4.41$9,172.80$24.00$33,245.20$2,543.26$5.60$797.88$5,748.10$51,512.84$515.13$515.13$52,543.09
* If this is H&W hours only are for 2080 if paid in a plan, the prices are not taxable.
** Use this figure to Calculate Added Tax if FB is paid in H&W benefits only.
*** No tax increase is considered on this amount because benefits for H & W are deducted before taxes.
**** Used this figure to calculate added tax if FB are paid in cash to employee.

File details come from the government source that posted it.