Attachment_11_-_FY_19_CFO_Report_Template.xlsx
XLSX spreadsheet 25 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 report template for spare parts inventory. The contract opportunity is for logistics sustainment support of instrumentation tracking systems across 26 government agencies. Services required include management of government-owned stock, component acquisition, repair, fabrication, on-site overhauls, and emergency engineering support. Ability to relocate systems and perform subsystem upgrades is also necessary. The response deadline is June 29, 2018. The applicable NAICS code is 334511 with a size standard of 1,250 employees. Respondents must indicate their business size and socioeconomic status. The quarterly report template instructions provide guidance on inputting inventory balances, transaction details, and ending balances by condition code.
Attachment 11 FY 19 CFO 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
| 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 .