Revenue growth rates comparison
Purpose: Compare revenue growth rates based on the timing of rental orders, return orders, and maintenance.
Timeframe: Revenue is recognized in the period when the rental order, return order, and maintenance are created (Created Date).
- Order revenue: Total value (Total Amount) of rental orders created within the period.
- Delay Cost: Total delay fees from return orders created within the period.
- Repair Cost: Total repair fees from maintenance created within the period that are charged to customers.
- Refund: Total refunded amount from return orders (type: Return and Get Money Back). The refund value is taken based on the selected date at the time of refund creation.
Formula:
Growth (%)= (Current Period Revenue − Previous Period Revenue) ÷ |Previous Period Revenue| × 100
Where:
- Current Period Revenue: Revenue of the current period
- Previous Period Revenue: Revenue of the corresponding previous period
- Growth (%): Percentage increase (or decrease) compared to the previous period
Special notes:
- If previous period = 0 and current > 0 → Growth (%) = 100%
- If previous period = 0 and current < 0 → Growth (%) = -100%
- If both periods = 0 → Growth (%) = 0%
Revenue by product/product group
Purpose: Provides detailed analysis of revenue by product and product group. You can identify:
- Which product group generates the highest revenue.
- Which product contributes the most within the group.
- Number of rental orders for each product.
- Contribution ratio of each product to its product group’s total revenue.
- Revenue: Actual product rental revenue (including tax and discount) within the selected period. Taken from rental orders.
- Number of rentals: Count of rental orders in which the product appears. Only one count per rental order, regardless of quantity.
Example: Order 1 has 2 units of product A, Order 2 has 3 units of product A → Number of rentals = 2.
- Group contribution: Product contribution to total product group revenue = Product revenue / Group revenue x 100
Revenue by customer
Purpose: Analyze revenue contribution of each customer, including order revenue, delay costs, repair costs, and total revenue. Also shows contribution % to overall revenue.
- Order revenue: Rental order revenue.
- Delay cost: Total late return fees from return orders.
- Repair Cost : Total repair fees from maintenance charged to customers.
- Total revenue = Order revenue + Delay cost + Repair cost.
- Revenue contribution: Percentage of customer revenue compared to total revenue.
- Pie chart (Revenue contribution): Displays contribution share of each customer to total revenue, highlighting Top customers.
Products currently rented
Purpose:
- Track which products are currently rented, who rented them, rental duration, and order status.
- Monitor products nearing due date or overdue for timely handling.
Status
- Currently rented (green): Rental order still within valid rental period.
- Rental overdue (red): Rental order is overdue but return has not yet been completed.
Product rental frequency
Purpose: Evaluate product popularity based on rental frequency and average rental rate.
- Number of rentals – Total number of times the product has been rented. Counts the number of rentals whose Rental Start Date falls within the filtered time range.
- Total customers rented – Total number of different customers who have rented this product. Each customer is counted only once no matter how many times they rent.
- Total rental days (Days) – Total rental days accumulated across all orders.
- Average rental duration (Days) – Average rental duration for one rental = Total rental days (Days) / Number of rentals
- Latest rental date – Most recent date/time the product was rented.
- Latest returned date – Most recent date/time the product was returned (may belong to a previous order if the latest rental is still ongoing).
- Monthly rental frequency – Average monthly rental frequency = Number of rentals / Number of months in the selected period.
Number of months = Days in selected range ÷ 30.4375 (average days per month). - Product Rental Revenue: Total rental revenue (excluding delay cost and maintenance).
Delay fee % of order value
Purpose: Measure and compare delay fees as a percentage of order value for each rental order.
- Total delay fee : Total delay fee the customer must pay for the order.
- Delay rate (%): Percentage of delay fees compared to original order value.
Delay rate (%) = Total delay fee / Order value x100
