Please enable JavaScript.
Coggle requires JavaScript to display documents.
Actuals D+2, Input Table in excel (Define Dimensions for upload in excel…
Actuals D+2
Input Table in excel
Define Dimensions for upload in excel table/Grid
Submit Data
Calc Script
Export to TXT flatfile
Upload Data via Cockpit
Calc Script
use Proper Rule File
Timeline
Controlling
FP&A :checkered_flag:
Topline :top:
Operations :factory:
BI team :computer:
Excel RF model
Topline only
Excel COGS model
Total values only, not per SKU
including Interco Volumes
Microstrategy
Auto/Manual Extract :computer:
Upload via Cockpit/Script :computer:
Calc Script :computer:
Cube
Check vs SAP :top: :checkered_flag: :factory:
mismatch?
manual adjustment :top: :checkered_flag: :factory:
Submit Data
Calc Script
recheck
ask for reload :checkered_flag:
OK? :checkered_flag:
E-mail / Workchat :checkered_flag:
no variables to select
Year/Month hardcoded in files
Error Logs :computer:
new SKU? :checkered_flag:
update Hierarchy excel :checkered_flag:
load excel :checkered_flag:
or add manually :checkered_flag:
ask for reload :checkered_flag:
no new SKU? :checkered_flag:
4 files
Excel GPS model
Excel Pre RF model
D-2
Check for New SKUs :checkered_flag:
Add SKUs :checkered_flag:
D-1
Upload AC: (Vol to CAF + Costs per prft cntr) :computer:
D+1 till 9.00
Uplad AC: All :computer:
D+2 till 9.00
Upload AC: All :computer:
D+3 till 9.00
1 more item...
Manual uploads
Pre Promo Volumes :top:
AC adjustments if mismatch :top: :factory: :checkered_flag:
missing COGS rate :factory:
Topline unorganic adj :top:
Add SKUs :checkered_flag:
Add SKUs :checkered_flag:
Excel COGS model
Forecasts/Allocations/COGS rates
Manual Uploads