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 (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.)
|
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 |