Attachment H HOOH and FOOH Analysis Form.xlsx

XLSX spreadsheet 28 KB Posted

Attached to
NORTHWEST MULTIPLE AWARD CONSTRUCTION CONTRACT (NW MACC) Federal contract opportunity
Solicitation number
N4425521R4000
Issued by
Department of the Navy Naval Facilities Engineering Command

About this file

Written by GovTribe AI ·

This document contains a template for analyzing home office overhead and field office overhead costs for a federal contractor.

The home office overhead template provides an example format for contractors to project and report allowable indirect expenses from their general ledger and financial statements. It includes prior year actual expenses in the same format and notes the requirements to classify costs based on FAR Part 31 criteria and make supporting documentation available upon request. The field office overhead template similarly provides an example format for contractors to report allowable field office indirect costs and calculate rates using percentage of direct costs, daily rate, or alternate methods from the FAR. Contractors must customize the templates to their own indirect cost structures but should not duplicate direct contract costs or costs already captured in other indirect pools like home office overhead.

View the file

Other files for this federal contract opportunity

Other files attached to NORTHWEST MULTIPLE AWARD CONSTRUCTION CONTRACT (NW MACC), newest first.
File Type Posted
21R4000_Amend 0013_8.11.22.pdf PDF
Amendment 0012_JL.pdf PDF
SF30_Amend_0010.pdf PDF
21R4000_Amend 0009_6.21.22.pdf PDF
21R4000_Amend_0008_06.15.22.pdf PDF
Attach 1_PPI Response Sheet.pdf PDF
21R4000_Amend_0006_6.01.22.pdf PDF
Attach 2_PPI Response Sheet.pdf PDF
Attach 1_GSA 60 day Extension01.PNG PNG image
Attachment G Financial Questionnaire Form01.docx DOCX document
21R4000_RFP_Amend 0004.pdf PDF
Attach 1_PPI Response Spreadsheet.pdf PDF
21R4000_Amend_0003_5.20.22.pdf PDF
Attach 3_pre_proposal conference attendees.pdf PDF
Attach 4_NW MACC PreProposal Conf.pdf PDF
Attach K Safety Data Sheet Safety Narrative.docx DOCX document
Attach 2_PPI Response Spreadsheet.pdf PDF
Attach 1_GSA 60 day Extension.PNG PNG image
Attach L_PPI Form.doc DOC document
Attach 01 PPI Response Sheet.pdf PDF
Attachment J Task Order Editable Clauses and Provisions.docx DOCX document
Attachment D PPQ Design Experience.docx DOCX document
Attachment A PIEE Vendor Access Instructions.pdf PDF
Attachment I Post Award Contractors Limitations Subcontracting SB Cert.doc DOC document
Attachment C Construction Design Experience Data Sheet.docx DOCX document
Attachment G Financial Questionnaire Form.docx DOCX document
Attachment E SB Subcontracting Record.docx DOCX document
Attachment B Offeror Team Composition Management.docx DOCX document
21R4000_Amend0002.pdf PDF
Attachment D PPQ Construction Experience.docx DOCX document
Attachment H HOOH and FOOH Analysis Form.xlsx XLSX spreadsheet
Attachment F SB Participation.docx DOCX document
Attachment G Surety Form.docx DOCX document
21R4000_Amend-0001.pdf PDF
Attachment 1 PPI Form.doc DOC document
Attachment 2 PPI Response Spreadsheet.pdf PDF
N4425521R4000 RFP_Final.pdf PDF
Attachment E2 Financial Questionnaire Form.docx DOCX document
Attachment K SB Participation.docx DOCX document
Attachment E1 Surety Form.docx DOCX document
Attachment B Construction Design Experience Data Sheet.docx DOCX document
Attachment C2 PPQ Design Experience.docx DOCX document
Attachment D Safety Data Sheet Safety Narrative.docx DOCX document
Attachment J Post Award Limitation on Subcontracting Certif.doc DOC document
Attachment G PIEE Vendor Access Instructions.pdf PDF
Attachment C1 PPQ Construction Experience.docx DOCX document
Attachment A Offeror Team Composition Management.docx DOCX document
Attachment M Task Order Editable Clauses and Provisions.docx DOCX document
Attachment L SB Subcontracting Record.docx DOCX document
Attachment F PPI Form.doc DOC document
Show all 50

