BUSINESS REVIEW
1
November 16, 2020
2
I. Introduction
II. Sales Per Category
III. Monthly Sales Per Branch
Agenda
I. Introduction
3
I. Layout of Stores per Category
DAU
I. Layout of Stores per Category
MALOLOS
I. Layout of Stores per Category
NOVALICHES
I. Layout of Stores per Category
TAGAYTAY
I. Branch Comparison
| DAU | MALOLOS | NOVA | TAGAYTAY |
AREA: | | | | |
PARKING | 160 SQ.M | 2628 SQ.M | 650 SQ.M | 6360 SQ.M |
WAREHOUSE | 84 SQ.M | 1834 SQ.M | 511 SQ.M | 2300 SQ.M |
BW | 3557 SQ.M | 3344 SQ.M | 1742 SQ.M | 3490 SQ.M |
APPLIANCE | 335 SQ.M | 605 SQ.M | 149 SQ.M | 570 SQ.M |
RED ABODE /FURNITURE | 1396 SQ.M | 3081 SQ.M | 494 SQ.M | 4625 SQ.M |
LM/BIGBUYS | 600 SQ.M | 2585 SQ.M | 400 SQ.M | 3410 SQ.M |
TOTAL: | 6132 SQ.M | 14077 SQ.M | 3946 SQ.M | 20755 SQ.M |
I. Branch Comparison
| DAU | MALOLOS | NOVA | TAGAYTAY |
SUPPLIERS: | | | | |
BW | 150 | 173 | 90 | 134 |
RED ABODE/ FURNITURE | 53 | 72 | 52 | 62 |
LM | 271 | 271 | 271 | 271 |
BIG BUYS | 86 | 86 | 86 | 86 |
I. Branch Comparison
BW | DAU | MALOLOS | NOVA | TAGAYTAY |
MANAGER Asst. Manager | 1 2 | 1 0 | 1 0 | 1 0 |
TRADING: Trading SV Sales Man | 2 1 | 1 6 | 0 0 | 1 6 |
DIY: DIY SV Sales Man | 1 0 | 4 4 | 1 0 | 4 4 |
APPLIANCE: App SV Sales Man | 1 0 | 1 1 | 0 0 | 1 1 |
RED ABODE: RA SV Sales Man Assembler | 1 0 0 | 1 2 2 | 0 0 0 | 1 2 2 |
I. Branch Comparison
BW | DAU | MALOLOS | NOVA | TAGAYTAY |
WAREHOUSE: WH SV Checker Utility Encoder | 1 0 1 1 | 1 1 4 1 | 1 (AS IS TRADING) 1 1 0 | 1 1 6 (2 helper) 1 |
Driver: | 0 | 0 | 1 | 2 |
CASHIER: Head Cashier Cashier Bagger | 0 3 (POS 3) 0 | 1 3 (POS 3) 2 | 1 4 0 | 1 5 (POS 5) 2 |
Customer Service Purchasing | 1 (BW & LM) | 1 | 0 1 | 1 |
TOTAL: | 15 | 37 | 14 | 43 |
I. Branch Comparison
LM | DAU | MALOLOS | NOVA | TAGAYTAY |
MANAGER: | 1 | 1 | 1 | 1 |
SV Fresh SV Food SV NON-FOOD/BIG BUYS | 0 0 0 | 0 1 1 | 1 0 0 | 1 1 1 |
STOCK CLERK: Fresh Non-Food Food &Liquor | 1 0 0 | 0 1 2 | 0 2 2 | 2 3 4 |
WAREHOUSE: SV Warehouse Checker Stock Man Encoder | 1 1 1 1 | 1 1 1 1 | 0 0 0 0 | 1 1 2 1 |
I. Branch Comparison
LM | DAU | MALOLOS | NOVA | TAGAYTAY |
CHECK OUT: Head Cashier Cashier Bagger | 1 2 0 | 0 (RIDE BW) 3 (POS 3) (RIDE BW) 2 | 0 0 0 | 1 6 4 |
Customer Service | 1 | 1 | 0 | 1 |
Purchasing Accounting | 1 (Act as SV) 0 | 1 1 | 1 0 | 1 1 |
TOTAL: | 11 | 18 | 7 | 32 |
I. Suppliers- Dau
| TOTAL SUPPLIERS | TOTAL SKU |
BW | 150 | 59,786 |
RED ABODE | 53 | 18,805 |
LM | 271 | 15,060 |
BIG BUYS | 86 | 6,593 |
I. Suppliers- Malolos
| TOTAL SUPPLIERS | TOTAL SKU |
BW | 173 | 59,786 |
RED ABODE | 72 | 18,805 |
LM | 271 | 15,060 |
BIG BUYS | 86 | 6,593 |
I. Suppliers- Novaliches
| TOTAL SUPPLIERS | TOTAL SKU |
BW | 90 | 59,786 |
RED ABODE | 52 | 18,805 |
LM | 271 | 15,060 |
BIG BUYS | 86 | 6,593 |
I. Suppliers- Tagaytay
| TOTAL SUPPLIERS | TOTAL SKU |
BW | 134 | 59,786 |
RED ABODE | 62 | 18,805 |
LM | 271 | 15,060 |
BIG BUYS | 86 | 6,593 |
I. Suppliers based on LOW- MID- HIGH
PLUMBING | LOW | MID | HIGH | TOTAL |
KITCHEN SINK | 4 | 2 | 5 | 11 |
FAUCET | 9 | 6 | 1 | 16 |
BATH ACCESSORIES | 9 | 4 | 2 | 15 |
PLUMBING ACCESSORIES | 8 | 4 | 2 | 14 |
BATHROOM MIRROR | 2 | 1 | 0 | 3 |
WATER HEATER | 1 | 2 | 1 | 4 |
WATER TANK | 2 | 1 | 0 | 3 |
WATER PUMP | 5 | 0 | 0 | 5 |
WATER DEVICE | 3 | 0 | 0 | 3 |
I. Suppliers based on LOW- MID- HIGH
HARDWARE | LOW | MID | HIGH | TOTAL |
DOOR ATTACHMENT | 15 | 1 | 1 | 17 |
CAR CARE & ACCESSORIES | LOW | MID | HIGH | TOTAL |
CAR CARE | 3 | 2 | 0 | 5 |
CAR ACCESSORIES | 1 | 1 | 0 | 2 |
GARDENING | LOW | MID | HIGH | TOTAL |
GARDEN HOSE | 5 | 0 | 0 | 5 |
GARDEN TOOLS | 5 | 0 | 0 | 5 |
I. Suppliers based on LOW- MID- HIGH
PET | LOW | MID | HIGH | TOTAL |
PET CARE | 2 | 0 | 0 | 2 |
PET ACCESSORIES | 0 | 1 | 0 | 1 |
DOOR | LOW | MID | HIGH | TOTAL |
PVC DOOR | 3 | 0 | 0 | 3 |
WOODEN DOOR | 2 | 1 | 1 | 4 |
ALUMINUM DOOR | 3 | 0 | 0 | 3 |
STEEL DOOR | 2 | 0 | 0 | 2 |
WOOD PRODUCTS | 2 | 1 | 1 | 4 |
I. Suppliers based on LOW- MID- HIGH
DOOR | LOW | MID | HIGH | TOTAL |
CABINET DOORS | 1 | 1 | 0 | 2 |
POLY-CARBONATE | 0 | 1 | 0 | 1 |
LAMINATES | 3 | 0 | 0 | 3 |
APPLIANCE | LOW | MID | HIGH | TOTAL |
HOME APPLIANCE | 9 | 4 | 3 | 16 |
AIRCON/AIR COOLER | 7 | 3 | 2 | 12 |
AUDIO VIDEO | 5 | 1 | 3 | 9 |
SMALL APPLIANCES | 4 | 3 | 3 | 10 |
I. Suppliers based on LOW- MID- HIGH
BLDG MAT | LOW | MID | HIGH | TOTAL |
PIPES | 2 | 1 | 0 | 3 |
PPR | 2 | 0 | 0 | 2 |
FITTINGS | 2 | 1 | 0 | 3 |
ROOFING COMPONENTS | 0 | 1 | 0 | 1 |
METAL DECORS | 0 | 1 | 0 | 1 |
TILE TRIM | 3 | 0 | 0 | 3 |
STAIR NOSING | 2 | 0 | 0 | 2 |
PVC WALL PANEL | 1 | 0 | 0 | 1 |
CEMENT BOARD | 0 | 1 | 1 | 2 |
I. Suppliers based on LOW- MID- HIGH
FURNITURE | LOW | MID | HIGH | TOTAL |
KD FURNITURE | 6 | 0 | 0 | 6 |
DINING | 3 | 1 | 0 | 4 |
SOFA & SALA SET | 8 | 2 | 0 | 10 |
BED & MATTRESS | 4 | 3 | 0 | 7 |
OUTDOOR | 3 | 1 | 0 | 4 |
OFFICE FURNITURE | 5 | 0 | 0 | 5 |
I. Suppliers based on LOW- MID- HIGH
LINEN | LOW | MID | HIGH | TOTAL |
BEDDINGS | 2 | 2 | 1 | 5 |
PILLOW | 1 | 1 | 1 | 3 |
TOWEL | 1 | 2 | 1 | 4 |
CURTAIN | 1 | 1 | 0 | 2 |
I. Suppliers based on LOW- MID- HIGH
PAINTS | LOW | MID | HIGH | TOTAL |
PAINTS | 7 | 2 | 1 | 10 |
CHEMICALS | 17 | 9 | 1 | 27 |
PAINT ACCESSORIES | 12 | 5 | 0 | 17 |
TOOLS | LOW | MID | HIGH | TOTAL |
HAND TOOLS | 9 | 1 | 0 | 10 |
POWER TOOLS | 10 | 1 | 0 | 11 |
SAFETY TOOLS | 5 | 0 | 0 | 5 |
TOOL ORGANIZER | 4 | 0 | 0 | 4 |
HAND TRUCKS | 4 | 0 | 0 | 4 |
I. Suppliers based on LOW- MID- HIGH
ELECTRICAL & LIGHTING | LOW | MID | HIGH | TOTAL |
LIGHTINGS | 24 | 1 | 1 | 26 |
CHANDELIER | 3 | 0 | 0 | 3 |
WIRING DEVICES | 7 | 1 | 2 | 10 |
CABLES AND WIRES | 4 | 0 | 1 | 5 |
POWER DISTRIBUTION | 7 | 0 | 0 | 7 |
I. Suppliers based on LOW- MID- HIGH
SANITARY WARES | LOW | MID | HIGH | TOTAL |
WATER CLOSET | 7 | 2 | 1 | 10 |
LAVATORY | 12 | 4 | 1 | 17 |
URINAL | 10 | 4 | 0 | 14 |
SANITARY PARTS | 3 | 0 | 0 | 3 |
BATH FURNITURE | 1 | 0 | 0 | 1 |
SHOWER ENCLOSURE | 2 | 0 | 0 | 2 |
I. Suppliers based on LOW- MID- HIGH
TILES | LOW | MID | HIGH | TOTAL |
TILES | 5 | 1 | 0 | 6 |
VINYL TILES | 1 | 2 | 0 | 3 |
I. Suppliers based on Trading LOW, MID, HIGH
I. Suppliers based on DIY LOW, MID, HIGH
I. Suppliers based on Appliance LOW, MID, HIGH
I. Suppliers based on Furniture LOW, MID, HIGH
I. Number of Consignment, Importer, Outright
Consignment
2019
2020
I. Yearly Sales of Suppliers (Consignment, Importer, Outright)- DAU 2019 & 2020
Consignment
2019
2020
I. Yearly Sales of Suppliers (Consignment, Importer, Outright)- MALOLOS 2019 & 2020
Consignment
2019
2020
I. Yearly Sales of Suppliers (Consignment, Importer, Outright)- NOVALICHES 2019 & 2020
I. Comparison on Competitors
BW | RA | LM | BB |
1.Wilcon | 1.All Home | 1.Puregold | 1.Uno |
2.All Home | 2.Furniture Republic | 2.Savemore | 2.Novo |
3.John & Carl | 3.Land Mark | 3.Walter Market | 3.Unitop |
4.Citi Hardware | 4.Robinson Appliance | 4.Metro | 4.Best Buy |
5.Ace Hardware | 5.Abenson | 5.HyperMarket | 5.Daiso |
6.Handyman | 6.SM Furniture | 6.Land Mark | 6.Japan Home Centre |
7.Mr. DIY | 7.Emilio S. Lim | 7.Robinson Supermarket | 7.American Home |
8. Workstation | 8. FC Home Center | 8.Ever super Market | 8. Divisoria Price |
II. BW Sales Per Category-DAU
BW-DAU | 2019- in Millions | 2020-in Millions | Growth |
1. TRADING | 60M | 38M | -36% |
2. DIY | 65M | 55M | -16% |
3. FURNITURE | 31M | 28M | -10% |
4. APPLIANCE | 9M | 13M | 44% |
II. BW Sales Per Category-DAU
Trading
2019
2020
II. BW Sales Per Category-Malolos
BW-MALOLOS | 2019- in Millions | 2020-in Millions | Growth |
1.TRADING | 48M | 51M | 6% |
2. DIY | 53M | 91M | 72% |
3. FURNITURE | 33M | 52M | 58% |
4. APPLIANCE | 8M | 23M | 187% |
II. BW Sales Per Category-Malolos
Trading
2019
2020
II. BW Sales Per Category-Novaliches
BW-NOVALICHES | 2019- in Millions | 2020-in Millions | Growth |
1.TRADING | 40M | 30M | -25% |
2. DIY | 22M | 20M | -9% |
3. FURNITURE | 12M | 10M | -17% |
4. APPLIANCE | 2M | 4M | 100% |
II. BW Sales Per Category-Novaliches
2020
2019
II. BW Sales Per Category-Tagaytay
BW-TAGAYTAY | 2019- in Millions | 2020-in Millions | Growth |
1.TRADING | - | 5M | N/A |
2. DIY | - | 10M | N/A |
3. FURNITURE | - | 7M | N/A |
4. APPLIANCE | - | 2M | N/A |
II. BW Sales Per Category-Tagaytay
2020
II. LM Sales Per Category-DAU
LM-DAU | 2019- in Millions | 2020-in Millions (May 2020) | Growth |
1. FOOD | - | 3M | N/A |
2. NON-FOOD | - | 3M | N/A |
3. BIG BUYS | - | 3M | N/A |
II. LM Sales Per Category-DAU
2020
Non-Food
Big Buys
II. LM Sales Per Category-Malolos
LM-MALOLOS | 2019- in Millions | 2020-in Millions (April 2020) | Growth |
1. FOOD | - | 21M | N/A |
2. NON-FOOD | - | 10M | N/A |
3. BIG BUYS | - | 7M | N/A |
II. LM Sales Per Category-Malolos
2020
Non-Food
Big Buys
II. LM Sales Per Category-Novaliches
LM-NOVALICHES | 2019- in Millions | 2020-in Millions (July 2020) | Growth |
1. FOOD | - | 5M | N/A |
2. NON-FOOD | - | 3M | N/A |
3. BIG BUYS | - | 1M | N/A |
II. LM Sales Per Category-Novaliches
2020
Non-Food
Big Buys
II. LM Sales Per Category-Tagaytay
LM-TAGAYTAY | 2019- in Millions | 2020-in Millions (Sept. 2020) | Growth |
1. FOOD | - | 4M | N/A |
2. NON-FOOD | - | 1M | N/A |
3. BIG BUYS | - | 658K | N/A |
II. LM Sales Per Category-Tagaytay
2020
Non-Food
Big Buys
II. With and With Out Last Minute
W/o Last Minute (Jan-Feb)
TRADING | DIY | FURNITURE | LM/BIG BUYS |
| JAN | FEB | JAN | FEB | JAN | FEB | JAN | FEB |
DAU | 6M | 6M | 7M | 6M | 3M | 4M | 0 | 0 |
MALOLOS | 7M | 8M | 10M | 11M | 8M | 9M | 0 | 0 |
NOVA | 3M | 3M | 1M | 1M | 1M | 924K | 0 | 0 |
TAGAYTAY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
II. With and With Out Last Minute
W/ Last Minute
(Sept-Oct)
TRADING | DIY | FURNITURE | LM/BIG BUYS |
| SEPT | OCT | SEPT | OCT | SEPT | OCT | SEPT | OCT |
DAU | 4M | 1M | 4M | 4M | 4M | 4M | 1M | 1M |
MALOLOS | 2M | 3M | 6M | 8M | 6M | 7M | 4M | 4M |
NOVA | 2M | 1M | 1M | 2M | 1M | 1M | 2M | 1M |
TAGAYTAY | 1M | 2M | 1M | 4M | 1M | 4M | 896K | 3M |
III. Monthly Sales of DAU 2019
III. Monthly Sales of DAU 2020
III. Monthly Sales of MALOLOS 2019
III. Monthly Sales of MALOLOS 2020
III. Monthly Sales of NOVALICHES 2019
III. Monthly Sales of NOVALICHES 2020
III. Monthly Sales of TAGAYTAY 2020
III. BW &LM Sales for 2019 & 2020
| 2019- in Millions | 2020-in Millions | Growth |
DAU | 170M | 130M | -24% |
MALOLOS | 147M | 224M | 52% |
NOVALICHES | 80M | 69M | -14% |
TAGAYTAY | - | 21M | N/A |
III. Renovations- DAU 2020
AREA | START | FINISH | REMARKS |
Wall Clock Module/ wire mesh | Feb. 07, 2020 | Feb. 09, 2020 | Counter Area |
Last Minute Grocers Setup | May 09, 2020 | May 10, 2020 | Open on May 11, 2020 |
Builders Café Renovation | 3rd Week of May | June 20, 2020 | Continuation of Last Minute Grocer's |
Second Floor Constraction | August 26, 2020 | up to Present | Front Area , Warehouse Area and D.I.Y. Area |
III. Damaged Items- MALOLOS 2020
ITEM CATEGORY | ITEM DESCRIPTION | QTY | RETAIL PRICE | TOTAL AMOUNT | RECOMMENDATION |
HOME DÉCOR | Flower Vase | 1 | 351.00 | 351.00 | for disposal |
OFFICE SUPPLIES | NoteBook | 14 | 19.50 | 273.00 | for disposal |
DIY | Air Pump | 2 | 302.75 | 605.50 | for disposal |
FURNITURE | ITR 7040 Tv Cabinet | 2 | 5,995.00 | 11,990.00 | (Infinite Brand) for pull-out |
FD 8913 Chest Drawer | 1 | 4,995.00 | 4,995.00 | ||
TH 50A Child Cabinet | 3 | 3,999.00 | 11,997.00 | ||
FD 284 Shoe Cabinet | 2 | 2,795.00 | 5,590.00 | ||
TH 24C Study Table | 1 | 2,995.00 | 2,995.00 | ||
Toyama TV Stand | 1 | 4,795.00 | 4,795.00 | for pull-out | |
TILES | Tilemax Adhesive | 2 | 216.00 | 432.00 | for disposal |
| Store Glass Panel | Â | Â | Â | temporarily covered with tarpaulin |
| Roll Up of Trad Area | Â | Â | Â | ok (already repaired) |
TOTAL AMOUNT: | | | 26,463.25 | 44,023.50 | |
III. Renovations- MALOLOS 2020
AREA | START | FINISH | REMARKS |
Offices, Pantry and Locker Room | February 2020 | April 2020 | Not fully furnished |
BCafe | March 2020 | April 2020 | Open on May 11, 2020 |
Last Minute Warehouse | October 2020 | | On-going Construction |
Appliance Extension | October 2020 | | On-going Construction |
III. Damaged Items- NOVALICHES 2020
DESCRIPTION | QTY | AMOUNT |
SY Book Case | 1 | 3,295.00 |
SY Display Cabinet | 1 | 3,895.00 |
SY Book Shelf | 1 | 6,095.00 |
SY Book Shelf | 2 | 7,390.00 |
Tarpaulin (Red Abode) | 1 | 787.40 |
Tarpaulin (Big Buys) | 1 | 787.40 |
Tarpaulin (LM) | 1 | 952.00 |
TOTAL AMOUNT: | | 23,201.8 |
III. Renovations- NOVALICHES 2020
AREA | START | FINISH | REMARKS |
Transferring of Tiles and Sanitary at the front Area of DIY | June 17, 2020 | | Finished |
Start of Racking set up for LMG | June 22, 2020 | June 30, 2020 | Finished |
Closure Traditional Hardware | June 17, 2020 | June 30, 2020 | Finished |
LMG Operation | July 03, 2020 | | Up to present |
III. Renovations- NOVALICHES 2020
AREA | START | FINISH | REMARKS |
Compressing of LMG Area | November 13 | November 18 | Finished |
Transferring of Tiles to Main Aisle | November 19 | November 21 | On-going |
Relocation for Sanitary Wares 1pc to new location | November 22 | November 23 | On-going |
Transferring of Outdoor Furniture to Brownlines | November 24 | November 26 | On-going |
Moving of Appliance items to DIY Extension | November 27 | November 30 | On-going |
III. Store Daily Records/Daily Average 2019
| DAU | MALOLOS | NOVALICHES | TAGAYTAY |
Daily Ave. Sales | 466,571.72 | 802,009.55 | 219,587.69 | - |
Daily Ave. Transaction Count | 125.30 | 255.56 | 122.10 | - |
Basket Size | 3,723.64 | 3,138.24 | 1,798.42 | N/A |
III. Store Daily Records/Daily Average 2020
| DAU | MALOLOS | NOVALICHES | TAGAYTAY |
Daily Ave. Sales | 426,347.01 | 736,487.51 | 226,575.01 | 347,383.28 |
Daily Ave. Transaction Count | 191.19 | 367.01 | 122.67 | 59.41 |
Basket Size | 2,229.97 | 2,006.72 | 1,847.03 | 5,847.22 |
Thank you
Thanks to your commitment and strong work ethic, we know next year will be even better than the last.
We look forward to working together.
72