1 of 72

BUSINESS REVIEW

1

November 16, 2020

2 of 72

2

I. Introduction

    • Layout of Stores per category
    • Branch Comparison
    • Suppliers based on LOW, MID, HIGH
    • Number of Consignment, Importer, Outright
    • Yearly Sales of Suppliers- Consignment, Importer, Outright
    • Comparison on Competitors

II. Sales Per Category

    • 2019 vs. 2020
    • With and With Out Last Minute

III. Monthly Sales Per Branch

    • Monthly and Yearly Sales
    • Daily Average Sales, Daily Transaction Counts, & Basket Size
    • Damaged Items
    • Renovations

Agenda

3 of 72

I. Introduction

3

4 of 72

I. Layout of Stores per Category

DAU

5 of 72

I. Layout of Stores per Category

MALOLOS

6 of 72

I. Layout of Stores per Category

NOVALICHES

7 of 72

I. Layout of Stores per Category

TAGAYTAY

8 of 72

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

9 of 72

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

10 of 72

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

11 of 72

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

12 of 72

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

13 of 72

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

14 of 72

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

15 of 72

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

16 of 72

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

17 of 72

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

18 of 72

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

19 of 72

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

20 of 72

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

21 of 72

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

22 of 72

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

23 of 72

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

24 of 72

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

25 of 72

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

26 of 72

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

27 of 72

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

28 of 72

I. Suppliers based on LOW- MID- HIGH

TILES

LOW

MID

HIGH

TOTAL

TILES

5

1

0

6

VINYL TILES

1

2

0

3

29 of 72

I. Suppliers based on Trading LOW, MID, HIGH

30 of 72

I. Suppliers based on DIY LOW, MID, HIGH

31 of 72

I. Suppliers based on Appliance LOW, MID, HIGH

32 of 72

I. Suppliers based on Furniture LOW, MID, HIGH

33 of 72

I. Number of Consignment, Importer, Outright

34 of 72

Consignment

2019

2020

I. Yearly Sales of Suppliers (Consignment, Importer, Outright)- DAU 2019 & 2020

35 of 72

Consignment

2019

2020

I. Yearly Sales of Suppliers (Consignment, Importer, Outright)- MALOLOS 2019 & 2020

36 of 72

Consignment

2019

2020

I. Yearly Sales of Suppliers (Consignment, Importer, Outright)- NOVALICHES 2019 & 2020

37 of 72

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

38 of 72

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%

39 of 72

II. BW Sales Per Category-DAU

Trading

2019

2020

40 of 72

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%

41 of 72

II. BW Sales Per Category-Malolos

Trading

2019

2020

42 of 72

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%

43 of 72

II. BW Sales Per Category-Novaliches

2020

2019

44 of 72

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

45 of 72

II. BW Sales Per Category-Tagaytay

2020

46 of 72

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

47 of 72

II. LM Sales Per Category-DAU

2020

Non-Food

Big Buys

48 of 72

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

49 of 72

II. LM Sales Per Category-Malolos

2020

Non-Food

Big Buys

50 of 72

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

51 of 72

II. LM Sales Per Category-Novaliches

2020

Non-Food

Big Buys

52 of 72

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

53 of 72

II. LM Sales Per Category-Tagaytay

2020

Non-Food

Big Buys

54 of 72

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

55 of 72

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

56 of 72

III. Monthly Sales of DAU 2019

57 of 72

III. Monthly Sales of DAU 2020

58 of 72

III. Monthly Sales of MALOLOS 2019

59 of 72

III. Monthly Sales of MALOLOS 2020

60 of 72

III. Monthly Sales of NOVALICHES 2019

61 of 72

III. Monthly Sales of NOVALICHES 2020

62 of 72

III. Monthly Sales of TAGAYTAY 2020

63 of 72

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

64 of 72

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

65 of 72

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

66 of 72

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

67 of 72

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

68 of 72

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

69 of 72

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

70 of 72

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

71 of 72

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

72 of 72

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