Please enable JavaScript.
Coggle requires JavaScript to display documents.
WIP FILE - Coggle Diagram
WIP FILE
1: Rollforward Beginning Balances :check:
OBL Beg Column
LIQ Beg Column
Deliveries Beginning Column
Forecast Column
WIP Beg Column
2: OBTAIN INPUTS
:black_flag:
SABRS
BEA24
BEA13
FIAR DATA
PRODSTAT DATA
(
ARMY
)
NON-SMCA (AMCOM)
5:Other
:warning:
Compile Highlights and Analytics Tab
Perform ARMY To FIAR Recon (send results to Kelly)
Complete Checklist
4: IMPORT Data Into WIP
:red_flag:
FIAR (Direct, JMC Lines)
Total MIPR Quantity (FORECAST Column)
DD250 Delivery Column (Quantity Delivered Ending Column)
Input all Current Period Deliveries in a Separate Tab
SABRS (All lines)
Obligation Amount into Ending Obl Column
Liquidation Amount into Ending LIQ Column
BSYM into BSYM Columm
Fiscal Year into Fiscal Year Column
Non SMCA (AMCOM Lines)
Total Order Amount (Into Forecast Column)
Total Deliveries into Quantity Delivered Ending)
3: MODIFY INPUTS
:star:
SABRS DATA
Create PIVOT TABLE
BSYM
OBL
LIQ
FY
MIPR#
FIAR Data
Create Pivot Table
DD250 Delivery Quantity
MIPR #
Total MIPR Quantity
AMCOM
Forecast (Order Amt)
Delivered Amount
PRODSTAT
Import FY13 and Before Spreadsheet
Create Pivot Table