SPT sequence:Sequence-Select--Select--Select--Select-Processing TimeDue DateAverageFlow TimeHow should he schedule the work?To meet all assignment deadlines, Mike should use -Select-vLatenessTardiness Mike Reynolds has four assignments due in class tomorrow, and his class times are as follows:Time9 a.m.11 a.m.2 p.m.5:30 p.m.Each class lasts one hour, and Mike has no other classes. It is now midnight, and Mike estimates that the psychology, marketing, OM, and financeassignments will take him four, two, five, and six hours, respectively. Assume that all time till the last class begins can be spent on completingassignments but each assignment should be done till the time of the class on the same subject. (Mike can prepare assignments for the next classesduring 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. Enterthe 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.EDD sequence:Sequence-Select--Select--Select--Select-Processing TimeClassOM 304Marketing 385Psychology 216Finance 200Due DateAverageFlow TimeLatenessTardiness

Sequencing involves deciding the order in which tasks or jobs are performed in a production or…

Answered: SPT sequence: Sequence -Select-…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

An independent accountant is planning to prepare tax returns for six of her clients.Prior to her actually preparing each return, her secretary checks the client’s file to besure all the necessary documentation is there and obtains all the tax forms needed forthe preparation of the return. Based on past experience with the clients, her secretaryestimates that the following times (in hours) are required for preparation of the returnand for the accountant to complete the necessary paperwork prior to filing each return:Client Secretary Time Accountant Time1 1.2 2.52 1.6 4.53 2.0 2.04 1.5 6.05 3.1 5.06 0.5 1.5In what order should the work be completed in order to minimize the total timerequired for all six clients?
A computer center has two identical computers for batch processing. Thecomputers are used as parallel processors. Job times are estimated by the user, but experience has shown that an exponential distribution gives an accurate description of the actual job times. Suppose that at a point in time there are eight jobs remaining to be processed with the following expected job times (expressed in minutes):Job 1 2 3 4 5 6 7 8Expected time 4 8 1 50 1 30 20 6a. In what sequence should the jobs be processed in order to minimize theexpected completion time of all eight jobs (i.e., the makespan)?b. Assume that computer A is occupied with a job that has exactly two minutes of processing time remaining and computer B is idle. If job times are deterministic, show the start and end times of each job on each computer using the sequence derived in part (a).
Five jobs must be scheduled for batch processing on a mainframe computer system. The processing times and the promised times for each of the jobs are listedhere.Job 1 2 3 4 5Processing time 40 min 2.5 hr 20 min 4 hr 1.5 hrPromised time 11:00 A.M. 2:00 P.M. 2:00 P.M. 1:00 P.M. 4:00 P.M.Assume that the current time is 10:00 A.M.a. If the jobs are scheduled according to SPT, find the tardiness of each job and themean tardiness of all jobs.b. Repeat the calculation in part (a) for EDD scheduling
A nursing home must schedule nurses in a manner that balances providing adequate patient care while keeping costs down. From historical records, administrators can project the minimum number of nurses to have on hand during each day/time slot. This data is shown below. Shift Time Slot Minimum number of nurses needed 1 12 am-4 10 2 4 am-8 6 3 8 am-12 8 4 12 pm-4 12 5 4 pm-8 10 6 8 pm-12 14 Nurses must start work at the beginning of one of the four-hour shifts (starting as early as 12 am midnight or as late as 8pm evening) and work for eight hours. Nurses who begin working at 8 pm will work until 4 am the next morning. Formulate and solve the nurse-scheduling problem so as to minimize excess stagging while satisfying minimum staffing requrements. What is the value of total excess staffing?
In her last semester at SPC, Polly Hedron needs to take Statistics, Composition 2, Ethics, and Physics. Because Polly is registering early, she has 14 choices for her section of Statistics, 19 choices for her section of Composition, 17 choices for her section of Ethics, and 18 choices for her section of Physics. From how many possible schedules can Polly choose? (You may presume that none of these sections interfere with each other) Your Answer:
Ron Satterfield's excavation company uses both Gantt scheduling charts and Gantt load charts. Today, which is the end of day 7, Ron is reviewing the Gantt chart depicting these schedules: Job #151 was scheduled to begin on day 3 and to take 7 days. It got started on time and is 1 day ahead of schedule. Job #177 was scheduled to begin on day 3 and take 5 days. It is currently on time. Job #179 was scheduled to start on day 6 and take 3 days. It actually got started on day 5 and is progressing according to plan. Job #211 was scheduled to begin on day 5, but missing equipment delayed it until day 6. It is progressing as expected and should take 3 days. Job #215 was scheduled to begin on day 4 and take 5 days. It got started on time but has since fallen behind 2 days. This exercise contains only part a. a) Add the actual progress to the Gantt schedule shown on the right (on which the planned timings have been already plotted as blue lines). Using the line drawing tool, plot the actual…
Dan's Auto Detailing business performs two major activities: exterior cleanup and interior detailing. Based on the size of car and condition, time estimates for six cars on Monday morning are as shown in the accompanying table. Car Number 1 5 6 Exterior Interior 55 75 4 65 35 50 60 45 90 35 40 a. Sequence the cars so that all exterior cleanup is done first and total completion time is minimized. The sequence is -Select-- -Select- -Select- -Select- -Select-- -Select- 2 3 80 20
Ron Satterfield's excavation company uses both Ganit scheduling charts and Gantt load charts. Today, which is the end of day 7, Ron is reviewing the Gantt chart depicting these schedules: Job #151 was scheduled to begin on day 3 and to take 5 days. It got started on time and is 1 day ahead of schedule. Job #177 was scheduled to begin on day 1 and take 4 days. It is currently on time. Job #179 was scheduled to start on day 6 and take 2 days. It actually got started on day 5 and is progressing according to plan. Job #211 was scheduled to begin on day 5, but missing equipment delayed it until day 6. It is progressing as expected and should take 3 days. Job #215 was scheduled to begin on day 5 and take 5 days. It got started on time but has since fallen behind 1 day. This exercise contains only part a a) Add the actual progress to the Gantt schedule shown on the right (on which the planned timings have been already plotted as blue lines). Using the line drawing tool, plot the actual…
Given the following information on job times and due dates. Job Job Time(Hours) Due Date(Hours) a 3.5 7 b 2.0 6 c 4.5 18 d 5.0 22 e 2.5 4 f 6.0 20 a-1. Determine the optimal processing sequence using (1) First come, first served, (2) Shortest processing time, (3) Earliest due date, and (4) Critical ratio. Sequence for First come, first served Sequence for Shortest processing time Sequence for Earliest due date Sequence for Critical ratio a-2. For each method, find the average job flow time and the average job tardiness. (Round your answers to 2 decimal places.) First Come, FirstServed Shortest ProcessingTime Earliest Due Date Critical Ratio Average flow time Average job tardiness
At the campus copy shop, six jobs have arrived in the order shown (A, B, C, D, E, and F) at the beginning of the day 1 (today, which is a work day). All of the jobs are due at various times today. Your job is to evaluate four common sequencing rules. JOB DUE (IN HOURS) DURATION (HOURS REQUIRED) A 8 (this job is due in 8 hours) 1.65 B 5.5 (this job is due in 5.5 hours) 1.20 C 4.5 (this job is due after lunch in 4.5 hours) 0.85 D 6 (this job is due in 6…
Ron Satterfield's excavation company uses both Gantt scheduling charts and Gantt load charts. Today, which is the end of day 7, Ron is reviewing the Gantt chart depicting these schedules: Day Job #151 was scheduled to begin on day 3 and to take 6 days. It got started on time and is 1 day ahead of schedule. Job #177 was scheduled to begin on day 1 and take 4 days. It is currently on time. Job #179 was scheduled to start on day 7 and take 2 days. It actually got started on day 6 and is progressing according to plan. Job #211 was scheduled to begin on day 5, but missing equipment delayed it until day 6. It is progressing as expected and should take 3 days. Job #215 was scheduled to begin on day 4 and take 5 days. It got started on time but has since fallen behind 2 days. Job 12 3 4 56 789 10 11 -- 151 177 + This exercise contains only part a. 179 a) Add the actual progress to the Gantt schedule shown on the right (on which the planned timings have been already plotted). Using the line…
Currently a company that designs Web sites has six customers in its backlog. The time since the order arrived, processing time, and promised due dates are given in the following table. Job Time Since Order Arrived (days ago) Processing Time (days) Due Date (days from now) A 6 18 48 B 4 22 52 C 1 30 70 D 10 14 28 E 7 12 56 F 5 20 62 Develop a schedule by using the first-come, first-served (FCFS) rule and calculate the average flow time and average days past due for the schedule. Develop a schedule by using the earliest due date (EDD) rule and calculate the average flow time and average days past due for the schedule. Comment on the performance of the FCFS and EDD rules relative to average flow time and average days past due.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

SPT sequence: Sequence -Select- -Select- -Select- -Select- Processing Time Due Date Average How should he schedule the work? To meet all assignment deadlines, Mike should use -Select- Flow Time Lateness Tardiness