Take$-$home portion of the final exam. Do not submit here $-$ submit your result$/$answers during the final exam.

Answer the following three questions and submit your work as a single Excel file, with the question answers at the bottom of your spreadsheet $-$ your spreadsheet shall include the calculations needed to answer the questions. This is individual effort $-$ no collaboration; you may work together on the scenario we covered in class, but not on the answers to these questions. Your submission should include appropriate formatting, as discussed in class.

Jack, the owner of Jack's Electronic Repair, currently has five jobs to be scheduled:

PROCESSING DUE

JOB TIME $($hours$)($hours$)$

$======================$

A $24$

B $33$

C $58$

D $110$

E $413$

a$.$ If Jack uses the shortest processing time first $($SPT$)$ priority rule to schedule these jobs, what will be the average job tardiness?

b$.$ If Jack uses the earliest due date first $($EDD$)$ priority rule to schedule these jobs, what is the flowtime of job D$?$

c$.$ If Jack uses the earliest due date first $($EDD$)$ priority rule to schedule these jobs, when will job E be finished?