Sheet209.02.2015PLMNRNC_LBLUNG23GIP_JAMBU_AIR1413GIP_JAMBU_AIR12309198.9997.7398.8399.2999.480.002.130.600.4609.02.2015PLMNRNC_LBLUNG23GIP_JAMBU_AIR1413GIP_JAMBU_AIR22309299.55100.0098.9599.3999.520.002.130.470.4009.02.2015PLMNRNC_LBLUNG23GIP_JATI_TENGAH_TB23793GIP_JATI_TENGAH_TB12379199.4199.5999.1499.6399.660.983.550.330.3009.02.2015PLMNRNC_LBLUNG23GIP_JATI_TENGAH_TB23793GIP_JATI_TENGAH_TB32379399.47100.0099.3099.6899.720.371.550.300.2709.02.2015PLMNRNC_LBLUNG23GIP_JATI_TENGAH_TB23793GIP_JATI_TENGAH_TB22379298.69100.0098.3783.0589.570.003.180.480.4409.02.2015PLMNRNC_LBLUNG23GIP_KHATIB_SULAIMAN1183GIP_KHATIB_SULAIMAN32340399.57100.0099.2699.4599.530.892.270.740.6509.02.2015PLMNRNC_LBLUNG23GIP_KHATIB_SULAIMAN1183GIP_KHATIB_SULAIMAN12340199.82100.0099.3799.7499.851.323.100.680.6809.02.2015PLMNRNC_LBLUNG23GIP_KHATIB_SULAIMAN1183GIP_KHATIB_SULAIMAN22340299.41100.0098.7399.4799.540.002.030.700.6809.02.2015PLMNRNC_LBLUNG23GIP_KOMP_ARAI_PINANG1293GIP_KOMP_ARAI_PINANG22338299.80100.0099.6499.8599.830.005.250.230.2409.02.2015PLMNRNC_LBLUNG23GIP_KOMP_ARAI_PINANG1293GIP_KOMP_ARAI_PINANG32338399.92100.0089.5399.5399.620.007.370.320.3009.02.2015PLMNRNC_LBLUNG23GIP_KOMP_ARAI_PINANG1293GIP_KOMP_ARAI_PINANG12338199.40100.0088.6399.4899.620.008.120.510.4609.02.2015PLMNRNC_LBLUNG23GIP_KOMP_MEGA_PERMAI1373GIP_KOMP_MEGA_PERMAI32339399.69100.0098.7999.6999.730.001.870.280.2509.02.2015PLMNRNC_LBLUNG23GIP_KOMP_MEGA_PERMAI1373GIP_KOMP_MEGA_PERMAI12339199.38100.0099.1499.7099.714.493.720.460.4409.02.2015PLMNRNC_LBLUNG23GIP_KOMP_MEGA_PERMAI1373GIP_KOMP_MEGA_PERMAI22339299.72100.0099.4699.6999.740.002.820.360.3009.02.2015PLMNRNC_LBLUNG23GIP_KOTO_BARU1463GIP_KOTO_BARU32313399.6299.2699.2699.4098.950.002.380.660.5109.02.2015PLMNRNC_LBLUNG23GIP_KOTO_BARU1463GIP_KOTO_BARU12313199.61100.0098.9399.8699.200.003.090.270.2509.02.2015PLMNRNC_LBLUNG23GIP_KOTO_BARU1463GIP_KOTO_BARU22313299.87100.0099.7099.7599.170.332.840.270.2809.02.2015PLMNRNC_LBLUNG23GIP_KURANJI1213GIP_KURANJI22317299.73100.0099.4399.4199.530.652.710.300.9309.02.2015PLMNRNC_LBLUNG23GIP_KURANJI1213GIP_KURANJI32317395.39100.0087.1298.1099.0914.296.7415.228.0109.02.2015PLMNRNC_LBLUNG23GIP_KURANJI1213GIP_KURANJI12317199.28100.0098.7997.4597.770.001.800.671.4609.02.2015PLMNRNC_LBLUNG23GIP_LIKI_PONDOK1163GIP_LIKI_PONDOK12335199.21100.0098.6999.4799.430.763.070.320.3309.02.2015PLMNRNC_LBLUNG23GIP_LIKI_PONDOK1163GIP_LIKI_PONDOK22335299.64100.0097.4599.5699.690.006.330.440.3609.02.2015PLMNRNC_LBLUNG23GIP_LIKI_PONDOK1163GIP_LIKI_PONDOK32335399.2795.2199.0599.4699.620.843.240.700.5009.02.2015PLMNRNC_LBLUNG23GIP_LOLONG2303U_LOLONG1ZZZ230370.000.0099.6899.730.003.570.180.2109.02.2015PLMNRNC_LBLUNG23GIP_LOLONG23033GIP_LOLONG32303399.65100.0097.6499.5599.680.001.940.420.3309.02.2015PLMNRNC_LBLUNG23GIP_LOLONG23033GIP_LOLONG12303199.87100.0099.2299.7699.800.002.690.330.4009.02.2015PLMNRNC_LBLUNG23GIP_LOLONG23033GIP_LOLONG22303299.86100.0098.4699.7699.880.002.730.580.4809.02.2015PLMNRNC_LBLUNG23GIP_LOLONG2303U_LOLONG2ZZZ230380.000.0099.5599.740.002.130.360.3109.02.2015PLMNRNC_LBLUNG23GIP_LOLONG2303U_LOLONG3ZZZ230390.000.0099.6399.670.002.060.230.3509.02.2015PLMNRNC_LBLUNG23GIP_LUBUK_BEGALUNG1223GIP_LUBUK_BEGALUNG32318398.7699.5498.5692.6871.701.332.180.610.54

