CDRL A030 Chief Financial Officer Report Attachment 1.xlsx
XLSX spreadsheet 34 KB Posted
- Solicitation number
- CLS-Nov22-RFI
View the file
Other files
Show 40 more
Latest 50 of 106 listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- 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 disposals. | ||
| Column H: Insert all condition code changes made by the C-ICP for assets located in the warehouse. | ||
| Column I: Insert $ value of All Price Changes for the Quarter | ||
| Please Note: Record ONLY the Change in $Dollar value | ||
| Column J: Insert the $ dollar value for gain in physical inventory for the current quarter. | ||
| Column K: Insert the $ dollar value for losses in physical inventory for current quarter. | ||
| Column L: Insert current quarter quantity ending balance | ||
| Column M: Formula calculates the total $ value of (C, D, E, F, G, I, J, K) of current quarter ending balances. |
| Column O: Insert the dollar $ Value of the assets with the condition codes listed. |
| 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 all assets remaining. |
| Column S: Formula calculates the total $ value of (O, P, Q , R) 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) 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 M and S of Tab 1 SHOULD Equal; If not, please explain why in Rows 7 to 17 text box. | ||
| Column S is a summary by condition code of Columns O through R |
Tab 1 Summary Name of Program and DoDAAC:
Didier A Ngay: Enter Program Name Here
SPARE PARTS
| 2nd Quarter | 2nd Quarter | 3rd Quarter | 3rd Quarter | 3rd Quarter |
| FY 2022 | FY 2022 | FY 2022 | FY 2022 | FY 2022 |
| 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 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, I, J, K)
| $ 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 O, P, Q, and R)
$ Value $ - 0 $ - 0 $0.00 0 $0.00 $0.00
Justification Required if Columns M and S 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 |
| $ - 0 | $ - 0 |
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 .