Analytics

From Date
To Date
gross profit

Gross Profit Margin

42 %

Gross Profit

₹67,57,787
operating profit margin
net profit margin
₹3,23,456
berry ratio
fixed expenses
 Salaries 16,32,323
Marketing 16,32,323
Accounting and Legal 16,32,323
Rent and Utilities 16,32,323
Office and Supplies 16,32,323
Insurance 16,32,323
variable expenses
 Salaries 16,32,323
Marketing 16,32,323
Accounting and Legal 16,32,323
Rent and Utilities 16,32,323
Office and Supplies 16,32,323
Insurance 16,32,323
vendor payment error rate
accounts payable turnover
accounts receivable turnover

AR Turnover:

30.8 days

AR Turnover Ratio:

11.8

AR TURNOVER BY PAYMENT TARGET

 1-30 Days
31-60 Days
61-90 Days
90+ Days
current ratio
1.90
Quick Ratio
Current Ratio
Last 12 Months
operating expenses ratio
cash conversion cycle

60.3

DSO

60.3

DIO

60.3

DPO

60.3

CCC

actual vs forecast expenses

Actual

₹54,23,454

Forecast

₹54,23,454

Absolute

₹54,23,454
return on assets
return on equity
economic value added
₹3,23,456
employee satisfaction

trend

positive
payroll headcount ratio
0.02
budget variance
Property Actual Budget Variance
Front Fairway ₹3997 ₹3997 ₹3997
Lakeside Apartment ₹3997 ₹3997 ₹3997
Front Fairway ₹3997 ₹3997 ₹3997
Front Fairway ₹3997 ₹3997 ₹3997
Total ₹3997 ₹3997 ₹3997
actual vs forecast income
Actual Forecast Absolute
Revenue ₹3997 ₹3997 ₹3997
COGS ₹3997 ₹3997 ₹3997
Gross Profit ₹3997 ₹3997 ₹3997
OPEX ₹3997 ₹3997 ₹3997
EBIT ₹3997 ₹3997 ₹3997
Taxes ₹3997 ₹3997 ₹3997
Net Profit ₹3997 ₹3997 ₹3997
working capital
Cash ₹3997
Accounts Receivable ₹3997
Inventory ₹3997
Prepaid Expenses ₹3997
Current Assets ₹3997
Accounts Payable ₹3997
Credit Card Debt ₹3997
Bank Operating Credit ₹3997
Accrued Expenses ₹3997
Taxes Payable ₹3997
Current Liabilities ₹3997
Working Capital ₹3997

Analytics

From Date
To Date
sales growth
₹323232

Current period

₹323232

previous period

sales revenue by sales representative | last 12 weeks
383

new customers | ytd

₹3,83,42,32,322

sales revenue | ytd

sales revenue vs. target | ytd
₹524

Avg Revenue per User

₹234

Customer Acquisition Cost

Acquisition Cost vs Avg Revenue per User
₹234 (12%)

Avg. Customer Acquisition Cost to Previous Month

Average Customer Acquisition Cost | Last 12 months
383

new customers | ytd

383

new customers | ytd

Average Customer Lifetime Value | Last 10 weeks
customer churn rate

Churn Rate

₹54,23,454

Customers Lost

₹54,23,454

Revenue Lost

₹54,23,454

184 days

Average Sales Cycle Length
Opportunity

3.2 days on average

Proposal

3.2 days on average

Negotiation

3.2 days on average

Closing

3.2 days on average

184
17%
21%
38%
24%
Lead to opportunity ratio

5:1

Unqualified leads turned into qualified leads

Leads

2287

Opportunities

2287

Opportunity to Win ratio
Anna

Sales Rep 1

31%
Anna

Sales Rep 1

31%
Anna

Sales Rep 1

31%
Opportunity to Win ratio | Last 10 weeks
Lead conversion ratio

16:1

Leads turned into customers(wins)

Lead conversion rate
Daniel

Sales Manager 1

3%

conversion rate

Daniel

Sales Manager 1

3%

conversion rate

Daniel

Sales Manager 1

3%

conversion rate

new sales opportunity
Nr. of opportunities

102 (+7%)

This vs Last Month

Purchase Volume

102 (+7%)

This vs Last Month

New Sales Opportunities & Purchase Volume

by First Contact Date

Sales Opportunity Score

2.82 (+1%)

Avg Score Value This vs Last Month

Sales Volume, Revenue & Profit per country
Top 5 Countries by Sales Volume
Country Sales Volume Revenue Profit Profit Margin
USA 141.282 ₹67,75,44,444 ₹1233454 18.8%
China 141.282 ₹67,75,44,444 ₹1233454 18.8%
Australia 141.282 ₹67,75,44,444 ₹1233454 18.8%
India 141.282 ₹67,75,44,444 ₹1233454 18.8%
South Korea 141.282 ₹67,75,44,444 ₹1233454 18.8%
Total/Avg 141.282 ₹67,75,44,444 ₹1233454 18.8%
Revenue & profit per product
Avg Purchase Value

518.78 (+4%)

This vs Last Month

Nr. of opportunities & avg. purchase value

by package

Revenue Per Sales ERP

Avg. Revenue per Sales ERP

₹3002

Target Per Sales ERP

₹3002

To Previous Period

7%

Profit Margin Per Sales ERP

Profit Margin per Sale

₹3002

Target Per Sales ERP

₹3002

To Previous Period

7%

Incremental Sales by campaign

Twitter

₹3002

Facebook

₹3002

Instagram

₹3002

Google Ads Search

₹3002

Email

₹3002

GDN

₹3002

NPS per sales erp
NPS last month NPS last 6 months
Fiona 84
Kennedy 84
Joe 84
Tom 84

Comparision to previous period

Up Sell/Cross-sale rates
Up/Cross-sale Revenue Up/Cross-sale Sales Up/Cross-sale % of Sales

Anna Kruger

 5 15%

Anna Kruger

 5 15%

Anna Kruger

 5 15%

Anna Kruger

 5 15%

Anna Kruger

 5 15%

Analytics

From Date
To Date
Software
75%
Marketing
74%
Infrastructure
47%
Hardware
33%
Digital Services
9%
Development Compliance Rate by Year

8

Gold Partner

55

Silver Partner

100

Bronze Partner

Number of Suppliers per Year
Development of Avg. Purchase Order Cycle (in Days)
Nr. of Suppliers
% of Suppliers
Short
48%
Medium
48%
Long
48%
Purchase Price Variance
This Quarter

98.1%(-1.3)

vs. Last Quarter

Trend
Purchase Order Coverage

This Quarter

96.7%

vs. Last Quarter

0.66pp
Trend
Supplier Quality Rating
Supplier % Refunded Availability Defect Rate Quality Score
Tech Consultant 0.102% 0.102% 0.102% 0.102%
McMilan Log 0.102% 0.102% 0.102% 0.102%
Globex Ship 0.102% 0.102% 0.102% 0.102%
Raw Suppl Co. 0.102% 0.102% 0.102% 0.102%
Plumbus Shop 0.102% 0.102% 0.102% 0.102%
Average 0.102% 0.102% 0.102% 0.102%
Supplier Availability
Supplier Defect Rate And Defect Type
Defect Rate
1.9% 1.9% 1.9% 1.9% 1.9% 1.9%
Vendor Rejection Rate & Return to Vendor Cost
Lead Time in Days
150

Avg. Lead Time (in Days)

Emergency Purchase Ratio

Quaterly Average

2.3%
2.3%
2.3%

Quaterly Average By Product

Percent of Purchases in Time & Budget

Average Total

75%

Average by Category

Cost of a Purchase Order

Cost-This Year

₹13,144(+4%)

Number of Orders-This Year

₹13,144(+4%)
Cost - 5 Year Trend
Cost Reduction

5 Year Trend

By Supplier Category

Transistors
 €543254
Switches
€543254
Sensors
€543254
Battery
€543254
Display
€543254
Other
€543254
Cost Avoidance
383

new customers | ytd

5 Year Trend

By Supplier Category

Maverick Spend
Nr. of opportunities

102 (+7%)

This vs Last Month

Quarterly Trend

This Quarter vs Last Quarter
Software 13.2% 0.3pp
Hardware 13.2% 0.3pp
Infrastructure 13.2% 0.3pp
Digital Services 13.2% 0.3pp
Marketing 13.2% 0.3pp
Spend Under Management

Average Total

80.6%

Average By Month

Procurement ROI

By Supplier Category

Analytics

From Date
To Date
Avg Absenteesim Rate
Absenteesim Rate Over Last 5 Years
1.5 hrs

Avg Overtime Per Week

12%

More Over This Time

Avg Overtime Hours By Age Group
Training Cost
3-Year Occupation
2-Year Occupation
Salary Cost

by department

Admin & HR
Customer Support
Finance & Accounting
IT
Product
Sales & Marketing
Salary Cost Development

by department, last 10 quarters

Salary Cost Development

by country, last 10 quarters

OLE over the last 5 Years
Congratulations!
Your target of 71% has been hit this year.
Talent Satisfaction(NPS)

By Employment Period

80

5 Years

55

2 Years

75

1 Year

6 Month
Employee Satisfaction

66(+1)

Manager Feedback Score

58(-3)

Employee Satisfaction and Manager Feedback Score

by department and country

Avg Cost Of Hiring By Seniority Level
Senior
Mid-Level
Senior

₹4321

Avg Hiring Costs This Year

Anna F.

12%
Recruitment Conversion Rate

Anna F.

12%
Recruitment Conversion Rate

