Sequencing using SPT Enter data only in yellow-shaded cells. Up to 10 jobs may be sequenced. Number of Jobs time from midnight (which is now) Processing Time Due time Job Sequence Processing Time Marketing 1 Finance 2 OM 3 Psych 4 5 6 7 8 9 10 Flowtime Lateness Tardiness Average Due time Flowtime Lateness Tardiness Sequencing using the EDD rule Enter data only in yellow-shaded cells. Up to 10 jobs may be sequenced. Number of Jobs Job Processing Time Due time Sequence Processing Time 1 2 3 4 5 6 7 8 9 10 Marketing Finance OM Psych Flowtime Lateness Tardiness Average Due time Flowtime Lateness Tardiness Chapter 14 # 9 (modified) Use the provided spreadsheet to answer this question. Mike Reynolds has four project assignments due at the following times: Class Time 8 a.m. Marketing 304 OM 385 10 a.m. Finance 216 1 pm 3:30 p.m. Psychology 200 It is now midnight, and Mike estimates that each assignment's processing time is Finance (6 hours), OM (3 hours), Marketing (4 hours), and Psychology (2 hours). Assume that each class lasts 1 hour and that the processing times include the class hour. Before using Excel, complete the below table. You will need to convert all clock times to hours from midnight (e.g., 1 pm = 13; 1:30 pm = 13.5). When you enter these into Excel, make sure to use the below job numbers exactly. This is very important! You will need to determine the job completion order sequence (job number 1 Marketing might be completed 1", 2", 3", or 4") that answers the questions below. Due Date Job Hour Dueprocessing time 1 Marketing 2 Finance 3 OM 4 Psych a. If Mike uses SPT, can he complete all of his assignments on-time? If not, what sequence minimizes flow time and which assignment(s) are late (tardy is >0)? b. If Mike uses EDD, can he submit all of his assignments on time? If not, what sequence minimizes flow time and which assignments are late? c. Mike's psychology professor offers extra credit to any student who submits their assignment by 6 am. Mike really needs some extra credit to help him pass the class. Propose a sequence that enables Mike to earn this extra credit while minimizing both his average tardiness (1 priority) and flowtime (2* priority). Sequencing using SPT Enter data only in yellow-shaded cells. Up to 10 jobs may be sequenced. Number of Jobs time from midnight (which is now) Processing Time Due time Job Sequence Processing Time Marketing 1 Finance 2 OM 3 Psych 4 5 6 7 8 9 10 Flowtime Lateness Tardiness Average Due time Flowtime Lateness Tardiness Sequencing using the EDD rule Enter data only in yellow-shaded cells. Up to 10 jobs may be sequenced. Number of Jobs Job Processing Time Due time Sequence Processing Time 1 2 3 4 5 6 7 8 9 10 Marketing Finance OM Psych Flowtime Lateness Tardiness Average Due time Flowtime Lateness Tardiness Chapter 14 # 9 (modified) Use the provided spreadsheet to answer this question. Mike Reynolds has four project assignments due at the following times: Class Time 8 a.m. Marketing 304 OM 385 10 a.m. Finance 216 1 pm 3:30 p.m. Psychology 200 It is now midnight, and Mike estimates that each assignment's processing time is Finance (6 hours), OM (3 hours), Marketing (4 hours), and Psychology (2 hours). Assume that each class lasts 1 hour and that the processing times include the class hour. Before using Excel, complete the below table. You will need to convert all clock times to hours from midnight (e.g., 1 pm = 13; 1:30 pm = 13.5). When you enter these into Excel, make sure to use the below job numbers exactly. This is very important! You will need to determine the job completion order sequence (job number 1 Marketing might be completed 1", 2", 3", or 4") that answers the questions below. Due Date Job Hour Dueprocessing time 1 Marketing 2 Finance 3 OM 4 Psych a. If Mike uses SPT, can he complete all of his assignments on-time? If not, what sequence minimizes flow time and which assignment(s) are late (tardy is >0)? b. If Mike uses EDD, can he submit all of his assignments on time? If not, what sequence minimizes flow time and which assignments are late? c. Mike's psychology professor offers extra credit to any student who submits their assignment by 6 am. Mike really needs some extra credit to help him pass the class. Propose a sequence that enables Mike to earn this extra credit while minimizing both his average tardiness (1 priority) and flowtime (2* priority)