Retail Intelligence

Sales Comparative

Previous Year

₱9,060,000

Comparable period

Current Year

₱9,090,000

Comparable period

Variance

+₱30,000

+0.3%

Branch Movement

3+ / 3-

Positive vs negative branches

Year-over-Year Comparison

Branch Sales Comparative by Region

This module compares previous year sales against current year sales per branch. Positive variance means the branch improved. Negative variance means the branch declined versus last year.


LUZON Region

Previous year vs current year sales performance

Previous Year₱1,180,000
Current Year₱990,000
Variance Amount-₱190,000
Variance %-16.1%

BranchCluster / CityPrevious YearCurrent YearVariance AmountVariance %Unit VarianceStatus
Robinsons PampangaBR005Central LuzonSan Fernando₱1,180,000₱990,000-₱190,000-16.1%-105-17.2%Needs Review

MINDANAO Region

Previous year vs current year sales performance

Previous Year₱1,320,000
Current Year₱1,425,000
Variance Amount+₱105,000
Variance %+8.0%

BranchCluster / CityPrevious YearCurrent YearVariance AmountVariance %Unit VarianceStatus
SM DavaoBR004DavaoDavao City₱1,320,000₱1,425,000+₱105,000+8.0%+35+5.1%Slight Growth

NCR Region

Previous year vs current year sales performance

Previous Year₱4,100,000
Current Year₱4,105,000
Variance Amount+₱5,000
Variance %+0.1%

BranchCluster / CityPrevious YearCurrent YearVariance AmountVariance %Unit VarianceStatus
SM North EDSABR001Metro Manila NorthQuezon City₱1,850,000₱2,125,000+₱275,000+14.9%+145+15.4%Strong Growth
GloriettaBR002Metro Manila SouthMakati₱2,250,000₱1,980,000-₱270,000-12.0%-140-12.5%Needs Review

VISAYAS Region

Previous year vs current year sales performance

Previous Year₱2,460,000
Current Year₱2,570,000
Variance Amount+₱110,000
Variance %+4.5%

BranchCluster / CityPrevious YearCurrent YearVariance AmountVariance %Unit VarianceStatus
Ayala CebuBR003CebuCebu City₱1,480,000₱1,695,000+₱215,000+14.5%+90+11.5%Strong Growth
Iloilo Business ParkBR006IloiloIloilo City₱980,000₱875,000-₱105,000-10.7%-65-12.5%Needs Review

Recommended Additional Data

Useful fields to improve this module later

Comparable Period

Make sure both years use the same month/week/date range. Example: January 2025 vs January 2026.

Transaction Count

Helps identify if sales changed because of more customers or higher average purchase value.

Units Sold

Helps separate price-driven growth from actual product movement.

Average Basket Value

Current sales divided by transaction count. Useful for store performance review.

Same-Store Flag

Important if some branches opened, closed, or relocated between years.

Target Sales

Allows comparison against both last year and current business target.