Preliminary Diagnostic
Executive Summary
ABC Limited
December 18, 2019
Objective of the engagement:
To strengthen the “building blocks” to support the company for its next phase of growth
System
Business Intelligence
Help the company transition
Providing the management
to the most optimum set of
with valuable business
systems and tools to
information and insights in
support scalability of
the form of MIS &
operations
Dashboards to enable
People
Process
Capital
decision making.
Assessing competencies and
Bring in Best Practices for
Assess readiness for next
skillsets of the F&A team
seamless flow of
round of fund-raise
members and ensuring that
transactions and information
the roles are aligned in a
in order to improve
manner that fosters
efficiencies and plug
2
productivity and learning.
leakages
Process
Current State
Existing Processes are too
“people-driven” rather than
“system-driven” with a high degree
of fragmentation and manual
intervention
Risk
There is a risk that the existing
processes may not be sustainable
as the size and scale of the
business grows..
Recommendation
Redefine existing processes to
make it more automated, system-
driven, comprehensive and robust
System
Proposed
Existing
Option 1
Option 2
Expense Mgt.
Base Data
Excel
Salesforce
HR Mgt. System
System
End-to-End ERP
Accounting Package
QBO
QBO
Reporting Tool
Excel
BI Tool
BI Tool
4
KPIs for Performance Measurement and Business Decision Making
Student Metrics
Financial Metrics
Faculty Metrics
Retention Rate / Roll over Rate
Percentage Of Students availing corporate
Percentage Of Faculty With Advanced
Student attendance rate
discounts
Certifications Or Degrees
CSAT
Average Tuition Cost per program
Number Of Training Sessions Per Year
Increase/Decrease in no. of Students
Repairs & Maintenance Cost per school
Faculty & Staff Attendance Rates
Student to Faculty Ratio
Meal expense per student
Teacher salaries
Number Of Students Enrolled Per Number Of
Admin expense per student
Staff Attrition rate
Applications
Overall Cost Per Student
Revenue and cost per employee
Distribution of income and cost between HO, RO
Faculty To Administration Ratio
and school
Revenue growth in existing business v/s new
business
Revenue vs cost vs profit
Program comparison (Capacity vs revenue)
Competitor benchmarking for fees
Facility Metrics
Transportation Metrics
Technological Metrics
Average Age Of Buildings
Availability of Tech Studio
Percentage Of Students availing School Van
Percentage Of Buildings Passing Corporate Inspection
Social Media Engagement
Service
Classroom Utilization Rate
Cost Of Transit per student
5
Plan of Action
MIS and reporting
Compliance
Completed: Determining KPI’s
Completed: Understand existing
Planned: Build MIS Framework,
compliance management process
Cash Flow Projection Process
Planned: Implementation of
Compliance tracker
Detailed Project Plan
#
Area
Particulars
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Pune Visit and
Bangalore Call
Pre Interim and
Final Review
Events
Weekly Meet
Weekly Meet
Weekly Meet2
and Weeklymeet
Interim Presentation3
Meet4
Performance Mgt.
- Understanding of current reporting matrix
Completed
Completed
Completed
- DeterminingKPI's
Completed
Completed
Completed
1
MIS
- Preparation and finalization of Reporting matrix(Template)
Not started
- Mapping of data sources from Tally
Not started
- Setting up Review Process
Not started
Process Improvement
- Identification of Process improvementareas
Completed
Completed
Completed
2
Process
- Walkthrough and mapping of as-is processes
Completed
Completed
Completed
- Identification of processgaps
Completed
Completed
Completed
- Mapping of to-be process
WIP
ERP Optimization (Tally)
-Understanding existing Architecture
Completed
Completed
Completed
3
Tools
- Identification of Gaps
Completed
Completed
Completed
- Rectification of logical flaws (Quickfixes)
Completed
Completed
Completed
- Future recommendations of changes in system
Not started
Cash flow Management
- Understanding current process of cash flow monitoring
Not started
4
Cash
- Gap analysis
Not started
- Suggest revised cashflow forecasting mechanism
Not started
- Pilot December 19 to report actuals
Not started
Compliance monitoring
Completed
- Understanding current process of compliance monitoring
5
Legal
- Gap analysis and improvement road map
WIP
-Implementation of compliance tracker
Not started
F&A Capability assessment
- Study of existing JD and time spent on each activity
6
People
Not started
- Efficiencyassessment
Not started
Thank You