Attachment_E-_Accounting_Data_Spreadsheet.xlsx

XLSX spreadsheet 19 KB Posted

Attached to
Waterfront Multiple Award Construction Contract (MACC) Federal contract opportunity
Solicitation number
N44255-18-R-5004
Issued by
Department of the Navy Naval Facilities Engineering Command

About this file

Written by GovTribe AI ·

This document contains an accounting data spreadsheet template and details of a federal solicitation opportunity. The spreadsheet template lists various general and administrative expense account titles and their allowability status according to FAR references. It appears to be a blank template for contractors to populate with budgeted and actual expense data for indirect cost rate proposals.

The related federal solicitation is for a multiple award construction contract with the Department of the Navy Naval Facilities Engineering Command. No other details of the required construction products or services are provided in the solicitation description. The response and award dates are also not included.

From the source

Accounting Data Spreadsheet

View the file

Other files for this federal contract opportunity

Other files attached to Waterfront Multiple Award Construction Contract (MACC), newest first.
File Type Posted
N44255-18-R-5004_conformed_through_amendment_0004.pdf PDF
N44255-18-R-5004_Amendment_0004.pdf PDF
N44255-18-R-5004_PPI_Log.pdf PDF
N44255-18-R-5004_Amendment_0003.pdf PDF
Attachment_I_-_PPI_Log.pdf PDF
N44255-18-R-5004_Amendment_0002.pdf PDF
18-R-5004_Conformed_through_Amendment_0002.pdf PDF
Attachment_G_-_SB__SUB_RECORD.doc DOC document
Attachment_H-_SB_Participation_Strategy.doc DOC document
Attachment_C.2_PPQ_Design_Experience.docx DOCX document
Attachment_B_-__Construction_and_Design_Experience_Data_Sheet.docx DOCX document
Attachment_D-_Change_Order_Markup_Evaluation.xlsx XLSX spreadsheet
N44255-18-R-5004-0001.pdf PDF
Attachment_F_-Bid_Bond_Review_Checklist.docx DOCX document
Attachment_C.1_PPQ_Construction_Experience.docx DOCX document
Attachment_A_-_PPI_Form.doc DOC document
WF_MACC_Solicitation_N44255-18-R-5004.pdf PDF
N44255-17-R-4021_Pre-Solicitation_Notice_Amendment_6.doc DOC document
N44255-17-R-4021_Pre-Solicitation_Notice_Amendment_5.doc DOC document
N44255-17-R-4021_Pre-Solicitation_Notice_Amendment_4.doc DOC document
N44255-17-R-4021_Pre-Solicitation_Notice_Amendment_4.doc DOC document
N44255-17-R-4021_Pre-Solicitation_Notice_Amendment_3.doc DOC document
N44255-17-R-4021_Pre-Solicitation_Notice_Amendment_2.doc DOC document
N44255-17-R-4021_Pre-Solicitation_Notice_Amendment_1.doc DOC document
N44255-17-R-4021_Pre-Solicitation_Notice.doc DOC document
Show all 25

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.

HOH Blank

Budget FY 2019
Account TitleFAR Reference
Ktr Budgeted
UnallowableNet Allowable ExpensesActual Expenses
FY 2017FY 2016FY 2015
Accounting Fees (Outside Auditor)31.205-33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Advertising31.205-1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Alcoholic Beverages31.205-51$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Asset Valuations Resulting from Business Combinations31.205-52$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Backpay31.205-6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Bad Debts31.205-3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Bonding Costs31.205-4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Bonuses and Incentives31.205-6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Compensation for Personal Services31.205-6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Contingencies31.205-7$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Contributions and Donations31.205-8$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Cost of Money31.205-10$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Depreciation31.205-11$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Dues - Professional Organizations31.205-43$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Economic Planning31.205-12$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Employee Morale, Health, Welfare, Food Service and Dormitory31.205-13$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Entertainment i.e. Memberships in Social, Dining or Country Clubs etc.31.205-14$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fines and Penalties31.205-15$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fringe Benefits i.e. Vacations, Sick Leave, Holidays, Military Leave, Employee Insurance and supplemental Unemployment Benefit Plans31.205-6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Gains and Losses of Depreciable Property31.205-16$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Goodwill31.205-49$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Idle Facilities and Capacity31.205-17$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Independent Research and Development and Bid and Proposal31.205-18$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Insurance and Indemnification31.205-19$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Interest31.205-20$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Relations31.205-21$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Legal & Other Proceeding Costs31.205-47$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Lobbying & Political Activity Costs31.205-22$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Losses on Other Contracts31.205-23$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Manufacturing & Production Engineering Costs31.205-25$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Material Costs31.205-26$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Office Rent31.205-36$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Office Supplies$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Organization Costs31.205-27$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Business Expense31.205-28$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Patent Costs31.205-30$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Payroll Taxes31.205-41$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Pension, Retirement31.205-6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Plant Protection31.205-29$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Plant Reconversion Costs31.205-31$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Postage$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Precontract Costs31.205-32$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Principal Salaries (Indirect)31.205-6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Professionals (Outside Legal) and Consultants31.205-33$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Public Relations31.205-1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Recruitment Costs31.205-34$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Relocation Costs31.205-35$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Rental Costs31.205-36$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Repair and Maintenance31.105$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Research & Development Costs (Deferred/Excess)31.205-48$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Royalties & Other Costs for Use of Patents31.205-37$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Selling Costs31.205-38$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Service and Warranty Costs31.205-39$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Severance Pay31.205-6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Special Tooling & Special Test Equip Costs31.205-40$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subscriptions and periodicals31.205-43$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Taxes (Income, other)31.205-41$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Tech Personnel Salaries (Indirect)31.205-6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Telephone$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Termination Costs31.205-42$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Trade/Business/Technical/Professional Activity costs31.205-43$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Training31.205-44$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Travel31.205-46$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Typing, Filing (Indirect)31.205-6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Utilities$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

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

Allocation Base - Revenue $ - 0 $ - 0 $ - 0 $ - 0

Rate 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).

&"Times New Roman,Bold"ATTACHMENT E HOME OFFICE OVERHEAD HOOH ACCOUNTING DATA SPREADSHEET

Enclosure (2)

HOH 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

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