Reviewing and Adjusting Gross Margin Budget Percentages
The Gross Margin Pct Budget form shows the gross profit margin percentages of Items. For each Item, the form shows the Budgeted percentage margin for each period.
Use the form to set gross margin percentages for Budget periods. You can enter Budget margin percentages manually or have them calculated based on the Prior Year Forecast trend. The margin percentages that you enter on this form are used to calculate the cost of goods sold for Inventory Items.
To review or adjust the gross margin Budget percentages by Item:
-
From the Home page, click the Budget card.
-
Click the 2 tab on the left
-
Click Gross Margin Pct.
-
In the Point of View, choose a Scenario, Version, Subsidiary, and Currency.
-
Click the arrow in the cell where the relevant Item row intersects the Trend Gross Margin Budget column.
Select Prior Yr Forecast. Or, select Manual to manually enter Budget values.
Note:You can only enter Budget values where the trend is set to Manual or is blank.
-
For Items set to Prior Yr Forecast, in the Adj (%) column, enter the percentage change as a decimal value. For example, enter 0.01 for a 1% increase or -0.01 for a 1% decrease.
-
For Items set to Manual, in the Budget periods, enter the margin percentages.
-
Click Save.
-
To update top-level members with the adjusted data in input currency, right-click the data grid and select Agg to Income Statement Budget.