Your company has been awarded the contract for the new Foundation Addition to the Engineering Building and you have been assigned as the project executive. The contract has a value of $22,000,000. The estimate and anticipated schedule durations are as follows: Your company will self-perform the concrete foundations and flatwork and the masonry work. For both disciplines your profit margin is 10% and your total labor cost is 50% of the cost of work. Assume all payroll taxes are paid the month incurred. Union fringes and insurance cost are 30% of your total labor cost and are paid the following month. All material and equipment cost are paid the following month. Your total project management and supervision staff cost is 50% of your general conditions cost. Employee benefits and insurance are 20% of labor cost. Your general conditions cost are incurred equally each over the duration of the project. Non-labor general condition cost are paid the following month. All of the remaining work has been subcontracted. All subcontracts contain pay when paid language. Pay applications are due to the University at the end of the month and are paid are the first of the second following month, i.e. the payment for the May invoice would be made July 1st. All invoices are subject to 10% retention and payment of retention will be made 90 days after completion of the project. Overhead and profit is to be billed on a pro-rata basis based on the work in place each month. Prepare a worksheet showing the monthly and cumulative cash flow for the project. To check your results, compute the total expected overhead and profit for the project. Your company has been awarded the contract for the new Foundation Addition to the Engineering Building and you have been assigned as the project executive. The contract has a value of $22,000,000. The estimate and anticipated schedule durations are as follows: Your company will self-perform the concrete foundations and flatwork and the masonry work. For both disciplines your profit margin is 10% and your total labor cost is 50% of the cost of work. Assume all payroll taxes are paid the month incurred. Union fringes and insurance cost are 30% of your total labor cost and are paid the following month. All material and equipment cost are paid the following month. Your total project management and supervision staff cost is 50% of your general conditions cost. Employee benefits and insurance are 20% of labor cost. Your general conditions cost are incurred equally each over the duration of the project. Non-labor general condition cost are paid the following month. All of the remaining work has been subcontracted. All subcontracts contain pay when paid language. Pay applications are due to the University at the end of the month and are paid are the first of the second following month, i.e. the payment for the May invoice would be made July 1st. All invoices are subject to 10% retention and payment of retention will be made 90 days after completion of the project. Overhead and profit is to be billed on a pro-rata basis based on the work in place each month. Prepare a worksheet showing the monthly and cumulative cash flow for the project. To check your results, compute the total expected overhead and profit for the project