Can you be a little more clear? I don't understand your comment. I posted the excercise as I received it and didn't change anything. So please be a little clearer about what is not proper like you said in your comment.

H9 X fr A F G H AQ B C D E IJKLMNOPQR S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP 2 3 Assignment 3 of 3: How should I schedule my jobs? 4 Here's an example to test your skills at creating an effective -- and efficient -- production schedule. You are managing a highly custom Job Shop that repairs classic cars. Schedule the 5 jobs below based on the Critical Ratio to set your Priorities. (This is a small shop -- assume no wasted time moving from station to station.) Then, compute your schedule's performance metrics. Finally, to improve customer service you are considering doubling your equipment to have 5 each worker run 2 machines at each station. Is this worth the expense? 6 7 8 Job # 9 1 10 2 Station/Hours A/1 B/2 B/2 C/3 C/2 A/3 A/2 D/2 D/2 C/1 Critical Ratio Due Time (Hour) C/R Priority (based on C/R) 8 10 8 Typical options for dispatching jobs: First come, first served (FCFS) Priority rule Preemptive rule Critical ratio Shortest processing time Critical ratio = remaining tin remaining pro Process time C/3 D/2 8 A/1 D/4 10 D/1 0/2 8 C/ 3B/1 8 A/2 B/4 9 Total Processing time = 43 11 3 4 12 14 13 5 12 14 15 Exan 16 Hours Hours 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Gantt Chart Hours Hours 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 17 1 18 A A 6 19 20 B B 21 Complete your schedule here in the format of a Gantt Chart by typing in the Job Number (e.g. 1, 2, 3...) in each block that will be worked. Color-coding is set using Conditional Format. Use the Critical Ratio that you computed above to prioritize dispatching (1st, 2nd, 3rd... = 1, 2, 3....). See 22 C 23 24 D Scheduling + H9 fic A B D E F G H I J K L MNOPQR S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP Due Completed by hour 26 Time (hour) 8 Job On-time (Y/N) Hours late 1 Note: Contract terms are rebate of $500 for each late job plus $50 per hour late 27 28 29 2 3 10 8 14 12 30 4 5 31 32 33 34 35 Make Span= Utilization = On-Time rate= Total lateness Cost of lateness = $ hours #DIV/0! 0,0% O hours 36 37 38 Two Machines per Station Now, schedule again with renting an additional machine per station. Use the same Critical Ratio prioritization. 39 40 Hours Hours 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Gantt Chart Hours Hours 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 41 Job # 42 1 A1 43 A2 2 3 Station/Hours A/1 B/2 B/2 C/3 C/2 A/3 A/2 D/2 D/2 C/1 (same requirements as before) C/ 3D/2 A/1 D/4 D/1 0/2 C/3 B/1 A/2 B/4 B1 44 45 4 B2 46 5 C1 47 C2 D1 48 49 D2 Scheduling H9 X for A B c F G H I J K L MNOPQR S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP W D Time (hour) 8 E Completed by hour 51 On-time (Y/N) Hours late Job 1 52 53 10 Note: Contract terms are rebate of $500 for each late job plus $50 per hour late 2 3 54 8 55 4 14 56 5 12 57 58 59 Make Span = Utilization = On-Time rate= Total lateness Cost of lateness = $ hours #DIV/0! 0,0% O hours 60 61 62 63 64 65 66 Variable cost of renting new machines (running or not): A $ 10,00 per hour B $ 15,00 per hour C $ 25,00 per hour D $ 17,00 per hour Additional cost of 2nd machines (during full Make Span) $ - $ - $- $ - 67 68 69 70 Total Additional Cost = $ - 71 72 Profit or Loss $ (positive is an overall benefit, negative is net loss) 73 74 What is your recommendation? Rent additional machines or not? Why? ROI = ### Scheduling + H9 X fr A F G H AQ B C D E IJKLMNOPQR S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP 2 3 Assignment 3 of 3: How should I schedule my jobs? 4 Here's an example to test your skills at creating an effective -- and efficient -- production schedule. You are managing a highly custom Job Shop that repairs classic cars. Schedule the 5 jobs below based on the Critical Ratio to set your Priorities. (This is a small shop -- assume no wasted time moving from station to station.) Then, compute your schedule's performance metrics. Finally, to improve customer service you are considering doubling your equipment to have 5 each worker run 2 machines at each station. Is this worth the expense? 6 7 8 Job # 9 1 10 2 Station/Hours A/1 B/2 B/2 C/3 C/2 A/3 A/2 D/2 D/2 C/1 Critical Ratio Due Time (Hour) C/R Priority (based on C/R) 8 10 8 Typical options for dispatching jobs: First come, first served (FCFS) Priority rule Preemptive rule Critical ratio Shortest processing time Critical ratio = remaining tin remaining pro Process time C/3 D/2 8 A/1 D/4 10 D/1 0/2 8 C/ 3B/1 8 A/2 B/4 9 Total Processing time = 43 11 3 4 12 14 13 5 12 14 15 Exan 16 Hours Hours 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Gantt Chart Hours Hours 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 17 1 18 A A 6 19 20 B B 21 Complete your schedule here in the format of a Gantt Chart by typing in the Job Number (e.g. 1, 2, 3...) in each block that will be worked. Color-coding is set using Conditional Format. Use the Critical Ratio that you computed above to prioritize dispatching (1st, 2nd, 3rd... = 1, 2, 3....). See 22 C 23 24 D Scheduling + H9 fic A B D E F G H I J K L MNOPQR S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP Due Completed by hour 26 Time (hour) 8 Job On-time (Y/N) Hours late 1 Note: Contract terms are rebate of $500 for each late job plus $50 per hour late 27 28 29 2 3 10 8 14 12 30 4 5 31 32 33 34 35 Make Span= Utilization = On-Time rate= Total lateness Cost of lateness = $ hours #DIV/0! 0,0% O hours 36 37 38 Two Machines per Station Now, schedule again with renting an additional machine per station. Use the same Critical Ratio prioritization. 39 40 Hours Hours 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Gantt Chart Hours Hours 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 41 Job # 42 1 A1 43 A2 2 3 Station/Hours A/1 B/2 B/2 C/3 C/2 A/3 A/2 D/2 D/2 C/1 (same requirements as before) C/ 3D/2 A/1 D/4 D/1 0/2 C/3 B/1 A/2 B/4 B1 44 45 4 B2 46 5 C1 47 C2 D1 48 49 D2 Scheduling H9 X for A B c F G H I J K L MNOPQR S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP W D Time (hour) 8 E Completed by hour 51 On-time (Y/N) Hours late Job 1 52 53 10 Note: Contract terms are rebate of $500 for each late job plus $50 per hour late 2 3 54 8 55 4 14 56 5 12 57 58 59 Make Span = Utilization = On-Time rate= Total lateness Cost of lateness = $ hours #DIV/0! 0,0% O hours 60 61 62 63 64 65 66 Variable cost of renting new machines (running or not): A $ 10,00 per hour B $ 15,00 per hour C $ 25,00 per hour D $ 17,00 per hour Additional cost of 2nd machines (during full Make Span) $ - $ - $- $ - 67 68 69 70 Total Additional Cost = $ - 71 72 Profit or Loss $ (positive is an overall benefit, negative is net loss) 73 74 What is your recommendation? Rent additional machines or not? Why? ROI = ### Scheduling +