CPWD Circular regarding factor to be adopted for GST when GST is 18% and CP is 15%

[RambabuJalli-SDE(C)]

Dear dbSoft user,

Please find herewith attached circular on the subject. This circular is not applicable to BSNL internal works because the CP is 10% only. 

Then what should be the factor ?

If you remember I have already posted the calculations. Once again for you.

What we should adopt for 18% GST and 10% CP & OH is as follows :

Let the Total amount worked out after 1% water charges : W

Let the multiplying factor for GST : f

Total after Water charges              :   w

Add GST  amount                         :   f x w      ... ..................... (Fig A)

Total after GST                   :  w  +  fw

Add CP & OH @ 10%          : 0.10 (w + fw)

Amount after CP & OH       : 1.10 (w+fw)

(Which is inclusive of GST)

GST = 18%

GST applicable amount  : 1.10 (w+ fw)/1.18    (Reverse calculation)

GST amount                    : 0.18 x 1.10 (w +fw)/1.18      which is equal to figure A above

f x w = 0.18 x 1.10 / 1.18 x w(1 + f)

or

f=0.1678 (1+f)

f-0.1678f=0.1678

0.8322f = 0.1678

f= 0.1678/0.8322

f=0.2016

So, instead of 0.2127 we have to adopt 0.2016 for BSNL internal works.

regards.

Rambabu Jalli

SDE(C)-Nalgonda

Telangana

 

[Sudheer Agrawal]

Sir,

PFA excel sheet for the same.

Sudheer Agrawal,

SDE(C), Dehradun

--
Dear dbSoft user! You received this message because you are a member of dbSoft-User Group! If you do not want to receive from the group you can send a mail to the Moderator at rambab...@gmail.com
---
You received this message because you are subscribed to the Google Groups "dbSoft-Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dbsoft-users+unsubscribe@googlegroups.com.
To post to this group, send email to dbsoft...@googlegroups.com.
Visit this group at https://groups.google.com/group/dbsoft-users.
For more options, visit https://groups.google.com/d/optout.

[Shaligram Patil]

Dear Sir,

Thanks for forwarding the excel sheet for GST coefficient,

but The excel sheet is passward protected.

Is is possible to send the same without password protection.

(Shri Shaligram Tryambak Patil),

Assistant Engineer ( Civil ),

Postal Civil Sub Division,

Coimbatore-641022

[Sudheer Agrawal]

Password 11

To unsubscribe from this group and stop receiving emails from it, send an email to dbsoft-users...@googlegroups.com.

To post to this group, send email to dbsoft...@googlegroups.com.
Visit this group at https://groups.google.com/group/dbsoft-users.
For more options, visit https://groups.google.com/d/optout.

--
Dear dbSoft user! You received this message because you are a member of dbSoft-User Group! If you do not want to receive from the group you can send a mail to the Moderator at rambab...@gmail.com
---
You received this message because you are subscribed to the Google Groups "dbSoft-Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to dbsoft-users...@googlegroups.com.

To post to this group, send email to dbsoft...@googlegroups.com.
Visit this group at https://groups.google.com/group/dbsoft-users.
For more options, visit https://groups.google.com/d/optout.

--
Dear dbSoft user! You received this message because you are a member of dbSoft-User Group! If you do not want to receive from the group you can send a mail to the Moderator at rambab...@gmail.com
---
You received this message because you are subscribed to the Google Groups "dbSoft-Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to dbsoft-users...@googlegroups.com.

[Nurul Haque]

GST factors calculation in Excel sheet for CP-15 & GST-12, CP-15 & GST-18,  CP-10 & GST-12 and  CP-10 & GST-18. in separate sheets

Password 11

To unsubscribe from this group and stop receiving emails from it, send an email to dbsoft-users+unsubscribe@googlegroups.com.

To post to this group, send email to dbsoft...@googlegroups.com.
Visit this group at https://groups.google.com/group/dbsoft-users.
For more options, visit https://groups.google.com/d/optout.

--
Dear dbSoft user! You received this message because you are a member of dbSoft-User Group! If you do not want to receive from the group you can send a mail to the Moderator at rambab...@gmail.com
---
You received this message because you are subscribed to the Google Groups "dbSoft-Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to dbsoft-users+unsubscribe@googlegroups.com.

To post to this group, send email to dbsoft...@googlegroups.com.
Visit this group at https://groups.google.com/group/dbsoft-users.
For more options, visit https://groups.google.com/d/optout.

--
Dear dbSoft user! You received this message because you are a member of dbSoft-User Group! If you do not want to receive from the group you can send a mail to the Moderator at rambab...@gmail.com
---
You received this message because you are subscribed to the Google Groups "dbSoft-Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to dbsoft-users+unsubscribe@googlegroups.com.

To post to this group, send email to dbsoft...@googlegroups.com.
Visit this group at https://groups.google.com/group/dbsoft-users.
For more options, visit https://groups.google.com/d/optout.

--
Dear dbSoft user! You received this message because you are a member of dbSoft-User Group! If you do not want to receive from the group you can send a mail to the Moderator at rambab...@gmail.com
---
You received this message because you are subscribed to the Google Groups "dbSoft-Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to dbsoft-users+unsubscribe@googlegroups.com.

[Rambabu Jalli]

Dear All,

Please find attached herewith an Excel file in which the formula which is adopted by dbSoft to calculate the factor is given. 

with regards,

Rambabu Jalli

Sub-Divisional Engineer (Civil)

BSNL Civil Sub-Division

Nalgonda - Telangana State

Mobile No. +91 9490 144 900