70.2K

Verified Solution

Link Copied!

CASH FLOW. Contrusion project controls

CASH FLOW SPREADSHEET INFORMATION USE FOR QUESTIONS 25 - 29 NOTE WEEKS 5, 6, and 7 HAVE BEEN OMITTED FROM THE CASH FLOW DIAGRAM BELOW, BUT ALL NECESSARY INFORMATION HAS BEEN INCLUDED FOR WEEK 8. THE INFORMATION FROM WEEK 4 IS THE STARTING POINT FOR YOUR CALCULATIONS Contract Terms: Billings to be submitted to the owner every four weeks. Payment received from the owner four weeks after submittal. 1 10% Retainage will be withheld for the entire project 2 3 Pricing Assumptions 4 All Schedule of Value costs include 10% Overhead and 5% profit. Profit should be calculated on both the cost of the work and overhead cost 5 16 7 Activity Week 4 Week 8 Week 9 Week 10 Week 11 Week 12 18 19 B 20 21 D 5,000.00 52 E 10,000.00 10,000.00 F 15,000.00 15,000.00 24 G 20,000 00 20,000.00 20,000.00 25 H 40.000.00 26 J K 8.000.00 8,000.00 29 L 15.000.00 15.000,00 30 M 31 32 Weekly Total Scheduled Value 5,000.00 33,000.00 33 Cumulative Scheduled Value 88,000.00 227,000.00 34 Amount Billed to Owner This Month 79.200.00 35 Cumulative Billed to Owner 79.200.00 026 36 Cash Income Payment Received 79,200.00 028 37 Cumulative Payment Received 79,200.00 38 Cumulative Cost or Work Performed 196,536.79 027 39 Net Cash Flow 025 029 40 27 28 CASH FLOW SPREADSHEET INFORMATION USE FOR QUESTIONS 25 - 29 NOTE WEEKS 5, 6, and 7 HAVE BEEN OMITTED FROM THE CASH FLOW DIAGRAM BELOW, BUT ALL NECESSARY INFORMATION HAS BEEN INCLUDED FOR WEEK 8. THE INFORMATION FROM WEEK 4 IS THE STARTING POINT FOR YOUR CALCULATIONS Contract Terms: Billings to be submitted to the owner every four weeks. Payment received from the owner four weeks after submittal. 1 10% Retainage will be withheld for the entire project 2 3 Pricing Assumptions 4 All Schedule of Value costs include 10% Overhead and 5% profit. Profit should be calculated on both the cost of the work and overhead cost 5 16 7 Activity Week 4 Week 8 Week 9 Week 10 Week 11 Week 12 18 19 B 20 21 D 5,000.00 52 E 10,000.00 10,000.00 F 15,000.00 15,000.00 24 G 20,000 00 20,000.00 20,000.00 25 H 40.000.00 26 J K 8.000.00 8,000.00 29 L 15.000.00 15.000,00 30 M 31 32 Weekly Total Scheduled Value 5,000.00 33,000.00 33 Cumulative Scheduled Value 88,000.00 227,000.00 34 Amount Billed to Owner This Month 79.200.00 35 Cumulative Billed to Owner 79.200.00 026 36 Cash Income Payment Received 79,200.00 028 37 Cumulative Payment Received 79,200.00 38 Cumulative Cost or Work Performed 196,536.79 027 39 Net Cash Flow 025 029 40 27 28

Answer & Explanation Solved by verified expert

See Answer