Question: please work step by step in Microsoft Excel or Google Sheets. please provide excel equations used in each step. 7. Using the information presented in

please work step by step in Microsoft Excel or Google Sheets. please provide excel equations used in each step. please work step by step in Microsoft Excel or
7. Using the information presented in the following table, identify the processing sequence that would result using (1) FCFS. (2) SPT (3) EDD, and (4) CR. For each method, determine (1) average job flow time. (2) average job tardiness, and (3) average number of jobs in the system. Jobs are listed in order of arrival. (How: First determine the total job time for each job by computing the total processing time for the job and then adding in the setup time. All times and due dates are in hours) Processing Units Setup Due Job Time per Unit per Job Time Date 14 45 0.7 4 b 25 14 0.5 10 c .10 18 0.2 12 d 25 40 1.0 20 c 10 75 0.5 IS

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!