You are tasked with constructing a cash flow projection for a contractor's project for a 100,000-square-foot...

Transcribed Image Text:

You are tasked with constructing a cash flow projection for a contractor's project for a 100,000-square-foot parking lot project. The holdback retention rate is 10%. Given the provided data, what's the anticipated net cash flow for Month 2? Assume a one- month payment lag and no holdback releases or interest. Contractor's Planned Schedule Construction Work Planned Schedule of Month Package Duration Values Earthwork 2.00 $500,000 1 $250,000 2 3 4 5 Gravel Base 2.00 $1,000,000 $250,000 $500,000 Pavement 2.00 $1,500,000 Total direct & indirect costs $3,000,000 Overhead 10% Profit 5% Total for contract $250,000 $750,000 $300,000 $25,000 $75,000 $150,000 $12,500 $37,500 $3,450,000 $287,500 $862,500 $500,000 $750,000 $750,000 $1,250,000 $750,000 $125,000 $75,000 $62,500 $1,437,500 $862,500 $37,500 ($428,750) ($703,750) $905,625 ($566,250) You are preparing an equipment cost control report using the following progress data. What would be the Total Equipment Variance for the project? Equipment Cost Control Report Job Code Job Description Budgeted Equipment Machine Hours Budgeted Unit Price per Machine Hour Actual Machine Hours Actual Unit Price per Machine Hour Installation of 08.100.03 Mobile Crane 250 $250 250 $265 Curtain Walls Installation of 08.200.03 Mobile Crane 50 $100 40 $150 Exterior Doors Total 300 290 $5,250 Under Budget $4,750 Under Budget $11,500 Under Budget $4,750 Over Budget You are tasked with constructing a cash flow projection for a contractor's project for a 100,000-square-foot parking lot project. The holdback retention rate is 10%. Given the provided data, what's the anticipated net cash flow for Month 2? Assume a one- month payment lag and no holdback releases or interest. Contractor's Planned Schedule Construction Work Planned Schedule of Month Package Duration Values Earthwork 2.00 $500,000 1 $250,000 2 3 4 5 Gravel Base 2.00 $1,000,000 $250,000 $500,000 Pavement 2.00 $1,500,000 Total direct & indirect costs $3,000,000 Overhead 10% Profit 5% Total for contract $250,000 $750,000 $300,000 $25,000 $75,000 $150,000 $12,500 $37,500 $3,450,000 $287,500 $862,500 $500,000 $750,000 $750,000 $1,250,000 $750,000 $125,000 $75,000 $62,500 $1,437,500 $862,500 $37,500 ($428,750) ($703,750) $905,625 ($566,250) You are preparing an equipment cost control report using the following progress data. What would be the Total Equipment Variance for the project? Equipment Cost Control Report Job Code Job Description Budgeted Equipment Machine Hours Budgeted Unit Price per Machine Hour Actual Machine Hours Actual Unit Price per Machine Hour Installation of 08.100.03 Mobile Crane 250 $250 250 $265 Curtain Walls Installation of 08.200.03 Mobile Crane 50 $100 40 $150 Exterior Doors Total 300 290 $5,250 Under Budget $4,750 Under Budget $11,500 Under Budget $4,750 Over Budget