Question: 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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

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...

Simulation This is a work integrated assessment item. The tasks are similar to what would be carried out in the workplace. Guide to marks: 20 marks - 8 for (a), 3 for (b), 5 for (c), 4 for (d) You...

QUESTION : Monte Carlo Simulation This is a work integrated assessment item. The tasks are similar to what would be carried out in the workplace. Guide to marks: 20 marks 12 for a, 2 for b, 6 for c...

QUESTION 3 Simulation Student guide to marks: 20 10 for a, 5 for b, 5 for c This is a work integrated assessment item. The tasks are similar to what would be carried out in the workplace. You have...

Assessment details for all students Assessment task 2Academic Essay Due date: 1:00PM AEST, Thursday of Week 7 (September 1) Weighting: 35% Length: 1200 words 10% (excluding reference list) ASSESSMENT...

Project Management Plan Value:20% Due date:16-May-2016 Return date:07-Jun-2016 Submission method options Alternative submission method Task This assignment follows from the case study used in...

i have attached the question 10/19/2010 Blackboard Academic Suite Assignment 2 (Session 1 Fall) Course Schedule Course Modules Review and Practice Exam Preparation Resources Print Note: T his...

please help me to find the answer for part 1, part3 and part4 Queensland University of Technology QUT Business School School of Accountancy AYB 339 Accountancy Capstone Integrated Case Study Semester...

2006EHR Assignment - Workplace Audit / Inspection Introduction (introduction & Presentation worth 5 Marks) Recommend 2 paragraphs Paragraph 1 - Provide overview of workplace; what it is, where it is,...

What type of chemical bonding is illustrated by Fig. 2.2

For each of the following long-lived assets, indicate its nature and the related cost allocation concept. Use the following symbols: Nature Cost Allocation Concept L Land DR Depreciation B Building...

Please provide the accurate answer to this General accounting problem using valid techniques. Melody Manufacturing provided the following data for the year: Standard variable overhead rate (SVOR) per...

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.