Difference between revisions of "ANLY482 AY2016-17 T2 Group10 Project Overview"

From Analytics Practicum
Jump to navigation Jump to search
Line 48: Line 48:
 
==<div style="background: #ffffff; padding: 17px;padding:0.3em; letter-spacing:0.1em; line-height: 0.1em;  text-indent: 10px; font-size:17px; text-transform:uppercase; font-weight: light; font-family: 'Century Gothic';  border-left:8px solid #1b96fe"><font color= #000000><strong>Sponsor Background</strong></font></div>==
 
==<div style="background: #ffffff; padding: 17px;padding:0.3em; letter-spacing:0.1em; line-height: 0.1em;  text-indent: 10px; font-size:17px; text-transform:uppercase; font-weight: light; font-family: 'Century Gothic';  border-left:8px solid #1b96fe"><font color= #000000><strong>Sponsor Background</strong></font></div>==
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Century Gothic, Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left; font-size: 15px">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Century Gothic, Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left; font-size: 15px">
Pharmaceutical Company L focuses on manufacturing products for illnesses such as asthma, cancer, infections, diabetes and mental health  that come in the form of medicines, vaccines and other various consumer health products. The company has a strong interest in the Singaporean market, as can be seen from its investment position, with a staggering 1.5 billion invested in the Singaporean biomedical industry. Singapore is the Asia Pacific headquarters for GSK and the company has two global manufacturing supply sites and a vaccines manufacturing facility locally.
+
Our sponsor, a global pharmaceutical company, relies heavily on its sales representatives to generate sales for new drugs and maintaining sales relationships with existing customers. Customers include that of government hospitals, private hospitals, polyclinics, to name a few. On a quarterly basis, our sponsor allocates their therapy teams a target number of sales interactions to be made with personnel of these institutions. As our sponsor believes there is a need for full understanding of products before one can make any meaningful headway in sales, it structures its sales teams into different therapy groups, whereby each therapy group focuses on a group of drugs that treat a genre of illnesses (e.g. respiratory diseases, allergies) and people in sales teams are only able to engage in sales related to their allocated therapy group.
 +
 
</div>
 
</div>
 
<!-- End Body --->
 
<!-- End Body --->
 
 
<!-- Body -->
 
==<div style="background: #ffffff; padding: 17px;padding:0.3em; letter-spacing:0.1em; line-height: 0.1em;  text-indent: 10px; font-size:17px; text-transform:uppercase; font-weight: light; font-family: 'Century Gothic';  border-left:8px solid #1b96fe"><font color= #000000><strong>Project Background</strong></font></div>==
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Century Gothic, Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left; font-size: 15px">
 
Pharmaceutical Company L supplies its products to various clinics in Singapore. Periodically, salespersons are sent to clinics of interest with the aim of promoting new/existing drugs, eventually leading to a purchase. Sales teams are split into their various drug therapy groups, i.e “cancer” and each drug therapy group has only exactly one sales team in charge of it. In each drug therapy group, there will be a couple of different brands and salespersons are only allowed to sell the brands under their respective therapy groups. For each brand, there is also differing prescription dosage and methods. Salespersons have a fixed number of calls to make every quarter for each drug, e.g Person A has to make 5 calls for drug A in Q1 but 6 calls in another drug in Q1. Salespersons also have a sales target to meet for the drugs they sell.
 
</div>
 
<!-- End Body --->
 
 
  
 
<!-- Body -->
 
<!-- Body -->
 
==<div style="background: #ffffff; padding: 17px;padding:0.3em; letter-spacing:0.1em; line-height: 0.1em;  text-indent: 10px; font-size:17px; text-transform:uppercase; font-weight: light; font-family: 'Century Gothic';  border-left:8px solid #1b96fe"><font color= #000000><strong>Project Objectives</strong></font></div>==
 
==<div style="background: #ffffff; padding: 17px;padding:0.3em; letter-spacing:0.1em; line-height: 0.1em;  text-indent: 10px; font-size:17px; text-transform:uppercase; font-weight: light; font-family: 'Century Gothic';  border-left:8px solid #1b96fe"><font color= #000000><strong>Project Objectives</strong></font></div>==
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Century Gothic, Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left; font-size: 15px">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Century Gothic, Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left; font-size: 15px">
Pharmaceutical Company L wishes to understand, if present, any relationship between sales interactions and actual sales outputs.  
+
The sponsor has long wished to understand the impact of sales interactions on the ability to drive sales. Yet to do that, there needs to be clear understanding that different factors could cause any possible correlation between sales interactions and sales revenue to be skewed. This paper will focus on identifying these potential factor groups and using ANOVA individually on these potential factor groups to understand if sales interactions do have an impact on sales revenue for those groups, essentially identifying sections in which the company should place emphasis on manpower interactions and areas where slack could exist for an efficient allocation of resources.
There are two main project objectives:
 
# Analyze and visualize consumer purchase habits
 
# Analyze, evaluate and visualize data regarding interactions between salespersons and consumers
 
Through these, some of the business applications that could potentially be improved are:
 
# Frequency of visits and number of calls salespersons should make to maximise manpower utility
 
# Strategic targeting of consumers during “restock” periods for higher rates of sales
 
# Pushing and prioritizing of certain brands for certain customers
 
 
</div>
 
</div>
 
<!-- End Body --->
 
<!-- End Body --->

Revision as of 10:54, 15 April 2017

Kesmyjxlogo.png

HOME

ABOUT US

PROJECT OVERVIEW

ANALYSIS & FINDINGS

PROJECT MANAGEMENT

DOCUMENTATION

Overview

Data

Methodology

<< ANLY482 AY2016-17 T2 Projects

Our sponsor, a global pharmaceutical company, relies heavily on its sales representatives to generate sales for new drugs and maintaining sales relationships with existing customers. Customers include that of government hospitals, private hospitals, polyclinics, to name a few. On a quarterly basis, our sponsor allocates their therapy teams a target number of sales interactions to be made with personnel of these institutions. As our sponsor believes there is a need for full understanding of products before one can make any meaningful headway in sales, it structures its sales teams into different therapy groups, whereby each therapy group focuses on a group of drugs that treat a genre of illnesses (e.g. respiratory diseases, allergies) and people in sales teams are only able to engage in sales related to their allocated therapy group.

Project Objectives

The sponsor has long wished to understand the impact of sales interactions on the ability to drive sales. Yet to do that, there needs to be clear understanding that different factors could cause any possible correlation between sales interactions and sales revenue to be skewed. This paper will focus on identifying these potential factor groups and using ANOVA individually on these potential factor groups to understand if sales interactions do have an impact on sales revenue for those groups, essentially identifying sections in which the company should place emphasis on manpower interactions and areas where slack could exist for an efficient allocation of resources.


Stakeholders

The primary stakeholders of this project are:

  • Sponsor: Ms Elaine Tan, Pharmaceutical Company L
  • Project Supervisor: Prof Kam Tin Seong, Associate Professor of Information Systems (Practice)