CAPEX REVENUE COLLECTION REPORT2017 Q 4 Report by
CAPEX REVENUE & COLLECTION REPORT_2017 Q 4 Report by: FHEY L. POLIZON 27
MONTHLY % COLLECTED TRANSACTIONS_2017 AIR FREIGHT JANUARY 100% FEBRUARY 100% MARCH 99% APRIL 100% MAY 100% JUNE 100% JULY 98% AUGUST 99% SEPTEMBER OCTOBER NOVEMBER DECEMBER TOTAL 98% 94% 83% 52% 93% SEA FREIGHT JANUARY 100% FEBRUARY 100% MARCH 100% APRIL 100% MAY 99% JUNE 99% JULY 98% AUGUST 99% SEPTEMBER 97% OCTOBER 93% NOVEMBER 81% DECEMBER 36% TOTAL 91%
BRANCHES SALES RECIEVABLES_2017
CAPEX COMULATIVE RECIEVABLES_2017 ST-RECIEVABLES 6, 646, 094. 91 AT-RECIEVABLES 15, 751, 183. 93 TOTAL RECIEVABLES 22, 397, 278. 84 INTRANSIT 1, 969, 441. 39 FOR BILLING 1, 048, 627. 61 FOR POSTING 569, 934. 24 PDC 598, 510. 75 TOTAL RECIEVABLES 18, 210, 763. 85
TOP 10 BRANCHES WITH HIGHEST DEPOSIT FOR THE MONTH OF DECEMBER_2017 MANILA CEBU DAVAO BACOLOD ZAMBOANGA ILO-ILO BUTUAN CAGAYAN DE ORO TACLOBAN PALAWAN
TOP 10 ACCOUNT WITH HIGHEST CONTRIBUTION FOR MONTH OF DECEMBER_2017 MANILA ACCOUNTS OPPO PHIL UTECH IRIIUM B GRUPPO INNOVARE MARSMAN COGNETICS UBIC EA GLOBAL COSMIC HLN TOTAL COLLECTION 3, 039, 277. 62 999, 010. 52 663, 368. 44 352, 217. 93 289, 382. 76 272, 968. 04 246, 009. 13 245, 809. 32 212, 303. 52 144, 076. 42
TOP 10 ACCOUNT WITH HIGHEST CONTRIBUTION FOR MONTH OF DECEMBER_2017 BRANCHES ACCOUNT RULLS (CEB) AMR (BXU) NG KHAI (CEB) A&M MEDCARE (BCD) NEW DATCHE (CEB) NEOMED(ZAM) CELLPOD (CEB) JEHU (CEB) GALLEON (BCD) FIL JAP (CEB) TOTAL COLLECTION 655, 410. 77 217, 353. 58 159, 620. 79 137, 767. 06 134, 447. 15 131, 614. 84 65, 971. 55 53, 234. 42 37, 578. 22 32, 929. 22
ITERINARY AUDIT JANUARY- FEBRUARY_2018 BRANCHES CEBU DUMAGUETE TAGBILARAN AUDITOR DATE FE /RODOLFO 2 ND WEEK JANUARY ROXAS ILO-ILO BACOLOD DAVE VILLAMOR 3 RD WEEK JANUARY DAVAO GENSAN CAGAYAN BUTUAN RODOLFO, RECIO 4 TH WEEK JANUARY ZAMBOANGA DIPOLOG OZAMIS NENE ESTRELLA TACLOBAN PALAWAN FE 1 ST WEEK OF FEB ? ? ?
REVENUE CHALENGES: MISS ROUTED/MISSING AND DAMAGE/OFF LOADED CARGOES SHORT REMMITANCE- CRATING WITHOUT INFORMING CLIENTS WEEKLY BASIS/REGULAR CLIENT WITH TERMS WITHOUT PROPER DOC’S MISS HANDLING OF DELIVERY RECIEPT CONSOLIDATION OF SOA BRANCHES DID NOT USE CTRACK MOBILE TURN OVER TO NEW INCHARGE-PROCESS OF INVOICES RELEASED OF BULK CARGO WITHOUT NOTIFYING REVENUE COLLECTION CHANGE MOVEMENT/REJECTED AIRLINES REVENUE OUTLOOK FOR Q 1: TARGET COLLECTION JANUARY 26 M / WEEKLY 6 M AGING TRANSACTION MINIMIZED IMPOSED INTEREST PER MONTH- C/O MR. MAGTANONG STRICLTY COD TRANSACTION QUARTERLY AUDIT
- Slides: 9