Anna F.

12%
Recruitment Conversion Rate
Avg Time To Fill By Development
49 days

Avg. Time to Fill An Open Position

Headcount

8,171(+2%)

New Hires

480(-1%)

Vacancy Rate

19%(-2)

HeadCount Development

last 10 quarters

Average Job Tenure

3.9 years(+0.2)

Turnover Rate

4%(-1)

Job Tenure

by Seniority level

Talent Rating
by Employment Period
3.9

5 Years

3.2

2 Years

3.7

1 Year

6 Month by Category
Turnover Rate By Age Group
Talent Turnover Rate
5%

Average Involuntary

8%

Average Voluntary

By Department
Turnover rate by Group(Voluntary Leavers)
Dismissal Rate

By Employment Period

Female To Male Ratio

This Year

546754

546754

Role Level by Gender
Female Rate

43%(+2)

Female Manager Rate

16%(-1)

Gender Ratio

by department

Part-Time vs Full-Time Employees
Time To Quit Job

Employees are most likey to leave their job around their one-year work anniversary.

Departments by Ethnicity and Gender

White

Asian

Black

Latino

Other

Male

Female & Divers

Recruitment Breakdown by Ethnicity

Analytics

From Date
To Date
Sales Target & Sales Growth

Growth to last month

Difference to Target

Revenue vs Target This Month

Revenue: ₹2345671
Average Order Value
Actual Target To Target
₹33.33 ₹33 -8.2%

By Channel

₹9980

Spend

₹9955

Revenue

₹200%

ROI

ROI per Marketing Channel

Display

Organic

Paid

Referral

Daily Marketing Spend | Last 30 Days
₹9980

Current CLTV

₹9955

3 Month CLTV

₹200%

12 Month CLTV

Customer Lifetime Value
Website Lead to Traffic Ratio

5423454:463726

Conversion Rate: 5%

This Month

Lead to MQL Ratio

This Month

13.70%

Lead to MQL
Leads
MQL to SQL Ratio
3021:1282

Marketing Leads Turned Into Sales Leads

MQL
SQL

Goal Conversion Rate

6%

of visitors signed up for our newsletters

By Channel

8% Organic

8% Paid

8% Social

8% Direct

Campaign | Discount

3%

Conversion Rate

Campaign | Discount

3%

Conversion Rate

Campaign | Discount

3%

Conversion Rate

Avg. Time To Conversion
Actual Target To Target
₹33.33 ₹33 -8.2%

By Product

Page

www.website.com

Sessions

2,34,56,234

Conversion Rate

6%

www.website.com/page-1 2,22,222
www.website.com/page-1 2,22,222
www.website.com/page-1 2,22,222
www.website.com/page-1 2,22,222
2203

CLICKS

34%

CLICK THROUGH RATE

₹20

COST PER CLICK

₹2022

ACQUISITIONS

₹201

COST PER ACQUISITION

CPC by Channel
Clicks by Channel
Paid
Organic
Referral

Bounce Rate

56.6%

Average Session Duration

75 sec

Average Pages Per Session

2.3 Pages
Engagement Rate
Actual Target To Target
₹1.69% ₹3.39% -8.2%
₹1.69% ₹3.39% 8.2%
₹1.69% ₹3.39% -8.2%
₹1.69% ₹3.39% 8.2%
CTR
2.5%

CTR By Channel

8% Organic

8% Paid

8% Social

8% Direct

Weekly CTR with Trendline | YTD

CTR by Keywords

Analytics

From Date
To Date
Production Volume
Production Volume By Produced Units
Share of Production Volume By Top 3 Machines

FWT-65432

FWT-65432

FWT-65432

Downtimes By Cause
Broken Machine
 30%
Missing Parts
35%
Service
30%
Current Downtimes
Machine Detailed Cause Duration
PJL-456456 Broken Engine 5 min
PJL-456456 Broken Engine 5 min
PJL-456456 Broken Engine 5 min

₹222

Total Costs Per Unit

Breakdown Of Cost Types

97%

Material Cost

2%

Tooling Cost

1%

Labour Cost

Avg Costs By Production Component

Overall Operations Effectiveness(OOE*)
71%

YTD

67%

Current Month

63%

Previous Month

Last 6 Months

*Performance x Quality x Availability(where Availability = Actual Production Time / Operating Time)

Overall Equipment Effectiveness(OEE*)
71%

YTD

67%

Current Month

63%

Previous Month

Last 6 Months

*Performance x Quality x Availability(where Availability = Actual Production Time / Scheduled Time)

Total Effective Equipment Performance(TEEP*)
71%

YTD

67%

Current Month

63%

Previous Month

Last 6 Months

*Performance x Quality x Availability(where Availability = Actual Production Time / Total Time)

Capacity Utilization
71%

YTD

67%

Current Month

