Reports #27
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Reports shall be decided. what reports we want and where should i show those reports to user is not decided yet.
The Report module should provide management-level insights for a selected date range (Daily, Weekly, Monthly, Custom Range).
Product Volume
Display the total quantity of each product manufactured within the selected period:
Zirconia Crowns
Temporary Crowns
PFM Crowns
Custom Abutments
Veneers
Implant Guides
Dentures / Prosthetics
Other Products
Product Distribution
Show the percentage share of each product from total production.
Example:
ProductQuantityPercentageZirconia Crowns45042%Temporary Crowns21020%
Production Trend
Display production trends over time:
Daily Production
Weekly Production
Monthly Production
Visualized using line or bar charts.
Revenue by Product
Display revenue generated by each product type.
ProductQuantityRevenueZirconia Crowns450$XX,XXXCustom Abutments130$XX,XXX
Top Revenue-Generating Products
Display:
Highest Revenue Product
Top 5 Revenue-Generating Products
Best Selling Products
Display:
Most Ordered Product
Top 5 Products by Quantity
Note: Highest quantity and highest revenue may not be the same product.
Average Order Value (AOV)
Calculate:
Average Order Value = Total Revenue / Total Orders
For commission-based employees.
Technician Productivity
Display for each technician:
TechnicianCases CompletedCommission Earned
Production Breakdown
For each technician display:
Zirconia Cases
Temporary Crown Cases
PFM Cases
Custom Abutments
Other Products
Revenue Contribution
Revenue generated by each technician's completed work.
Commission Summary
Display:
Total Commission Paid
Commission by Technician
Commission by Date Range
Remake Analysis
Display:
Total Remakes
Remake Rate (%)
Formula:
Remake Rate = (Remakes / Total Cases) × 100
Remakes by Product
ProductRemakes
Remakes by Technician
Identify technicians with the highest remake rates.
Quality Trend
Display remake trend over time.
Zirconia Blank Consumption
Display:
Blank TypeQuantity Used
Premilled Consumption
Display:
Premilled TypeQuantity Used
Material Cost Analysis
If material costs are configured:
Total Blank Cost
Total Premilled Cost
Total Material Cost
Average Completion Time
Measure average duration between:
Order Created → Design Started
Design Started → Manufacturing
Manufacturing → Delivery
Overall Turnaround Time
Average number of days from order creation to delivery.
Delivery Performance
Display:
On-Time Deliveries
Delayed Deliveries
Delay Percentage
Top Customers by Order Count
CustomerOrders
Top Customers by Revenue
CustomerRevenue
Customer Trend
Track customer activity growth over time.
Open Orders
Display:
Total Open Orders
Orders In Progress
Orders Awaiting Delivery
Overdue Orders
Display:
Number of Overdue Orders
Average Delay Duration
If costs are available in the system.
Formula:
Gross Profit =
Revenue
− Material Cost
− Technician Commission
Display:
Total Revenue
Total Material Cost
Total Commissions
Gross Profit
Profit Margin (%)
Dashboard KPIs (Summary Cards)
At the top of the Report page display:
Total Orders
Total Revenue
Gross Profit
Remake Rate
Average Turnaround Time
Open Orders
Top Revenue Product
Top Technician
Material Consumption Cost
Total Commission Paid
اگه بشه لطفا اضافه بشه: Export to Excel / CSV