You can use formulas to update budgets for one or more customers. With a formula, you can adjust a budget by a certain dollar amount or a certain percentage. For instance, you can increase all of this year's budgets by 10% over last year's budgets. This year is the year you specify, last year is always the year prior to the specified year.
Applying a formula to multiple budgets is much faster than opening and editing the Sales Budget Detail Maintenance window for each customer. This instruction shows how to apply formulas to selected budgets from the Calculate Monthly Budgets screen, but you can also do so from the Sales Budget Queue. The system uses the message system to notify you when the formula calculations are complete.
To change the monthly sales budget calculation formula:
Do one of the following to display the Sales Budget Formula dialog box.
From the Maintenance > Sales Budgeting menu, select Sales Budget Queue to display the Sales Budget Queue window, display a list of sales budgets and select one to update, and, from the File menu, select Formula.
From the Maintenance > Sales Budgeting menu, select Sales Budget Monthly Calculations to display the Calculate Monthly Budgets screen. If prompted, log on to the character-based system. In the Year field, enter the year for which to calculate monthly sales budgets, filter the list of sales budget records, if needed, and use the Formula hot key.
Complete the following fields:
|
Field |
Description |
|
Budget From |
Indicates whether to create a budget from this year's actual sales or last year's actual sales. |
|
Budgeted Sales Formula |
The formula to apply to the selected sales amount (This Year Actual or Last Year Actual) to calculate the new budgeted sales amount. For example, to set the budget at 5% more than the actual sales, enter *1.05 in this field. |
|
Budgeted GP% Formula |
The formula to apply to the selected gross profit percentage (This Year Actual or Last Year Actual) to calculate a new gross profit percentage for the new budget. For example, to increase the gross profit percentage by 2% for the new budget, enter +0.02 in this field. Note: You cannot enter only a budgeted gross profit percentage formula. |
|
Apply To All Customers |
If you accessed the dialog box from the Sales Budget Queue window, to apply the formulas to all listed customers, enter Yes, or to apply the formulas only the customer you selected in the Sales Budget Queue window, enter No. |
Click OK to exit the dialog box.
Note: If the system calculates any negative amounts, it updates those budget amounts to be zero (0).
See Also: