Just had the call,
According to this tool, the net sales & standard margin input is by store for the year. The phasing according to the holidays, promotion will phase the full year sales, margins.
However, net sales/ margins by stores by months have been finalized by finance/ IBP. There is limitation, how “accurate” we can get the phasing by weeks to tie to reality. We have to work the other way round.
1. Finance, please share your Net sales and Standard Margin by months by store to Operation.
2. Operation, I have mentioned in the call, how to use the file, hope you can work on it so that u can yell for help if you dun understand.
3. Operation, work on the phasing, still got to twit to tie to finance month net sales (margins should be ok, as the phasing tab is by month)
4. Operation, create the BI flat file, check on overview to ensure it ties to finance numbers.
5. Send flat file to Finance to upload in BI (finance please make sure u have access by now)
6. I will drop a mail to Global to say that, no GRAPE flat file will be uploaded. (we will make sure BI flat file is the same as what finance key in)
Let me know if above is clear?
Aside: Vietnam, still checking with global, how I can phase the store as I dun have past year data. Might need to develop one from scratch. Let u know if I need help.