Excel Solver Product Scheduling

Sorry that Sum was already supposed to be there copied over this sheet and it wouldn't copy over the formula so had to recreate them all, guess I missed that one. What I am referring to is after you run the Solver the Vlookup will only reference whatever cell it Orders as 1 for every Vlookup formula throughout the sheet. You can see this by evaluating a few of the formulas with "Evaluate Formula" in the Formula tab. After I sort the order the Vlookup formulas reset and reference the correct cells, but once sorted it doesn't give the optimum ordering. I can sort manually by Time then Temp and get a Delay around

Delay around 1600