QUESTION 3: (40 marks) Project Accounting 3. Given is a table of revenue and costs for a project to be implemented. a) Please create a forecasted cashflow spreadsheet. Please show clearly the Cash In-flow, (8 marks) ii. the Cash outflow, (8 marks) iii. the Net Cashflow, (8 marks) iv. the Cumulative Cash flow. (8 marks) V. 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? 18 marks) Cost Revenue Cost Price Ottar Pro Description Quantity Uni Rate Total Rate Preliminaries Mabilisation ] unit 1 5.000.00 5.000.00 10,000.00 10,000.00 Total Preliminaries 5.000.00 10,000.00 2 Installation Work Project Manager 6 month 1 7,000.00 42,000.00 10 000 00 50.000.00 in month 4,000.00 00 00027 6 000.00 35,000.00 Engineer Supervisor 2 month 2 2.000.00 00 000 4,000.00 100000 Labour month S. 7,500.00 48,000.00 2000.00 6.000.00 2.5 Total Installation Works 00000 SET 192.000.00 Materials 20 sites 1 3000100 00 00009 5.000.00 100 000.00 Testing Took 20 200 00 6,000.00 03.00 8.000.00 NA 100000 5.000.00 10,000.00 10.000.00 Miscellaneous TOTAL Cost/Revenue 240000D 320 000 00 Conditions for the Cashflow: 1. Payment terms is 45 days after submission of Invoice. 2. Invoicing will be done at end of working month. 3. Project Manager and Engineer will start one month before the installation team and finishes one month after. 4. Total Installation works for the installation team is 4 months 5. There are 20 sites for installation. Each month can complete 5 sites. 6. Testing will be done immediately after installation works is complete. 3. Given is a table of revenue and costs for a project to be implemented. a) Please create a forecasted cashflow spreadsheet. Please show clearly i. the Cash In-flow, (8 marks) ii. the Cash outflow, (8 marks) iii. the Net Cashflow, (8 marks) iv. the Cumulative Cash flow. (8 marks) y. 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? (8 marks) Cost/Revenue Cost Price Offer Price Description Quantity Unit Rate Total Rate Total 1 Preliminaries 1.1 Mobilisation 1 unit 1 5,000.00 5,000.00 10,000.00 10,000.00 1.2 Total Preliminaries 5,000.00 10,000.00 2 Installation Work 2.1 Project Manager 6 month 1 7,000.00 42,000.00 10,000.00 60,000.00 2.2 Engineer 6 month 1 4,000.00 24,000.00 6,000.00 36,000.00 2.3 Supervisor 4 month 2. 3,000.00 24,000.00 4,000.00 32,000.00 2.4 Labour 4 month 00 1,500.00 48,000.00 2,000.00 64,000.00 2.5 Total Installation Works 12 138,000.00 192,000.00 Materials 20 sites 1 3,000.00 60,000.00 5,000.00 100,000.00 4 Testing Tools 20 sites 1 300.00 6,000.00 400.00 8,000.00 5 Miscellaneous 1 5,000.00 5,000.00 10,000.00 10,000.00 6 TOTAL Cost/Revenue 214,000.00 320,000.00 Conditions for the Cashflow: 1. Payment terms is 45 days after submission of Invoice. 2. Invoicing will be done at end of working month. 3. Project Manager and Engineer will start one month before the installation team and finishes one month after. 4. Total Installation works for the installation team is 4 months 5. There are 20 sites for installation. Each month can complete 5 sites. 6. Testing will be done immediately after installation works is complete. QUESTION 3: (40 marks) Project Accounting 3. Given is a table of revenue and costs for a project to be implemented. a) Please create a forecasted cashflow spreadsheet. Please show clearly the Cash In-flow, (8 marks) ii. the Cash outflow, (8 marks) iii. the Net Cashflow, (8 marks) iv. the Cumulative Cash flow. (8 marks) V. 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? 18 marks) Cost Revenue Cost Price Ottar Pro Description Quantity Uni Rate Total Rate Preliminaries Mabilisation ] unit 1 5.000.00 5.000.00 10,000.00 10,000.00 Total Preliminaries 5.000.00 10,000.00 2 Installation Work Project Manager 6 month 1 7,000.00 42,000.00 10 000 00 50.000.00 in month 4,000.00 00 00027 6 000.00 35,000.00 Engineer Supervisor 2 month 2 2.000.00 00 000 4,000.00 100000 Labour month S. 7,500.00 48,000.00 2000.00 6.000.00 2.5 Total Installation Works 00000 SET 192.000.00 Materials 20 sites 1 3000100 00 00009 5.000.00 100 000.00 Testing Took 20 200 00 6,000.00 03.00 8.000.00 NA 100000 5.000.00 10,000.00 10.000.00 Miscellaneous TOTAL Cost/Revenue 240000D 320 000 00 Conditions for the Cashflow: 1. Payment terms is 45 days after submission of Invoice. 2. Invoicing will be done at end of working month. 3. Project Manager and Engineer will start one month before the installation team and finishes one month after. 4. Total Installation works for the installation team is 4 months 5. There are 20 sites for installation. Each month can complete 5 sites. 6. Testing will be done immediately after installation works is complete. 3. Given is a table of revenue and costs for a project to be implemented. a) Please create a forecasted cashflow spreadsheet. Please show clearly i. the Cash In-flow, (8 marks) ii. the Cash outflow, (8 marks) iii. the Net Cashflow, (8 marks) iv. the Cumulative Cash flow. (8 marks) y. 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? (8 marks) Cost/Revenue Cost Price Offer Price Description Quantity Unit Rate Total Rate Total 1 Preliminaries 1.1 Mobilisation 1 unit 1 5,000.00 5,000.00 10,000.00 10,000.00 1.2 Total Preliminaries 5,000.00 10,000.00 2 Installation Work 2.1 Project Manager 6 month 1 7,000.00 42,000.00 10,000.00 60,000.00 2.2 Engineer 6 month 1 4,000.00 24,000.00 6,000.00 36,000.00 2.3 Supervisor 4 month 2. 3,000.00 24,000.00 4,000.00 32,000.00 2.4 Labour 4 month 00 1,500.00 48,000.00 2,000.00 64,000.00 2.5 Total Installation Works 12 138,000.00 192,000.00 Materials 20 sites 1 3,000.00 60,000.00 5,000.00 100,000.00 4 Testing Tools 20 sites 1 300.00 6,000.00 400.00 8,000.00 5 Miscellaneous 1 5,000.00 5,000.00 10,000.00 10,000.00 6 TOTAL Cost/Revenue 214,000.00 320,000.00 Conditions for the Cashflow: 1. Payment terms is 45 days after submission of Invoice. 2. Invoicing will be done at end of working month. 3. Project Manager and Engineer will start one month before the installation team and finishes one month after. 4. Total Installation works for the installation team is 4 months 5. There are 20 sites for installation. Each month can complete 5 sites. 6. Testing will be done immediately after installation works is complete