Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Repair Windows errors before they cause bigger problems3Fix the driver behind crashes, sound loss and screen glitchesIn Lynne Chanzu’s 2026 project analysis, JCars Logistics recorded 452 vehicles sold, approximately KES 1.94 billion in revenue, KES 532.11 million in gross profit and a 27.44% gross profit margin. Those are figures produced by the project’s cleaned transaction data and calculations—not verified company financial results. Other public analyses of a similarly described JCars dataset report different totals, so the figures should be read as one analysis’s results rather than an established company-wide record.
What this JCars Logistics analysis covers
The project uses a Power BI dashboard to examine vehicle sales alongside profitability, vehicle performance and operational status. Lynne Chanzu describes a transaction-level dataset containing customer, vehicle, order, payment, delivery, sales and cost information. The dashboard organizes those records into views of overall sales and profitability, vehicle and model performance, and operations and customer activity.
As an Amazon Associate I earn from qualifying purchases.
That scope makes the work useful as a management BI case study: it shows how sales data can be transformed into questions about revenue, margins, delivery progress and customer channels. It is not an official JCars Logistics performance release, and the available project account does not establish that the dashboard totals match audited company records.
How the project calculated revenue and profit
Chanzu reports that the source data had missing and null values, inconsistent category labels, invalid or mixed-format dates, multiple currencies, inconsistent discounts and transaction IDs that appeared duplicated. The project describes standardizing categories and dates, converting financial amounts to Kenyan shillings using available rates, normalizing discounts, and retaining suspicious duplicate-looking order IDs for investigation.
#1 Best Overall
Because the original revenue values were inconsistent, the project says it reconstructed revenue and profitability from cleaned fields using these definitions:
- Revenue: (Unit Selling in KES × Units Sold) × (1 − Discount Clean) + Delivery Fee
- Gross profit: Revenue − (Unit Cost in KES × Units Sold) − Logistics Cost
- Gross profit margin: Gross Profit ÷ Revenue
These choices matter: conversion rates, discount treatment, the reconstructed revenue formula and included costs all affect the result. A separate walkthrough of a similarly described 276-row, 32-column dataset also stresses validating financial fields, dates, discounts, ratings and categories before building a dashboard. That walkthrough is methodological context, not independent verification of Chanzu’s figures.
Rank #2
Headline results reported by the project
| Measure | Project-reported result | How to read it |
|---|---|---|
| Vehicles sold | 452 | Reported by Lynne Chanzu’s 2026 project analysis. |
| Revenue | Approximately KES 1.94 billion | Reconstructed from cleaned fields; reported by Chanzu’s 2026 project analysis. |
| Gross profit | KES 532.11 million | Calculated after unit cost and logistics cost; reported by Chanzu’s 2026 project analysis. |
| Gross profit margin | 27.44% | Project-calculated gross profit divided by revenue; reported by Chanzu’s 2026 project analysis. |
These numbers are not corroborated by the other public analyses located for the same named dataset. One reports 466 units, about KES 1.898 billion in revenue, KES 415.35 million gross profit and an approximately 21.9% margin; another reports KES 1.8975 billion in revenue, KES 415.49 million gross profit and a 21.9% margin. A LinkedIn project summary gives yet another combination of orders, vehicles, revenue and margin. Because the analyses do not establish aligned transformations or metric definitions, their totals should not be combined or treated as a vote on which result is correct.
What the dashboard reports about sales and profitability
Revenue and profit trend
Chanzu’s analysis reports a downward trend in revenue and gross profit from January 2025 through January 2026. The dashboard identifies a pattern to investigate; it does not show that a particular factor caused the decline. Management would need to test units sold, prices, discounts and costs against the underlying records.
Vehicle makes and models
The project identifies Toyota as the leading make by revenue and gross profit. It reports that Toyota maintained a strong margin across 137 units, while Volkswagen had the highest margin on only 17 units. The volume difference is important: a high percentage margin on a small number of vehicles does not by itself establish stronger total contribution.
The project also reports a negative gross margin of 9.35% for Isuzu and flags several models as loss-making. These are results of the project’s cleaning and calculation choices, not independently validated performance findings. A useful follow-up comparison would put units beside revenue, gross profit, margin and logistics cost, while checking the sample size and data quality for each make or model.
Rank #4
What the operations view says about delivery and payment
In Chanzu’s dashboard, 47.57% of vehicles were marked delivered, 14.60% in transit, 12.17% at the yard and 13.05% cancelled. The project also reports payment completion for 51.33% of transactions and identifies M-Pesa as the most-used payment method. These are dashboard status figures, not verified current service levels.
Recommended Free Tools
The percentages need careful interpretation before being used as operational targets. Orders and vehicles are not necessarily the same denominator, and the project account notes duplicate-looking IDs were retained for investigation. The available description does not establish how cancelled or returned records were handled in every status calculation. Nor does it provide a value for revenue still unpaid: a transaction completion percentage is not an unpaid-revenue total.
Management questions the findings suggest
- Investigate the reported decline: compare monthly units, realized selling prices, discounts and unit and logistics costs to determine which measures moved with revenue and profit.
- Review loss-making vehicles: validate the cost and discount inputs for the flagged models and Isuzu before deciding whether pricing, procurement or delivery costs warrant action.
- Follow up on unfinished payments and deliveries: reconcile dashboard statuses against current order records and distinguish transaction counts from vehicle counts.
- Compare regional performance with context: the project recommends investigating weaker regions, but the published account does not establish why they underperform.
- Assess lead sources: website and walk-in are described as strong sources in the analysis; the account does not demonstrate that either channel caused stronger sales or profitability.
These are investigative leads, not causal conclusions. To make the financial results reproducible, a reviewer would need the source records and Power BI model, plus agreed definitions for transaction grain, order-ID reconciliation, currency conversion rates and dates, discount normalization, revenue and included costs.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
