iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
Lynne Chanzu’s 2026 JCars Logistics project analysis reports 452 vehicles sold, approximately KES 1.94 billion in revenue, KES 532.11 million in gross profit, and a 27.44% gross profit margin. These are results from a Power BI analysis of transaction data—not verified company financial statements. Other public analyses of a similarly described dataset report different totals, so the figures should be read as project findings rather than settled facts.
What this JCars Logistics analysis covers
The project presents a management view of vehicle sales and related logistics operations. Its author describes records containing vehicle, customer, order, payment, delivery, sales, cost, branch, and region information. The dashboard is organized around overall sales and profitability, vehicle and model performance, and operations and customer activity.
The underlying dataset is described as 276 rows and 32 columns in related write-ups. That is the reported dataset size, not an independently verified company-wide record count. The featured project treats a row as a sales transaction or order; this grain matters when interpreting counts because one order, one vehicle, and one transaction are not necessarily interchangeable.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →How the project calculated sales and profit
Chanzu’s project says recorded revenue values were inconsistent, so it reconstructed revenue from cleaned fields. The stated calculations were:
#1 Best Overall
- 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
The project also reports converting financial amounts in multiple currencies to Kenyan shillings using available rates and normalizing discounts. The exact conversion rates and dates are not specified in the project summary, and the reported totals depend on those choices as well as on which cost fields are included.
Why data preparation changes the result
The project author describes missing and null values, inconsistent category labels, invalid or mixed-format dates, multiple currencies, inconsistent discounts, and transaction identifiers that look duplicated. These are not cosmetic issues: they can alter grouped make or region totals, time trends, order counts, and profitability calculations. The author says suspicious duplicate-looking IDs were retained for further investigation rather than automatically removed.
A related walkthrough of the named dataset likewise emphasizes validating dates, financial fields, discounts, ratings, categories, and transaction grain before building measures. Neither project description is an independent audit of the underlying records.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Fix the driver behind crashes, sound loss and screen glitches3Clear out junk files and repair common Windows errorsWhat the reported headline figures mean
According to Lynne Chanzu’s 2026 project analysis, the dashboard shows 452 vehicles sold, approximately KES 1.94 billion in revenue, KES 532.11 million in gross profit, and a 27.44% gross profit margin. These are calculated outputs of that project’s cleaning and metric definitions, not company-reported or independently confirmed financial results.
Rank #3
Other public analyses of what appears to be a similar JCars dataset do not match those figures. 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 revenue and KES 415.49 million gross profit at 21.9%. A LinkedIn project summary gives a further differing combination. Because the analyses’ transformations and definitions are not aligned, the figures cannot establish which calculation is correct and should not be combined.
How is the business performing over time?
Chanzu’s project analysis reports revenue and gross profit trending downward from January 2025 through January 2026. That pattern is a signal to investigate, not evidence of a particular cause. To understand it, management would need to examine units sold, selling prices, discounting, and costs over the same periods, while checking that date parsing and transaction inclusion are consistent.
Which vehicles appear most profitable?
In the featured analysis, Toyota leads by both reported revenue and gross profit. The project also reports a strong margin across 137 Toyota units. Volkswagen is reported to have the highest margin despite only 17 units, illustrating why a percentage alone can make a small sample look more decisive than it is. Isuzu is reported at a negative gross margin of 9.35%, and the author flags several individual models as loss-making.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallOutdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchThese comparisons are useful as investigation leads, not verified rankings of the company’s fleet economics. A sound make or model comparison should show units alongside revenue, gross profit, margin, and logistics cost, and should account for data quality and sample size. A high margin on 17 units does not by itself mean Volkswagen contributed more total profit than a higher-volume make.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.What do the payment and delivery statuses show?
Chanzu’s dashboard reports 47.57% of vehicles delivered, 14.60% in transit, 12.17% at the yard, and 13.05% cancelled. It also reports payment completion for 51.33% of transactions and identifies M-Pesa as the most-used payment method. These are status shares reported by the project, not independently verified or necessarily current service levels.
Payment completion is stated as a share of transactions, while delivery figures are described as shares of vehicles. Those denominators differ. The project summary does not establish how returned or cancelled transactions were handled in each denominator, or how duplicate-looking order IDs affect the counts; readers should not infer an exact unpaid-revenue total from the payment percentage alone.
What should management investigate next?
- Declining monthly results: Separate the effects of volume, pricing, discounts, unit cost, and logistics cost to see which components move with the reported decline.
- Loss-making makes and models: Reconcile selling price, discounts, unit cost, delivery fees, and logistics costs at the model level before deciding whether a product or pricing change is warranted.
- Incomplete deliveries and payments: Review transaction-level records for vehicles still in transit or at the yard and orders without completed payment, using clearly defined denominators and current status dates.
- Regional and lead-source differences: The project identifies website and walk-in leads as strong sources and recommends examining weaker regions. Compare volume and profit as well as percentages, and verify category consistency before drawing conclusions.
- Suspicious identifiers: Investigate duplicate-looking order IDs against source records rather than treating every repeated identifier as either a confirmed duplicate or a separate valid sale.
The project points to these areas for follow-up but does not demonstrate that any one factor caused the observed trend or status pattern.
How to use the findings responsibly
For readers using the dashboard as a management case study, the key lesson is that a Power BI result is only as reliable as its transaction grain, cleaning decisions, and measure definitions. Before using the headline figures for business decisions, an analyst would need the source CSV and Power BI model, then reconcile order IDs, currency rates and dates, discounts, revenue construction, cost treatment, and the inclusion of returns or cancellations. Until those inputs and definitions are aligned, treat the reported figures and rankings as the findings of Chanzu’s project analysis—not as a definitive account of JCars Logistics’ actual performance.
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.
