Overview

Here you will learn how to synchronize the sales forecast figures with the cash flow budget to provide early feedback on budget fulfillment and forecasting figures.

You need to supplement data on goods quantity in the sales forecast with data on item prices. You can do it semi-manually. The monetized figures are allocated by period in accordance with the standard payment terms (most relevant for forecasting) and then compared to the cash flow budget.

In case of major deviations, the key drivers need to be identified. As a result, to keep up with the budget, you can:

  • Re-evaluate forecasting assumptions.
  • Initiate follow-up activities in forecasting or budgeting.

As a result of the process, the total deviation between the sales revenue forecast and budget is identified and aligned.

Calculate sales revenue forecast and align it with budgets flowchart

Calculate sales revenue cash flow forecast and align it with budgets

(v.0)

Loading diagram...

Paths

Path

Budgeting and planning → Budget process → My budget tasks

In-app link EN code

e1cib/list/Task.BudgetTask

In-app link RU code

e1cib/list/Задача.БюджетнаяЗадача

How to find and review budget tasks

1. Go to Budgeting and planning and click My budget tasks under Budget process.

2. Find the Budget task related to the budgeting process step and open it.

3. In the Budget task document, click the Additional information tab.

4. Review the time requirements in the Due date field.

5. Review the task details in the Instructions field and make sure you understand them.

6. Review the start date and time in the Start field.

7. Review the Main task and Process stage - base document fields.

8. Click the hyperlink in the middle of the form and review the input settings.

9. Click the Task action tab.

10. Click Enter plan to drill down to the entry form to fill in or the reference document.

Note

Hyperlinks in steps 8 and 10 appear if Plan entry is selected in the Action field.

Paths

Path

Budgeting and planning → Sales and operations plans → Sales forecasts by items

In-app link EN code

e1cib/list/Document.SalesPlan

In-app link RU code

e1cib/list/Документ.ПланПродаж

How to calculate sales revenue forecast

1. Go to Budgeting and planning and click Sales forecast by items under Sales and operations plans.

2. Open the Sales forecast by items document and go to the Goods tab.

3. Fill in the Scenario and the Plan profile relevant for the planning step.

4. Specify the Period to fill in.

5. Choose the Business unit (or Dispatching unit), Warehouse, or other applicable analytics, if required by the plan profile settings.

6. Go to the Product categories / Goods / Manufactured products tab.

7. Click Fill in categories / goods → By default rule. The system will automatically fill in the lines in accordance with the Population settings of the Plan profile.

8. Review the information and check that the data is complete.

9. Correct the figures if necessary.

10. Specify any relevant notes, such as special requirements, in the Comment field.

11. Click  and attach additional files.

12. Set the Created status and post the document.

13. Go to the Payment tab.

14. Select the standard Payment terms.

15. Click Autofill payment milestones. The system will automatically fill in the lines grouped by payment date.

Paths

Path

Budgeting and planning  Tools → Planning process management

In-app link EN code

e1cib/app/DataProcessor.PlanningProcessManagement

In-app link RU code

e1cib/app/Обработка.УправлениеПроцессомПланирования

How to submit sales revenue forecast

1. Go to Budgeting and planning and then click Planning process management under Tools.

2. Choose the Scenario and specify the planning Period.

3. Find the Plan profile related to the process.

4. Double-click the relevant flowchart area, select the plan document, and click Set status → Submitted.

The system will automatically set the Submitted status for the document.

How to request feedback from budgets

1. Open the required document.

2. Create a Duty based on the document.

3. Specify the work name in the Duty field.

4. Assign it to the responsible user within the database.

5. Set the Priority and specify the Due date.

6. Describe the actions to take in the Subject field.

7. Start and close the document.

How to provide feedback from budgets to sales forecast

1. Open the Sales forecast by items document and go to the Payment tab.

2. Leave comments for each line in the Comment column.

3. Post the document.

4. Go to Quick menu and then click My Tasks under Mail, tasks.

5. Open the Task related to the process step.

6. In the Task document, describe the task deliverables or the current progress in the Results field.

7. Enter the Date of completion.

8. Click Completed.

How to complete budget tasks

1. Open the Sales forecast by items document and go to the Payment tab.

2. Review comments for each line in the Comment column.

3. Fix or escalate all issues identified.

4. Go to Budgeting and planning and click My budget tasks under Budget process.

5. Find the Budget task related to the process step and open it.

6. Enter the date of completion in the Completed field.

7. Click Complete and close.


  • No labels