On your sheet, you say "the completion time for customer 222 should be 6:30 PM". If the shift starts at 3 pm and they can make 20/shift, wouldn't the order for 222, 10 parts, finish at 7 pm?

Do you want to account for lunch breaks? Do the shifts only run zero or 8 hours?