Follow

S&OP Budget and Revised Budget Management

The following described the steps required to populate a primary and revised budget. Both Budget and Revised Budget may be uploaded as defined below. The copy budget process works only with the Budget line, not Revised Budget

Populate Primary Budget using Copy Budget function

To populate the primary budget, once the demand plan for the coming fiscal year is ready, you may click on "Copy Budget" to populate the latest demand plan from the item level on up in the Budget line in the S&OP view.

You may update the budget line through out the year by repeating the process. It will populate the value from the current period forward.

Note: This button can be hidden via the user permissions to prevent users from populating the budget line in error.

Populate Primary Budget by Uploading

The SOP budget upload file is prepared in the exact same format as the userdefinedsopforecast.txt but with the name sopbudget.txt. The only difference difference between the user defined forecast upload and the Budget uploads is the name of the file. The name of the file communicates to DC what is being upload. Everything else stays exactly the same. 

See the article Uploading a User Defined Forecast / Demand Plan (S&OP Platform) for directions on how to prepare the user defined forecast upload file. Once ready, rename the file to sopbudget, zip the file, and then upload.

The uploaded file must be a zipped tab delimited text file named sopbudget.txt.

You can upload the budget at any hierarchical level above the item and even including average pricing to project budgeted revenue.

If you wish to upload the budget as of the beginning of the current fiscal year, please email support and ask that a hold back be run in your demand plan. A hold back runs a forecast as of the beginning of the fiscal year and populates the empty current fiscal year demand plan with forecast values. Once this is complete, you may upload the current fiscal year budget and the data will load.

Revised Budget Line

To enable the revised budget, in system settings, check "Yes" in the "Enable revised budget in demand plan" option under "Sales & Operation Planning Settings."

Populate Revised Budget by Uploading

The SOP revised budget upload file is prepared in the exact same format as the SOP budget as defined above but with the name soprevisedbudget.txt.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk