With the work schedule given below, the project quantities and unit prices (table 1), the contractor cost per pay item (table 2): Detour Install Electric Wiring Install Lights Start Deliver Breaker Remove Pavement Install Base Place Topping Paint Detour Remove End Deliver Plant *Schedule Concrete Plant as late as possible Table 1: Pay Item Detour Remove Payment Install Base Place Topping Paint Lights Quantity Unit 1 IS 30000 SY 3500 CY 3500 CY 20000 LF 1 IS $/Unit $237,500.00 $15.30 $206.00 $649.00 $3.10 $826,000.00 Table 2: Cost Item Quantity Unit Material Equip Labor Sub. Detour 1 EA $32,000 580,000 $40,000 $32,000 Duration (days) 15 Install 8 Remove 25 EA $220,000 EA $128,000 20 SY $20,000 $100,000 $108,000 40 S40/CY $220/CY $60/CY $80/CY $40/CY $120/CY Concrete Plant 1 (for topping) Pavement 1 Breaker Remove 30000 Pavement Install Base 3500 Concrete Topping 3500 Electric Wiring 15000 Install Lights 60 Paint Pavement 20000 Quality Control 1 (9 base; topping) Variable Overhead Fixed Overhead $520,000 Fee $262.200 CY CY LE EA LF EA $260,000 $380,000 30 30 40 20 8 $0.60/LF $0.80/LF $1.00/LE $140,000 $400/day $320/day $1,080/day (a) Draw a graph showing the curve for the contractor's cash flow out, the curve for the contractor's cash flow in, and the curve for the difference. Plot S on the vertical axis and time on the horizontal axis. Show all calculations on a Excel spreadsheet. (b) Find the cash flow out, the contractor's cash flow in, and the difference, if owner's payments are delayed four weeks. Draw a graph of this situation and compare this with (a) above. (9) How much should the contractor's fee be adjusted for part (b) if the contractor's expected rate of return is 12% Contractor's Method of Payment: (all payments are at the end of week) Labor: Paid weekly Material: Materials purchased during the month are paid at the end of the first week of the next month. Spread labor and materials evenly over activity duration. Equipment: Pavement breaker - pay upon delivery. Concrete plant -50% when ordered and 50% upon delivery. All other equipment spread over total activity duration. Monthly payments, paid in advance. (For detour, spread over total duration of "detour install" up to end of "detour remove") Fixed Overhead: This is a G&A item; not a project cash flow Variable Overhead: Labor paid at the end of each month, material same as above, and equipment paid at the end of the month. Subcontractors: Paid one week after the contractor receives his payment from the owner for the sub's work. No retainage is held on subcontractors. Owner's Method of Payment: (one payment per month) - Total quantities for the month for the unit priced items. -50% of detour lump sum when detour install is finished and 50% when detour remove is finished. - 45% of lights lump sum when all wiring is finished and 55% when all lights are installed - 10% retention for pay items up to and including concrete topping, no retention thereafter. - Pay request submittal is made at the end of the month. Payment is due two weeks after submittal. Additional Information: - One week is equal to 5 working days, starting on Monday. -One month is equal to 20 working days, near is equal to 48 weeks Acuma With the work schedule given below, the project quantities and unit prices (table 1), the contractor cost per pay item (table 2): Detour Install Electric Wiring Install Lights Start Deliver Breaker Remove Pavement Install Base Place Topping Paint Detour Remove End Deliver Plant *Schedule Concrete Plant as late as possible Table 1: Pay Item Detour Remove Payment Install Base Place Topping Paint Lights Quantity Unit 1 IS 30000 SY 3500 CY 3500 CY 20000 LF 1 IS $/Unit $237,500.00 $15.30 $206.00 $649.00 $3.10 $826,000.00 Table 2: Cost Item Quantity Unit Material Equip Labor Sub. Detour 1 EA $32,000 580,000 $40,000 $32,000 Duration (days) 15 Install 8 Remove 25 EA $220,000 EA $128,000 20 SY $20,000 $100,000 $108,000 40 S40/CY $220/CY $60/CY $80/CY $40/CY $120/CY Concrete Plant 1 (for topping) Pavement 1 Breaker Remove 30000 Pavement Install Base 3500 Concrete Topping 3500 Electric Wiring 15000 Install Lights 60 Paint Pavement 20000 Quality Control 1 (9 base; topping) Variable Overhead Fixed Overhead $520,000 Fee $262.200 CY CY LE EA LF EA $260,000 $380,000 30 30 40 20 8 $0.60/LF $0.80/LF $1.00/LE $140,000 $400/day $320/day $1,080/day (a) Draw a graph showing the curve for the contractor's cash flow out, the curve for the contractor's cash flow in, and the curve for the difference. Plot S on the vertical axis and time on the horizontal axis. Show all calculations on a Excel spreadsheet. (b) Find the cash flow out, the contractor's cash flow in, and the difference, if owner's payments are delayed four weeks. Draw a graph of this situation and compare this with (a) above. (9) How much should the contractor's fee be adjusted for part (b) if the contractor's expected rate of return is 12% Contractor's Method of Payment: (all payments are at the end of week) Labor: Paid weekly Material: Materials purchased during the month are paid at the end of the first week of the next month. Spread labor and materials evenly over activity duration. Equipment: Pavement breaker - pay upon delivery. Concrete plant -50% when ordered and 50% upon delivery. All other equipment spread over total activity duration. Monthly payments, paid in advance. (For detour, spread over total duration of "detour install" up to end of "detour remove") Fixed Overhead: This is a G&A item; not a project cash flow Variable Overhead: Labor paid at the end of each month, material same as above, and equipment paid at the end of the month. Subcontractors: Paid one week after the contractor receives his payment from the owner for the sub's work. No retainage is held on subcontractors. Owner's Method of Payment: (one payment per month) - Total quantities for the month for the unit priced items. -50% of detour lump sum when detour install is finished and 50% when detour remove is finished. - 45% of lights lump sum when all wiring is finished and 55% when all lights are installed - 10% retention for pay items up to and including concrete topping, no retention thereafter. - Pay request submittal is made at the end of the month. Payment is due two weeks after submittal. Additional Information: - One week is equal to 5 working days, starting on Monday. -One month is equal to 20 working days, near is equal to 48 weeks Acuma