how to calculate the monthly received in the Excel table using the Known data

i. The gross profit margin is 10% of the cost. ii. Retention money is 5%. iii. Progress payment is on monthly basis and measurement will be made at the end of each month and the contractor receives the payment one (1) month later iv. The contractor is given advance payment of RM 500,000 at the start of the project; the advance payment will be returned to the client through progress payment deduction starting from the end of third month to the end seventh month equally v. The retention money is repaid 3 (three) months after the practical completion. To simplify the calculation, you may assume that all costs must be met at the instant they are incurred. You may also assume that the monthly value and cost for each activity are equally distributed. TABLE Q6 Based on the above information's, answer the following questions. a. What is the contract value of the project? (4 marks) b. Calculate the maximum cash required for this project. (7 marks) c. At the end of which month, the maximum cash is required? (4 marks) d. What is the expected monthly payment received of all works that are scheduled to be completed in May? (5 marks) Profit: 10\% Retention: 5% i. The gross profit margin is 10% of the cost. ii. Retention money is 5%. iii. Progress payment is on monthly basis and measurement will be made at the end of each month and the contractor receives the payment one (1) month later iv. The contractor is given advance payment of RM 500,000 at the start of the project; the advance payment will be returned to the client through progress payment deduction starting from the end of third month to the end seventh month equally v. The retention money is repaid 3 (three) months after the practical completion. To simplify the calculation, you may assume that all costs must be met at the instant they are incurred. You may also assume that the monthly value and cost for each activity are equally distributed. TABLE Q6 Based on the above information's, answer the following questions. a. What is the contract value of the project? (4 marks) b. Calculate the maximum cash required for this project. (7 marks) c. At the end of which month, the maximum cash is required? (4 marks) d. What is the expected monthly payment received of all works that are scheduled to be completed in May? (5 marks) Profit: 10\% Retention: 5%