Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3 Simulation This is a work integrated assessment item. The tasks are similar to what would be carried out in the workplace. 10 marks A
3 Simulation This is a work integrated assessment item. The tasks are similar to what would be carried out in the workplace. 10 marks A general practice has a nurse to attend patients with wounds and who need vaccinations.wages of the nurse is $12.50. From an analysis of one week's operation of the nursing service the following data were derived: Time Number between of arrivals occasions 10 10 15 20 20 25 25 30 30 15 Service Number time of (minutes) occasions 10 40 15 20 20 20 30 10 40 10 Using Excel set up a simulation model to simulate about 2 hours (120 minutes) from time zero, and determine whether one nurse is sufficient or whether a second nurse is needed in the practice. 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started