Production & Yield report

You can access this report in the tab Production in the top menu and select Production & Yield in the Reports section of the drop-down menu.

The Production & Yield report can be printed in a printer-friendly format or downloaded as an Excel file by selecting the buttons in the top right corner.

You can use the filters on your left to select specific recipes, production orders, manufacturers, tags, SKUs etc. You can switch views between the different tabs By Order, Consumes and Produces.

On the left side of the screen you can also select a cut-off date for availability or an order date.

If your are working on a small screen you can find the filters by clicking on the illustrated magnifying glass next to the button Printer Friendly.

Below you can read about the content of the different columns in the report:

 

By order

Column name Explanation
Producer This is the name of the producer.
Order # This is the number of the production order to which the yield relates.
Avail. date This is the availability date, as entered on the production order.
Recipes This is the recipe associated to the production order.

The number in parentheses refers to how many recipe units were produced.
Net weight, Consumed (kg) This is the total weight in kg of the consumed lots.
Net weight, Finished (kg) This is the total weight in kg of the lots produced. The weight of the standard unit per lot can be changed in the Stock keeping Unit setup.
Yield: Actual (pct) This is the actual yield in percent based on the net weight of the produced and the actual lots.
Yield: Expected (pct) This is the expected yield in percent based on the consumed and the produced lots of the recipe.
Yield: Deviation (pp) This is the absolute difference between the percentage of the expected versus the actual yield
Cost of goods: Consumed This is the cost price of the consumed lots based on the purchase prices and as well as the expected costs (budget items) eg freight charges.
Cost of goods: Finished This is the cost price of the produced lots (after finished production) based on the purchase price of the raw material as well as on the expected and / or actual costs related to the production.
Change in Value This is the change in value of the production, ie. the difference between the cost price of goods consumed and produced. This change may be due to the fact that budget items are associated to the order.

 

Consumes

Column name Explanation
SKU This is the Stock Keeping Unit to which the consumed lot relates.
Global Name This is the global name of the SKU, as entered when creating the SKU.
Producer This is the name of the producer.
Order # This is the number of the production order to which the consumed lot relates.
Avail. date This is the availability date, as entered on the production order.
Unit of Measure This is the selected unit of measure of the SKU. You can read more about SKU here.
Consumed: Actual (Unit of measure) This is the actual number of consumed units of measure of the SKU that are part of the production.
Expected This is the expected amount of consumed lots of the SKU in kg based on the recipe
Actual This is the actual amount of consumed lots of the SKU in kg.
Deviation This is the difference between expected and actual consumed lots of the SKU.
Cost of goods This is cost of the consumed lots of the SKU.

 

Produces

Column name Explanation
SKU This is the SKU to which the produced items relates.
Global Name This is the global name of the SKU, as entered when creating the SKU.
Producer This is the name of the producer.
Order # This is the number of the production order to which the produced items relates.
Avail. date This is the availability date, as entered on the production order.
Unit of Measure This is the selected unit of measure of the SKU. You can read more about SKU here.
Production: Actual (Unit of measure) This is the actual number of produced unit of measure of the SKU
Net Weight Expected (kg) This is the expected number of kg of produced goods based on the recipe.

The net weight of the SKU can be found under Measures & Units in the SKU setup.
Net Weight Actual (kg) This is the actual number of kg of produced goods based on the recipe.

The net weight of the SKU can be found under Measures & Units in the SKU setup.
Net Weight Deviation (kg) This is the difference between expected and actual produced lots of the SKU.
Cost of goods This is the availability date, as entered on the production order.

 

Extraction

If you want to create your own report which contains the exact information of your needs, you can create a pivot table. Your data is already in tabulated form - which means, that every single type of data is in separate columns, to ensure the data is compatible when generating a pivot table.

Click the tab Extraction in the Production & Yield report, and click XLSX in the upper right corner. By this, a spreadsheet is generated for download, which can then be adjusted to your needs.

Most spreadsheets has a pivot function. It varies from sheet to sheet, how the pivot table is generated. You can do an internet search, by entering e.g. “Pivot table excel” into your search engine.

 

Outline