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 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) 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? (8 marks) Cast/Revenue Cost Price Offer Price Description Quantity Unit Rate Total Rate Total 1 Preliminaries 1.1 Mobilisation 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 an month 4,000.00 24,000.00 6,000.00 36,000.00 2.3 Supervisor 4 month 2 3,000.00 32,000.00 24,000.00 48,000.00 4,000.00 2,000.00 2.4 Labour 4 month DO 1,500.00 64,000.00 192,000.00 2.5 Total Installation Works 12 138,000.00 3 Materials 20 sites 1 3,000.00 50,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. I 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) 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? (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 Installation Work N 2.1 6 month 1 7,000.00 42,000.00 10,000.00 60,000.00 Project Manager Engineer 2.2 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 3 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 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 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) 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? (8 marks) Cast/Revenue Cost Price Offer Price Description Quantity Unit Rate Total Rate Total 1 Preliminaries 1.1 Mobilisation 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 an month 4,000.00 24,000.00 6,000.00 36,000.00 2.3 Supervisor 4 month 2 3,000.00 32,000.00 24,000.00 48,000.00 4,000.00 2,000.00 2.4 Labour 4 month DO 1,500.00 64,000.00 192,000.00 2.5 Total Installation Works 12 138,000.00 3 Materials 20 sites 1 3,000.00 50,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. I 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) 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? (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 Installation Work N 2.1 6 month 1 7,000.00 42,000.00 10,000.00 60,000.00 Project Manager Engineer 2.2 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 3 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