Question: Just provide answer. No need to show work Thanks Enter data only in yellow-shaded cells. Up to 10 jobs may be sequenced. Average Average Average

Just provide answer. No need to show work

Thanks

Just provide answer. No need to show work ThanksJust provide answer. No need to show work Thanks
Enter data only in yellow-shaded cells. Up to 10 jobs may be sequenced. Average Average Average Number of |Maximum Flowtime Lateness Tardiness Tardy Jobs Tardiness Number of Jobs 5 14.40 4.20 5.00 3 12.00 Job Processing Time Due Date Sequence Processing Time Due Date Flowtime Lateness Tardiness 7 11 1 7 11 7 -4 2 10 IN 3 10 10 0 0 3 5 8 5 8 15 7 7 IN 5 2 5 17 12 12 17 un 6 17 23 6 6 10Mike Reynolds has four assignments due in class tomorrow, and his class times are as follows: Class Time Finance 304 9 am. Psychology 385 12 pm. OM 215 3 pm. Marketing 200 5:30 pm. Each class last}; one hour, and Mike has no other classes. It is now midnight, and Mike estimates that the OM. psychology, nance, and marketing assignments will take him five, six, four, and two 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.) Use 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 pm. should be entered as 15.5. vaour 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 sequence: Sequence Processing Time Due Date Flow Time Lateness Tardiness ll 4 12.0 o ll 3 4.0 o lml 6 7.0 o |Wl 2 13.0 D Average SPT sequence: Sequence Processing Time Due Date Flew Time Lateness Tardiness iml iml iml iml Average -SEIBCt' HOW should he Schedule the Work? SPT I'LIIB To meet all assignment deadlines, Mike should use ]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!