36C78619Q0038-003.xlsx

XLSX spreadsheet 19 KB Posted Oct 3, 2018

Attached to: Trimming and Edging Services for Memphis National Cemetery.
Solicitation number: 36C78619Q0038
Issued by: Department of Veterans Affairs National Cemetery Administration

About this file

From the source

36C78619Q0038 S02_Attachment-C_Labor Rate Worksheet.xlsx

View the file

Other files

File	Type	Posted
36C78619C0016-000.docx	DOCX document	Nov 28, 2018
36C78619Q0038-0001000.docx	DOCX document	Oct 23, 2018
36C78619Q0038-0001001.pdf	PDF	Oct 23, 2018
36C78619Q0038-001.pdf	PDF	Oct 3, 2018
36C78619Q0038-000.docx	DOCX document	Oct 3, 2018
36C78619Q0038-004.pdf	PDF	Oct 3, 2018
36C78619Q0038-002.pdf	PDF	Oct 3, 2018

On GovTribe

Work with this file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Worksheet

1. Please reference the current U.S. Dept. of Labor Wage Determination and identify the Occupation Code and Occupation Title for each labor category that will be used to accomplish the work described in the Performance Work Statement (PWS). This table may be expanded or enlarged if more room is needed.

2. Complete one worksheet for the base period, and one for each option period, specifying the Period of Performance (POP) and Base/Option Period number on each worksheet.

3. Fill-in the Occupation Code and Title at the top of each column. Expand table as needed to add additional labor categories.

4. For each Occupation, fill-in the Base Hourly Wage Rate (a) and Health & Welfare amount (b) paid to employees. Enter all amounts as hourly rates.

Please check ONE of the following:

___ Health & Welfare is paid to employees as a cash benefit included in each paycheck.

___ Health & Welfare amount is applied to the premium of an employer-provided health insurance plan.

(In the table below, enter the LESSER OF THESE AMOUNTS: the Health & Welfare amount OR the actual health insurance premium amount.)

5. Calculate Direct Labor Rate (d) by adding together all amounts for (a), (b) and (c).

6. For each labor category, enter the annual number of labor hours (e) required to accomplish the work described in the Transportation Motor Pool Statement of Objectives.

7. Calculate Total Direct Labor (f) for each column by multiplying (d) x (e).

8. Calculate Total Annual Direct Labor (g) by adding together all column total amounts for Total Direct Labor (f).

9. Calculate Total Annual Amount (k) by adding together (g), (h), (i) and (j).

Base Period:_________________ POP:____April- September__________________________________________ Peak Growning Season

Wage Determination Codes	(Code)	(Code)	(Code)	(Code)	(Code)	(Code)
Position Titles	(Title)	(Title)	(Title)	(Title)	(Title)	(Title)
a. Base Wage Rate (Hourly)
b. Health & Welfare (Hourly)
c. Payroll Taxes:
(1)____________________ ____%
(2)____________________ ____%
(3)____________________ ____%
(4)____________________ ____%
(5)____________________ ____%
(6)____________________ ____%
d. Direct Labor Rate
e. Annual Number of Labor Hours
f. Total Direct Labor							TOTALS
g. Total Annual Direct Labor	Enter G&A % Below						$ - 0
h. G&A Rate/ enter %	%						ERROR:#VALUE!
Total	Enter Overhead % Below						ERROR:#VALUE!
i. Overhead/ enter %	%						ERROR:#VALUE!
Total	Enter Profit % Below						ERROR:#VALUE!
j. Fee/Profit/ enter %	%						ERROR:#VALUE!
k. Total Annual Amount							ERROR:#VALUE!

Add and remove items as needed
Service Supply Items (List supplies below)	Annual Costs
Trash Bags
Trimmers/Trim String

Grand Total ERROR:#VALUE!

Total	$ - 0
Safety Equipment (List safety items below)	Annual Costs
Eye Protection
Ear Protection

Toatl	$ - 0
Combined Totals	$ - 0
Base Period:_________________ POP:______________________________________________		December-March	Dormant Season

