Inventory Report in Excel Format
MODEL
Flow_Repossessed
BOX
Beginning Balance
BRONCO R150
Assumed
BRONCO R150-AMLAN
Change Unit
BULLRIDER 150
Others
BULLRIDER 150-AMLAN
Company service
CANVAS TOP
Redeemed
E-BIKE ( BANDIT)
Repossessed_IN
E-BIKE ( NO.1X)
Repossessed_IN owned by other branch
E-BIKE (CASANOVA)
Sold
E-BIKE (CITY GIRL)
Sold in other branch
E-BIKE (POD-JOCK)
Undeclared Sales_previous months
E-BIKE (QUEST)
Units owned by other branch
E-BIKE (THOMSON)
Units owned in other branch
EBIKE- A8
Returned to Supplier for repair
E-RIWHEELER-PASS.TYPE W/OUT CANOPY
E-TRIKE ( PASSENGER)
ETRIKE (cargo)
Received from Supplier
E-TRIWHEELER-CARGO CONVERTED TO PASS TYPE W/CANOPY
E-TRIWHEELER-CARGO CONVERTED TO PASS TYPE W/CANOPY BUT W/OUT SEAT ASSY
E-TRIWHEELER-CARGO W/ CANOPY
E-TRIWHEELER-CARGO W/ OUT CANOPY
E-TRIWHEELER-MINI DUMP STYLE-GARBAGE TYPE
E-TRIWHEELER-PASS.TYPE W/ CANOPY
E-TRIWHEELER-ROLLING STORE
EXCEED-110
F/R CANOPY
F/R CANOPY PASSENGER TYPE
FRONT CANOPY
GY110 (1)
HAVAL100
HAVAL100 (cargo type)
HAVAL100 W/ WATER TANK
JR125-31
MAYA 150 (ZEBS) PATROL TYPE
MAYA 150 (ZEBS) W/ FRONT CANVASS TOP
MAYA 150 (ZEBS) W/ REAR CANOPY
MAYA 150(ZEBS) new
MAYA150 (ZEBS) W/ F&R Canvass (whole)
MAYA150(ZEBS)- CLOSED VAN
MAYA150(ZEBS)-ROLLING STORE
MAYA150(ZEBS)W/ PASSENGER TYPE CANOPY
MC110 (TSB)
MC110A
MC110F
MC110GY (1)
+
+
+
+
-
+
MC110J (1)
MC125A (1)
MC125GY.
MC125GY-F (1)
MC150 (1)
MC150GY.
MC150GY-A (1)
MC150GY-B (1)
MC150GY-B (1) amlan
MC150GY-R
MC150GY-X (1)
MC150GY-X (1) amlan
MD100 (1)
MD100A
MD100R (1)
MD100S (1)
MD110
MD110 (1)
MD110A (1)
MD110B (1)
MD110S (1)
MD110X (1)
MIA125 (1)
PATROL TYPE
QUEST 125
RAYS- N1
RAYS 141-365 W/ FRONT CANVASS
RAYS MAYA N1
RAYS MAYA N1 W/ PASSENGER TYPE CANOPY
RC110 (1)
REAR CANOPY
SAMURAI 110
SPEED-X 125
STRIKER 110
THUNDERBOLT
THUNDERBOLT (1)
TS125
TS125- cebu 1
TS125-B
TS125-CG
TS125-CG (amlan)
TS125-CG W/SC
TS125-CG W/SIDECAR
TS125F W/SC
TS125F(1)
TS150
TS150 -cebu 1
TS150-CG
TS150-CG (amlan)
TS150F(1)
WATER TANK
Branch
Outlet
STA CRUZ BRANCH
STA CRUZ
INFANTA
LUCENA
CANDELARIA
Flow_Brand New
Beginning Balance
Delivered to other branch
Received from other branch
Received from Supplier
Sold
Returned to Suppliers
Change Unit
Received from Supplier_Repaired
Received from Customer
Received from other outlets
Delivered to other outlets
Transferred to SOUTH
Account
+
+
+
+
+
+
-
Accounts Receivable balance
AR balance of Ending Repossessed Unit
Collection
Company Service Unit
Current Accounts for the month
DQC (Quit Claim) of sold Repossessed Unit
Due
Overdue
Rebate
Resale value of Company Service
Resale value of Repossessed Unit
Company Name :
Month Period :
Ending Inventory Unit :
Sold Unit :
Inventory:
Racal Motorsales Corporation
OCTOBER, 2017
7
1
Brand New
Branches
STA CRUZ BRANCH
STA CRUZ BRANCH
STA CRUZ BRANCH
STA CRUZ BRANCH
STA CRUZ BRANCH
STA CRUZ BRANCH
STA CRUZ BRANCH
STORE/OUTLET
STA CRUZ
STA CRUZ
Model
TS150-CG
TS150-CG
INFANTA
INFANTA
HAVAL100
TS150-CG
1 Beginning Balance
2 Beginning Balance
CANDELARIA
TS150-CG
3 Beginning Balance
UNIT
Flow
2 Beginning Balance
1 Sold
1
DO NOT EDIT
2 3 Total Unit
TC
2
-1
0
1
2
0
3
Racal Motorsales Corporation
BRGY. PAGSAWITAN STA CRUZ, LAGUNA-
Ending Inventory per Model for the Month of OCTOBER, 2017
Sum of Total Unit
Model
HAVAL100
TS150-CG
(blank)
Grand Total
Branches
(blank)
STORE/OUTLET
STA CRUZ BRANCH
(blank)
STA CRUZ
0
0
1
0
1
STA CRUZ BRANCH
INFANTA
STA CRUZ BRAN
LUCENA
CANDELARIA
1
2
3
0
0
3
0
3
1
6
0
7
Grand Total
1
6
0
7
Racal Motorsales Corporation
BRGY. PAGSAWITAN STA CRUZ, LAGUNA-
Brand New Inventory Sold out for the Month of OCTOBER, 2017
Flow
(Multiple Items)
Sum of Unit
Branches
STA CRUZ BRANCH
STA CRUZ
Model
TS150-CG
TOTAL
STORE/OUTLET
STA CRUZ BRANCH Total
1
1
TOTAL
1
1
1
1
Racal Motorsales Corporation
BRGY. PAGSAWITAN STA CRUZ, LAGUNA-
Brand New Inventory Report for the Month of OCTOBER, 2017
For the STORECANDELARIA
Units
Beginning Inventory as of OCTOBER, 2017
3
Add:
Received from other branch
Received from other outlets
Received from Supplier_Repaired
Received from Customer
Received from Supplier
0
0
0
0
0
Inventory Available for Sale
0
3
Less:
Sold
Change Unit
Returned to Supplier
Delivered to other outlets
Transferred to SOUTH
Delivered to other branch
##
Prepared by:
0
0
0
0
0
0
0
3
Racal Motorsales Corporation
BRGY. PAGSAWITAN STA CRUZ, LAGUNA-
Consolidated Brand New Inventory Report for the Month of OCTOBER, 2017
Units
Beginning Inventory as of OCTOBER, 2017
8
Add:
Received from other branch
Received from other outlets
Received from Supplier_Repaired
Received from Customer
Received from Supplier
0
0
0
0
0
Inventory Available for Sale
Less:
Sold
Change Unit
Returned to Suppliers
Delivered to other outlets
Transferred to SOUTH
Delivered to other branch
#WERT!
Prepared by:
BABY GIRL D. TUBOG
SALES & INVENTORY COORDINATOR SOUTH 1
0
8
-1
0
0
0
0
0
-1
7
Racal Motorsales Corporation
BRGY. PAGSAWITAN STA CRUZ, LAGUNA-
DITO LANG PO KAYO MAG INPUT. :)
DR MONITORING FORM
DR NO.
DR DATE
Brand New Inventory: RMC Unit for the Month of OCTOBER, 2017
Flow
(Multiple Items)
Branches
(blank)
(blank) Total
STA CRUZ BRANCH
STA CRUZ BRANCH Total
Grand Total
Model
(blank)
(blank)
Sum of Unit
-
MODEL
ENGINE NO.
REMARKS
Racal Motorsales Corporation
BRGY. PAGSAWITAN STA CRUZ, LAGUNA-
TRANSFER IN
BRANCH/OUTLET
MODEL
COLOR
Racal Motorsales Corporation
STA CRUZ BRANCH
-
TRANSFER OUT
ENGINE NUMBER
RECEIVED FROM:
BRANCH/OUTLET
MODEL
COLOR
ENGINE NUMBER
DELIVERED TO:
STA CRUZ, LAGUNA- INFANTA OUTLET
SECOND HAND
SI DATE
SI NO ID
-
CUSTOMER NAME
10787 ALIM, MARK ANTHONY#2 D
10788 RAFON, ELMAR V
10794 BRONCANO, ROSIELYN
SUB-TOTAL MOTOR RELEASE:
ENGINE NUMBER
RMC100XZML-
RMC100RACH-
RMC125MLXR-
SUB-TOTAL MOTOR RELEASE:
STA. CRUZ, LAGUNA MAIN BRANCH
SECOND HAND
STA CRUZ, LAGUNA- INFA
SI DATE
ENGINE NUMBER
-
SI NO ID-
CUSTOMER NAME-
GONIO, RIZA BARCELONA
RMC100XZML-
MACATANGAY, JOANA ANN FERNARMC100RACH-
GALINDEZ, JUNIE JAVILINAR
RMC125MLXA-
MORTEL, BERLIN GARIZA
RMC100XZML-
REYES, GEMMA ABAUAG
RMC100RACH-
SALAZAR, ENRICO SR CASTRO
RMC125MLXA-
FLORES, RODNEL MACATANGGA RMC125MLXA-
ALBEUS, AGNES REGONDOLA
RMC100XZML-
ROMERO, YVAN JOE ANGELES
RMC100RACH-
DELA CRUZ, EDUARDO PANLUBUTON
RMC100RACH-
DELA CRUZ, RANDEL C.
RMC100RACH-
BAUTISTA, EDZER#4 DARAN
RMC150ZEBS-
SUB-TOTAL MOTOR RELEASE:
12
BRAND NEW
SI DATE
SI NO ID
-
CUSTOMER NAME
10781 ORTEGA, RUSSEL MONTANANO RMC150MLAJ-
SUB-TOTAL MOTOR RELEASE:
1
SUB-TOTAL MOTOR RELEASE:
TOTAL MOTOR RELEASE:
JEDRA LUCENA
ENGINE NUMBER
STA. CRUZ, LAGUNA MAIN BR
SECOND HAND
SI DATE-
SI NO ID-
-
CUSTOMER NAME
ENGINE NUMBER
POBEDA, ROWEL ROCERO
REVADULLA, SHERYL NEDUA
DE LEON, RAMIL T
NIERA, RIZA MAE MENDOZA
ORTIZ, EDDIESON#3 CONTI
FLORIDA, AIZA
EVANGELISTA, FELIX
SUB-TOTAL MOTOR RELEASE:
RMC110XPJR-
RMC125MLXR-
RMC125MLXR-
RMC100RACH-
RMC125MLXR-
RMC100RACH-
RMC100RACH-
SUB-TOTAL MOTOR RELEASE:
LUCENA - CANDELARIA OUTLET
SECOND HAND
JEDRA LUCENA
SI DATE
ENGINE NUMBER
-
SI NO ID-
CUSTOMER NAME-
ANTALAN, MARIVIC VIDONIA
RMC110XPJR-
SANTOS, JESSIE NAPIZA
RMC100RACH-
ATIENZA, RONAL VILLAPANDO
RMC150JAKE-
ARTISTA, EDGARDO LAQUI
RMC100RACH-
DUDAS, ROLDAN
RMC100RACH-
MONTEROSO, JERICK PANGANIBAN
RMC125MLXR-
CRUZAT, JESUS MAGBUHOS
RMC100RACH-
PIANAR, ROBERTO#7 EDUYAN
RMC100RACH-
PIANAR, ROBERTO#11 EDUYAN RMC100RACH-
PIANAR, ROBERTO#8 EDUYAN
RMC100RACH-
PIANAR, ROBERTO#10 EDUYAN RMC100RACH-
PIANAR, ROBERTO#9 EDUYAN
RMC100RACH-
PIANAR, ROBERTO#12 EDUYAN WXGMA48XI-
PIANAR, ROBERTO #13
RMC110XPJR-
PIANAR, ROBERTO #14
RMC110XPJR-
SUMAGI, JENNY ILAGAN
RMC100RACH-
SULANGI, NORBERTO BUGAY
RMC100XZML-
SUB-TOTAL MOTOR RELEASE:
17
SUB-TOTAL MOTOR RELEASE:
TOTAL MOTOR RELEASE:
LUCENA - CANDELARIA O
40
SUMMARY OF SALES INVOICE REPORT - ENTIRE BRANCH- TO-
CHASSIS NUMBER
MODEL
COLOR TYPE RESALE
RMC100XZML-MD100R BLACK INST
RMC100RACH-MD100R BLUE INST
RMC125MLXR-TS125-CG RED
INST
SECOND HAND
-
TRM MONTHLY REB
24
18
24
-
DP-
-
INFANTA OUTLET
CHASSIS NUMBER
130620
MODEL
COLOR TYPE RESALE
RMC100XZML-MD100R BLACK
RMC100RACH-MD100R BLUE
RMC125MLXA-JR125-31 RED
RMC100XZML-MD100R RED
RMC100RACH-MD100R BLACK
RMC125MLXA-JR125-31 RED
RMC125MLXA-JR125-31 WHITE
RMC100XZML-MD100R RED
RMC100RACH-MD100R BLACK
RMC100RACH-MD100R RED
RMC100RACH-MD100R BLUE
RMC150ZEBS- MAYA 150BLACK
SECOND HAND
CHASSIS NUMBER
MODEL
INST
CASH
INST
INST
INST
INST
CASH
INST
INST
CASH
CASH
INST
-
COLOR TYPE LCP
RMC150MLAJ- TS150-CG BLACK INST
BRAND NEW
TRM MONTHLY REB-
-
DP-
TRM MONTHLY REB
40000
36
2000
DP
300
MAIN BRANCH
-
557910
SUMMARY OF SALES INVOICE REPORT - ENTIRE BRANCH- TO-
-
CHASSIS NUMBER
MODEL
COLOR TYPE RESALE
RMC110XPJR- XCEED 110BLACK
RMC125MLXR-TS125-CG BLACK
RMC125MLXR-TS125-CG BLUE
RMC100RACH-MD100R RED
RMC125MLXR-TS125-CG BLUE
RMC100RACH-MD100R BLUE
RMC100RACH-MD100R BLACK
SECOND HAND
INST
INST
INST
INST
INST
INST
INST
-
TRM MONTHLY REB-
-
DP-
-
CHASSIS NUMBER
MODEL
COLOR TYPE RESALE
RMC110XPJR- XCEED 110GREEN INST
RMC100RACH-MD100R BLACK CASH
RMC150JAKE- BULL DIDER
RED
INST
RMC100RACH-MD100R RED
INST
RMC100RACH-MD100R BLACK CASH
RMC125MLXR-TS125-CG BLACK INST
RMC100RACH-MD100R BLUE CASH
RMC100RACH-MD100R BLACK CASH
RMC100RACH-MD100R BLACK CASH
RMC100RACH-MD100R RED
CASH
RMC100RACH-MD100R BLACK CASH
RMC100RACH-MD100R RED
CASH
WXGMA48XI-EBIKE A8 ORANGECASH
RMC110XPJR- XCEED 110GREEN CASH
RMC110XPJR- XCEED 110BLACK CASH
RMC100RACH-MD100R BLACK INST
RMC100XZML-MD100R RED
INST
SECOND HAND
-
TRM MONTHLY REB-
-
DP-
RIA OUTLET
-
423840
TOTAL AR
TYPE
-
TOTAL AR
TYPE
-
TOTAL AR
72000
TYPE
TOTAL AR
TYPE
-
TOTAL AR-
TYPE
INFANTA OUTLET
INFANTA OUTLET
TS150-CG
TS150-CG
RED
BLACK
RMC150MLAJ-
RMC150MLAJ-
-
1
1
BRANCH/OUTLET
MODEL
COLOR
ENGINE NUMBER
STA CRUZ BRANCH
STA CRUZ BRANCH
TS150-CG
TS150-CG
BLACK
BLUE
RMC150MLAJ-
RMC150MLAJ-
INFANTA OUTLET
INFANTA OUTLET
INFANTA OUTLET
HAVAL100
TS150-CG
TS150-CG
RED
RED
BLACK
RMC100XTRM-
RMC150MLAJ-
RMC150MLAJ-
TS150-CG
TS150-CG
TS150-CG
BLACK
BLACK
BLUE
RMC150MLAJ-
RMC150MLAJ-
RMC150MLAJ-
LUCENA BRANCH
LUCENA BRANCH
LUCENA BRANCH
CANDELARIA OUTLET
CANDELARIA OUTLET
CANDELARIA OUTLET
FROM
SOLD
TO
STOCK ON HAND REPORT STA. CRUZ,
REPORT AS OF November, 02, 2017
ENGINE
CHASSIS
STA. CRUZ, LAGUNA MAIN BRANCH
BRAND NEW
RMC150MLAJ-
RMC150MLAJ-
BRAND NEW
STA CRUZ, LAGUNA- INFANTA OUTLET
BRAND NEW
RMC150MALJ-
RMC150MALJ-
RMC150MLAJ-
RMC150MLAJ-
RMC100XTRM-
RMC100XTRM-
BRAND NEW
MODEL
COLOR
DQC
RESALE
TS150-CG BLUE
0
0
TS150-CG BLACK
TS150-CG RED
HAVAL 100 RED
(
0
0
0
0
0
0
TS150-CG BLACK
TS150-CG BLACK
TS150-CG BLUE
0
0
0
0
0
0
1
3
LUCENA - CANDELARIA OUTLET
BRAND NEW
RMC150MLAJ-
RMC150MLAJ-
RMC150MLAJ-
RMC150MLAJ-
RMC15MLAJ-
RMC15MLAJ-
BRAND NEW
3
TOTAL
7
CRUZ, LAGUNA MAIN BRANCH ONLY
2017
UNIT FROM