Attachment_11_-_FY_19_CFO_Report_Template.xlsx
XLSX spreadsheet 26 KB Posted
- Attached to
- Instrumentation Range Support Program Federal contract opportunity
- Solicitation number
- FA2521-18-R-0024
About this file
This document contains a federal contract opportunity notice and instructions for completing a quarterly contractor financial report template. The federal contract opportunity is a re-competition for logistics sustainment support of instrumentation tracking systems for 26 test ranges worldwide. Services required include management of government-owned stock, stock replenishment, component repair, engineering field support, system relocations, and upgrades. The applicable NAICS code is 334511 with a size standard of 1250 employees. Responses were due by June 29, 2018. The financial report template provides instructions for contractors to record inventory transactions on a quarterly basis, including beginning balances, acquisitions, returns, shipments, condition code changes, price adjustments, and physical inventory results. Contractors must submit transaction details and an ending inventory balance list grouped by condition code.
Attachment 11 FY 19 CFP Report Template
View the file
Other files for this federal contract opportunity
Show all 50
Instrumentation Range Support Program 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
Text version
Instructions
FA2521-19-R-A007
(REF FA2521-18-R-0024)
RFP Attachment 11
| USAF CFO REPORT - Instructions on how to Complete Report | ||
| TAB 1 | Summary | |
| Header: | Insert Name of Program and DoDAAC | |
| Column A : | Insert your prior quarter $ ending balance. | |
| Column B : Insert your prior quarter quantity ending balance. | ||
| Column C: Insert your current quarter $ beginning balance. | ||
| (Please Note: Ending balance from Prior quarter and Beginning balance from Current quarter MUST Equal) | ||
| Column D: Insert the dollar $ Value of new acquisitions. | ||
| Column E: Insert the dollar $ Value of customer returns. | ||
| Column F: Insert the dollar $ Value of shipments/issues. | ||
| Column G: | Insert the dollar $ Value of in-transits. Only use this field if you have the capability to capture spares that have shipped but not yet received at destination. Until the receipt acknowledgement is received, in-transits must be included as part of ending inventory. If you do not have the capability, skip this column. |
| Column H: Insert the dollar $ Value of disposals. | |
| Column I: Insert all condition code changes made by the C-ICP for assets located in the warehouse. | |
| Column J: Insert $ value of All Price Changes for the Quarter | |
| Please Note: Record ONLY the Change in $Dollar value | |
| Column K: Insert the $ dollar value for gain in physical inventory for the current quarter. | |
| Column L: Insert the $ dollar value for losses in physical inventory for current quarter. | |
| Column M: Insert current quarter quantity ending balance | |
| Column N: Formula calculates the total $ value of (C, D, E, F, G, H, J, K, and L) of current quarter ending balances. |
| Column P: Insert the dollar $ Value of the assets with the condition codes listed. |
| Column Q: Insert the dollar $ Value of the assets with the condition codes listed. |
| Column R: Insert the dollar $ Value of the assets with the condition codes listed. |
| Column S: Insert the dollar $ Value of all assets remaining. |
| Column T: Formula calculates the total $ value of (P, Q , R, and S) of the current quarter ending balances. |
| TAB 2 | TRANSACTION DETAIL |
| Submit all transactions that make up the information in columns (D, E, F, G, H, I, J, K, L) of Tab 1 |
| TAB 3 | ENDING BALANCE LIST OF ASSETS BY CONDITION CODE | |
| Submit all details supporting the total in Column T of Tab 1 identified by Condition Codes | ||
| Please Note: Columns N and T of Tab 1 SHOULD Equal; If not, please explain why in Rows 7 to 17 text box. | ||
| Column T is a summary by condition code of Columns P through S |
Tab 1 Summary Name of Program and DoDAAC:
Didier A Ngay: Enter Name Here
SPARE PARTS
| 1st Quarter | 1st Quarter | 2nd Quarter | 2nd Quarter | 2nd Quarter |
| 2019 | 2019 | 2019 | 2019 | 2019 |
| Ending Balance |
Prior Quarter
$ Value Ending Balance Prior Quarter
Quantity Beginning Balance Current Quarter
$ Value New Acquisitions (Delivered) - D4S
$ Value Customer Returns - D6x
$ Value Shipments/Issue - D7x
$ Value In-Transits
$ Value Disposals - D7J
$ Value Condition Code Changes - D8C/D9C $ Value Price Change - DBx/DCx
$ Value Physical Inventory Adjustments - Gains - D8x
| $ Value | Physical Inventory Adjustments - Losses - D9x |
| $ Value | Ending Balance |
Quantity Ending Balance (Total of Columns:
C, D, E, F, G, H, J, K, L)
| $ Value | Serviceable Condition Codes (A,B,C,D) | |
| $Value | Assets in Condition Codes: E,J K,L,Q | |
| $Value | Unserviceable Condition Codes (F,G,M,R) | |
| $ Value | Assets in |
All other Condition Codes $Value Total Dollar Value (Total of Column P, Q, R and S)
$ Value $0.00 $0.00
Justification Required if Columns N and T do not match:
Didier A Ngay: Note: If Column M does not match Column S, enter justification here. Add other explanations here.
Tab 2 Transaction Detail
| Transaction Details | ||||||||||
| Transaction Code | Code Description | Program | NSN | Part Number | Nomenclature | Unit of Issue | Qty | Condition Code | Unit Cost | Extended Cost |
Tab 3 Ending Balance
| Ending Balance List of Assets by Condition Code | ||||||||
| Program | NSN | Part Number | Nomenclature | Unit of Issue | Qty | Condition Code | Unit Cost | Extended Cost |
Sheet5
| Select Prior Quarter | Select Current Quarter |
| 1st Quarter | 1st Quarter |
| 2nd Quarter | 2nd Quarter |
| 3rd Quarter | 3rd Quarter |
| 4th Quarter | 4th Quarter |
File details come from the government source that posted it. Updated .