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-20-R-0006
About this file
This document provides instructions for completing a quarterly CFO report template for an Air Force spare parts inventory program. The template requires entering beginning and ending balances by quarter for dollar value and quantity on hand. Transaction details must be provided for acquisitions, returns, shipments, in-transits, disposals, condition code changes, and price adjustments. An ending balance list is also required, grouped by condition codes. Columns on the template for ending balances and total dollar value by condition code must be equal, with any differences explained. The template collects spare parts inventory data to track inventory levels and value for an Air Force program.
View the file
Other files for this federal contract opportunity
Show all 49
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 .