NORTHWEST MULTIPLE AWARD CONSTRUCTION CONTRACT (NW MACC) has more files on GovTribe.

On GovTribe

Work with this file on GovTribe

  • 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.

HOOH Example

Home Office OverheadPOOL and BASE format for projected/actual Indirect Expenses. This Spreadsheet represents typical structure for G&A (aka Home Office Overhead). Modify this form as applicable for other Indirect Expenses.
DescriptionProjected Expenses 2019Adjustments/Unallowable Per FAR 31.2052019 Net Allowable ExpensesUnallowable FAR ReferenceActual / Annualized Expenses 2018Actual/Annualized Expenses
FY 2017FY2016FY2015
Accounting Fees (Outside Auditor)$26,096$0$26,096$0$24,598$23,882$23,186
Advertising$3,125$3,125$031.205-1$3,034$2,945$2,859$2,776
Depreciation and Amortization$336,133$0$336,133$326,342$316,837$307,609$298,650
Donations and Contributions$86,320$86,320$031.205-8$83,806$81,365$78,995$76,694
Dues & Subscriptions$9,754$0$9,754$9,470$9,195$8,927$8,667
Education$5,446$0$5,446$5,287$5,133$4,984$4,839
Fines and Penalties$37,449$37,449$021.205-15$36,358$35,299$34,271$33,273
IndirectEquipment$24,677$0$24,677$23,958$23,261$22,583$21,925
Indirect Materials$1,538$0$1,538$1,493$1,450$1,408$1,367
Indirect Other$2,623$0$2,623$2,546$2,472$2,400$2,330
Interest and Other Financial Costs$122,575$122,575$031.205-20$120,123$111,714$103,894$96,622
Insurance - Employee Health$199,806$199,806$193,986$188,336$182,851$177,525
Insurance - Liability$152,746$152,746$148,297$143,977$139,784$135,712
Licenses and Permits$3,214$3,214$3,120$3,029$2,941$2,855
Meals and Entertainment$18,401$18,401$031.205-14$17,865$17,345$16,839$16,349
Officers' Salaries$146,316$146,316$142,055$137,917$133,900$130,000
Office Expense$2,958$2,958$2,872$2,789$2,707$2,629
Office Supplies$13,000$13,000$12,621$12,254$11,897$11,550
Professional and Consulting Services$8,676$8,676$031.205-33$8,423$8,178$7,940$7,709
Payroll Taxes$36,161$36,161$41,673$40,459$39,281$38,137
Pension, Retirement$272,181$0$272,181$264,254$256,557$249,084$241,830
Postage$9,222$0$9,222$8,954$8,693$8,440$8,194
Property Tax$23,024$0$23,024$22,353$21,702$21,070$20,456
Rental Costs$394,544$0$394,544$383,052$371,895$361,063$350,547
Repair and Maintenance$15,644$0$15,644$15,188$14,746$14,316$13,899
Salaries and Wages (indirect employees)$305,698$0$305,698$296,794$288,150$279,757$271,609
Tax - Other$56,443$0$56,443$54,799$53,203$51,664$50,149
Tax - Use$0$0$0$0$0$0$0
Telephone and Communication$49,607$0$49,607$48,162$46,760$45,398$44,075
Utlities$26,797$0$26,797$26,017$25,259$24,523$23,809
Other Expenses$2,599$0$2,599$2,524$2,450$2,379$2,309
$0
Total G&A (Home Office Overhead) Pool$2,392,773$276,546$2,116,227$2,305,426$2,257,968$2,187,646$2,119,672
G&A Base (Cost of Sales / Total Cost Input)New Contract
Direct Labor (including applicable Fringe and Overhead)$ 10,009,345$ 969,032$ 10,978,377$10,649,025$10,116,574$9,914,243$9,815,100
Direct Materials (including mark-ups)$ 13,212,335$ 133,622$ 13,345,957$12,945,578$12,298,299$12,052,333$11,931,810
Equipment Costs$ 2,402,243$ 15,000$ 2,417,243$2,344,725$2,227,489$2,182,939$2,161,110
Subcontract Costs$ 8,007,476$ 400,532$ 8,408,008$8,155,768$7,747,979$7,593,020$7,517,089
Other Direct Costs$ 800,748$ 200,532$ 1,001,280$971,241$922,679$904,226$895,183
Cost of Sales (Total Cost Input Base)$ 34,432,147$ 1,718,718$ 36,150,865$35,066,337$33,313,020$32,646,761$32,320,292

