In: Accounting
Brady Construction Company contracted to build an apartment
complex for a price of $6,800,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,680 | 2,670 | 1,440 | 4,110 | 1,440 | — | ||||||
2 | 1,680 | 1,440 | 3,120 | 4,110 | 3,120 | — | ||||||
3 | 1,680 | 2,670 | 3,040 | 4,110 | 2,940 | — | ||||||
4 | 680 | 3,180 | 1,360 | 4,760 | 965 | — | ||||||
5 | 680 | 3,180 | 2,560 | 4,760 | 2,940 | — | ||||||
6 | 680 | 3,180 | 3,600 | 6,355 | 3,320 | — | ||||||
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.)
Answer is not complete.
|
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,680,000 | $1,680,000 | $5,790,000 | 29.02% | $6,800,000 | $1,973,057 | $1,973,057 | $293,057 | |
2019 | $2,670,000 | $4,350,000 | $5,790,000 | 75.13% | $6,800,000 | $5,108,808 | $3,135,751 | $465,751 | |
2020 | $1,440,000 | $5,790,000 | $5,790,000 | 100.00% | $6,800,000 | $6,800,000 | $1,691,192 | $251,192 | |
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,680,000 | $1,680,000 | $5,790,000 | 29.02% | $6,800,000 | $1,973,057 | $1,973,057 | $293,057 | |
2019 | $1,440,000 | $3,120,000 | $6,240,000 | 50.00% | $6,800,000 | $3,400,000 | $1,426,943 | -$13,057 | |
2020 | $3,120,000 | $6,240,000 | $6,240,000 | 100.00% | $6,800,000 | $6,800,000 | $3,400,000 | $280,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,680,000 | $1,680,000 | $5,790,000 | 29.02% | $6,800,000 | $1,973,057 | $1,973,057 | $293,057 | $1,973,057 - $1,680,000 |
2019 | $2,670,000 | $4,350,000 | $7,290,000 | 59.67% | $6,800,000 | $4,057,613 | $2,084,556 | -$783,057 | $6,800,000 - $7,290,000 - $293,057 |
2020 | $3,040,000 | $7,390,000 | $7,390,000 | 100.00% | $6,800,000 | $6,800,000 | $2,742,387 | -$100,000 | $6,800,000 - $7,390,000 - $293,057 + $783,057 |
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 | $680,000 | $680,000 | $5,440,000 | 12.50% | $6,800,000 | $850,000 | $850,000 | $170,000 | |
2019 | $3,180,000 | $3,860,000 | $4,825,000 | 80.00% | $6,800,000 | $5,440,000 | $4,590,000 | $1,410,000 | |
2020 | $1,360,000 | $5,220,000 | $5,220,000 | 100.00% | $6,800,000 | $6,800,000 | $1,360,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 | $680,000 | $680,000 | $5,440,000 | 12.50% | $6,800,000 | $850,000 | $850,000 | $170,000 | |
2019 | $3,180,000 | $3,860,000 | $6,800,000 | 56.76% | $6,800,000 | $3,860,000 | $3,010,000 | -$170,000 | |
2020 | $2,560,000 | $6,420,000 | $6,420,000 | 100.00% | $6,800,000 | $6,800,000 | $2,940,000 | $380,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 | $680,000 | $680,000 | $7,035,000 | 9.67% | $6,800,000 | $657,285 | $657,285 | -$235,000 | $6,800,000 - 7,035,000 |
2019 | $3,180,000 | $3,860,000 | $7,180,000 | 53.76% | $6,800,000 | $3,655,710 | $2,998,425 | -$145,000 | $6,800,000 - 7,180,000 + $235,000 |
2020 | $3,600,000 | $7,460,000 | $7,460,000 | 100.00% | $6,800,000 | $6,800,000 | $3,144,290 | -$280,000 | $6,800,000 - 7,460,000 + $235,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,680,000 | $1,680,000 | $5,790,000 | $6,800,000 | $0 |
2019 | $2,670,000 | $4,350,000 | $5,790,000 | $6,800,000 | $0 |
2020 | $1,440,000 | $5,790,000 | $5,790,000 | $6,800,000 | $1,010,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,680,000 | $1,680,000 | $5,790,000 | $6,800,000 | $0 |
2019 | $1,440,000 | $3,120,000 | $6,240,000 | $6,800,000 | $0 |
2020 | $3,120,000 | $6,240,000 | $6,240,000 | $6,800,000 | $560,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,680,000 | $1,680,000 | $5,790,000 | $6,800,000 | $0 |
2019 | $2,670,000 | $4,350,000 | $7,290,000 | $6,800,000 | -$490,000 |
2020 | $3,040,000 | $7,390,000 | $7,390,000 | $6,800,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 | $680,000 | $680,000 | $5,440,000 | $6,800,000 | $0 |
2019 | $3,180,000 | $3,860,000 | $4,825,000 | $6,800,000 | $0 |
2020 | $1,360,000 | $5,220,000 | $5,220,000 | $6,800,000 | $1,580,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 | $680,000 | $680,000 | $5,440,000 | $6,800,000 | $0 |
2019 | $3,180,000 | $3,860,000 | $6,800,000 | $6,800,000 | $0 |
2020 | $2,560,000 | $6,420,000 | $6,420,000 | $6,800,000 | $380,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 | $680,000 | $680,000 | $7,035,000 | $6,800,000 | -$235,000 |
2019 | $3,180,000 | $3,860,000 | $7,180,000 | $6,800,000 | -$145,000 |
2020 | $3,600,000 | $7,460,000 | $7,460,000 | $6,800,000 | -$280,000 |
Gross Profit (Loss) Recognized | ||||||
Situation | Revenue Recognized over time | Revenue recognized upon completion | ||||
2018 | 2019 | 2020 | 2018 | 2019 | 2020 | |
1 | $293,057 | $465,751 | $251,192 | $0 | $0 | $1,010,000 |
2 | $293,057 | -$13,057 | $280,000 | $0 | $0 | $560,000 |
3 | $293,057 | -$783,057 | -$100,000 | $0 | -$490,000 | -$100,000 |
4 | $170,000 | $1,410,000 | $0 | $0 | $0 | $1,580,000 |
5 | $170,000 | -$170,000 | $380,000 | $0 | $0 | $380,000 |
6 | -$235,000 | -$145,000 | -$280,000 | -$235,000 | -$145,000 | -$280,000 |