mike reynolds has four assignments due in class tomorrow, and his class times are as follows:\nclass…

mike reynolds has four assignments due in class tomorrow, and his class times are as follows:\nclass time\nfinance 304 9 a.m.\npsychology 385 11 a.m.\nom 216 1 p.m.\nmarketing 200 2:30 p.m.\neach class lasts one hour, and mike has no other classes. it is now midnight, and mike estimates that the om, psychology, finance, and marketing assignments will take him six, four, one, and three hours, respectively. assume that all time till the last class begins can be spent on completing assignments but each assignment should be done till the time of the class on the same subject. (mike can prepare assignments for the next classes during previous classes.)\nuse the excel sequencing template to determine how he should schedule the work. use minus sign to enter negative lateness values, if any. enter the half an hour value as 0.5, e.g., 3:30 p.m. should be entered as 15.5. if your answer is zero, enter \0\. round your answers for the due date, lateness, and tardiness to one decimal place. round your answers for the average values to two decimal places.\nedd sequence:\nsequence processing time due date flow time lateness tardiness\nfinance 1 9 1 -8.0 0.0\npsychology 4 11 5 -6.0 0.0\nom 6 13 11 -2.0 0.0\nmarketing 3 14.5 14 -0.5 0.0\naverage\nspt sequence:\nsequence processing time due date flow time lateness tardiness\nfinance 1 9 1 -8.0 0.0\nmarketing 3 14.5 4 -10.5 0.0\npsychology 4 11 8 -3.0 0.0\nom 6 13 14 1.0 1.0\naverage

mike reynolds has four assignments due in class tomorrow, and his class times are as follows:\nclass time\nfinance 304 9 a.m.\npsychology 385 11 a.m.\nom 216 1 p.m.\nmarketing 200 2:30 p.m.\neach class lasts one hour, and mike has no other classes. it is now midnight, and mike estimates that the om, psychology, finance, and marketing assignments will take him six, four, one, and three hours, respectively. assume that all time till the last class begins can be spent on completing assignments but each assignment should be done till the time of the class on the same subject. (mike can prepare assignments for the next classes during previous classes.)\nuse the excel sequencing template to determine how he should schedule the work. use minus sign to enter negative lateness values, if any. enter the half an hour value as 0.5, e.g., 3:30 p.m. should be entered as 15.5. if your answer is zero, enter \0\. round your answers for the due date, lateness, and tardiness to one decimal place. round your answers for the average values to two decimal places.\nedd sequence:\nsequence processing time due date flow time lateness tardiness\nfinance 1 9 1 -8.0 0.0\npsychology 4 11 5 -6.0 0.0\nom 6 13 11 -2.0 0.0\nmarketing 3 14.5 14 -0.5 0.0\naverage\nspt sequence:\nsequence processing time due date flow time lateness tardiness\nfinance 1 9 1 -8.0 0.0\nmarketing 3 14.5 4 -10.5 0.0\npsychology 4 11 8 -3.0 0.0\nom 6 13 14 1.0 1.0\naverage

Answer

Explanation:

Step1: Identify the EDD (Earliest Due - Date) sequence

Arrange assignments in order of earliest due - date. Finance is due at 9 a.m., Psychology at 11 a.m., OM at 1 p.m. (13 in 24 - hour format) and Marketing at 2:30 p.m. (14.5 in 24 - hour format). The EDD sequence is Finance, Psychology, OM, Marketing.

Step2: Calculate Flow Time for EDD sequence

For Finance: Processing time is 1 hour. Flow time = 1. For Psychology: Processing time is 4 hours. Flow time = 1+4 = 5. For OM: Processing time is 6 hours. Flow time = 5 + 6=11. For Marketing: Processing time is 3 hours. Flow time = 11+3 = 14.

Step3: Calculate Lateness for EDD sequence

Lateness = Flow time - Due date. For Finance: 1 - 9=-8.0. For Psychology: 5 - 11=-6.0. For OM: 11 - 13=-2.0. For Marketing: 14 - 14.5=-0.5.

Step4: Calculate Tardiness for EDD sequence

Tardiness = max(0, Lateness). So all are 0.0.

Step5: Identify the SPT (Shortest Processing Time) sequence

Arrange assignments in order of shortest processing time. Finance (1 hour), Marketing (3 hours), Psychology (4 hours), OM (6 hours).

Step6: Calculate Flow Time for SPT sequence

For Finance: Flow time = 1. For Marketing: Flow time = 1+3 = 4. For Psychology: Flow time = 4+4 = 8. For OM: Flow time = 8+6 = 14.

Step7: Calculate Lateness for SPT sequence

For Finance: 1 - 9=-8.0. For Marketing: 4 - 14.5=-10.5. For Psychology: 8 - 11=-3.0. For OM: 14 - 13 = 1.0.

Step8: Calculate Tardiness for SPT sequence

For Finance, Marketing, Psychology: Tardiness = 0.0. For OM: Tardiness = 1.0.

Answer:

Sequence Type Processing Time Due Date Flow Time Lateness Tardiness
EDD - Finance 1 9 1 -8.0 0.0
EDD - Psychology 4 11 5 -6.0 0.0
EDD - OM 6 13 11 -2.0 0.0
EDD - Marketing 3 14.5 14 -0.5 0.0
SPT - Finance 1 9 1 -8.0 0.0
SPT - Marketing 3 14.5 4 -10.5 0.0
SPT - Psychology 4 11 8 -3.0 0.0
SPT - OM 6 13 14 1.0 1.0