https://www.random.org/dice/(I suggest rolling 10 dice at once with the above random generator to fill in your spreadsheet, rolling 5 times, once for each work center. Complete the spreadsheet in the order the dice appear on the screen, from day 1 to day 10.)SCENARIO:Assume that as the manager of a process, you have instructed your team that they need to complete at least 30 units of finished goods, or the business will need to shut down. To aid in this production goal, you have instructed each worker that they must individually be capable of producing (i.e. the total number rolled across the 10 days by each work center, i.e. the planned production or the work center’s potential production) must be at least 30. In fact, to incentivize the workers, you have come up with the following evaluation system:If WC rolled ≥ 30, the worker gets to keep his/her jobIf WC rolled 35-40, worker gets an “Excellent” ratingIf WC rolled > 40, worker gets an “OUTSTANDING”Before starting the exercise, what is your estimate of total finished goods produced, knowing that the average roll of a die will be 3.5, so over the 10 days of production, the expected outcome for each workstation would be 3.5×10 = 35?After completing the exercise, was the team able to meet the production goal of 30? What contributed to their success or failure in meeting this goal?As a manager, what do you suggest to improve the system?SET- UP:You can set up physical bowls (you’ll need 6 total – one for supply to start with and one each for the production that each of 5 work centers completes) and run the game using actual tokens of some sort (i.e. pennies, rocks, etc.). Alternatively, or in addition to, you can set it up on the following spreadsheet. Either way, you will need to record your results (roll amount, production amount, WIP amount/ Finished Goods for each work center for each day) and should use the attached EXCEL spreadsheet to record these values for each workcenter for each of 10 days.EXCEL SPREADSHEET to record/ run the simulation: In the additional materials named – (Dice Game Sheet RUN 1.xlsx)Complete the game in the Excel Spreadsheet. The instructions are in the powerpoint linkOnce you have completed the exercise, you should post the responses to the following questions within one post (you will not be able to see other posts until you have posted your own results and comments.)By the way you could answer these questions on a separate sheet or you could put it underneath the game excel link whatever works for you.1) What was your guess/ estimate on how many completed goods you would have at the end of the 10 days?2a) Embed an image of your completed spreadsheet for the 10 days of production for each of the 5 work centers. Make sure the image is EMBEDDED in your post and not attached as a file. If you can’t see the image, it hasn’t been embedded properly.2b) List the total finished goods produced for the 10 days3) Calculate and list each Work Center’s Efficiency.Remember, Efficiency = actual total production/ total rolls (planned production)WC 1 = 100%WC 2 = ??WC 3= ??WC 4 = ??WC 5 = ??4) List the total WIP across the 4 work centers (not after WC 5 since this is finished goods)5) Why do you believe your total finished goods were less / more than your estimated amount? In other words, what has contributed to the success/ failure of the team to meet/ exceed the manager’s production goal?6) Based on your understanding of the Theory of Constraints, what could be done to INCREASE the total finished goods, using the same 6-sided dice to determine production?7) What lessons, or concepts have you learned from this exercise?
