The report tracks how efficient RM01279 is used in the process to produce the final product M080033. The report shows how much is inputted and outputted from the Raw Material. The process is RM01279(Oleo Marigold) – 080031 (Kemin Yellow)– 080121 (Wet Cake) – M080033 (Dry Cake).
The user first start filter the lot number associated with 080031 (kemin yellow). Then table will show the RM01279 and M080033 lot numbers associated with the selected lot as well as the Yield % and Avg % Lutein. The graph will show the average % Lutein and Yield % by the final product M080033’sl lot number.
The report is refreshed once daily at 10 pm central time.
This report is connected to “BPW_Datamarts” from “bpw.kemin.com”, “M3FDBKMN” from “m3livedata.kemin.com”, and “labvantageprod” from “uskilvsql1.ki.com”. From BPW, StockTransactionDetailed is imported. From M3, V_ItemAttributeFile is imported. From Labvantage, V_BI_SampleTestResult is imported.