In: Accounting
Brady Construction Company contracted to build an apartment complex for a price of $5,200,000. Construction began in 2021 and was completed in 2023. 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 2021 2022 2023 2021 2022 2023 1 1,520 2,190 960 3,150 960 — 2 1,520 960 2,480 3,150 2,480 — 3 1,520 2,190 1,760 3,150 1,660 — 4 520 3,020 1,040 3,640 885 — 5 520 3,020 1,440 3,640 1,660 — 6 520 3,020 2,000 4,800 1,880 — Required: Complete the following table.
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) | |
2021 | $1,520,000 | $1,520,000 | $4,670,000 | 32.55% | $5,200,000 | $1,692,505 | $1,692,505 | $172,505 | |
2022 | $2,190,000 | $3,710,000 | $4,670,000 | 79.44% | $5,200,000 | $4,131,049 | $2,438,544 | $248,544 | |
2023 | $960,000 | $4,670,000 | $4,670,000 | 100.00% | $5,200,000 | $5,200,000 | $1,068,951 | $108,951 | |
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) | |
2021 | $1,520,000 | $1,520,000 | $4,670,000 | 32.55% | $5,200,000 | $1,692,505 | $1,692,505 | $172,505 | |
2022 | $960,000 | $2,480,000 | $4,960,000 | 50.00% | $5,200,000 | $2,600,000 | $907,495 | -$52,505 | |
2023 | $2,480,000 | $4,960,000 | $4,960,000 | 100.00% | $5,200,000 | $5,200,000 | $2,600,000 | $120,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) | |
2021 | $1,520,000 | $1,520,000 | $4,670,000 | 32.55% | $5,200,000 | $1,692,505 | $1,692,505 | $172,505 | $1,692,505 - $1,520,000 |
2022 | $2,190,000 | $3,710,000 | $5,370,000 | 69.09% | $5,200,000 | $3,592,551 | $1,900,046 | -$342,505 | $5,200,000 - $5,370,000 - $172,505 |
2023 | $1,760,000 | $5,470,000 | $5,470,000 | 100.00% | $5,200,000 | $5,200,000 | $1,607,449 | -$100,000 | $5,200,000 - $5,470,000 - $172,505 + $342,505 |
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) | |
2021 | $520,000 | $520,000 | $4,160,000 | 12.50% | $5,200,000 | $650,000 | $650,000 | $130,000 | |
2022 | $3,020,000 | $3,540,000 | $4,425,000 | 80.00% | $5,200,000 | $4,160,000 | $3,510,000 | $490,000 | |
2023 | $1,040,000 | $4,580,000 | $4,580,000 | 100.00% | $5,200,000 | $5,200,000 | $1,040,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) | |
2021 | $520,000 | $520,000 | $4,160,000 | 12.50% | $5,200,000 | $650,000 | $650,000 | $130,000 | |
2022 | $3,020,000 | $3,540,000 | $5,200,000 | 68.08% | $5,200,000 | $3,540,000 | $2,890,000 | -$130,000 | |
2023 | $1,440,000 | $4,980,000 | $4,980,000 | 100.00% | $5,200,000 | $5,200,000 | $1,660,000 | $220,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) | |
2021 | $520,000 | $520,000 | $5,320,000 | 9.77% | $5,200,000 | $508,271 | $508,271 | -$120,000 | $5,200,000 - 5,320,000 |
2022 | $3,020,000 | $3,540,000 | $5,420,000 | 65.31% | $5,200,000 | $3,396,310 | $2,888,039 | -$100,000 | $5,200,000 - 5,420,000 + $120,000 |
2023 | $2,000,000 | $5,540,000 | $5,540,000 | 100.00% | $5,200,000 | $5,200,000 | $1,803,690 | -$120,000 | $5,200,000 - 5,540,000 + $120,000 + $100,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 |
2021 | $1,520,000 | $1,520,000 | $4,670,000 | $5,200,000 | $0 |
2022 | $2,190,000 | $3,710,000 | $4,670,000 | $5,200,000 | $0 |
2023 | $960,000 | $4,670,000 | $4,670,000 | $5,200,000 | $530,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 |
2021 | $1,520,000 | $1,520,000 | $4,670,000 | $5,200,000 | $0 |
2022 | $960,000 | $2,480,000 | $4,960,000 | $5,200,000 | $0 |
2023 | $2,480,000 | $4,960,000 | $4,960,000 | $5,200,000 | $240,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 |
2021 | $1,520,000 | $1,520,000 | $4,670,000 | $5,200,000 | $0 |
2022 | $2,190,000 | $3,710,000 | $5,370,000 | $5,200,000 | -$170,000 |
2023 | $1,760,000 | $5,470,000 | $5,470,000 | $5,200,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 |
2021 | $520,000 | $520,000 | $4,160,000 | $5,200,000 | $0 |
2022 | $3,020,000 | $3,540,000 | $4,425,000 | $5,200,000 | $0 |
2023 | $1,040,000 | $4,580,000 | $4,580,000 | $5,200,000 | $620,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 |
2021 | $520,000 | $520,000 | $4,160,000 | $5,200,000 | $0 |
2022 | $3,020,000 | $3,540,000 | $5,200,000 | $5,200,000 | $0 |
2023 | $1,440,000 | $4,980,000 | $4,980,000 | $5,200,000 | $220,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 |
2021 | $520,000 | $520,000 | $5,320,000 | $5,200,000 | -$120,000 |
2022 | $3,020,000 | $3,540,000 | $5,420,000 | $5,200,000 | -$100,000 |
2023 | $2,000,000 | $5,540,000 | $5,540,000 | $5,200,000 | -$120,000 |
Gross Profit (Loss) Recognized | ||||||
Situation | Revenue Recognized over time | Revenue recognized upon completion | ||||
2021 | 2022 | 2023 | 2021 | 2022 | 2023 | |
1 | $172,505 | $248,544 | $108,951 | $0 | $0 | $530,000 |
2 | $172,505 | -$52,505 | $120,000 | $0 | $0 | $240,000 |
3 | $172,505 | -$342,505 | -$100,000 | $0 | -$170,000 | -$100,000 |
4 | $130,000 | $490,000 | $0 | $0 | $0 | $620,000 |
5 | $130,000 | -$130,000 | $220,000 | $0 | $0 | $220,000 |
6 | -$120,000 | -$100,000 | -$120,000 | -$120,000 | -$100,000 | -$120,000 |