I would try it this way:
Code:
tblStep
S_ID S_Name ---> other step specific information
1 Step A
2 Step B
3 Step C
4 Step D
tblProduct
P_ID P_Name ----> other product specific information
1 Product A
2 Product B
3 Product C
tblProductStep
PS_ID P_ID S_ID PS_Qty ----> other product step specific information
1 1 1 5
2 1 3 10
3 1 4 2
4 2 1 4
5 2 3 6
6 2 4 10
7 3 1 2
8 3 2 4
9 3 3 6
10 3 4 8
This would be your basic product setup your 'generic' template for each product
Code:
tblJob
J_ID P_ID J_StartTime J_EndTime -----> other job related fields
1 1 08:00 12:30
tblJobStep
JS_ID J_ID PS_ID JS_StartTime JS_EndTime ---> other job step related information
This would be your day to day recording of each job you complete.
Then all you have to devise is a way to, when you create a new job, copy the relevant information from your 'setup' table to your 'job step' table, then your job is set up and your users just have to record the results each step.