Prime or Subcontractor HOOH Rate 6.95% 5.85% 6.6% 6.8% 6.7% 6.6%

Notes:
1. All costs claimed should be classified based on consideration of the criteria in FAR Part 31. The citations shown here are for reference purposes only and are not meant to be all inclusive.
2. The budgeted G&A (or Home Office Overhead) expenses should be based on the company's budget for the upcoming fiscal year with supporting documentation available immediately upon request.
3. Provide the prior three year's actual G&A (or Home Office Overhead) expenses, excluding unallowable costs, and the allocation base in the same format as the upcoming fiscal year budgeted G&A. These expenses should be based on the company's general ledger and/or financial statements. For FY10, please include actuals or actuals/estimates (depending on your fiscal year).
4. All Unallowable Expenses Remain in Base
5. By submission of this HOOH worksheet and any back-up information, the contractor acknowledges the requirements
FAR 52.204-10 Reporting Executive Compensation and First-Tier Subcontract Award clause of their contract and meets the
the FAR Part 31 including Executive Compensation outlined in FAR 31.205-6.

&"Times New Roman,Bold"ATTACHMENT 2-1

HOME OFFICE OVERHEAD (HOOH) ANALYSIS FORM

Enclosure (2)

HOOH Blank -Contractor Complete

Home Office OverheadPOOL and BASE format for projected/actual Indirect Expenses. This Spreadsheet represents typical structure for G&A (aka Home Office Overhead). Modify this form as applicable for other Indirect Expenses.
DescriptionProjected Expenses 2019Adjustments/Unallowable Per FAR 31.2052019 Net Allowable ExpensesUnallowable FAR ReferenceActual / Annualized Expenses 2018Actual/Annualized Expenses
FY 2020FY2019FY2018
Accounting Fees (Outside Auditor)$0$0$0$0$0$0$0
Advertising$0$0$031.205-1$0$0$0$0
Depreciation and Amortization$0$0$0$0$0$0$0
Donations and Contributions$0$0$031.205-8$0$0$0$0
Dues & Subscriptions$0$0$0$0$0$0$0
Education$0$0$0$0$0$0$0
Fines and Penalties$0$0$021.205-15$0$0$0$0
IndirectEquipment$0$0$0$0$0$0$0
Indirect Materials$0$0$0$0$0$0$0
Indirect Other$0$0$0$0$0$0$0
Interest and Other Financial Costs$0$0$031.205-20$0$0$0$0
Insurance - Employee Health$0$0$0$0$0$0$0
Insurance - Liability$0$0$0$0$0$0$0
Licenses and Permits$0$0$0$0$0$0$0
Meals and Entertainment$0$0$031.205-14$0$0$0$0
Officers' Salaries$0$0$0$0$0$0$0
Office Expense$0$0$0$0$0$0$0
Office Supplies$0$0$0$0$0$0$0
Professional and Consulting Services$0$0$031.205-33$0$0$0$0
Payroll Taxes$0$0$0$0$0$0$0
Pension, Retirement$0$0$0$0$0$0$0
Postage$0$0$0$0$0$0$0
Property Tax$0$0$0$0$0$0$0
Rental Costs$0$0$0$0$0$0$0
Repair and Maintenance$0$0$0$0$0$0$0
Salaries and Wages (indirect employees)$0$0$0$0$0$0$0
Tax - Other$0$0$0$0$0$0$0
Tax - Use$0$0$0$0$0$0$0
Telephone and Communication$0$0$0$0$0$0$0
Utlities$0$0$0$0$0$0$0
Other Expenses$0$0$0$0$0$0$0

Total G&A (Home Office Overhead) Pool $0 $0 $0 $0 $0 $0 $0

G&A Base (Cost of Sales / Total Cost Input)New Contract
Direct Labor (including applicable Fringe and Overhead)$0$0$0$0$0$0$0
Direct Materials (including mark-ups)$0$0$0$0$0$0$0
Equipment Costs$0$0$0$0$0$0$0
Subcontract Costs$0$0$0$0$0$0$0
Other Direct Costs$0$0$0$0$0$0$0
Cost of Sales (Total Cost Input Base)$0$0$0$0$0$0$0

