In: Accounting
Brady Construction Company contracted to build an apartment complex for a price of $6,300,000. Construction began in 2018 and was completed in 2020. The following is a series of independent situations, numbered 1 through 6, involving differing costs for the project. All costs are stated in thousands of dollars. Estimated Costs to Complete Costs Incurred During Year (As of the End of the Year) Situation 2018 2019 2020 2018 2019 2020 1 1,630 2,520 1,290 3,810 1,290 — 2 1,630 1,290 2,920 3,810 2,920 — 3 1,630 2,520 2,640 3,810 2,540 — 4 630 3,130 1,260 4,410 940 — 5 630 3,130 2,210 4,410 2,540 — 6 630 3,130 3,100 5,855 2,870 — Required: Complete the following table. (Do not round intermediate calculations. Enter answers in dollars. Round your final answers to the nearest whole dollar. Negative amounts should be indicated by a minus sign.)
Estimated Costs to Complete | ||||||||||||
Costs Incurred During Year |
(As of the End of the Year) |
|||||||||||
Situation |
2018 |
2019 |
2020 |
2018 |
2019 |
2020 |
||||||
1 | 1,630 | 2,520 | 1,290 | 3,810 | 1,290 | — | ||||||
2 | 1,630 | 1,290 | 2,920 | 3,810 | 2,920 | — | ||||||
3 | 1,630 | 2,520 | 2,640 | 3,810 | 2,540 | — | ||||||
4 | 630 | 3,130 | 1,260 | 4,410 | 940 | — | ||||||
5 | 630 | 3,130 | 2,210 | 4,410 | 2,540 | — | ||||||
6 | 630 | 3,130 | 3,100 | 5,855 | 2,870 |
Solution:
Computation of % of completion, revenue recognition and Gross Profit - Brady Construction Company (Situation 1) | |||||||||
Year | Actual cost incurred (A) | Total cost incurred till date (B) | Total estimated Cost ( C ) | % of completion (D) (B/C) |
Contract Price (E) |
Total Revenue to be recoganized (F) (E * D) | Revenue for current period (G) | Gross Profit (H) (G - A) | |
2018 | $1,630,000 | $1,630,000 | $5,440,000 | 29.96% | $6,300,000 | $1,887,684 | $1,887,684 | $257,684 | |
2019 | $2,520,000 | $4,150,000 | $5,440,000 | 76.29% | $6,300,000 | $4,806,066 | $2,918,382 | $398,382 | |
2020 | $1,290,000 | $5,440,000 | $5,440,000 | 100.00% | $6,300,000 | $6,300,000 | $1,493,934 | $203,934 | |
Computation of % of completion, revenue recognition and Gross Profit - Brady Construction Company (Situation 2) | |||||||||
Year | Actual cost incurred (A) | Total cost incurred till date (B) | Total estimated Cost ( C ) | % of completion (D) (B/C) |
Contract Price (E) |
Total Revenue to be recoganized (F) (E * D) | Revenue for current period (G) | Gross Profit (H) (G - A) | |
2018 | $1,630,000 | $1,630,000 | $5,440,000 | 29.96% | $6,300,000 | $1,887,684 | $1,887,684 | $257,684 | |
2019 | $1,290,000 | $2,920,000 | $5,840,000 | 50.00% | $6,300,000 | $3,150,000 | $1,262,316 | -$27,684 | |
2020 | $2,920,000 | $5,840,000 | $5,840,000 | 100.00% | $6,300,000 | $6,300,000 | $3,150,000 | $230,000 | |
Computation of % of completion, revenue recognition and Gross Profit - Brady Construction Company (Situation 3) | |||||||||
Year | Actual cost incurred (A) | Total cost incurred till date (B) | Total estimated Cost ( C ) | % of completion (D) (B/C) |
Contract Price (E) |
Total Revenue to be recoganized (F) (E * D) | Revenue for current period (G) | Gross Profit (H) | |
2018 | $1,630,000 | $1,630,000 | $5,440,000 | 29.96% | $6,300,000 | $1,887,684 | $1,887,684 | $257,684 | $1,887,684 - $1,630,000 |
2019 | $2,520,000 | $4,150,000 | $6,690,000 | 62.03% | $6,300,000 | $3,908,072 | $2,020,388 | -$647,684 | $6,300,000 - $6,690,000 - $257,684 |
2020 | $2,640,000 | $6,790,000 | $6,790,000 | 100.00% | $6,300,000 | $6,300,000 | $2,391,928 | -$100,000 | $6,300,000 - $6,790,000 - $257,684 + $647,684 |
Computation of % of completion, revenue recognition and Gross Profit - Brady Construction Company (Situation 4) | |||||||||
Year | Actual cost incurred (A) | Total cost incurred till date (B) | Total estimated Cost ( C ) | % of completion (D) (B/C) |
Contract Price (E) |
Total Revenue to be recoganized (F) (E * D) | Revenue for current period (G) | Gross Profit (H) (G - A) | |
2018 | $630,000 | $630,000 | $5,040,000 | 12.50% | $6,300,000 | $787,500 | $787,500 | $157,500 | |
2019 | $3,130,000 | $3,760,000 | $4,700,000 | 80.00% | $6,300,000 | $5,040,000 | $4,252,500 | $1,122,500 | |
2020 | $1,260,000 | $5,020,000 | $5,020,000 | 100.00% | $6,300,000 | $6,300,000 | $1,260,000 | $0 | |
Computation of % of completion, revenue recognition and Gross Profit - Brady Construction Company (Situation 5) | |||||||||
Year | Actual cost incurred (A) | Total cost incurred till date (B) | Total estimated Cost ( C ) | % of completion (D) (B/C) |
Contract Price (E) |
Total Revenue to be recoganized (F) (E * D) | Revenue for current period (G) | Gross Profit (H) (G - A) | |
2018 | $630,000 | $630,000 | $5,040,000 | 12.50% | $6,300,000 | $787,500 | $787,500 | $157,500 | |
2019 | $3,130,000 | $3,760,000 | $6,300,000 | 59.68% | $6,300,000 | $3,760,000 | $2,972,500 | -$157,500 | |
2020 | $2,210,000 | $5,970,000 | $5,970,000 | 100.00% | $6,300,000 | $6,300,000 | $2,540,000 | $330,000 | |
Computation of % of completion, revenue recognition and Gross Profit - Brady Construction Company (Situation 6) | |||||||||
Year | Actual cost incurred (A) | Total cost incurred till date (B) | Total estimated Cost ( C ) | % of completion (D) (B/C) |
Contract Price (E) |
Total Revenue to be recoganized (F) (E * D) | Revenue for current period (G) | Gross Profit (H) | |
2018 | $630,000 | $630,000 | $6,485,000 | 9.71% | $6,300,000 | $612,028 | $612,028 | -$185,000 | $6,300,000 - 6,485,000 |
2019 | $3,130,000 | $3,760,000 | $6,630,000 | 56.71% | $6,300,000 | $3,572,851 | $2,960,823 | -$145,000 | $6,300,000 - 6,630,000 + $185,000 |
2020 | $3,100,000 | $6,860,000 | $6,860,000 | 100.00% | $6,300,000 | $6,300,000 | $2,727,149 | -$230,000 | $6,300,000 - 6,860,000 + $185,000 + $145,000 |
Computation of Gross Profit - Revenue on completion - Brady Construction Company (Situation 1) | |||||
Year | Actual cost incurred (A) | Total cost incurred till date (B) | Total estimated Cost ( C ) |
Contract Price (D) |
Gross Profit |
2018 | $1,630,000 | $1,630,000 | $5,440,000 | $6,300,000 | $0 |
2019 | $2,520,000 | $4,150,000 | $5,440,000 | $6,300,000 | $0 |
2020 | $1,290,000 | $5,440,000 | $5,440,000 | $6,300,000 | $860,000 |
Computation of Gross Profit - Revenue on completion - Brady Construction Company (Situation 2) | |||||
Year | Actual cost incurred (A) | Total cost incurred till date (B) | Total estimated Cost ( C ) |
Contract Price (D) |
Gross Profit |
2018 | $1,630,000 | $1,630,000 | $5,440,000 | $6,300,000 | $0 |
2019 | $1,290,000 | $2,920,000 | $5,840,000 | $6,300,000 | $0 |
2020 | $2,920,000 | $5,840,000 | $5,840,000 | $6,300,000 | $460,000 |
Computation of Gross Profit - Revenue on completion - Brady Construction Company (Situation 3) | |||||
Year | Actual cost incurred (A) | Total cost incurred till date (B) | Total estimated Cost ( C ) |
Contract Price (D) |
Gross Profit |
2018 | $1,630,000 | $1,630,000 | $5,440,000 | $6,300,000 | $0 |
2019 | $2,520,000 | $4,150,000 | $6,690,000 | $6,300,000 | -$390,000 |
2020 | $2,640,000 | $6,790,000 | $6,790,000 | $6,300,000 | -$100,000 |
Computation of Gross Profit - Revenue on completion - Brady Construction Company (Situation 4) | |||||
Year | Actual cost incurred (A) | Total cost incurred till date (B) | Total estimated Cost ( C ) |
Contract Price (D) |
Gross Profit |
2018 | $630,000 | $630,000 | $5,040,000 | $6,300,000 | $0 |
2019 | $3,130,000 | $3,760,000 | $4,700,000 | $6,300,000 | $0 |
2020 | $1,260,000 | $5,020,000 | $5,020,000 | $6,300,000 | $1,280,000 |
Computation of Gross Profit - Revenue on completion - Brady Construction Company (Situation 5) | |||||
Year | Actual cost incurred (A) | Total cost incurred till date (B) | Total estimated Cost ( C ) |
Contract Price (D) |
Gross Profit |
2018 | $630,000 | $630,000 | $5,040,000 | $6,300,000 | $0 |
2019 | $3,130,000 | $3,760,000 | $6,300,000 | $6,300,000 | $0 |
2020 | $2,210,000 | $5,970,000 | $5,970,000 | $6,300,000 | $330,000 |
Computation of Gross Profit - Revenue on completion - Brady Construction Company (Situation 6) | |||||
Year | Actual cost incurred (A) | Total cost incurred till date (B) | Total estimated Cost ( C ) |
Contract Price (D) |
Gross Profit |
2018 | $630,000 | $630,000 | $6,485,000 | $6,300,000 | -$185,000 |
2019 | $3,130,000 | $3,760,000 | $6,630,000 | $6,300,000 | -$145,000 |
2020 | $3,100,000 | $6,860,000 | $6,860,000 | $6,300,000 | -$230,000 |
Gross Profit (Loss) Recognized | ||||||
Situation | Revenue Recognized over time | Revenue recognized upon completion | ||||
2018 | 2019 | 2020 | 2018 | 2019 | 2020 | |
1 | $257,684 | $398,382 | $203,934 | $0 | $0 | $860,000 |
2 | $257,684 | -$27,684 | $230,000 | $0 | $0 | $460,000 |
3 | $257,684 | -$647,684 | -$100,000 | $0 | -$390,000 | -$100,000 |
4 | $157,500 | $1,122,500 | $0 | $0 | $0 | $1,280,000 |
5 | $157,500 | -$157,500 | $330,000 | $0 | $0 | $330,000 |
6 | -$185,000 | -$145,000 | -$230,000 | -$185,000 | -$145,000 | -$230,000 |