Set up a spreadsheet to solve Problem 2.

In Problem 2, A construction company is negotiating on a construction project with a six-month duration. On the last day of each month the construction company may bill the owner for the work completed during the month. The owner pays the monthly bills 15 days after they are received. The owner also holds a 10% retention. Final payment is expected one month after completion of the project and includes payment of the retention. The construction company pays material suppliers in full when it receives payment from the owner. The construction company pays subcontractors when it receives payment from the owner but withholds 10% from the subcontractor’s payment. The construction company pays for labor weekly. The projected monthly material, labor, and subcontractor costs follow. Determine the monthly cash flows and the total cash generated by the project at the end of each month and just before each payment is received from the project’s owner.

What is the maximum amount of cash invested by the company during the completion of theproject?

Transcribed Image Text:

COSTS MATERIALS ($) 33,700 54,100 69,600 17,200 14,700 11,600 200,900 LABOR ($) 25,300 42,400 77,900 17,900 21,900 12,700 198,100 SUB. () 35,600 125,200 93,600 105,700 60,400 35,600 456,100 MONTH BILL TO OwNER ($) 101,200 237,200 258,000 150,700 103,800 64,100 915,000 4 5 6 Total