104267-21-A-0002-Amendment No.A01-Labor Categories Costs and Overhead.xlsx

XLSX spreadsheet 27 KB Posted Nov 4, 2020

Attached to: Commissioning Services
Solicitation number: 104267-21-A-0002
Issued by: United States Postal Service

View the file

Other files

File	Type	Posted
104267-21-A-0002-Amendment No.A01.pdf	PDF	Nov 4, 2020
104267-21-A-0002-Amendment No.A01-Technical Evaluation Factors.pdf	PDF	Nov 4, 2020
104267-21-A-0002 Commissioning.pdf	PDF	Oct 30, 2020
104267-21-A-0002-Labor Categories Costs and Overhead.xlsx	XLSX spreadsheet	Oct 30, 2020

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.

OverheadProfit Calculations

Overhead Analysis Worksheet	Fill in the blue blocks
Firm Name:	Orange blocks have formulas
Prepared from Income Statement for 12-month period ending:

		Overhead on Direct Labor
1	Direct Labor
2	Vacation, Holidays, Sick Leave
3	Other Fringe Benefits		(3a+3b+3c)	$0.00
	a	Bonus
	b	Retirement/Pension
	c	Profit Plan
4	Health Insurance
5	Payroll Taxes		(4a+4b+4c+4d)	$0.00
	a	FICA
	b	FUTA
	c	SUTA
	d	Other (Specify
6	Subtotal - Overhead on Direct Labor			$0.00
7	Overhead Rate on Direct Labor (6:1)				ERROR:#DIV/0!
8	Other Direct Costs		(8a+8b+8c+8d)	$0.00
	a	Photocopy Printing
	b	Photography
	c	Telephone
	d	Travel
9	Total Cost		(1 + 6 + 8)	$0.00

		General and Administrative Overhead
10	Indirect Labor
11	Overhead on Indirect Labor		(11a+11b+11c+11d)	$0.00
	a	Office Equipment
	b	Other fringe Benefits
	c	Health Insurance
	d	Payroll Taxes
12	Telephone
13	Utilities (Gas, Electric, etc)
14	Accounting by Services
15	Legal Services
16	Profelssional Dues and Licenses
17	Rent and Lease Expense		(17a+17b+17c+17d)	$0.00
	a	Office Equipment
	b	Computers
	c	Automobiles
	d	Building (leased)
	e	Other (specify)
18	Office Supplies - General
19	Professional Periodicals
20	Depreciation Expense		(20a+20b+20c+20d)	$0.00
	a	Office Equpment
	b	Computers
	c	Automobiles
	d	Building (owned)
	e	Other (specify)
21	Insurance Expense		(21a+21b+21c+21d)	$0.00
	a	Professional Liability
	b	Comprehensive and Fire
	c	Automobiles
22	Reproduction (printing, maps, photos)
23	Auto Expenses
24	Postage and Express
25	Education Expense
26	State and Local Taxes
27	Travel		(27a+27b+27c+27d)	$0.00
	a	Employees
	b	Executives
	c	Conference/Seminars
28	Employee Relocation
29	Computer and Administrative Services
30	Repairs and Maintenance - Buildings
31	Miscellaneous Expenses		(31a+31b+31c+31d)	$0.00
	a	Technical Supplies
	b	Business License Fees
	c	Professional License Fees
	d	Temporary Service Employees
	e	Other (specify)
32	Subtotal: G&A Overhead		(11 thru 31)	$0.00
33	Grand Total Expense		(6+32)	$0.00
34	G&A Overhead Rate (32:1)				ERROR:#DIV/0!
35	Combined Overhead Rate (7+34)				ERROR:#DIV/0!

Rates

Firm		Contract #
Schedule - Classification Of Personnel:		Proposeded Rates
Item #	Brief Name of Discipline	Base Rate $ per Hour	OH %	Profit %	Contract Rate - $ Per Hour
1	Principal				$0.00
2	Project Manager				$0.00
3	Architect SR				$0.00
4	Architect JR				$0.00
5	Electrical Engineer SR				$0.00
6	Electrical Engineer JR				$0.00
7	Mechanical Engineer SR				$0.00
8	Mechanical Engineer JR				$0.00
9	Structural Engineer SR				$0.00
10	Structural Engineer JR				$0.00
11	Civil Engineer SR				$0.00
12	Civil Engineer JR				$0.00
13	Designer				$0.00
14	Drafting				$0.00
15	CAD Operator				$0.00
16	Construction Cost Estimator				$0.00
17	Specification Writer				$0.00
18	Construction Inspector				$0.00
19	Typist/Office Administrative				$0.00

Schedule - Direct Expenses:		Proposed Rates
Item #	Brief Name of Expense	Cost
1	Vehicle Travel to and from Project (beyond 50 miles round trip)	GSA rate per Mile
2	Telephone, Taxi, Parking, etc.	at Cost
3	Photocopy	$0. per Each
4	Blueprinting	$0. per sqft
5	Per Diem	GSA rate per Day
6	Lodging	GSA rate per Night
	* Drawings printed for the A/E internal review
	are included as a cost of business and are
	not an acceptable reimbursable cost.
See notes next page.

Hourly Rates:

The hourly rates may be subject to revision every option period. Any increase or decrease in the rates will be based on the changes in the "National Consumer Price Index for the Urban Wage Earners and Clerical Workers" (US City Average) using the expenditure category "All Items" for the previous (12 month) year; and/or based on the results of audit(s) of the A/E firms records by the Postal Inspection Service.

Overhead Rates:

The overhead rate may be subjected to audit(s) by the USPS at the discretion of the Contracting Officer. If determined reasonable, the overhead rate will be subject to downward adjustment only upon such audits.

Travel and Subsistence:

Reimbursement for subsistence (food and lodging) during USPS authorized travel will be paid in the manner and to the extend provided by regulations applicable to USPS employees (Travel & Relocation Handbook F-15). All travel expenses shall be supported by actual invoices. Air travel shall be by second-class (coach) to be billed at cost with no mark-up.

Subcontracts:

Subcontracts such as land surveying, soil drilling, laboratory, and field testing will be reimbursed at cost plus 10% markup for handling. For work performed by the design team under contract, including consultants, there will be no percentage mark-up.

File details come from the government source that posted it. Updated Nov 4, 2020.