3 Spreadsheet Mike Reynolds has four woments due in class tomorrow, and his dess times are as follows: Class Time Marketing 304 9 am OM 385 11 am Finance 210 2 pm Psychology 200 4:30 pm Each class tasts one hour, and Mike has no other classes. It is now midnight, and Mike estimates that the finance, OM, marketing, and psychology asignments will take him two, ones, and three hours, respectively. Assume that all time of the last class begins can be spent on computing assignments but each mignment should be done til the time of the class on the same subject. (Mile can prepare assignments for the next classes during previous datos) Use the Excel Segurong template to determine how he should schedule the work. Use minus on to enter negative lateness values, if any. Enter the half an hour values 0.5.0.1:30p.m. should be entered as 15.5. 1 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. EDD sequences Flow Time Due Date Lateness Sequence Tardiness Processing Time Select- Select- Average Average SPT sequences Sequence Processing Time Due Date Flow Time Lateness Tardiness Select -Select -Select -Select Average How should he schedule the work? To meet all assignment deadlines, Mike should use Select 3 Spreadsheet Mike Reynolds has four woments due in class tomorrow, and his dess times are as follows: Class Time Marketing 304 9 am OM 385 11 am Finance 210 2 pm Psychology 200 4:30 pm Each class tasts one hour, and Mike has no other classes. It is now midnight, and Mike estimates that the finance, OM, marketing, and psychology asignments will take him two, ones, and three hours, respectively. Assume that all time of the last class begins can be spent on computing assignments but each mignment should be done til the time of the class on the same subject. (Mile can prepare assignments for the next classes during previous datos) Use the Excel Segurong template to determine how he should schedule the work. Use minus on to enter negative lateness values, if any. Enter the half an hour values 0.5.0.1:30p.m. should be entered as 15.5. 1 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. EDD sequences Flow Time Due Date Lateness Sequence Tardiness Processing Time Select- Select- Average Average SPT sequences Sequence Processing Time Due Date Flow Time Lateness Tardiness Select -Select -Select -Select Average How should he schedule the work? To meet all assignment deadlines, Mike should use Select