p&l template 0908 aug bta

8/3/2019 P&L Template 0908 AUG BTA

1/6

Distributor :Area of Coverage :AUG BATANGAS

No. of Human Resources 67No. of Key Account Booking Salesmen 2No. of PMS Book-Ahead Salesmen 6No. of Book-Ahead Salesmen (Secondary Accounts) 0No. of Van Salesmen 12Van Team Composition (1 if one-man team, 2 if two-manteam, and so on) 12No. of Van Teams 1No. of Tricycle Salesmen 1

Tricycle Team Composition (1 if one-man team, 2 if two-man team, and so on) 1No. of Tricycle Teams 1Inventory Coverage 34Operating Profit 335,371ROI 13.0%

MonthlyFinancials

% toSTT Data Source

BUSINESS TURNOVER (STT Goal) 14,825,233 EDMS/ITTGROSS INCOME 2,048,847 13.8%

SERVICE FEE 1,233,459 8.3% SF-KPI Excel FileBUSINESS BUILDERS FUND 222,378 1.5% SD MechanicsPROMPT PAYMENT DISCOUNT 593,009 4.0% CP Invoices

EXPENSES 1,713,476 OPERATIONAL EXPENSES 1,323,831 8.9% Book of Accounts (details contained in the OpEx Schedules Sheet)TERM DISCOUNTS TO TRADE 222,378 1.5% CP Invoices / BWPROMO / DISC - FUNDED BY BBF 222,378 1.5% BBF MonitoringPROMO / DISC - FUNDED BY DISTRIBUTOR (55,112) -0.4% EDMS / Book of Accounts

OPERATING PROFIT 335,371 2.3%INVESTMENT 31,016,137

INVENTORY 16,734,245 112.9% EDMS/ITTRECEIVABLES FROM TRADE 8,593,392 58.0% A/R AgingRECEIVABLES FROM CP (Funds Tied-up in Claims) - 0.0% Disbursement Ledger INVESTMENT IN FIXED ASSETS 5,688,500 38.4% Fixed Assets Ledger

LESS: ACCUMULATED DEPRECIATION - 0.0%NET FIXED ASSETS 5,688,500 38.4%LESS: PAYABLE TO CP - 0.0% Oustanding Invoices as of Month-end

RETURN ON INVESTMENT - P. A. 13.0%

RETURN ON SALES 2.3%DAYS SALES OUTSTANDING 18 INVENTORY DAYS COVERAGE 34


2/6


3/6


4/6

OPERATING EXPENSE DETAILS FOR THE MONTH OF:DISTRIBUTOR:

HEADCOUNT:Name Position Hiring date Base Salary

1. BOY MATA OM Feb 2002 570002 . ERWIN REYES SALES/SUPERVISOR March 1998 10,400.003. BRIAN REQUINTO SALES/SUPERVISOR March 2003 9,542.004. GYMVE GARCIA BOOKING/SALESMAN November 2006 8,710.005. JONATHAN PENAFLORIDA BOOKING/SALESMAN June 1999 8,710.00

6. ETHEL ESGUERRA CMO April 2003 9,542.007. FELICIANO BUNYI MKT SPECIALIST Oct 2005 7,618.008. ALBERT OBLEFIAS MKT SPECIALIST June 2007 7,618.009. MICHAEL FERRER MKT SPECIALIST March 2007 7,618.0010. REYNATE ABREHAN MKT SPECIALIST Oct 2002 7,618.0011 JP ZAPORTEZA MKT SPECIALIST Dec 2006 7,618.0012 JOSEPH HERRERO MKT SPECIALIST Dec 2005 7,618.0013 EUGENE RODRIGUEZ VAN SALESMAN April 2006 7,618.0014 JONATHAN HERNANDEZ VAN SALESMAN Aug 2003 7,618.0015 GUILLERMO CUPO VAN SALESMAN May 2006 7,618.00

