Difference between revisions of "ANLY482 AY2017-18 T2 Group 16 Methodology"

From Analytics Practicum
Jump to navigation Jump to search
(Created page with "centre|1000px <!------- Main Navigation Bar----> <center> {| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"| | style="font-family:...")
 
Line 31: Line 31:
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="150px" |  
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="150px" |  
 
[[ANLY482_AY2017-18_T2_Group_16_Project_Overview|<font color="#3c3c3c"><strong>OVERVIEW</strong></font>]]
 
[[ANLY482_AY2017-18_T2_Group_16_Project_Overview|<font color="#3c3c3c"><strong>OVERVIEW</strong></font>]]
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="150px" | 
 
[[ANLY482_AY2017-18_T2_Group_16_SROI|<font color="#3c3c3c"><strong>SROI</strong></font>]]
 
  
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; background-color: #fff" width="150px" |   
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; background-color: #fff" width="150px" |   
Line 47: Line 44:
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left">
  
We will have data on YMCA's programmes from the last 10 years. This data will include variables such as number of volunteers, the costs of the programme, the number of beneficiaries involved and the activities.
+
*Forecasted and Actual number of volunteers, beneficiaries and sessions per programme, from 2012 to 2017
 
+
*Sector served per session in each programme, and the number of beneficiaries served (from 15 separate .pptx files)
More to be updated as time goes.
+
*Where these volunteers were recruited from
 +
*Annual Report figures on the number of volunteers, beneficiaries (from .pdf files)
  
 
</div>
 
</div>
  
==<div style="background: #ffffff; padding: 17px; line-height: 0.1em;  text-indent: 10px; font-size:17px; font-family: Helvetica;  border-left:8px solid #0091b3"><font color= #000000><strong>Methodology</strong></font></div>==
+
==<div style="background: #ffffff; padding: 17px; line-height: 0.1em;  text-indent: 10px; font-size:17px; font-family: Helvetica;  border-left:8px solid #0091b3"><font color= #000000><strong>Midpoint Methodology</strong></font></div>==
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left">
  
The main project will involve the formulation and calculation of the SROI of each of their programmes. Essentially, the SROI will be measured using the following equation:
+
Based on the data, the group has decided to split up the work into three components.
 +
 
 +
<strong> 1. Trend-based insight generation </strong>
 +
YMCA has indicated that their forecasted figures have remained the same throughout the years (they have been copying it over since 2012), but they have used these inaccurate forecasted figures as a planning gauge. They have also listed out the actual number of volunteers, beneficiaries and sessions completed per year, from January to December.
 +
 
 +
From this data, some of the questions we may answer include:
 +
 
 +
Performance:
 +
*Has YMCA improved its efficiency of volunteers over time? Has it occurred only in specific sectors or programmes?
 +
*What is its peak efficiency ratio for each sector or programme?
 +
 
 +
Time-based:
 +
*When are the peak periods for YMCA, in terms of total number of sessions, and in terms of sector?
 +
*Are there certain months or times where YMCA has not been able to recruit the number of volunteers forecasted?
 +
 
 +
<strong>2. Sector-based insight generation </strong>
 +
YMCA discussed three main sectors that it serves - youths, elderly, and disabilities. However, it is unsure of whether it is using volunteers efficiently. For instance, while programmes involving disabilities typically require one volunteer for every beneficiary, other programmes involving youth may be able to cater for a larger number of beneficiaries served per volunteer. Therefore, some of the questions we may answer include:
  
''Social purpose cashflow = Total social benefit - Operating expenses of the programme''
+
*What is each sector's average volunteer efficiency, in terms of number of beneficiaries?
 +
*What is each sector's highest and lowest volunteer efficiency, and does it match the actual needs of the sector as mentioned by YMCA?
  
First, we will be exploring the data given and coming up with components that will help us calculate the operating expenses of the individual programs. Additionally, other components such as indirect social benefits and program cost savings which will be included in our proposed SROI framework will be discussed with the sponsor (and if necessary, additional data will be requested).
+
<strong>3. Programme-based insight generation </strong>
 +
YMCA would also like to know how each of its 14 programmes have been performing in terms of efficiency. Some programmes occur once a year, yet have a perceived high impact (which YMCA defines through speaking to its participants, generating qualitative feedback). Other programmes occur on an ad-hoc basis, and may be seen as inefficient in terms of manpower. Therefore, some of the questions we may answer include:
  
The final framework will be reviewed by the sponsor and applied to each of their programmes to allow them to find the net present value of their current programmes and take the necessary actions. Additionally, we also intend to leverage on the YMCA’s volunteer data given and explore it further to see if we can derive any insights about their volunteers eg. the top determinant of volunteer satisfaction, retainment, where are regression could be done. The end product would help them find out if there are any improvements which can be made to their volunteer programme.
+
*What is the peak and average efficiency of each programme?
 +
*After accounting for the number of sessions per year, is each programme efficient in its use of volunteers?
  
 
</div>
 
</div>

Revision as of 08:10, 6 February 2018

YMCA.jpg

HOME

PROJECT OVERVIEW

INSIGHTS

PROJECT MANAGEMENT

DOCUMENTATION

BACK TO ANLY482

OVERVIEW

METHODOLOGY

Data

  • Forecasted and Actual number of volunteers, beneficiaries and sessions per programme, from 2012 to 2017
  • Sector served per session in each programme, and the number of beneficiaries served (from 15 separate .pptx files)
  • Where these volunteers were recruited from
  • Annual Report figures on the number of volunteers, beneficiaries (from .pdf files)

Midpoint Methodology

Based on the data, the group has decided to split up the work into three components.

1. Trend-based insight generation YMCA has indicated that their forecasted figures have remained the same throughout the years (they have been copying it over since 2012), but they have used these inaccurate forecasted figures as a planning gauge. They have also listed out the actual number of volunteers, beneficiaries and sessions completed per year, from January to December.

From this data, some of the questions we may answer include:

Performance:

  • Has YMCA improved its efficiency of volunteers over time? Has it occurred only in specific sectors or programmes?
  • What is its peak efficiency ratio for each sector or programme?

Time-based:

  • When are the peak periods for YMCA, in terms of total number of sessions, and in terms of sector?
  • Are there certain months or times where YMCA has not been able to recruit the number of volunteers forecasted?

2. Sector-based insight generation YMCA discussed three main sectors that it serves - youths, elderly, and disabilities. However, it is unsure of whether it is using volunteers efficiently. For instance, while programmes involving disabilities typically require one volunteer for every beneficiary, other programmes involving youth may be able to cater for a larger number of beneficiaries served per volunteer. Therefore, some of the questions we may answer include:

  • What is each sector's average volunteer efficiency, in terms of number of beneficiaries?
  • What is each sector's highest and lowest volunteer efficiency, and does it match the actual needs of the sector as mentioned by YMCA?

3. Programme-based insight generation YMCA would also like to know how each of its 14 programmes have been performing in terms of efficiency. Some programmes occur once a year, yet have a perceived high impact (which YMCA defines through speaking to its participants, generating qualitative feedback). Other programmes occur on an ad-hoc basis, and may be seen as inefficient in terms of manpower. Therefore, some of the questions we may answer include:

  • What is the peak and average efficiency of each programme?
  • After accounting for the number of sessions per year, is each programme efficient in its use of volunteers?