2.12. Develop a spreadsheet model to solve Problem 6.

this question need these previos question in order to solve it .

2.6. For the factory and initial conditions of Problem 2.4, compute the long-run

average factory throughput, cycle time and x-factors for various constant work-inprocess

levels of 1 through 5.

11:37 ::!! LTE O Done 13 of 53 Guy L. Curry Richard M. Feldman Manufacturing Systems Modeling and Analysis Second Edition Springer Manufacturing Systems Modeling and Analysis Done 3 Book2.pdf (13 of 54) 2.4. Develop a table of the factory status at the beginning of each one-hour time interval for the following serial system under the condition that the system maintains a total work-in-process of 5 jobs. Develop this table for the system status for 15 hours of operation. The workstation processing times in hours) are listed in the squares representing the workstations. The initial (time 0) starting work-in-process distribution is (5,0,0). That is, 5 jobs in the first workstation and none elsewhere and assume that the first job begins processing at time 0. Compute the cycle times (time in the system) for the first 4 completed jobs assuming that all 5 initial jobs entered the system at time 0. 72 A 3 12 out new 11:37 ::!! LTE O Done 13 of 53 Guy L. Curry Richard M. Feldman Manufacturing Systems Modeling and Analysis Second Edition Springer Manufacturing Systems Modeling and Analysis Done 3 Book2.pdf (13 of 54) 2.4. Develop a table of the factory status at the beginning of each one-hour time interval for the following serial system under the condition that the system maintains a total work-in-process of 5 jobs. Develop this table for the system status for 15 hours of operation. The workstation processing times in hours) are listed in the squares representing the workstations. The initial (time 0) starting work-in-process distribution is (5,0,0). That is, 5 jobs in the first workstation and none elsewhere and assume that the first job begins processing at time 0. Compute the cycle times (time in the system) for the first 4 completed jobs assuming that all 5 initial jobs entered the system at time 0. 72 A 3 12 out new