16 ROBERT MASACAYAN VAN SALESMAN Feb 2006 7,618.0017 FREDDIE RAMIREZ VAN SALESMAN Oct 2005 7,618.0018 JOSEPH MENDOZA VAN SALESMAN May 2006 7,618.0019 JEFFREY ALOG VAN ASSISTANT March 2008 7,618.002 0 Ryan Aquino VAN ASSISTANT May 2008 7,618.002 1 DARWIN DELA CRUZ VAN ASSISTANT May 2007 7,618.0022 MICHAEL GONZALGO VAN ASSISTANT Jan 2004 7,618.002 3 ALLAN COMETA VAN ASSISTANT Oct 2005 7,618.002 4 WILFREDO REVILLOSA VAN ASSISTANT Jan 1999 7,618.002 5 VENANCIO CAHIGAN VAN ASSISTANT April 2007 7,618.002 6 KIRK ROCES VAN ASSISTANT Nov 2005 7,618.002 7 ALBERT ABDON VAN ASSISTANT March 2008 7,618.002 8 JOHN ESMOSO VAN ASSISTANT Sept 2007 7,618.002 9 WENCY TAVERA VAN ASSISTANT March 2006 7,618.0030 JOEL GUMAPAC VAN ASSISTANT July 2007 7,618.0031 OLIVER BALITA VAN HELPER/DRIVER Dec 2005 7,618.0032 JED RYAN MARTINEZ VAN HELPER/DRIVER July 2007 7,618.0033 VALENTIN BAUTISTA VAN HELPER/DRIVER Feb 2008 7,618.0034 ROLANDO RODRIGUEZ VAN HELPER/DRIVER Oct 2007 7,618.0035 ANTHONY LEONARDO VAN HELPER/DRIVER Oct 2007 7,618.0036 JONATHAN ANASCO VAN HELPER/DRIVER Feb 2007 7,618.0037 JIMMY VILLAFANIA MARKET MERCHANDIS May 2008 7,618.0038 RYAN ARCANGHEL MARKET MERCHANDIS Oct 2007 7,618.0039 EXPELITO RECIO MARKET MERCHANDIS Dec 2005 7,618.0040 MICHAEL HERNANDEZ TRADE MERCHANDISE April 2008 7,618.0041 REYNALDO OLAN TRADE MERCHANDISE Oct 2005 7,618.0042 RODEL MALIMATA TRADE MERCHANDISE Oct 2005 7,618.0043 RONALD CABRAL TRADE MERCHANDISE Oct 2005 7,618.0044 RICO MAGALLANES TRADE MERCHANDISE Oct 2005 7,618.0045 JOJO PERILE TRADE MERCHANDISE Oct 2005 7,618.0046 JAYSON ARCENA TRADE MERCHANDISE May 2006 7,618.0047 CHARLIE LABRO TRADE MERCHANDISE Oct 2006 7,618.0048 JOBERT ESPENIDA TRADE MERCHANDISE July 2007 7,618.0049 Fernando Hagad TRADE MERCHANDISE Feb 2009 7,618.0050 Marvin Mendoza TRADE MERCHANDISE Feb 2009 7,618.0051 Jonathan Lanuza TRADE MERCHANDISE June 2007 7,618.0052 CHRIS JOHN LABRO TRADE MERCHANDISE June 2007 7,618.0053 BAN DETAL FINANCE HEAD 12,740.0054 DANNAH DIOMANO HEAD CMO 9,542.0055 HONEY ADMIN SUPERVISOR/OFFICER 10,400.0056 LOURDES LIMQUIACO AUDITOR 9,360.00

57 SHERWIN ADARIO BILLER 8,346.0058 ANGELO MERCADO CLERK 8,808.8059 ALLAN MARTINEZ WHSE FOREMAN 8,840.0060 CHRISTINA RATIO WHSE CLERK 7,618.0061 CEDRIC PAGADORA WAREHOUSEMAN 4/1/2003 8,379.8062 YOLANDO CIAGARA DRIVER/COLLECTOR 2/18/2008 8,379.8063 ABELLARDO PALILIO DRIVER/COLLECTOR 2/2/2009 8,379.8064 DARWIN LANTACA DRIVER/COLLECTOR 1/19/2009 8,379.80


5/6

SELLING EQUIPMENT

Van Route Plate Number Salesmen Hiring date

1. Nasugbu, Lian,Calatagan, Cuenca UNT 832 Feliciano Bunyi MS 101

2 . Balayan, Tuy, Calaca RDF 589 Joed Mentoy MS 102

3. Lemery, Mabini, Anilao, Alitagtag, Taal WHW 256 Michael Ferrer MS 103

4. Batangas City, Bauan, Padre Garcia WTR 937 Rey Abrehan MS 104

5. San Juan, Rosario, Ibaan, San Jose XFU 105 PJ Zaporteza MS 105

6. Sto. Tomas, Tanauan, Lipa, Talisay , Laurel WSM 737 Joseph Herrero MS 106

7. Nasugbu, Lian,Calatagan XCN 563 Eugene Rodriguez SS 211

8. Balayan, Tuy, Calaca RBA 420 Jonathan Hernandez SS 212

9. Lemery, Mabini, Anilao, Alitagtag, Taal, Cuenca, Ag CTX 506 Guillermo Cupo SS 213

10. Batangas City, Bauan, Padre Garcia, San Jose CTX 538 Robert Masacayan SS 214

11 San Juan, Rosario, Ibaan, Taysan, Lobo RDF 107 Jed Martinez SS 215

12 Sto. Tomas, Tanauan, Lipa, Talisa CTN 190 Jefr Alo SS 216


6/6

** OM 1** Sales Mgr/Supvr 2* Booking Salesman 2

* CMO 1* Mkt Specialist 6* Van Salesman 7* Asst. Van Salesman 12

Van Helper/Driver 6* Merchandiser - Wet Mkt 6* Merchandiser - SSG 11

54

** Admin Supvr/Officer 1* Biller 1* Clerk for Van/

Backup Biller* BookKeeper 1

3

* Warehouse Foreman 1- Clerk 1- Warehouseman 1

- Driver/Collector 4- Helper (Truck/Whse) 2- Motorpool Manager

p&l template 0908 aug bta

Documents