Sheet1Period start timePLMN nameRNC nameWBTS nameWBTS IDWCEL nameWCEL IDRRC CS_PSCSSR CSCSSR PS NRTHSDPA Resource Accessibility for NRT TrafficHSUPA Resource Accessibility for NRT TrafficCDR CSCDR PSCDR PS_HSDPACDR PS_HSUPASoft HO Success RateInter-Sys HHO SRIntra-Sys HHO SRAvg reported CQICell AvailabilityTotal CS traffic - ErlTRAFFIC PSTRAFFIC VOICETRAFFIC VIDEOPayload DL PS R99Payload UL PS R99HSDPA received dataHSUPA MAC-es DV at RNCActive HS-DSCH MAC-d throughput, network perspectivePayload UL PS HSDPAHSUPA active cell thpAvg HSDPA end usr thpInc SMS attRRC_CS_SRRRC_PS_SRHOSR_NEWSoft HO Success rate, RTSoft HO Success rate, NRTInter sys RT Hard HO SRInter sys NRT Hard HO SRCDR_PS_SESSIONCDR_R99_USRCDR_HSDPA_USRCDR_HSUPA_USRSSSR_PSSSSR_R99SSSR_HSDPASSSR_HSUPAIFHO SRRRC_CS_PSCSSR_CS_14RNC_576ERNC_605BRNC_913ACDR_CS_14CDR_PS_14CDR_PS_HSDPACDR_PS_HSUPARNC_195ARNC_169FRNC_168ARNC_706BRNC_183CRNC_280CTRAFFIC_PS_14TRAFFIC_VOICE_14TRAFFIC_VIDEO_14PAYLOAD_DL_PS_R99_14PAYLOAD_UL_PS_R99_14RNC_608CRNC_931CRNC_722BPAYLOAD_UL_PS_HSDPA_14RNC_1883BRNC_1879BRNC_5046ARRC_CS_SR_14RRC_PS_SR_14HOSR_14RNC_153BRNC_191BRNC_300GRNC_301ECDR_PS_SESSIONCDR_R99_USRCDR_HSDPA_USRCDR_HSUPA_USRSSSR_PSSSSR_R99SSSR_HSDPASSSR_HSUPARNC_2328A09.02.2015PLMNRNC_LBLUNG23G2IP_AIRTAWAR1143G2IP_AIRTAWAR52328599.75100.0099.5179.5747.040.406.090.320.3021.6898.005.65111,667.075.650.0024.093,693.738,097.3132,120.008,097.31490.951,057100.0099.7209.02.2015PLMNRNC_LBLUNG23G2IP_AIRTAWAR1143G2IP_AIRTAWAR12328198.95100.0098.6074.2740.991.664.340.420.5217.3698.0012.08187,077.0912.080.00833.907,615.5019,419.1561,962.1519,419.16113.96453100.0098.9209.02.2015PLMNRNC_LBLUNG23G2IP_AIRTAWAR1143G2IP_AIRTAWAR22328299.54100.0098.9977.7748.471.216.350.570.5119.0398.005.7880,777.585.780.0069.113,182.689,103.0011,339.149,103.00300.23455100.0099.5209.02.2015PLMNRNC_LBLUNG23G2IP_AIRTAWAR1143G2IP_AIRTAWAR32328399.28100.0091.0178.0750.480.0010.441.080.8119.0798.000.6531,463.310.650.0029.171,148.162,789.7081,177.112,789.71378.9372100.0099.2709.02.2015PLMNRNC_LBLUNG23G2IP_AIRTAWAR1143G2IP_AIRTAWAR62328697.36100.0096.7878.2345.490.005.850.800.6522.0398.004.1842,074.424.180.006.021,510.132,739.9071,736.632,739.91583.58411100.0097.2009.02.2015PLMNRNC_LBLUNG23G2IP_AIRTAWAR1143G2IP_AIRTAWAR42328498.5899.2298.3064.4738.470.673.630.360.3919.0298.0013.64197,341.1213.640.001,910.4910,313.1217,767.3582,170.2317,767.36104.862,15899.5298.5509.02.2015PLMNRNC_LBLUNG23G2IP_UNIVERSITAS_ANDALASXYX2305U_UNIVERSITAS_ANDALAS22305899.2498.4499.0288.0265.851.522.231.321.0314.02100.002.1897,399.862.180.00128.722,175.028,299.5701,845.078,299.57211.06278100.0099.2409.02.2015PLMNRNC_LBLUNG23G2IP_UNIVERSITAS_ANDALASXYX23053G2IP_UNIVERSITAS_ANDALAS6XYX2305699.82100.0096.7493.5585.420.004.140.260.2321.75100.003.84181,976.373.840.0046.601,603.4919,700.5202,283.0619,700.52120.89494100.0099.8109.02.2015PLMNRNC_LBLUNG23G2IP_UNIVERSITAS_ANDALASXYX2305U_UNIVERSITAS_ANDALAS12305798.9997.0698.7866.2957.460.001.321.251.0312.50100.0013.4574,200.6313.450.00356.363,259.1112,903.3801,237.5612,903.3818.8659998.0699.0009.02.2015PLMNRNC_LBLUNG23G2IP_UNIVERSITAS_ANDALASXYX2305U_UNIVERSITAS_ANDALAS32305998.05100.0097.7883.0368.510.654.320.630.6413.69100.007.44131,521.467.440.00432.183,794.8617,784.1641,581.9917,784.1657.60610100.0098.0309.02.2015PLMNRNC_LBLUNG23G2IP_UNIVERSITAS_ANDALASXYX23053G2IP_UNIVERSITAS_ANDALAS12305199.34100.0097.3391.2980.960.003.490.760.5620.68100.004.0674,196.924.060.00125.32898.349,620.0911,767.069,620.0987.63505100.0099.3309.02.2015PLMNRNC_LBLUNG23G2IP_UNIVERSITAS_ANDALASXYX23053G2IP_UNIVERSITAS_ANDALAS5XYX2305599.7296.9794.4594.1991.150.004.340.860.4118.26100.002.3141,019.122.310.0013.47513.862,743.6211,446.422,743.6296.73128100.0099.7209.02.2015PLMNRNC_LBLUNG23G2IP_UNIVERSITAS_ANDALASXYX23053G2IP_UNIVERSITAS_ANDALAS32305399.71100.0078.6293.6286.760.005.760.250.2120.13100.002.51187,190.022.510.0090.331,168.6018,169.7522,430.6418,169.75124.18245100.0099.7109.02.2015PLMNRNC_LBLUNG23G2IP_UNIVERSITAS_ANDALASXYX23053G2IP_UNIVERSITAS_ANDALAS4XYX2305499.74100.0097.4791.5381.170.353.080.620.4821.97100.007.1496,282.157.140.0089.081,238.8412,936.5961,948.0812,936.60105.53920100.0099.7209.02.2015PLMNRNC_LBLUNG23G2IP_UNIVERSITAS_ANDALASXYX23053G2IP_UNIVERSITAS_ANDALAS22305299.61100.0092.0093.5090.460.005.880.790.3018.29100.001.4027,570.161.400.0023.19159.242,109.9601,283.422,109.9667.3872100.0099.6009.02.2015PLMNRNC_LBLUNG23GIP_AIRPORT_PADANG1303GIP_AIRPORT_PADANG22315299.1599.0098.8599.5097.631.182.880.470.4117.22100.004.19160,226.814.190.001,047.041,469.0324,974.5802,200.0124,974.58235.5261399.3899.1409.02.2015PLMNRNC_LBLUNG23GIP_AIRPORT_PADANG1303GIP_AIRPORT_PADANG12315199.71100.0097.4899.1297.660.003.171.421.0817.61100.000.2033,031.480.200.0066.2787.193,481.5822,010.993,481.58612.2928100.0099.7109.02.2015PLMNRNC_LBLUNG23GIP_AIRPORT_PADANG1303GIP_AIRPORT_PADANG32315399.5998.1899.2699.7397.120.005.110.290.2819.96100.002.70214,292.452.700.00205.43767.0719,318.4683,412.8119,318.47503.6720098.1899.6209.02.2015PLMNRNC_LBLUNG23GIP_AIR_HANGAT1453GIP_AIR_HANGAT12310199.6896.9798.8782.7896.010.003.350.330.3020.88100.001.4962,656.611.490.00815.58550.437,002.8592,359.777,002.86839.4752696.9799.7209.02.2015PLMNRNC_LBLUNG23GIP_AIR_HANGAT1453GIP_AIR_HANGAT32310399.47100.0099.2781.6395.110.762.230.380.3519.14100.001.4288,026.371.420.001,058.711,201.788,434.6492,406.208,434.65733.691,073100.0099.4509.02.2015PLMNRNC_LBLUNG23GIP_AIR_HANGAT1453GIP_AIR_HANGAT22310299.31100.0098.4680.8096.140.003.030.770.8321.16100.005.06136,718.965.060.002,149.411,665.6017,404.5952,677.2917,404.60610.631,404100.0099.2909.02.2015PLMNRNC_LBLUNG23GIP_ANDURING2302U_ANDURING12302799.37100.0098.9990.7893.390.432.240.880.8412.69100.0020.32113,394.0620.320.00458.001,308.6319,355.5891,237.3419,355.5944.772,608100.0099.3509.02.2015PLMNRNC_LBLUNG23GIP_ANDURING23023GIP_ANDURING12302199.3499.8398.8493.8093.490.362.910.490.4618.98100.0011.32271,506.0011.320.00711.242,111.9028,661.8163,320.6528,661.82175.521,376100.0099.3209.02.2015PLMNRNC_LBLUNG23GIP_ANDURING23023GIP_ANDURING32302399.7399.1599.4297.7396.070.002.640.610.5118.67100.006.96111,944.006.960.00476.93845.0416,738.6682,215.6116,738.67345.231,00499.5099.7409.02.2015PLMNRNC_LBLUNG23GIP_ANDURING2302U_ANDURING22302899.0699.6498.6696.6194.360.991.830.870.7212.99100.0011.8672,636.0511.860.00585.491,391.1913,873.146978.5113,873.1581.31637100.0099.0409.02.2015PLMNRNC_LBLUNG23GIP_ANDURING23023GIP_ANDURING22302299.2499.7298.7596.3993.440.292.381.000.7717.52100.009.96134,126.339.960.00525.561,998.3517,364.8182,068.5017,364.82226.25597100.0099.2209.02.2015PLMNRNC_LBLUNG23GIP_ANDURING2302U_ANDURING32302999.7599.7198.8297.7096.010.002.330.470.4416.49100.0010.6868,633.0210.680.00356.45532.8410,159.3171,678.2210,159.32280.391,320100.0099.7309.02.2015PLMNRNC_LBLUNG23GIP_AUR_KUNING2301U_AUR_KUNING32301997.0098.9753.0388.9980.672.514.691.371.7611.42100.0022.1897,317.9822.180.00810.553,886.1722,702.301939.2122,702.3025.193,03099.5496.9709.02.2015PLMNRNC_LBLUNG23GIP_AUR_KUNING23013GIP_AUR_KUNING22301299.4097.8698.9298.3886.142.352.891.521.4516.69100.005.41181,976.445.410.00858.663,331.7424,297.6032,160.1224,297.6099.4692699.3099.4109.02.2015PLMNRNC_LBLUNG23GIP_AUR_KUNING23013GIP_AUR_KUNING32301399.4499.1981.2794.3483.420.523.190.960.7416.27100.005.89216,671.655.890.001,155.214,569.3528,864.3712,293.1928,864.3772.2659299.4499.4409.02.2015PLMNRNC_LBLUNG23GIP_AUR_KUNING23013GIP_AUR_KUNING12301199.3199.3998.5798.2780.460.003.760.750.6219.84100.004.11258,285.434.110.00316.992,418.2322,016.8093,345.9322,016.81204.431,02899.3999.3109.02.2015PLMNRNC_LBLUNG23GIP_AUR_KUNING2301U_AUR_KUNING12301799.4098.8998.4498.1182.502.002.422.091.4415.91100.0012.08103,261.0712.080.00441.112,246.5713,076.9801,509.6313,076.98124.651,844100.0099.3809.02.2015PLMNRNC_LBLUNG23GIP_AUR_KUNING2301U_AUR_KUNING22301899.6797.6298.1998.1284.540.523.111.092.5617.59100.003.6198,624.203.610.00311.781,021.569,186.3092,236.439,186.31385.86717100.0099.6609.02.2015PLMNRNC_LBLUNG23GIP_BAITURRAHMAN1343GIP_BAITURRAHMAN32330399.40100.0097.2999.5594.351.283.210.820.7720.06100.006.95134,706.596.950.00140.65377.9214,097.1932,949.4814,097.19475.23426100.0099.3809.02.2015PLMNRNC_LBLUNG23GIP_BAITURRAHMAN1343GIP_BAITURRAHMAN22330299.46100.0097.2899.5796.722.024.080.720.4918.12100.003.03140,965.783.030.00228.071,469.9717,996.7922,431.9217,996.79334.8999100.0099.4609.02.2015PLMNRNC_LBLUNG23GIP_BAITURRAHMAN1343GIP_BAITURRAHMAN12330199.57100.0098.3399.5895.720.003.970.320.3120.55100.004.31240,896.404.310.00171.22852.8525,359.9553,668.5825,359.95269.42202100.0099.5609.02.2015PLMNRNC_LBLUNG23GIP_BUKIT_TINGGI_PLAZA_ST23003GIP_BUKIT_TINGGI_PLAZA22300298.8499.1798.3499.2399.400.002.521.200.9518.42100.002.99106,701.112.990.00226.00696.2112,058.2202,195.0812,058.22412.1836599.1798.8409.02.2015PLMNRNC_LBLUNG23GIP_BUKIT_TINGGI_PLAZA_ST23003GIP_BUKIT_TINGGI_PLAZA32300399.2699.2089.1099.4199.601.674.150.520.4420.17100.002.6671,269.412.660.00177.24184.228,852.4572,476.948,852.46596.12234100.0099.2509.02.2015PLMNRNC_LBLUNG23GIP_BUKIT_TINGGI_PLAZA_ST23003GIP_BUKIT_TINGGI_PLAZA12300199.1899.5998.7499.5898.900.002.200.400.3917.22100.002.04150,963.612.040.00404.261,112.7419,971.8322,417.0019,971.83220.08498100.0099.1709.02.2015PLMNRNC_LBLUNG23GIP_BYPASS1383GIP_BYPASS12346199.51100.0099.1399.3399.511.832.750.710.5219.64100.002.9662,183.972.960.00155.40381.4112,308.7642,109.0912,308.76964.20550100.0099.5009.02.2015PLMNRNC_LBLUNG23GIP_BYPASS1383GIP_BYPASS22346299.70100.0097.7099.6899.743.973.760.810.7424.26100.002.9949,163.522.990.0088.11280.036,808.2112,611.616,808.211,283.11314100.0099.6909.02.2015PLMNRNC_LBLUNG23GIP_BYPASS1383GIP_BYPASS32346398.82100.0096.4699.3999.460.003.951.060.8220.23100.001.8239,121.701.820.0063.72262.584,079.4491,831.414,079.451,007.87317100.0098.7809.02.2015PLMNRNC_LBLUNG23GIP_CENGKEH_PADANG1263GIP_CENGKEH_PADANG32327398.8899.3398.5499.4299.400.682.600.800.6317.39100.001.68150,219.031.680.00658.171,972.7622,751.5332,181.1222,751.53212.07311100.0098.8609.02.2015PLMNRNC_LBLUNG23GIP_CENGKEH_PADANG1263GIP_CENGKEH_PADANG22327299.66100.0099.2099.5399.511.473.220.520.4918.48100.001.22174,269.611.220.00272.17944.2917,305.8112,683.1617,305.81278.70264100.0099.6609.02.2015PLMNRNC_LBLUNG23GIP_CENGKEH_PADANG1263GIP_CENGKEH_PADANG12327199.5299.0499.2799.4199.472.021.850.490.4318.29100.002.82125,968.132.820.00239.20297.0318,028.7102,247.6118,028.71300.53532100.0099.5109.02.2015PLMNRNC_LBLUNG23GIP_GADUT1393GIP_GADUT32307399.41100.0099.0499.4499.150.353.430.450.3918.7899.787.42243,043.117.420.00336.692,494.7525,028.3493,120.2725,028.35244.711,366100.0099.4009.02.2015PLMNRNC_LBLUNG23GIP_GADUT1393GIP_GADUT22307299.60100.0099.3099.5899.510.823.700.290.3220.0399.781.38204,874.881.380.00187.56329.0222,265.1973,144.3422,265.20356.23182100.0099.5909.02.2015PLMNRNC_LBLUNG23GIP_GADUT1393GIP_GADUT12307199.6098.9795.1299.2999.560.003.910.720.5020.7999.772.5771,358.072.570.0026.5579.606,141.4982,823.846,141.50705.04289100.0099.5809.02.2015PLMNRNC_LBLUNG23GIP_GUGUK_RANDAH1433GIP_GUGUK_RANDAH22314299.6197.0699.3699.6799.720.002.810.630.5319.73100.001.00162,993.241.000.00311.95994.5115,562.5662,841.4015,562.57432.5846498.2199.6209.02.2015PLMNRNC_LBLUNG23GIP_GUGUK_RANDAH1433GIP_GUGUK_RANDAH12314199.40100.0098.9299.4699.561.382.390.730.5919.15100.001.54106,955.531.540.00170.04498.9912,450.6762,373.6212,450.68478.59318100.0099.3909.02.2015PLMNRNC_LBLUNG23GIP_GUGUK_RANDAH1433GIP_GUGUK_RANDAH32314399.4496.8898.9599.0799.230.001.940.470.3621.24100.000.5987,178.220.590.0048.08107.526,488.5813,286.236,488.58907.0555696.8899.4909.02.2015PLMNRNC_LBLUNG23GIP_G_SPORT_CENTER23593GIP_G_SPORT_CENTER32341399.7298.9299.2798.8798.891.232.660.400.4418.89100.000.76159,796.560.760.00257.331,460.9710,381.5072,695.8610,381.51543.88132100.0099.7109.02.2015PLMNRNC_LBLUNG23GIP_G_SPORT_CENTER23593GIP_G_SPORT_CENTER22341299.7697.5699.4198.6198.570.001.990.700.8019.07100.001.1091,808.471.100.00129.75283.7814,602.8112,234.5314,602.81607.878497.5699.7909.02.2015PLMNRNC_LBLUNG23GIP_G_SPORT_CENTER23593GIP_G_SPORT_CENTER12341199.5098.8892.7498.7199.091.302.690.460.3919.28100.001.3247,197.181.320.00126.43242.126,165.4181,991.236,165.42576.50337100.0099.4909.02.2015PLMNRNC_LBLUNG23GIP_HOTEL_HAYAMWURUK1173GIP_HOTEL_HAYAMWURUK22337299.4599.5598.8299.5699.690.003.380.460.3718.22100.003.4374,285.523.430.00149.85291.7011,042.6162,211.6511,042.62699.28332100.0099.4309.02.2015PLMNRNC_LBLUNG23GIP_HOTEL_HAYAMWURUK1173GIP_HOTEL_HAYAMWURUK12337198.7799.5194.7199.1799.380.583.730.670.4621.02100.004.2259,017.314.220.00121.07276.459,451.6842,253.369,451.68770.27158100.0098.7409.02.2015PLMNRNC_LBLUNG23GIP_HOTEL_HAYAMWURUK1173GIP_HOTEL_HAYAMWURUK32337399.83100.0098.4899.7899.830.003.470.270.2721.27100.002.61109,305.962.610.0068.76379.789,932.3122,972.299,932.31901.97117100.0099.8309.02.2015PLMNRNC_LBLUNG23GIP_JAMBU_AIR1413GIP_JAMBU_AIR32309399.67100.0099.4299.3399.470.003.620.510.4720.81100.000.5694,435.090.560.0067.7693.518,996.1323,044.788,996.131,000.74143100.0099.6609.02.2015PLMNRNC_LBLUNG23GIP_JAMBU_AIR1413GIP_JAMBU_AIR12309198.9997.7398.8399.2999.480.002.130.600.4618.74100.002.47128,496.302.470.00301.69695.8014,609.1882,651.7214,609.19592.0251197.7399.01

