Exercise - Create a step consumption formula

• 12 minutes

The formula for product P9500 in company USP2 is to be updated to change the formula line M9003 from a linear consumption to a stepwise consumption. The consumption on the line should be as follows:

• 0-1400: 5.5
• 1400-2400: 10.6
• 2400+: 15.8

Copy the existing formula for P9500

1. Go to Product information management > Products > Released products.
2. Use the Quick Filter to filter on the Item number field with a value of P9500.
3. In the list, select the link in the selected row for P9500.
4. Select Formula versions.
5. Select New.
6. Select Formula and formula version.
7. In the Formula number field, enter P9500V1.
8. In the Name field, enter V1.
9. Select the Copy option.
10. In the Site field, enter or select 1.
11. Select OK.
12. In the Formula version field, select the current version.
13. Select OK.

Set the line for M9003 in the new formula to stepwise consumption and set the step levels

1. In the lines, find the line for M9003.
2. Select the Setup tab.
3. In the Formula field, select Step.
4. Select the Step consumption tab.
5. Set Quantity to 5.5.
6. Select New.
7. Set From series to 1400.
8. Set Quantity to 10.6.
9. Select New.
10. Set From series to 2400.
11. Set Quantity to 15.8.
12. Select Save.
13. Close all pages.

Date out the old formula and date in the new one

1. In the list, find and select the old formula.
2. In the To date field, set the date to 2016-12-27.
3. Select Save.
4. In the list, find and select the new formula.
5. In the From date field, set the date to 2016-12-28.
6. Select Save.

Approve and activate the formula

1. Select Approve.
2. In the Approved by field, enter or select an employee.
3. Select the Do you also want to approve the formula? option.
4. Select OK.
5. Select Activate.