How to: Create a Sales Budget from Sales Data

In this article

To create a sales budget from historical sales data

Retail Sales Budgets let you reuse historical sales data when a new budget is created. This is usually done when a Sales Budget should incorporate an overall growth in sales in the next planning period.

Example: A company sold items worth 50 million in the current year and plans to increase sales by 10% in the next year. The future budget should be based on the historical sales data and apply the expected increase (using Multiplication Factor).

To create a sales budget from historical sales data

  1. Click the icon, enter Retail Sales Budget List, and select the relevant link.
  2. In the Retail Sales Budget List, select the budget you want to plan, and click the Sales Budget action.
  3. Click Create - Create Budget from Sales.
  4. In the Options FastTab, select a Budget. This is defaulted to the current budget. If you wish to select a different budget it must be one to which you have edit permission, if the Edit Budget permission is not set to Anyone in the Replen. Setup. For more details see Budget Permissions.
  5. The remaining fields in the FastTab will be populated from the selected Budget.
  6. Select the Assign Stores to Budget check box, if you wish to consider the sales history from all stores for the budget entries creation and assign new stores from the sales history to the budget, otherwise only sales history of the existing assigned stores in the budget will be considered.
  7. Select the Consider Sales Hist. Adj. check box, if you wish to consider the sales history adjustment entries from Replen. Sales History Adj. in the calculation. The values from the Sales History Adjustments will be added on top of the Quantity, Sales Amount, and Cost Amount of the Retail Sales Budget Entry calculated from the Value Entries. The Sales Amount and Cost Amount originating from the Sales History Adjustments will be calculated by consulting the Last Direct Cost and Unit Price of the item.
  8. Click OK.

Note: The Create Budget from Sales functionality lets you get an estimated value from historical data and then the new sales budget is constructed by multiplying the estimated historical data with the Multiplication Factor.