Please show all workings not on excel for this question

The Ace Machine Company is considering using a priority scheduling rule in its fabrication shop and must decide whether to use: the critical rule, the arder slack rule, the shortest operation next rule or the slack per operation rule. The table below shows the company's current inventary and shop status. Erhibits indudes no mone or gueue timen. a) State the formula for calculating the priority index for each of sequencing rules ghen above. b) Compute the scheduling priority index for each order in Exh bit 1 for the four sequencing rules