Skip my solution and all my number. Just take monthly subcontractor cost

Insert Delete Format Sensitivity Paste U- - = = Merge & Center $ % Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter - Select Editing Cells Sensitivity Clipboard Number Font Alignment L16 P M B. A G K D H N 1 Note: Please leave the green cells untouched as it will be used for evaluating the exam and to be filled by the professor 2 Q4-A general contractor GC has been awarded to construct an industrial building within a period of 8 months. The contractor sublet the project to subcontractors. Table 4 shows Question 4 Marks- 3 monthly estimated cost for subcontractors. The markup of the general contractor added to the values of subcontractors is 20%. Owner will pay the general contractor 2 months from billing date and will keep Reten 4 contractor two months after practical completion of the project. The general contractor will pay the subcontractor (monthly cost) full amount of the cost without retention one month after each billing month. 5 To simplify the calculation you may assume that all costs must be met at the instant they are incurred. 6 Calculate the monthly cash needed using cash flow table in the answer sheet. R= 5% 7 Profit 20% 8 2 1 3 4 6 5 7 Marks 8 9 10 12 11 1.25 24000 24000 45000 40000 20000 60000 15000 6000 10000 5000 11250 56250 6000 30000 1500 60000 15000 75000 3750 40000 10000 50000 2500 313000 78250 391250 19562.5 25000 30000 1500 50000 2500 75000 3750 2812.5 1250 84375 1500 3000 12062.5 5812.5 28500 9562.5 53437.5 9 Description 10 Monthly sub-Contractor Cost 11 Monthly Contractor profit 12 Contractor Total Billed monthly value 13 Monthly Retention 14 Total project value at moth 12 15 Cumulative Retention 16 Month received for Contractor 17 Payment to subcontractor 18 cumulative cost 19 cumulative payment received by contractor 20 Monthly cash flow 21 22 01 Q2 03 Q4 18312.5 47500 14562.5 47500 19562.5 71250 1.25 1.25 1.25 1.5 1.25 1.25 1.25 1.25 1.25 1.25 71250 23750 48000 93000 24000 153000 193000 293000 233000 313000 10 10 Ready ) ENG 6:34 AM 4/13/2021 Type here to search