Solve the following questions USING EXCEL:

$5.$ An IT analyst found four project $$tickets$$ in their inbox at $8$:$00$ AM$.$ The estimated times to complete the tickets and the due dates requested are given below.

Ticket $1234$

Processing time $($minutes$)42257050$

Due date $10$:$00$ AM $9$:$00$ AM $12$:$00$ PM $9$:$30$ AM

Compute tardiness for each ticket and compare average flow time for all tickets under the following processing orders:

a$)$ FCFS$.$

b$)$ SPT$.$

c$)$ EDD.