Retention held by the owner = x% of bill to owner Retention held from the sub-y% of sub amount 7% 12% 93.00% 88.00% Sub, material, equipment, and other costs are pay when paid; Labor is paid weekly; PO is paid monthly before the payment is received from the owner (i.e. when the costs are incurred). Gross Profit Margin 23% GC will send the invoice (bill or pay apps) to the owner at the end of the month; GC will receive payment from the owner at the end of the next (following) month. All previously held Retention (month 1 & 2) will be released during month 3 and then during month 5 (month 3, 4, 5)
Retention held by the owner = x% of bill to owner Retention held from the sub-y% of sub amount 7% 12% 93.00% 88.00% Sub, material, equipment, and other costs are pay when paid; Labor is paid weekly; PO is paid monthly before the payment is received from the owner (i.e. when the costs are incurred). Gross Profit Margin 23% GC will send the invoice (bill or pay apps) to the owner at the end of the month; GC will receive payment from the owner at the end of the next (following) month. All previously held Retention (month 1 & 2) will be released during month 3 and then during month 5 (month 3, 4, 5)
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
100%
Need help with the project cash flow !
Money received from owner/Gc module
Payments made to suppliers, labor, and sub
And the bottom part
![Total Direct Costs
Profit &GOH (Indirect Costs)
Bill To owner.
Retention held by the owner = x% of bill to owner
Retention held from the sub-y% of sub amount
Sub, material, equipment, and other costs are pay when paid; Labor is paid weekly; PO is paid monthly before the payment is received from the owner (i.e. when the costs are incurred).
Gross Profit Margin
23%
GC will send the invoice (bill or pay apps) to the owner at the end of the month; GC will receive payment from the owner at the end of the next (following) month.
All previously held Retention (month 1 & 2) will be released during month 3 and then during month 5 (month 3, 4, 5)
Month
1
2
3
Direct Costs
Money Received from the owner
Retention held by the owner
Retention released by the owner
Total Money Received (Cash In)
Paid for Materials
Paid for Labor
Paid to Equipment Supplier
Paid to Project Overhead
Materials
Labor
Equipment
Project Overhead
SubContractor
Paid to SubContractor
Retention held from Sub Contractor
Retention released to the Sub
Total Payments (Cash out)
Net Cash Flow at Month's end (Cash in - Cash out)
Total cash generated at Month's end (after payment is received from owner)
7%
12%
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
$3,000
$5,000
$1,000
$1500
$2,000
$12,500
Money Received from Owner/GC
Payments made to suppliers, labor, and sub
93.00%
88.00%
$6,000
$500
$1700
$1100
$6,000
$15,300
Month with max cash need and the amount:
Total amount of cash needed for the project is =
$3500
$300
$200
$100
$7,000
$11,100
4
$2,000
$200
$300
$200
$2,700
$5,400
5
Totals
$14,500
$8,000
$3,200
$2,900
$15,700
$44,300](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F7a85083f-c711-4fe4-a0ea-d798364bd78d%2F6091ded9-a20a-45ca-af5d-47eb67599db7%2Fhp95tep_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Total Direct Costs
Profit &GOH (Indirect Costs)
Bill To owner.
Retention held by the owner = x% of bill to owner
Retention held from the sub-y% of sub amount
Sub, material, equipment, and other costs are pay when paid; Labor is paid weekly; PO is paid monthly before the payment is received from the owner (i.e. when the costs are incurred).
Gross Profit Margin
23%
GC will send the invoice (bill or pay apps) to the owner at the end of the month; GC will receive payment from the owner at the end of the next (following) month.
All previously held Retention (month 1 & 2) will be released during month 3 and then during month 5 (month 3, 4, 5)
Month
1
2
3
Direct Costs
Money Received from the owner
Retention held by the owner
Retention released by the owner
Total Money Received (Cash In)
Paid for Materials
Paid for Labor
Paid to Equipment Supplier
Paid to Project Overhead
Materials
Labor
Equipment
Project Overhead
SubContractor
Paid to SubContractor
Retention held from Sub Contractor
Retention released to the Sub
Total Payments (Cash out)
Net Cash Flow at Month's end (Cash in - Cash out)
Total cash generated at Month's end (after payment is received from owner)
7%
12%
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
$3,000
$5,000
$1,000
$1500
$2,000
$12,500
Money Received from Owner/GC
Payments made to suppliers, labor, and sub
93.00%
88.00%
$6,000
$500
$1700
$1100
$6,000
$15,300
Month with max cash need and the amount:
Total amount of cash needed for the project is =
$3500
$300
$200
$100
$7,000
$11,100
4
$2,000
$200
$300
$200
$2,700
$5,400
5
Totals
$14,500
$8,000
$3,200
$2,900
$15,700
$44,300
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education