PROVIDE EXCEL SOLUTION

Find the average completion time, average number of jobs in the system, and the average delay for: a) FCFS b) SPT c) EDD dispatching rules. Jobs have been listed in the same sequence as arrival.

FCFS Rule:

Tasks	Time (days)	Due Date	Flow Time	Delay	Results
A	13	18			Avg. Flow Time =
B	7	10			Avg # of jobs =
C	8	27			Avg. Delay =
D	2	21

SPT Rule:

Tasks	Time (days)	Due Date	Flow Time	Delay	Results
					Avg. Flow Time =
					Avg # of jobs =
					Avg. Delay =

EDD Rule:

Tasks	Time (days)	Due Date	Flow Time	Delay	Results
					Avg. Flow Time =
					Avg # of jobs =
					Avg. Delay =