Wage Determination Codes	(Code)	(Code)	(Code)	(Code)
Position Titles	(Title)	(Title)	(Title)	(Title)
a. Base Wage Rate (Hourly)
b. Health & Welfare (Hourly)
c. Payroll Taxes:
(1)____________________ ____%
(2)____________________ ____%
(3)____________________ ____%
(4)____________________ ____%
(5)____________________ ____%
(6)____________________ ____%
d. Direct Labor Rate
e. Annual Number of Labor Hours
f. Total Direct Labor					TOTALS
g. Total Annual Direct Labor	Enter G&A % Below				$ - 0
h. G&A Rate/ enter %	%				ERROR:#VALUE!
Total	Enter Overhead % Below				ERROR:#VALUE!
i. Overhead/ enter %	%				ERROR:#VALUE!
Total	Enter Profit % Below				ERROR:#VALUE!
j. Fee/Profit/ enter %	%				ERROR:#VALUE!
k. Total Annual Amount					ERROR:#VALUE!
Add and remove items as needed
Service Supply Items (List supplies below)	Annual Costs
Trash Bags
Trimmers/Trim String

Grand Total ERROR:#VALUE!

Total	$ - 0
Safety Equipment (List safety items below)	Annual Costs
Eye Protection
Ear Protection

Toatl	$ - 0
Combined Totals	$ - 0
Option Periods:_________________ POP:______________________________________________		October through March	Dormant Season

Wage Determination Codes	(Code)	(Code)	(Code)	(Code)
Position Titles	(Title)	(Title)	(Title)	(Title)
a. Base Wage Rate (Hourly)
b. Health & Welfare (Hourly)
c. Payroll Taxes:
(1)____________________ ____%
(2)____________________ ____%
(3)____________________ ____%
(4)____________________ ____%
(5)____________________ ____%
(6)____________________ ____%
d. Direct Labor Rate
e. Annual Number of Labor Hours
f. Total Direct Labor					TOTALS
g. Total Annual Direct Labor	Enter G&A % Below				$ - 0
h. G&A Rate/ enter %	%				ERROR:#VALUE!
Total	Enter Overhead % Below				ERROR:#VALUE!
i. Overhead/ enter %	%				ERROR:#VALUE!
Total	Enter Profit % Below				ERROR:#VALUE!
j. Fee/Profit/ enter %	%				ERROR:#VALUE!
k. Total Annual Amount					ERROR:#VALUE!
Add and remove items as needed
Service Supply Items (List supplies below)	Annual Costs
Trash Bags
Trimmers/Trim String

Grand Total ERROR:#VALUE!

Total	$ - 0
Safety Equipment (List safety items below)	Annual Costs
Eye Protection
Ear Protection

Toatl	$ - 0
Combined Totals	$ - 0
Option Periods:_________________ POP:______________________________________________		April through September	Peak Season

Wage Determination Codes	(Code)	(Code)	(Code)	(Code)	(Code)	(Code)
Position Titles	(Title)	(Title)	(Title)	(Title)	(Title)	(Title)
a. Base Wage Rate (Hourly)
b. Health & Welfare (Hourly)
c. Payroll Taxes:
(1)____________________ ____%
(2)____________________ ____%
(3)____________________ ____%
(4)____________________ ____%
(5)____________________ ____%
(6)____________________ ____%
d. Direct Labor Rate
e. Annual Number of Labor Hours
f. Total Direct Labor							TOTALS
g. Total Annual Direct Labor	Enter G&A % Below						$ - 0
h. G&A Rate/ enter %	%						ERROR:#VALUE!
Total	Enter Overhead % Below						ERROR:#VALUE!
i. Overhead/ enter %	%						ERROR:#VALUE!
Total	Enter Profit % Below						ERROR:#VALUE!
j. Fee/Profit/ enter %	%						ERROR:#VALUE!
k. Total Annual Amount							ERROR:#VALUE!
Add and remove items as needed
Service Supply Items (List supplies below)	Annual Costs
Trash Bags
Trimmers/Trim String

Grand Total ERROR:#VALUE!

Total	$ - 0
Safety Equipment (List safety items below)	Annual Costs
Eye Protection
Ear Protection

Toatl	$ - 0
Combined Totals	$ - 0

&"Times New Roman,Bold"&12Labor Rate Worksheet &"Times New Roman,Regular"&12W911RZ-07-R-0007 Attachment 4

&"Times New Roman,Regular"&12Page &P of &N

Sheet1

File details come from the government source that posted it.