Prime or Subcontractor HOOH Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Notes:
1. All costs claimed should be classified based on consideration of the criteria in FAR Part 31. The citations shown here are for reference purposes only and are not meant to be all inclusive.
2. The budgeted G&A (or Home Office Overhead) expenses should be based on the company's budget for the upcoming fiscal year with supporting documentation available immediately upon request.
3. Provide the prior three year's actual G&A (or Home Office Overhead) expenses, excluding unallowable costs, and the allocation base in the same format as the upcoming fiscal year budgeted G&A. These expenses should be based on the company's general ledger and/or financial statements. For FY10, please include actuals or actuals/estimates (depending on your fiscal year).
4. All Unallowable Expenses Remain in Base
5. By submission of this HOOH worksheet and any back-up information, the contractor acknowledges the requirements
FAR 52.204-10 Reporting Executive Compensation and First-Tier Subcontract Award clause of their contract and meets the
the FAR Part 31 including Executive Compensation outlined in FAR 31.205-6.

&"Times New Roman,Bold"ATTACHMENT 2-1

HOME OFFICE OVERHEAD (HOOH) ANALYSIS FORM

Enclosure (2)

HOOH Chart

Account TitleFAR Reference
A=Allowable

UA=Unallowable

AWR=Allowable w/RestrictionsAccount TitleFAR Reference
A=Allowable

UA=Unallowable AWR=Allowable w/Restrictions

Accounting Fees (Outside Auditor)31.205-33Office Supplies
Advertising31.205-1UA, AWROrganization Costs31.205-27UA
Alcoholic Beverages31.205-51UAOther Business Expense31.205-28A
Asset Valuations Resulting from Business Combinations31.205-52AWRPatent Costs31.205-30A, UA, AWR
Backpay31.205-6UA, AWRPayroll Taxes31.205-41
Bad Debts31.205-3UAPension, Retirement31.205-6UA, AWR
Bonding Costs31.205-4APlant Protection31.205-29A
Bonuses and Incentives31.205-6AWRPlant Reconversion Costs31.205-31UA, AWR
Compensation for Personal Services31.205-6A, UA, AWRPostage
Contingencies31.205-7A, UAPrecontract Costs31.205-32AWR
Contributions and Donations31.205-8UAPrincipal Salaries (Indirect)31.205-6
Cost of Money31.205-10AWRProfessionals (Outside Legal) and Consultants31.205-33A, UA, AWR
Depreciation31.205-11AWRPublic Relations31.205-1UA, AWR
Dues - Professional Organizations31.205-43Recruitment Costs31.205-34A, UA, AWR
Economic Planning31.205-12A, UARelocation Costs31.205-35A, UA, AWR
Employee Morale, Health, Welfare, Food Service and Dormitory31.205-13A, AWRRental Costs31.205-36A, AWR
Entertainment i.e. Memberships in Social, Dining or Country Clubs etc.31.205-14UARepair and Maintenance31.105
Fines and Penalties31.205-15UA, AWRResearch & Development Costs (Deferred/Excess)31.205-48UA, AWR
Fringe Benefits i.e. Vacations, Sick Leave, Holidays, Military Leave, Employee Insurance and supplemental Unemployment Benefit Plans31.205-6AWRRoyalties & Other Costs for Use of Patents31.205-37AWR
Gains and Losses of Depreciable Property31.205-16Selling Costs31.205-38A, UA
Goodwill31.205-49UAService and Warranty Costs31.205-39A
Idle Facilities and Capacity31.205-17UA, AWRSeverance Pay31.205-6AWR
Independent Research and Development and Bid and Proposal31.205-18A, AWRSpecial Tooling & Special Test Equip Costs31.205-40AWR
Insurance and Indemnification31.205-19A, UA. AWRSubscriptions and periodicals31.205-43
Interest31.205-20UA, AWRTaxes (Income, other)31.205-41A, UA
Labor Relations31.205-21ATech Personnel Salaries (Indirect)31.205-6
Legal & Other Proceeding Costs31.205-47UA, AWRTelephone
Lobbying & Political Activity Costs31.205-22UA, AWRTermination Costs31.205-42A, AWR
Losses on Other Contracts31.205-23UATrade/Business/Technical/Professional Activity costs31.205-43A, AWR
Manufacturing & Production Engineering Costs31.205-25ATraining31.205-44A, UA, AWR
Material Costs31.205-26ATravel31.205-46AWR
Office Rent31.205-36Typing, Filing (Indirect)31.205-6
Utilities

