Here's an example to test your skills at creating an effective -- and efficient -- production schedule. You are managing a highly custom Job Shop that repairs classic cars. Schedule the 5 jobs below based on the Critical Ratio to set your Priorities. (This is a small shop -- assume no wasted time moving from station to station.) Then, compute your schedule's performance metrics. Finally, to improve customer service you are considering doubling your equipment to have each worker run 2 machines at each station. Is this worth the expense?

Job #	Station/Hours				Process time	Due Time (Hour)	C/R		Priority (based on C/R)
1	A/1	B/2	C/3	D/2	8	8
2	B/2	C/3	A/1	D/4	10	10
3	C/2	A/3	D/1	C/2	8	8
4	A/2	D/2	C/3	B/1	8	14
5	D/2	C/1	A/2	B/4	9	12
				Total Processing time =	43

Complete your schedule here in the format of a Gantt Chart by typing in the Job Number (e.g. 1, 2, 3...) in each block that will be worked. Color-coding is set using Conditional Format. Use the Critical Ratio that you computed above to prioritize dispatching (1st, 2nd, 3rd... = 1, 2, 3....). See example on right.

Job			Due Time (hour)	Completed by hour ____	On-time (Y/N)	Hours late
1			8
2			10
3			8
4			14
5			12