MYOB EXO Business

Hide NavigationShow Navigation

  • Contents
  • Index
  • Search
 
Show results that include all search words

 

Creating a Sales Budget

Sales budgets are budgets allocated for stock items. Sales budgets provide the following benefits.

  • Budget allocation for each stock item by each sales territory.

  • Budget spread for each stock item, for each period, by each sales territory.

  • A combined analysis of overall budget allocation (budgets allocated by different territories for a particular stock item) for a stock item by different sales territories.

  • Copy budgets and actual values for a stock item from one year to another year forward.

  • Activity details for a stock item.

When creating a Sales Budget, if the Setup Sales Budgets function is not already in one of your menus, then it needs to be added using the Menu Designer. See Create a Sales Territory for instructions on adding the menu item.

A key feature in Sales Budget functionality is the ability to use formulas to spread a total annual budget amount across each month on a percentage basis. See Set up a sales budget formula.

Creating a Sales Budget for Sales Territory

The following steps are essentially the same whether you are creating a sales budget for a sales territory/primary stock group, or for a primary stock group/ sales territory.

  1. In the Setup Sales Budgets window, select Sales Territory/Primary Stock Group from the Budgets for drop-down menu.

  2. Select the year for which you want to create a new budget, and then click Search. A list of sales territory/stock group combinations is displayed.

  3. Double-click on the required sales territory/stock group combination. The Setup window for a Sales Territory/Primary Stock Group is displayed.

  4. Use the following table to choose which budget method you want to use.

    Budget method

    Description

    Action

    Copy Actual Values

    Copies the actual sales total for the selected sales territory/ primary stock group, into the budget column.

    Select which year's sales total you want to copy.

    Copy Budgets

    Copies an existing Sales Budget, and allows you to adjust it by a percentage.

    Enter the adjustment percentage if required.

    Spread by Actual Budget

    The total budget amount for the year for the sales territory/ primary stock group, which you then want to split by percentages you enter in each month in this window.

    Enter the budget total to which you want to apply monthly percentages.

    Spread by Formula

    The total budget amount for the year for the sales territory/ primary stock group, which you want to spread by your setup formula spread percentages.

    Enter the budget total to which you want to apply your budget formula.

  5. Click Update, whenever you make any selection changes in the window, to update the window with your selection.

  6. Click Save.