2 Simulation This is a work integrated assessment item. The tasks are similar to what would be carried out in the workplace. 20 marks - 10 for (a), 3 for (b), 7 for (c) A factory has a toolshop in which one person serves toolmakers and is paid $75 per hour. Toolmakers employed by the factory must go to the toolshop for new tools, and are paid $100 per hour. Over a period of time it has been noted that the time between arrivals of toolmakers at the toolshop and the time to serve a toolmaker are as follow: Time between (minutes) Arrivals Relative Frequency 3 4 5 6 7 8 0.01 0.15 0.20 0.20 0.35 0.09 1.00 Service Time (minutes) 5 6 7 8 9 Relative Frequency 0.1 0.2 0.4 0.2 0.1 1.0 (a) Using Excel set up a simulation model to simulate about 2 hours (120 minutes) from time zero, and determine whether one attendant is sufficient or whether it is profitable to place a second attendant in the toolshop. (b) Provide the costs over the 2 hours for the toolmakers' lost time and for the attendant's wages. Show the data and the model in two printouts: (1) the results, and (2) the formulas. Both printouts must show row and column numbers and be copied from Excel into Word. See Spreadsheet Advice in Interact Resources for guidance. (c) Your manager has suggested that a reorganisation of the toolshop could reduce the time taken to serve the toolmakers by 2 minutes, ranging from 3 to 7 minutes per toolmaker (but with the same relative frequencies as in parts (a) and (b)). Change the data for service times in your model (copy the model to make the changes, keeping the original model intact). Write a report to your manager explaining your conclusions, suggesting how much might be spent on the reorganisation and still be as well off. The report must be dated, addressed to the Manager and signed off by you. (Word limit: No more than 200 words)