Question: Your company has been awarded the contract for the new JT Foundation Addition ot the Engineering Building at LTU and you have been assigned as

Your company has been awarded the contract for the new JT Foundation Addition ot the Engineering Building at LTU 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:Mobilization (Front-loaded OH&P) General ConditionsExcavation and UtilitiesSite workC.I.P. Concrete Foundations C.I.P.ConcreteFlatworkMasonry Structural SteelRoofingGlass and GlazingInterior Finishes Fireproofing Plumbing HVACElectricalContractor overhead and profit Bond (payable when invoiced)Budget (S)Start Date 100,000May, 20221,100,000May, 20221,800,000 May, 2022500,000 Mar, 20231,400,000 Jun, 2022900,000 Dec,20221,900,000 Nov,20222,900,000Sep, 2022950,000Dec, 20221,200,000Dec, 2022,200,000Feb, 2023375,000 Feb, 2023850,000 Jan, 20231,700,000 Jan, 20233,000,000 Jan, 20231,100,00025,000End Date May, 202 Apr, 2023 July, 2022 Ap,r 2023 Oct, 2022 Mar, 2023 Feb, 2023 Dec, 2022 Feb. 2023 Feb, 2023 Apr, 2023 Mar, 2023 Ap,r 2023 Apr, 2023 Apr, 2023.22,000,000Your company wil 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. Al material and equipment cost are paid the foilowing 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. Al of the remaining work has been subcontracted. Al 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, Al invoices are subject ot 10% retention and payment of retention wil 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 ni 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!