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.Questions1. 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.SequenceJobProcessing TimeDue DateFlow TimeLatenessTardiness1 2 3 4 5 **Sequencing (SPT)****Number of Jobs:** 5| Job | Processing Time | Due Date ||-----|-----------------|----------|| 1 | 10 | 17 || 2 | 6 | 19 || 3 | 7 | 5 || 4 | 4 | 10 || 5 | 9 | 8 |**Sequence:**1. Job 42. Job 33. Job 24. Job 55. Job 1**Fields for Further Calculation (with labels):**- **Job:** Lists the sequence of jobs based on specific criteria (SPT - Shortest Processing Time).- **Processing Time:** Total time required to complete each job.- **Due Date:** Deadline by which the job should be completed.- **Flow Time:** Total time a job spends in the system.- **Lateness:** Difference between completion time and due date.- **Tardiness:** Amount of time a job exceeds its due date.**Average:** A row is provided for calculating the average values for flow time, lateness, and tardiness, though these values are not completed in this image.*Note: The spreadsheet partially completed shows a detailed setup for sequencing jobs based on different time management criteria often used in operations management.*

Given information is We have to calculate the flow time, tardiness, and lateness for each job, and…

Answered: The data for five tax analysis jobs…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

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.