Master Progress Billing for Construction Sample for Production with Ease

Progress billing for construction sample for Production

[Music] foreign [Music] s greeting of the days hope you are all doing good this time I would like to share progress payment open power supply for free commissioning works in the construction projects in the oil and gas bill so it is common in construction projects when the project is nearing the end or when the project approaching pre-commissioning the main contractor or client is really asks the contractor for assisting pre-commissioning works the supply and power of all civil mechanical seal structures and piping work or Supply material consumable construction equipment tool supply of experts and others in connection with Supply Manpower for assisting pre-commissioning mechanical works it's time I will discuss how to devise a complete manually progress payment for supply and power work for existing pre-commissioning mechanical works this progress template is consists of three worksheets starting from daily main hour records where the manhowers are recorded daily and then some remain hours and monthly payments data is taken from daily Min hours and then multiply with the red red uni rate per for normalcy over time and Sunday holiday works and then the last one is monthly payments certificates for your information each section in this templates are has been integrated with the formulation they are in so you only need to monthly input the start and finish or in the section with the blue colors here yes you only need to manually input the start and finish when hours all data will be built in and migrate to each section automatically okay let me discuss it more deeply let me back again soon daily main hour record okay in this section in Daily main hour records any project name job number contractor period this is cut off a reporting variant and in this table any orderly number name position period okay this template records when hours for a month depending on the card update reporting Azure project Nation okay as I explained in the earlier that we only need to input manually the working hour when stuck and when finished okay also as I explained before all section and all cells in this daily menomorical tables has been equipped with the formulation they're in so you only need to input manually in the blue colors here yes in the all blue colored here okay total working hour will be automatically uh B fields and immediately reduce the breed time usually one hour for example the break time here is start from uh 12 at noon till 13. it's been one hour break time okay furthermore yes if the difficult word is same and sorry SP in this section means Standard Time yes okay okay uh furthermore it will be difficult if the difficult works is safe then Standard time will be automatically uh will be automatically B fields in the zip section and but if the standard time is normal not seen the standard time will be built in the normal section yes okay and for over time hour four over time hour outside the standard time or say the science time and if it actually differs one hours over time years okay the overtime will move to the next section here okay okay furthermore for holiday and Sunday for example years I type it with I type it with the red color means holiday yes for uh for a holiday yeah for holidays and sunny all over time hours we will be filled automatically into this holiday section yes into this holiday session here okay into the holiday session one hour in the section okay and one hour sorry seven hours initiation one hour one hour overtime in the section the rest indication the rest in the section address shall be built in the section okay and so on the same applies to the other part of this table okay all section it is travels except for the standard and first sorry four star and finish section have been integrated with the formula they are in okay and totally at the bottom totally the bottom here's records record Standard Time for difficult normal excluding Standard Time for typical shift okay uh furthermore the total on the right cell okay the total on the right so yes the total on the right okay total on the right so uh the total number of working hours ing to the type initiation starting from Ship Shape okay see see normal yes if normal okay ship normal overtime and holiday okay and Holiday okay next we move to the summary manhowers and monthly payment okay the table in the section includes number yes number description you need unit rate quantity deep last month this month up to this month amount for last month this month up to this month and any remarks column again this section describe a summary of Turtleman hours yes of its employee yes you could check this is taken from daily Main Highway record scene cell ex22 plus daily Min hours he could see cell ex34 you could check also the other cell where uh which has been equipped with a population got it okay okay so this is the total number of employees starting from normal shift over time Sunday holiday okay sunny holiday next the quantity is the number of manhower earn it okay then there is among column yeah amount column which is the amount of progress filling which is the amount of progress feeling Earnest after the number of men hours yeah number of men hours earn it is multiplied by the unit rate by the unit rate of normal save over time Sunday or holiday yes this is you could check the formulation Inside by Click by double clicking and you could see where is the cell come from okay so this section yeah this section will be the section sorry also in this table are equipped with the formulation they are in so the section here will be built automatically from the previous table and the section below so the total billing progress the total progress feeling here this is the below section on the below section shows the total billing progress in the billing period okay this is a rounded this is the title that I recorded already okay then we go to the monthly progress Payment Certificate okay the monthly progress Payment Certificate boxing which shows the total progress of payment for this month after deducting ten percent foreign poor retention yes for attention and added ten percent with value in the tax yes value added tax in this section any accumulative progress payment up to last month a community progress payment up to this month through this payment this month repayment of down payment and percent payment up for this month less for attention payment to this month and valuated tax again February tax this session also shows the progress payment for this month yes yes after added uh by ten percent with uh after added with failure detect ten percent okay so it will automatically convert to say yes yes because this is equip uh weight formulation than in also yes okay okay here are my uh brief explanation related to progress payment form Manpower supply for pre-commissioning work okay hopefully this is useful uh making in making it easier for you to carry out your notice and responsibilities in relate field okay especially for willing and power supply for pre-commissioning work thank you for watching this video don't forget to subscribe like and comment on this video so that my YouTube channel can develop orderly so I am also excited to share my knowledge and experience in the construction industry in the oil and gas bill so it is so beautiful to support always and share knowledge and experience each other thank you very much again for your attention see you in the next video okay uh the monthly progress Payment Certificate worksheet here which shows the total of progress payment for this month okay years okay Total Focus payment for this month after deducting 10 percent power than 5 months five percent for the tension money and added with 10 value-added tax yes a detection any accumulative progress payment this month yeah repayment of the entertainment payment amount for this month less Volcan payment due this month and value added tax okay uh this section also total progress payment for this for this month after added value added tax ten percent years it will automatically convert to say yeah compote to says yes because equip uh and it has been equipped already with the formulation daring okay okay this template this template yes this template is standard but it can be adjusted as your project feature hopefully this template is useful and making it easier for you to carry out your values and responsibilities in the in relayed field especially for William and power supply for pre-commissioning works thank you for watching this video don't forget to subscribe like share and comment on this video so that my YouTube channel can develop properly so that I'm excited to share my knowledge and experience in the construction industry in the oil and gas bill it is so beautiful to support always and share knowledge and experience each other okay thanks again for watching this video see you in the next video