Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Mathematics questions