Computational Analytics for Value Networks
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.
Run the data where the goal is to minimise inputs. Analyse and interpret results, including
managerial implications and operational areas for improvement as appropriate
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.
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.
Marking criteria Assessment ltem 2 (lndividual)
Very Excellent
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