In: Accounting
in 2021, the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,000. The road was completed in 2023. Information related to the contract is as follows: 2021 2022 2023 Cost incurred during the year $ 2,044,000 $ 2,628,000 $ 2,890,800 Estimated costs to complete as of year-end 5,256,000 2,628,000 0 Billings during the year 2,170,000 2,502,000 5,328,000 Cash collections during the year 1,885,000 2,600,000 5,515,000 Westgate recognizes revenue over time according to percentage of completion.
1. Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years. ( Do not round intermediate calculation. Loss amounts should be indicated with a minus sign.)
2021 |
2022 |
2023 |
|
Revenue |
$ 2,800,000.00 |
$ 3,013,315 |
$ 4,186,685 |
Gross Profit (Loss) |
$ 756,000.00 |
$ (955,000.00) |
$ 115,000.00 |
Working |
2021 |
2022 |
2023 |
|
A |
Contract Price |
$ 10,000,000.00 |
$ 10,000,000.00 |
$ 10,000,000.00 |
B |
Cost Incurred to Date |
$ 2,044,000.00 |
$ 5,929,000.00 [2044000+3885000] |
$ 10,084,000.00 [5929000+4155000] |
C |
Estimated cost yet to be incurred to complete the contract |
$ 5,256,000.00 |
$ 4,270,000.00 |
$ - |
D = B+C |
Total Cost |
$ 7,300,000.00 |
$ 10,199,000.00 |
$ 10,084,000.00 |
E = (B/D) x 100 |
% of Completion |
28.00% |
58.13% |
100.00% |
F = A x E |
Revenue to date |
$ 2,800,000.00 |
$ 5,813,315.03 |
$ 10,000,000.00 |
G |
Revenue of Previous year |
$ - |
$ 2,800,000.00 |
$ 5,813,315.03 |
H = F - G |
Net Revenue this year |
$ 2,800,000.00 |
$ 3,013,315.03 |
$ 4,186,684.97 |
I (=B) |
Cost to date |
$ 2,044,000.00 |
$ 5,929,000.00 |
$ 10,084,000.00 |
J |
Cost to date of previous year |
$ - |
$ 2,044,000.00 |
$ 5,929,000.00 |
K = I - J |
Net Cost for the year |
$ 2,044,000.00 |
$ 3,885,000.00 |
$ 4,155,000.00 |
L = A - D |
Estimated Gross Profit (Loss) |
$ 2,700,000.00 |
$ (199,000.00) |
$ (84,000.00) |
M |
Gross Profit (Loss) to be recognised |
$ 756,000.00 |
$ (955,000.00) |
$ 115,000.00 |