ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
DATABUILD-UPPILOT TESTING
2
PSIC SUBCLASS CODEPSIC SUBCLASSSETUP OF FEES
(e.g. Business Tax New, Business Tax Essential, Business Tax Non-essential, Mayor's Permit Fee, Sanitary Permit Fee)		Computation
X=(basis/capital/gross income/etc.)		TYPE OF COMPUTATION (Constant/Formula/Range/ Monthly/Measure&Pax)SETUP STATUS (Complete/Incomplete)NEW
(Done)		RENEW
(Done)
3
1AGRICULTURAL PRODUCTComplete
4
Business Tax (Essential)
1-400K, X*.02
400000.01-9999999999999999=(X*.01)+8000		Formula
5
Solid Waste Management1-100k - 720, 500k - 2000, 5M - 3000, 20M - 3500, 999999999999999 - 4500Range
6
Mayor's Permit Fee
1-10k, =100
25k, 300 , 50k, - 500 ,75k- 750 , 100k-1000, 125k - 1250, 150k - 1500, 175k- 1750, 200k - 2000, 225k - 2250, 250k - 2500, 275k - 2750, 300k - 3000, 350k - 3250, 400k - 3500, 450k - 4000, 500k - 5000, 3,000,000-9999999999999999 - ((X-3000000)*.01)+5000		Range
7
Inspection Fee1-50sqm - 100, 100sqm- 150,200sqm - 200, 500sqm - 250, 1000sqm - 300, 9999999999999 - 500 Range
8
Sanitary Permit Fee200Constant
9
Tax Clearance150Constant
10
11
AG01VEGETABLE VENDORWeight and Measures
1-30= 200
30.01-300=380
300.01-3000=950
3000.01-99999999=1600
Rangecompletedonedone
12
FRUIT VENDORcompletedonedone
13
ROOT CROP VENDORcompletedonedone
14
TOBACCO VENDORcompletedonedone
15
BALUT VENDORcompletedonedone
16
SNACKScompletedonedone
17
BURGER JUNCTIONcompletedonedone
18
SUGARCANE VENDORcompletedonedone
19
COCONUT VENDORcompletedonedone
20
LECHON MANOK VENDORcompletedonedone
21
POULTRYcompletedonedone
22
RYE VENDORcompletedonedone
23
BARBECUE VENDORcompletedonedone
24
FLOWER VENDORcompletedonedone
25
FISH VENDORcompletedonedone
26
FROZEN PRODUCTcompletedonedone
27
DRIED FISH VENDORcompletedonedone
28
MEAT VENDORcompletedonedone
29
STREET FOOD VENDORcompletedonedone
30
LECHON DEALERcompletedonedone
31
RICE/CORN VENDORcompletedonedone
32
WHEAT VENDORcompletedonedone
33
LIVESTOCK BUYERcompletedonedone
34
HAY VENDORcompletedonedone
35
FRIED CHICKEN VENDORcompletedonedone
36
FRUIT VENDORcompletedonedone
37
ROOT CROP VENDORcompletedonedone
38
3AMUSEMENT PLACESCapitalization (New)
39
Business Tax (Essential)
1-400K, X*.02
400000.01-9999999999999999=(X*.01)+8000
40
Solid Waste Management1-100k - 720, 500k - 2000, 5M - 3000, 20M - 3500, 999999999999999 - 4500RANGE
41
Mayor's Permit Fee
1-10k, =100
25k, 300 , 50k, - 500 ,75k- 750 , 100k-1000, 125k - 1250, 150k - 1500, 175k- 1750, 200k - 2000, 225k - 2250, 250k - 2500, 275k - 2750, 300k - 3000, 350k - 3250, 400k - 3500, 450k - 4000, 500k - 5000, 3,000,000-9999999999999999 - ((X-3000000)*.01)+5000
42
Inspection Fee1-50sqm - 100, 100sqm- 150,200sqm - 200, 500sqm - 250, 1000sqm - 300, 9999999999999 - 500
43
Sanitary Permit Fee200
44
Tax Clearance150
45
COCKPIT ARENASolid Waste Management1-100k - 1500, 500k - 2000, 5M - 3000, 20M - 4500, 999999999999999 - 6000RANGEcompletedonedone
46
4BANKS & OTHER FINANCIAL INSTITUTIONCapitalization (New)
47
Business Tax (Essential)
1-400K, X*.02
400000.01-9999999999999999=(X*.01)+8000
48
Solid Waste Management1-100k - 1500, 500k - 2000, 5M - 3000, 20M - 4500, 999999999999999 - 6000RANGE
49
Mayor's Permit Fee
1-10k, =100
25k, 300 , 50k, - 500 ,75k- 750 , 100k-1000, 125k - 1250, 150k - 1500, 175k- 1750, 200k - 2000, 225k - 2250, 250k - 2500, 275k - 2750, 300k - 3000, 350k - 3250, 400k - 3500, 450k - 4000, 500k - 5000, 3,000,000-9999999999999999 - ((X-3000000)*.01)+5000
50
Inspection Fee1-50sqm - 100, 100sqm- 150,200sqm - 200, 500sqm - 250, 1000sqm - 300, 9999999999999 - 500
51
Sanitary Permit Fee200
52
Tax Clearance150
53
PAWNSHOPcompletedonedone
54
LENDING INVESTORcompletedonedone
55
FINANCE & INVESTMENT COMPANIEScompletedonedone
56
5BARBusiness Tax (Essential)
1-400K, X*.02
400000.01-9999999999999999=(X*.01)+8000		Formulacompletedonedone
57
Solid Waste Management1-100k - 720, 500k - 2000, 5M - 3000, 20M - 3500, 999999999999999 - 4500Range
58
Mayor's Permit Fee
1-10k, =100
25k, 300 , 50k, - 500 ,75k- 750 , 100k-1000, 125k - 1250, 150k - 1500, 175k- 1750, 200k - 2000, 225k - 2250, 250k - 2500, 275k - 2750, 300k - 3000, 350k - 3250, 400k - 3500, 450k - 4000, 500k - 5000, 3,000,000-9999999999999999 - ((X-3000000)*.01)+5000		Range
59
Inspection Fee1-50sqm - 100, 100sqm- 150,200sqm - 200, 500sqm - 250, 1000sqm - 300, 9999999999999 - 500 Range
60
Sanitary Permit Fee200Constant
61
Tax Clearance150Constant
62
6BUSINESS AGENTBusiness Tax (Essential)
1-400K, X*.02
400000.01-9999999999999999=(X*.01)+8000		Formulacompletedonedone
63
Solid Waste Management1-100k - 720, 500k - 2000, 5M - 3000, 20M - 3500, 999999999999999 - 4500Range
64
Mayor's Permit Fee
1-10k, =100
25k, 300 , 50k, - 500 ,75k- 750 , 100k-1000, 125k - 1250, 150k - 1500, 175k- 1750, 200k - 2000, 225k - 2250, 250k - 2500, 275k - 2750, 300k - 3000, 350k - 3250, 400k - 3500, 450k - 4000, 500k - 5000, 3,000,000-9999999999999999 - ((X-3000000)*.01)+5000		Range
65
Inspection Fee1-50sqm - 100, 100sqm- 150,200sqm - 200, 500sqm - 250, 1000sqm - 300, 9999999999999 - 500 Range
66
Sanitary Permit Fee200Constant
67
Tax Clearance150Constant
68
7CONTRACTORBusiness Tax (Essential)
1-5K - 27.50, 5001-10K - 61.60, 10001-15K -104.50,15001-20K-165,20001-30K-275,30001-40K-385,40001-50K-550, 50001-75K-880, 75001-100K-1320,100001-150K-1980, 150001-200K- 2640, 200001-250K-3630, 250001-300K-4620, 300001-400K-6160, 400001-500K-8250, 500001-750K - 9250,750001-1M - 10,250,1000001-2M -11500, 2000001-9999999999999 -((X-2000000)*.005)+11500Range
69
Solid Waste Management1-100k - 1500, 500k - 2000, 5M - 3000, 20M - 4500, 999999999999999 - 6000Range
70
Mayor's Permit Fee
1-10k, =100
25k, 300 , 50k, - 500 ,75k- 750 , 100k-1000, 125k - 1250, 150k - 1500, 175k- 1750, 200k - 2000, 225k - 2250, 250k - 2500, 275k - 2750, 300k - 3000, 350k - 3250, 400k - 3500, 450k - 4000, 500k - 5000, 3,000,000-9999999999999999 - ((X-3000000)*.01)+5000		Range
71
Inspection Fee1-50sqm - 100, 100sqm- 150,200sqm - 200, 500sqm - 250, 1000sqm - 300, 9999999999999 - 500 Range
72
Sanitary Permit Fee200Constant
73
Tax Clearance150Constant
74
CATERING SERVICEScompletedonedone
75
LANDSCAPEcompletedonedone
76
BARANGAY ELECTRICIANcompletedonedone
77
HOLLOW BLOCK MAKERcompletedonedone
78
PROPRIETOR OR OPERATOR OF MINE DRILLING APPARATUS
completedonedone
79
PROPRIETOR OR OPERATOR OF DOCKYARDS
completedonedone
80
PROPRIETOR OR OPERATOR OF SMELTING PLANTS, ENGRAVING & PLATING
completedonedone
81
PROPRIETOR OR OPERATOR OF ESTABLISHMENTS FOR REPAIRING, REPAINTING & UPHOLSTERING
completedonedone
82
PROPRIETOR OR OPERATORS OF FURNITURE SHOPS
completedonedone
83
PROPRIETOR OR OPERATORS OF DRY CLEANING OR DYEING ESTABLISHMENTS
completedonedone
84
PROPRIETOR OR OPERATORS OF TAILOR SHOPS
completedonedone
85
PROPRIETOR OR OWNERS OF ESTABLISHMENTS OR LOTS FOR PARKING PURPOSES
completedonedone
86
PROPRIETOR OR OWNERS OF SHOPS FOR THE REPAIR OF ANY KIND OF MECHANICAL AND ELECTRICAL DEVICES, INSTRUMENTS, APPARATUS, AND FURNITURE
completedonedone
87
PROPRIETORS OR OPERATORS OF ARRASTRE AND STEVEDORING, WAREHOUSING, OR FORWARDING ESTABLISHMENTS
completedonedone
88
PERSONS ENGAGED IN THE INSTALLATION OF WATER SYSTEM, GAS OR ELECTRIC LIGHT, HEAT AND POWER
completedonedone
89
PROPRIETORS OR OPERATORS OF SMELTING PLANTS, ENGRAVING & PLATING.
completedonedone
90
PLASTIC LAMINATION ESTABLISHMENTScompletedonedone
91
WASHING OR GREASING OF VEHICLES AND HEAVY EQUIPMENT.
completedonedone
92
STEAM LAUNDRIES AND LAUNDRIES USING WASHING MACHINE
completedonedone
93
VULCANIZING SHOPcompletedonedone
94
RECAPPING AND BATTERY CHARGINGcompletedonedone
95
ESTABLISHMENTS FOR PLANING OR SURFACING AND RE CUTTING OF LUMBER, SAWMILLS UNDER CONTRACT TO SAW OR CUT LOGS BELONGING TO OTHERS.
completedonedone
96
97
DRESS SHOPScompletedonedone
98
MILLINERS AND HATTERScompletedonedone
99
BEAUTY PARLORScompletedonedone
100
BARBERSHOPScompletedonedone