FOOH Example Field Office Overhead (FOOH):

Percentage, Daily Rate (Per Diem) and NAVFAC Alternate Methods Examples are based on FAR 31.105(d)(3). Customize to actual FOOH but do not duplicate costs from direct contract costs or other indirect costs such as HOOH.

Description Projected Expense

Project Manager (Divide time if not Fulltime on project)$35,000
Quality Control Manager$65,000
SSHO$60,000
Site Supervisor$90,000
Engineering/Shop Drawings/Surveys$22,193
Site Survey$12,968
Field Office (temporary facilities, utilities, maintenance)$6,181
Temporary material storage$6,973
Equipment for material handling$3,136
prepartory work and laboratory testing$983
Vehicles (not personal use)$3,797
janitorial services and/or supplies$859
field office supplies$57
scheduling, reports, including updates and changes$5,194
temporary protection and OSHA$135
Telephone and communications$2,243
Permits and Licenses$2,404
Insurance (project coverage) including builders risk and general liability$6,878
small tools$3,637
Quality Control$4,802
Site Cleanup$961
Estimating Tools$547
Taxes (if not direct charged on proposals)$1,190
Equipment costs not chargeable to specific task$4,581
operation and maintenance of temporary job-site facilities$1,526
portable toilets$5,328
bottled water$890
office internet/fax$1,107
dumpsters$5,535
safety barricades$830
TOTAL POOL$354,935
Percentage Method
CONTRACT DIRECT COSTS$3,691,498
Percentage Method9.61%
Receive Percentage Method on all modifications
Back up documentation may be required to substantiate rate
Daily Rate Method
Total Pool$356,934
Total Contract or Task Order Days300
Receive daily rate only on modifications with compensable days$1,190
Back up documenation may be required to substantiate rate
NAVFAC ALTERNATE Method
10% Field Office, 5% Subcontractor Management, 3% HOOH10% / 5% / 3%
Receive all percentages on all modifications
No back-up documentation is required to substantiate rate

FOOH Blank -Contractor Complete Field Office Overhead (FOOH):

Percentage, Daily Rate (Per Diem) and NAVFAC Alternate Methods Examples are based on FAR 31.105(d)(3). Customize to actual FOOH but do not duplicate costs from direct contract costs or other indirect costs such as HOOH.

Description Projected Expense

Project Manager (Divide time if not Fulltime on project)$0
Quality Control Manager$0
SSHO$0
Site Supervisor$0
Engineering/Shop Drawings/Surveys$0
Site Survey$0
Field Office (temporary facilities, utilities, maintenance)$0
Temporary material storage$0
Equipment for material handling$0
prepartory work and laboratory testing$0
Vehicles (not personal use)$0
janitorial services and/or supplies$0
field office supplies$0
scheduling, reports, including updates and changes$0
temporary protection and OSHA$0
Telephone and communications$0
Permits and Licenses$0
Insurance (project coverage) including builders risk and general liability$0
small tools$0
Quality Control$0
Site Cleanup$0
Estimating Tools$0
Taxes (if not direct charged on proposals)$0
Equipment costs not chargeable to specific task$0
operation and maintenance of temporary job-site facilities$0
portable toilets$0
bottled water$0
office internet/fax$0
dumpsters$0
safety barricades$0
TOTAL POOL$0
Percentage Method
CONTRACT DIRECT COSTS$0
PercentageERROR:#DIV/0!
Receive Percentage Method on all modifications
Back-up documentation may be required to substantiate rate
Daily Rate Method
Total Pool$0
Total Contract or Task Order Days0
Receive daily rate only on modifications with compensable daysERROR:#DIV/0!
Back-up documenation may be required to substantiate rate
NAVFAC ALTERNATE Method
10% Field Office, 5% Subcontractor Management, 3% HOOH10% / 5% / 3%
Receive all percentages on all modifications
No back-up documentation is required to substantiate rate

File details come from the government source that posted it. Updated .