service and network productivity with data analytics
lntent: Using case studies presented, measure and compare the productiv¡ty of the service
organization and the value network using data anal¡ical toolkits. Provide managerial implications
and suggest operational areas for improvement as appropriate.
Task: The NSW Health would like you to analyse and compare the productivity of 20 hospitals using
the following data. The 2 outputs are the minor cases and acute cases, whilst the inputs are the
number of nurses and the number of beds. They have specifically requested that you use Data
Envelopment Analysis (DEA) to perform your analysis which is available as an add-in on Excel.
E[ospital number Minor cases Acute cases Àrrl:es Eeds
t
;
4
5
6
7II
It
11
1?
13
14
1i
1ó
L7
ls
l9
2A
150
225
90
1é0
50
75
200
350
400
250
350
350
275
?20
100
324
375
?30
290
3é0
5û
75
10
4A
50
75
50
I00
90
300
350
400
375
40
IO
275
230
50
90
7t
200
600
20û
600
500
32A
175
400
550
900
850
720
900
250
115
õ0ù
550
2Ð0
450
.115
600
120û
2AO
300
2AO
150
450
320
480
660
72Ð
940
850
170
25A
590
710
280
410
575
7. Run the data where the goal is to minimise inputs. Analyse and interpret results, including
managerial implications and operational areas for improvement as appropriate
2. Run the data where the goal is to maximise outputs. Analyse and interpret results, including
managerial implications and operational areas for improvement as appropriate
Assessment Task 2: Computational Analytics
for Value Networks (lndividuall
Objective(s):
o This addresses subject learning objective(s) 3 and 4
o This assignment also contributes to development of
program learning objective(s) 3.2.
sAssessment
ASSESSMENT 2: COMPUTATIONAL ANALYTICS FOR VALUE NETWORKS
(rNDrvrDU ALI - 40%
25
UHIVERs{TY ÉF
TECHNOLOGT SYONEY
3. Based on the Emergency Scenario provided below, map the SVN identifying a 8-10 node
network. Based service value network identify any improvements to the efficiency that may
be gained. Make recommendations based on above on the metrics for each of the nodes
and the how the efficiency of these services may be improved. For this part of the question
you may'research and obtain publicly available data to substantiate your arguments
a. http://emergencvnsw.info/
b. https://data. nsw.gov.auldata/dataset?organ ization=bu rea u-of-health-information
EMERGENCY SCENARIO
The NSW government is looking to see if they can find any potent¡al productivity
improvement in their Emergency Services. You have been requested to examine the
potential for closer collaboration across the stakeholders of emergency services. You have
been given the following information.
Emergency services are required to respond to S accidents.
Accident 1- a child in Pyrmont has fallen from a tree and has a suspected broken collar
bone.
Accident2 -there is a serious accident on the Anzac Bridge. The motor cycle driver is down
and reporting not able to feel his legs, the driver in the car is distressed an in shock
Accident3 - am executive staying at the Novotel in Darling Harbour is reportedly having a
heart attack
Accident 4 - A fire has been reported at the local community centre in Ultimo and there are
5 people suffering smoke inhalation and one is having an asthma aüack
Accident 5 - an elderly person has fallen over in Harris Street Ultimo and a by passer called
000 for an ambulance
All accidents were notified to 000
a Allvictims will be taken to Royal Prince Alfred Hospital Emergency Department
Your writeup can be a maximum of 3000 Words lnclusive of References.
26
Marking criteria Assessment ltem 2 (lndividual)
Very Excellent
Good
Satisfactory Good
#
b
w
4p
Fail
lnput oriented (10)
Running the DEA data and obtaining the three worksheets (2)
Correct identification of technical effìciency categories (2)
ldentification of the areas of improvement where relevant (1)
ldentification of targets for technically and weakly efficient
DMUs (1)
Appropriate and feasible management recommendations
made (4)
Output oriented (8)
Correct identification of technical efficiency categories (2)
ldentifìcation of the areas of improvement where relevant (1)
ldentification of targets for technically and weakly efficient
DMUs (1)
Appropriate and feasible management recommendations
made (4)
Service Value Network (18)
ldentifìcation of appropriate stakeholders (4)
Professional service value map (4)
ldentifìcation of appropriate inputs and outputs (8)
Use of existing publically available data to substantiate case
(4)
Quality of Written document (4)
References (1)
Logical flow (1)
Grammar (1)
Presentation (1)