4. Given is a table of revenue and costs for a project to be implemented. Please create a forecasted cashflow spreadsheet. Please show clearly: 4.1 the Cash In-flow, (8 marks) 42 the Cash Outflow, (8 marks) 4.3 the Net Cashflow, (8 marks) 4.4 the Cumulative Cash flow. (8 marks) 4.5 Analyze and state the minimum amount of money that should be advanced to the Project Team to ensure that the project team cumulative cashflow remain positive throughout the project? (it is better to show this analysis in the forecasted cash flow spreadsheet. (8 marks) Description Quantity Unit Total Rate Total Cost/evenue Cost Revenue 1 Mobilisation 1 unit 1 6,000.00 6,000.00 7.500.00 7.500.00 2 Installation Work 21 Project Manager months 6,000.00 24,000.00 7,500.00 30,000.00 Engineer months 4,000.00 16,000.00 5,000.00 20,000.00 Supervisor 1 months 2 3,000.00 10,000.00 3,750.00 22,500.00 2.4 General Labour 3 months 1.500,00 36,000.00 1.875.00 45,000.00 Total 2.5 Installation Works 12 94,000.00 117,500.00 3 Materials sites 1 8.000.00 120,000.00 10,000.00 150,000.00 4 Transportation months 1 3,000.00 9,000.00 3,750,00 11,250.00 5 Testing Tools 15 sites 1 1000 15,000.00 1.250,00 18,750.00 6 Miscellaneous 1 10,000.00 10,000.00 12.500.00 12,500.00 TOTAL CO/Revenue 254.000.00 317,500.00 1 ? 1 Terms 1. Payment terms is 45 days after submission of invoice 2. Involdne will be done at end of working month 3. Project Manager and Engineer will start 2 weeks before the installation team and finishes 2 weeks after 4. Total Installation works for the installation team is 3 months 5. There are 15 sites for Installation. Each month can complete 5 sites 4. Given is a table of revenue and costs for a project to be implemented. Please create a forecasted cashflow spreadsheet. Please show clearly: 4.1 the Cash In-flow, (8 marks) 42 the Cash Outflow, (8 marks) 4.3 the Net Cashflow, (8 marks) 4.4 the Cumulative Cash flow. (8 marks) 4.5 Analyze and state the minimum amount of money that should be advanced to the Project Team to ensure that the project team cumulative cashflow remain positive throughout the project? (it is better to show this analysis in the forecasted cash flow spreadsheet. (8 marks) Description Quantity Unit Total Rate Total Cost/evenue Cost Revenue 1 Mobilisation 1 unit 1 6,000.00 6,000.00 7.500.00 7.500.00 2 Installation Work 21 Project Manager months 6,000.00 24,000.00 7,500.00 30,000.00 Engineer months 4,000.00 16,000.00 5,000.00 20,000.00 Supervisor 1 months 2 3,000.00 10,000.00 3,750.00 22,500.00 2.4 General Labour 3 months 1.500,00 36,000.00 1.875.00 45,000.00 Total 2.5 Installation Works 12 94,000.00 117,500.00 3 Materials sites 1 8.000.00 120,000.00 10,000.00 150,000.00 4 Transportation months 1 3,000.00 9,000.00 3,750,00 11,250.00 5 Testing Tools 15 sites 1 1000 15,000.00 1.250,00 18,750.00 6 Miscellaneous 1 10,000.00 10,000.00 12.500.00 12,500.00 TOTAL CO/Revenue 254.000.00 317,500.00 1 ? 1 Terms 1. Payment terms is 45 days after submission of invoice 2. Involdne will be done at end of working month 3. Project Manager and Engineer will start 2 weeks before the installation team and finishes 2 weeks after 4. Total Installation works for the installation team is 3 months 5. There are 15 sites for Installation. Each month can complete 5 sites