Build a spreadsheet model for problem 2.15 in (CF). Note this is the same factory model we studied in class. Vary the CONWIP between 1 and 15 units for this system, and for each value of CONWIP simulate 1020 hours. Estimate the average throughput, cycle-time and x-factor of the last 1000 hours. Comment on which values of CONWIP are undesirable and which ones could be desirable depending on the company's priorities. 2.15. Develop a spreadsheet model of the factory in Sect. 2.2 (Fig. 2.6) except that Workstation 1, 2, and 4 have random processing times that are distributed according to a discrete uniform distribution between 1 and 3, and Workstation 3 has a random processing time distributed according to a discrete uniform distribution between 1 and 4. To generate random integers uniformly between a and b in Excel use [...] RANDBETWEEN(a,b). Fig. 2.6 A four machine serial flow production factory 2 with constant service times and a constant WIP level out new Build a spreadsheet model for problem 2.15 in (CF). Note this is the same factory model we studied in class. Vary the CONWIP between 1 and 15 units for this system, and for each value of CONWIP simulate 1020 hours. Estimate the average throughput, cycle-time and x-factor of the last 1000 hours. Comment on which values of CONWIP are undesirable and which ones could be desirable depending on the company's priorities. 2.15. Develop a spreadsheet model of the factory in Sect. 2.2 (Fig. 2.6) except that Workstation 1, 2, and 4 have random processing times that are distributed according to a discrete uniform distribution between 1 and 3, and Workstation 3 has a random processing time distributed according to a discrete uniform distribution between 1 and 4. To generate random integers uniformly between a and b in Excel use [...] RANDBETWEEN(a,b). Fig. 2.6 A four machine serial flow production factory 2 with constant service times and a constant WIP level out new