Exercise - Create a new formula with a version from the Released products page

  • 13 minutes

The marketing department at Contoso orange juice factory has determined the need for production of a new product for frozen apple juice concentrate. As the Product designer, you are asked to create a formula version with the following details:

  • Product Number: P7100

  • Product Name: Frozen Apple Juice Concentrate

  • Formula Size: 1000 gal

  • Formula Line: M9103 (Apples), QTY 800

  • Formula Line: M8001 (Ascorbic Acid), QTY 660

  • Formula Line: M8003 (Vitamin A), QTY 40

  • Formula Line: M8004 (Vitamin C), QTY 18

  • Formula Line: M7003 (Sucrose), QTY 33

  • Formula Line: M8008 (Can), QTY 2400

  • Approved by: Glen John

Create a new product

  1. In the USP2 company, go to Product information management > Products > Released products.
  2. Select New.
  3. In the Product number field, enter P7100.
  4. In the Product name field, enter Frozen Apple Juice Concentrate.
  5. In the Search name field, enter FrozenAppleJuice.
  6. In the Item model group field, enter or select a value.
  7. In the Item group field, enter or select a value.
  8. In the Storage dimension group field, enter or select a value.
  9. In the Tracking dimension group field, enter or select a value.
  10. In the Inventory unit field, enter lb.
  11. In the Purchase unit field, type lb.
  12. In the Sales unit field, type lb.
  13. In the BOM unit field, type lb.
  14. Select OK.
  15. On the Engineer FastTab, in the Production type field, select Formula.
  16. Select Save.

Create a formula with the description "For making Frozen Apple Juice Concentrate"

  1. Select Formula versions.
  2. Select New.
  3. Select Formula and formula version.
  4. In the Formula number field, enter FOR-7100.
  5. In the Name field, enter For making Frozen Apple Juice Concentrate.
  6. In the Site field, enter or select 1.
  7. Select OK.

Create formula lines to enter the ingredients with quantities and relevant units of measurement

  1. In the Lines or Header field, select Header.
  2. Set Formula size to 1000.
  3. Set From formula size to 1000.
  4. In the Lines or Header field, select Lines.
  5. In the Item number field, enter M9103.
  6. Set Quantity to 800.
  7. Select New.
  8. In the Item number field, enter M8001.
  9. Set Quantity to 660.
  10. Select New.
  11. In the Item number field, enter M8003.
  12. Set Quantity to 40.
  13. Select New.
  14. In the Item number field, enter M8004.
  15. Set Quantity to 18.
  16. Select New.
  17. In the Item number field, enter M7003.
  18. Set Quantity to 33.
  19. Select New.
  20. In the Item number field, enter M8008.
  21. Set Quantity to 2400.
  22. Select Save.

Approve and activate the formula

  1. Select Approve formula.
  2. In the Approved by field, enter Glen John.
  3. Select OK.
  4. In the Lines or Header field, select Header.
  5. Select Approval in the Formula versions section.
  6. In the Approved by field, enter Glen John.
  7. Select OK.
  8. Select Activate.
  9. Close the page.