15 pts 2 Hour Question 4 24/7 Proc & Culo Live The following barchart illustrates the direct costs of a project leo construction will be working on. Assuming $5.000 indirect cost per month and 12% markup. If the owner retains 10% of validated progress payments until the project is completed, and payments will be billed at the end of the month and will be received one month later, Leo construction also needs to pay the bank 1% per month for the amount of the overdraft at the end of the month. Complete the following table and find out the net profit. Pha $50,000 Excavation $30,000 Backfill 360,000 Sheet Pilling $75,000 Reinforcing Steel $90,000 Concrete Work 0.5 1 Month 1.5 2.5 3 Hide End of Month app honorock.com is tharing your screen Stop sharing Sheet Pilling $75,000 Reinforcing Steel 590,000 Concrete Work 0.5 1.5 2 2.5 3 Month 1 End of Month 2 3 4 5 Monthly Cost (Direct & Indirect Cost) Monthly Billing Monthly Income Retainage Overdraft 4 (before interest) Interest (1%) Overdraft (deduct interest) Overdraft spp honorock.com is sharing your screen Stop (add income) 15 pts 2 Hour Question 4 24/7 Proc & Culo Live The following barchart illustrates the direct costs of a project leo construction will be working on. Assuming $5.000 indirect cost per month and 12% markup. If the owner retains 10% of validated progress payments until the project is completed, and payments will be billed at the end of the month and will be received one month later, Leo construction also needs to pay the bank 1% per month for the amount of the overdraft at the end of the month. Complete the following table and find out the net profit. Pha $50,000 Excavation $30,000 Backfill 360,000 Sheet Pilling $75,000 Reinforcing Steel $90,000 Concrete Work 0.5 1 Month 1.5 2.5 3 Hide End of Month app honorock.com is tharing your screen Stop sharing Sheet Pilling $75,000 Reinforcing Steel 590,000 Concrete Work 0.5 1.5 2 2.5 3 Month 1 End of Month 2 3 4 5 Monthly Cost (Direct & Indirect Cost) Monthly Billing Monthly Income Retainage Overdraft 4 (before interest) Interest (1%) Overdraft (deduct interest) Overdraft spp honorock.com is sharing your screen Stop (add income)