Dear all,
In the past communication of budgeted sales figures from SU’s to MU’s was not standardized and caused some potential for misunderstandings. Therefore I prepared an excel file to standardize reporting and reduce workload overall for this task. Basically you have to
1) Enter on top of tab ‘RollerConveyor’ the buyer and vendor company code and the reporting currency code (yellow cells)
2) Copy budget figures out of the sales budget file and paste it in the red frame (data entry figures per tab columns D-F)
3) Enter markup per product (yellow column)
4) Send completed file to the concerned MU
The use of this template is not mandatory. Should you have any question or remark don’t hesitate to contact me.