Assigning a Production Route Status to AssemblyID

I am struggling to work out the logic for assigning an overall route status to production assemblies and display them in a table visual.   All assemblies are assigned a route that consists of speci...