You "must" use Microsoft Excel in order to complete this problem.

Required:

Complete the requirements of the problem below assuming that Westgate Constructions contract with Santa Clara County does NOT qualify for revenue recognition over time.

Requirements:

1. Calculate the amount of revenue and gross profit to be recognized in each of the three years.

2. Prepare all necessary journal entries for each of the years (credit Cash, Materials, etc. for construction costs incurred).

3. Prepare a partial balance sheet for 2021 and 2022 showing any items related to the contract. Indicate whether any of the amounts shown are contract assets or contract liabilities.

4. Calculate the amount of revenue and gross profit to be recognized in each of the three years assuming the following costs incurred and costs to complete information:

5. Calculate the amount of revenue and gross profit to be recognized in each of the three years assuming the following costs incurred and costs to complete information:

In 2021 , the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,0 The road was completed in 2023 . Information related to the contract is as follows: Westgate recognizes revenue over time according to percentage of completion. \begin{tabular}{lccc} & 2021 & 2022 & \multicolumn{1}{c}{2023} \\ \hline Costs incurred during the year & $2,400,000 & $3,800,000 & $3,200,000 \\ Estimated costs to complete as of year-end & 5,600,000 & 3,100,000 & 0 \end{tabular} \begin{tabular}{llrrr} & & 2021 & 2022 & \multicolumn{1}{c}{2023} \\ \cline { 1 } \cline { 5 - 6 } Costs incurred during the year & & $2,400,000 & $3,800,000 & $3,900,000 \\ Estimated costs to complete as of year-end & & 5,600,000 & 4,100,000 & 0 \end{tabular} In 2021 , the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,0 The road was completed in 2023 . Information related to the contract is as follows: Westgate recognizes revenue over time according to percentage of completion. \begin{tabular}{lccc} & 2021 & 2022 & \multicolumn{1}{c}{2023} \\ \hline Costs incurred during the year & $2,400,000 & $3,800,000 & $3,200,000 \\ Estimated costs to complete as of year-end & 5,600,000 & 3,100,000 & 0 \end{tabular} \begin{tabular}{llrrr} & & 2021 & 2022 & \multicolumn{1}{c}{2023} \\ \cline { 1 } \cline { 5 - 6 } Costs incurred during the year & & $2,400,000 & $3,800,000 & $3,900,000 \\ Estimated costs to complete as of year-end & & 5,600,000 & 4,100,000 & 0 \end{tabular}