The data for five tax analysis jobs waiting to be processed by Martha at T. R. Accounting Service has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the...


The data for five tax analysis jobs waiting to be processed by Martha at T. R. Accounting Service has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.


Questions


1. Use the shortest-processing-time (SPT) sequencing rules to sequence the jobs. Compute the flow time, tardiness, and lateness for each job, and the average flow time, average tardiness, and average lateness for all jobs. Use minus sign to enter negative lateness values, if any. Round the average values to two decimal places.






































































Sequence




Job




Processing Time




Due Date




Flow Time




Lateness




Tardiness


1
2
3
4
5

A<br>B<br>D<br>E<br>K<br>Sequencing (SPT)<br>2<br>Number of Jobs<br>5<br>4<br>Processing Time<br>10<br>5<br>Job<br>Due Date<br>Sequence<br>Job<br>Processing Time Due Date Flow Time Lateness Tardiness<br>6.<br>1<br>17<br>1<br>7<br>19<br>2<br>8<br>3<br>7<br>9.<br>4<br>4<br>10<br>4<br>10<br>9<br>8<br>11<br>12<br>Average<br>13<br>

Extracted text: A B D E K Sequencing (SPT) 2 Number of Jobs 5 4 Processing Time 10 5 Job Due Date Sequence Job Processing Time Due Date Flow Time Lateness Tardiness 6. 1 17 1 7 19 2 8 3 7 9. 4 4 10 4 10 9 8 11 12 Average 13

Jun 03, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here