Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

materials- 800 2500 1500 2000 labor- 1000 500 2000 1200 equipment - 5000 5000 1200 500 Project Overhead - 1200 500 1100 600 sub-contractor- 4000

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
materials-
800
2500
1500
2000
labor-
1000
500
2000
1200
equipment -
5000
5000
1200
500
Project Overhead -
1200
500
1100
600
sub-contractor-
4000
8000
2000
2700
DISREGARD the first 3 photos
A combustice company is megotiating consontration project with Swee dunia. Os be laut day of the wel be conduction conguey may be there for the completed during the one we pay themelybill et month after they are received. The owner bolde 7% relations Relenco is paid mice during the proje and emots) (includes retention held during out 12.13 de end of eat 6 wy rotation. But we not reund die Aditionally following information is provided 35% of Material is paid at the time of divery. Bet 85% detail in paytren yed .45% of project vahead is paid the time of delivery or when the con la scund Red 35% of project rehead in pay when prid. Ellis work wederpay when poll - Tami pattaamatamarai yet during123) and diseade (my retention to deter) The company for later weekly. - Indicar 225 for the centre The projectataraiyaraa teadal al. Complaints 2 Directed SL300 1300 $1.000 Law Prowhead 12.500 5500 35,000 9900 $2,000 $2.000 11.30 5500 100 $100 3.700 $1.200 34.000 11.200 SU100 $2.000 6.7 Tatal Direct lego Gare Cad BTW er CIGAR Money Bacrived from Rent by the Mes by the Total Mens Red Calle Par mampe, ale, and (CAROLT Paid for tale Paid for Laber Paid to Equali Paid to Paid to Sob Color eate a emained to the Bad Total Post C Met) tail Maal Tudalencashire A construction company is negotiating on a construction project with a four-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 one month after they are received. The owner holds 7% retention. Retention is paid twice during the projects at the end of month 3 (includes retention held during month 1,2,3) and at the end of month 6 (any retention that was not released earlier). Additionally following information is provided. -35% of Material is paid at the time of delivery. Rest 65% of material is pay when paid. 45% of project overhead is paid at the time of delivery or when the cost is incurred. Rest 55% of project overhead is pay when paid. Equipment suppliers work under pay when paid. The construction company name.subcontractors when it nocives payment from the 55% of project overhead is pay when paid. Equipment suppliers work under pay when paid. The construction company pays subcontractors when it receives payment from the owner but withholds 11% retention. SC retention is released twice during the projects at the end of month 3 (includes retention held during month 1.2.3) and at the end of month 6 (any retention that was not released earlier). . The company pays for labor weekly. Indirect costs are 21% for the construction company. The projected monthly direct costs are shown in the attached table. Complete the project cash flow table. 1 2 J Month Direct Costs $2.500 $500 Materials Labor Equipment Project Overhead Sub-contractor S800 $1,000 $5.000 S1.200 $4.000 $3,000 5500 S8.000 51.500 $2.000 $1,200 $1,100 522000 52.000 $1,200 5500 5600 52.700 Total Direct Con Pront AGOH (Indirect Costs Hul Tower Monry Received from Owner GC (CASH IN Money Received from the owner tetation held by the OWE Retention released by the owner Total Money Received (Cash In amma and CASHOU Payments made to suppliers, labor, and sub (CASH OUT) Paid for Materials Paid for Labor Paid to Equipment Supplier Paid to Project Overhead Paid to Subcontractor Retention beld from Sub Contractor Retention released to the Sub Total Payments (Cashout) Cash Flow Net Cash Flow at Month's end (Cash in-Cash out) Total cash generated at Month's end (after payment is received from the owner) Cash Invested Cash needed for the project before payment is received from the owner Effective Cash needed for the project before payment is received from the owner Total Cash invested in the project before payment is received from the owner Month with max cash need and the amount: Total amount of cash needed for the project is A combustice company is megotiating consontration project with Swee dunia. Os be laut day of the wel be conduction conguey may be there for the completed during the one we pay themelybill et month after they are received. The owner bolde 7% relations Relenco is paid mice during the proje and emots) (includes retention held during out 12.13 de end of eat 6 wy rotation. But we not reund die Aditionally following information is provided 35% of Material is paid at the time of divery. Bet 85% detail in paytren yed .45% of project vahead is paid the time of delivery or when the con la scund Red 35% of project rehead in pay when prid. Ellis work wederpay when poll - Tami pattaamatamarai yet during123) and diseade (my retention to deter) The company for later weekly. - Indicar 225 for the centre The projectataraiyaraa teadal al. Complaints 2 Directed SL300 1300 $1.000 Law Prowhead 12.500 5500 35,000 9900 $2,000 $2.000 11.30 5500 100 $100 3.700 $1.200 34.000 11.200 SU100 $2.000 6.7 Tatal Direct lego Gare Cad BTW er CIGAR Money Bacrived from Rent by the Mes by the Total Mens Red Calle Par mampe, ale, and (CAROLT Paid for tale Paid for Laber Paid to Equali Paid to Paid to Sob Color eate a emained to the Bad Total Post C Met) tail Maal Tudalencashire A construction company is negotiating on a construction project with a four-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 one month after they are received. The owner holds 7% retention. Retention is paid twice during the projects at the end of month 3 (includes retention held during month 1,2,3) and at the end of month 6 (any retention that was not released earlier). Additionally following information is provided. -35% of Material is paid at the time of delivery. Rest 65% of material is pay when paid. 45% of project overhead is paid at the time of delivery or when the cost is incurred. Rest 55% of project overhead is pay when paid. Equipment suppliers work under pay when paid. The construction company name.subcontractors when it nocives payment from the 55% of project overhead is pay when paid. Equipment suppliers work under pay when paid. The construction company pays subcontractors when it receives payment from the owner but withholds 11% retention. SC retention is released twice during the projects at the end of month 3 (includes retention held during month 1.2.3) and at the end of month 6 (any retention that was not released earlier). . The company pays for labor weekly. Indirect costs are 21% for the construction company. The projected monthly direct costs are shown in the attached table. Complete the project cash flow table. 1 2 J Month Direct Costs $2.500 $500 Materials Labor Equipment Project Overhead Sub-contractor S800 $1,000 $5.000 S1.200 $4.000 $3,000 5500 S8.000 51.500 $2.000 $1,200 $1,100 522000 52.000 $1,200 5500 5600 52.700 Total Direct Con Pront AGOH (Indirect Costs Hul Tower Monry Received from Owner GC (CASH IN Money Received from the owner tetation held by the OWE Retention released by the owner Total Money Received (Cash In amma and CASHOU Payments made to suppliers, labor, and sub (CASH OUT) Paid for Materials Paid for Labor Paid to Equipment Supplier Paid to Project Overhead Paid to Subcontractor Retention beld from Sub Contractor Retention released to the Sub Total Payments (Cashout) Cash Flow Net Cash Flow at Month's end (Cash in-Cash out) Total cash generated at Month's end (after payment is received from the owner) Cash Invested Cash needed for the project before payment is received from the owner Effective Cash needed for the project before payment is received from the owner Total Cash invested in the project before payment is received from the owner Month with max cash need and the amount: Total amount of cash needed for the project is

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Commercial Real Estate Finance

Authors: Gail Ramshaw, Mortgage Bank

1st Edition

0793157099, 9780793157099

More Books

Students also viewed these Finance questions

Question

6. Practice effective customer service behaviors.

Answered: 1 week ago