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 periods.
Use the form to set the gross margin percentages for Budget periods. You can enter Budget margin percentages manually or have the percentages 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-hand side.
-
Click Gross Margin Pct.
-
In the Point of View, select a Scenario, Version, Subsidiary, and Currency.
-
Click the arrow in the cell that intersects the relevant Item row and the Trend Gross Margin Budget column.
Select Prior Yr Forecast. Alternatively, 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 increase or decrease 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 populate top-level members with the adjusted data in input currency, right-click the data grid, and then select Agg to Income Statement Budget.