63%

Previous Month

Last 6 Months

Throughput
Machine A 9/5 Minutes
Machine B 9/5 Minutes
Machine C 9/5 Minutes
Machine D 9/5 Minutes
First Pass Yield
Machine A
92%
Machine B
92%
Machine C
92%
Machine D
92%

Per 5 Minute

Scrap Rate

Per 5 Minutes

Defect Density By Product

22%

Rate Of Return

22%

First Order Rate Of Return

Rate Of Return By Product
Right First Time

Target of 96.5% is hit!

Asset Turnover
Unit Costs With Target < ₹41
Return On Assets
On-Time Delivery
71%

YTD

67%

Current Month

63%

Previous Month

Last 6 Months

Your average maintenance costs are above the target. Try to reduce your costs!
4,334

Avg Maintainance Cost

maintenance costs by month

(With target < ₹4100)

Average Revenue Per Employee
71%

YTD

67%

Current Month

63%

Previous Month

Last 6 Months

Analytics

From Date
To Date

Avg Call Response Time

37 Sec

Best Day To Call

Tuesday
Response Time By Weekday
Call Resolution
Average Resolution Time

Standard Request

Special Request

*in Minutes

Cost Per Resolution
Customer Churn*

Last Month

1.45% (+0.46)

Last 12 Months

0.98%

Monthly Customer Churn Rate

*Calculations include cancellations and downgrades

JUDY DANIELS

This Months Top Agent

Top 5 Agents
Agent First Call Resolution Average Calls Per Hour Positive Customer Feedback
Judy Daniels 69% 4.6 86%
Judy Daniels 69% 4.6 86%
Judy Daniels 69% 4.6 86%
Judy Daniels 69% 4.6 86%
Judy Daniels 69% 4.6 86%
Average Number Of Issues Per Day By Means Of Communication
Total And Solved Tickets By Channel
15,541

Total

12,778

Solved

By channel

Abandon Rate

Phone

Live Chat

Customer Satisfaction
Net Promoter Score

on a scale of 1-10 how likely is that you would recommend our service to a friend?

Promoters

(6.5%)

Defractors

(6.5%)

48
Average Customer Effect Score

on a scale of 1-10 how much effort you had to put in to get what you were looking for?

Customer Retention

Target >= 90%

Net Retention*

Monthly Net Retention

*Calculations only includes cancellations

Request Volume vs Service Level
99%

Avg. Answered Requests

Support Costs
383

Avg Costs per Support

Revenue and % of support costs to revenue

Revenue Churn

Last Month

1.45% (+0.46)

Last 12 Months

0.98%

Monthly Revenue Churn Rate

MRR Growth

Last Month

1.45% (+0.46)

Last 12 Months

0.98%

MRR Growth Rate

Analytics

From Date
To Date
On-Time Shipping

Within Time Limit

549

Outside Time Limit

73
Perfect Order Rate

95.8%

This Year

Picking Accuracy

Last Month

95.8%

Current Month

95.8%
Average Delivery Time in Days
Pick And Pack Cycle Time

Current Month

234 sec

Target

119 sec

Per Line

Order Cycle Time

(in Months)

Equipment Utilization Rate

Last Month

85%

Current Month

98%
Trailer Utilization Rate

(This Year Compared to Previous Year)

Transportation Related Costs
₹3,83,234

Avg Transportation Costs

Distribution of Transportation Related Costs

Transportation Costs
 €543254
Warehousing Costs
€543254
Inventory Carrying Costs
€543254
Administrative Costs
€543254
Order Processing Costs
€543254
Average Dwell Time for This Week

(in Hours)

Inventory Carrying Costs

(= total carrying costs/overall inventory costs)

Warehouse 1

₹22,222

Warehouse 2

₹33,222

50%

of Warehousing costs are order picking costs

Warehouse Operating Cost Distribution
Pick And Pack Cost

Last Month

₹22,222

Current Month

₹33,222

Cost Compared to Target per Line

Operating Ratio
Operating Expenses for This Year
Use Of Packing Material

Per Line

Packing Material Used

400 g

Target

300 g
Shipments By Country
Congrats!

You Hit The Target of 96.5%

Average Monthly Inventory Accuracy
Inventory Turnover
₹3,83,234

Avg Transportation Costs

Inventory To Sales Ratio

Analytics

From Date
To Date
Assets Pulled From Pool v/s Net New Purchase
Verification Status
Asset Count By Location
Asset Value By Category
Asset Fulfillment Time
Total Spend
Breakup Of Hardware Assets Based On Hardware Assets Status
End Of Life In Next 90 Days
Top Mean Time To Repair - April 2024
Avg. Maint. Expenses - Since April 2024
Incident Resolution And Response Time
avg. asset utilization - since April 2024
Top asset by wo labor - since April 2024
Top asset by downtime - since April 2024