THR SIMPELPERHITUNGAN PPh PASAL 21 ATAS THR 2013sesuai PER-31/PJ/2012* diisi/diganti kolom warna biru ya ..PERHITUNGAN SEMUA PENGHASILANPERHITUNGAN TANPA THRPenghasilan Bulan Ini$10,000,000Penghasilan Bulan Ini$10,000,000Penghasilan Disetahunkan$120,000,000Penghasilan Disetahunkan$120,000,000THR$15,000,000THR0.0Status TanggunganStatus TanggunganK/2$30,375,000K/2$30,375,000PerhitunganPerhitunganPenghasilan Bruto$135,000,000Penghasilan Bruto$120,000,000Biaya JabatanBiaya Jabatan5% atau max 6jt$6,000,0005% atau max 6jt$6,000,000Penghasilan Netto$129,000,000Penghasilan Netto$114,000,000PTKP$30,375,000PTKP$30,375,000PKP$98,625,000PKP$83,625,000PPh TerutangPPh Terutang5%x$50,000,000$2,500,0005%x$50,000,000$2,500,00015%x$48,625,000$7,293,75015%x$33,625,000$5,043,75025%x0.00.025%x0.00.030%x0.00.030%x0.00.0(a)$9,793,750(b)$7,543,750PPh Pasal 21 atas THR(a)-(b)=PPh THR$9,793,750-$7,543,750=$2,250,000Penghasilan Tidak Kena Pajak (PTKP), mulai 1 Januari 2013STATUSSETAHUNPENGERTIANTK/024,300,000Tidak menikah tanpa tanggunganTK/126,325,000Tidak menikah dengan 1 tanggunganK/026,325,000Menikah tanpa tanggunganTK/228,350,000Tidak menikah dengan 2 tanggunganK/128,350,000Menikah dengan 1 tanggunganTK/330,375,000Tidak menikah dengan 3 tanggunganK/230,375,000Menikah dengan 2 tanggunganK/332,400,000Menikah dengan 3 tanggunganTarif Pasal 17 UU PPh, mulai berlaku sejak Tahun 2009PENGHASILAN KENA PAJAKTARIF NPWPTARIF NON NPWP0 - 50.000.0005%6%>50.000.000 - 250.000.00015%18%>250.000.000 - 500.000.00025%30%>500.000.00030%36%