Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please look at my excel spreadsheet and the result from my homework. Why did get the red marks for the answers below? I can't figure

Please look at my excel spreadsheet and the result from my homework. Why did get the red marks for the answers below? I can't figure out what I did wrong.

image text in transcribedimage text in transcribedimage text in transcribed

m. Brady Construction Company contracted to build an apartment complex for a price of $6,500,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. 3 points 2019 Costs Incurred During Year Situation 2018 2020 1,650 2,580 1,350 2 1,650 1,350 3,000 3 1,650 2,580 2,800 4 650 3,150 1,300 5 650 3,150 2,350 6 650 3,150 3.300 Estimated Costs to Complete (As of the End of the Year) 2018 2019 2020 3,930 1,350 3.930 3.000 3,930 2,700 4.550 950 4,550 2,700 6,055 3,050 Required: Complete the following table. (Do not round intermediate calculations. Enter your answers in dollars. (For example, enter 500,000 rather than 500. Round your final answers to the nearest whole dollar. Negative amounts should be indicated by a minus sign.) Answer is complete but not entirely correct. Gross Profit (Loss) Recognized Revenue Recognized Over Time Revenue Recognized Upon Completion 2018 2019 2020 2018 2019 2020 Situation 1 2 3 $ 425,376 $ 222,581 272,043 0 0$ 920,000 272,043 (22,043) 250,000 0 0 500,000 272,043 (534,511) X (267,532) X 0 (430,000) (100,000) 162,500 1,237,500 0 0 0 1,400,000 162,500 (162,500) 350,000 0 0 350,000 (19,873) X (174,287) (405,839) X (205,000) (350,000) X (250,000) 4 5 6 Revenue Recognized Over Time Year 1 Previous Year 1 2 Cost Incurred 1,650,000 1,650,000 1,650,000 650,000 650,000 650,000 Actual Costs 1,650,000 1,650,000 1,650,000 650,000 650,000 650,000 Total Estimated Cost Incurred 5,580,000 5,580,000 5,580,000 5,200,000 5,200,000 6,705,000 Estimate 3,930,000 3,930,000 3,930,000 4,550,000 4,550,000 6,055,000 3 Percentage-of- Completion 29.5699% 29.5699% 29.5699% 12.5000% 12.5000% 9.6943% Gross Margin (Total Est. Costs - Contract Gross Price) Profit/Loss 920,000 272,043 920,000 272,043 920,000 272,043 1,300,000 162,500 1,300,000 162,500 (205,000) (19,873) Contract Price/Revenue 6,500,000 6,500,000 6,500,000 6,500,000 6,500,000 6,500,000 4 5 6 Year 2 Cost Incurred 1 2,580,000 2 1,350,000 3 2,580,000 4 3,150,000 5 3,150,000 6 3,150,000 Previous Year 1,650,000 1,650,000 1,650,000 650,000 650,000 650,000 Actual Costs 4,230,000 3,000,000 4,230,000 3,800,000 3,800,000 3,800,000 Estimate 1,350,000 3,000,000 2,700,000 950,000 2,700,000 3,050,000 Total Estimated Cost Incurred 5,580,000 6,000,000 6,930,000 4,750,000 6,500,000 6,850,000 Percentage-of- Completion 75.8065% 50.0000% 61.0390% 80.0000% 58.4615% 55.4745% Contract Price/Revenue 6,500,000 6,500,000 6,500,000 6,500,000 6,500,000 6,500,000 Gross Margin to date (Total Est. Costs - Contract To date Gross Gross Profit for Year 2 Price) Profit/Loss (Subtrac Year 1) 920,000 697,419 425,376 500,000 250,000 (22,043) (430,000) (262,468) (534,511) 1,750,000 1,400,000 1,237,500 (162,500) (350,000) (194,161) (174,287) Year 3 Estimate Cost Incurred 1 1,350,000 2 3,000,000 3 2,800,000 4 1,300,000 5 2,350,000 6 3,300,000 Previous Year 4,230,000 3,000,000 4,230,000 3,800,000 3,800,000 3,800,000 Actual Costs 5,580,000 6,000,000 7,030,000 5,100,000 6,150,000 7,100,000 Total Estimated Cost Incurred 5,580,000 6,000,000 7,030,000 5,100,000 6,150,000 7,100,000 Percentage-of- Completion 100.0000% 100.0000% 100.0000% 100.0000% 100.0000% 100.0000% Contract Price/Revenue 6,500,000 6,500,000 6,500,000 6,500,000 6,500,000 6,500,000 Gross Margin to date (Total Est. Costs - Contract To date Gross Price) Profit/Loss 920,000 920,000 500,000 500,000 (530,000) (530,000) 1,400,000 1,400,000 350,000 350,000 (600,000) (600,000) Gross Profit for Year 222,581 250,000 (267,532) - 350,000 (405,839) Revenue Upon Completion Year 1 Previous Year Cost Incurred 1 1,650,000 2 1,650,000 3 1,650,000 4 650,000 5 650,000 6 650,000 Actual Costs 1,650,000 1,650,000 1,650,000 650,000 650,000 650,000 Estimate 3,930,000 3,930,000 3,930,000 4,550,000 4,550,000 6,055,000 Total Estimated Cost Incurred 5,580,000 5,580,000 5,580,000 5,200,000 5,200,000 6,705,000 Gross Margin Contract (Total Est. Costs - Contract Price/Revenue Price) 6,500,000 920,000 6,500,000 920,000 6,500,000 920,000 6,500,000 1,300,000 6,500,000 1,300,000 6,500,000 (205,000) Year 2 1 2 3 3 Cost Incurred Previous Year Actual Costs 2,580,000 1,650,000 4,230,000 1,350,000 1,650,000 3,000,000 2,580,000 1,650,000 4,230,000 3,150,000 650,000 3,800,000 3,150,000 650,000 3,800,000 3,150,000 650,000 3,800,000 Estimate 1,350,000 3,000,000 2,700,000 950,000 2,700,000 3,050,000 Total Estimated Cost Incurred 5,580,000 6,000,000 6,930,000 4,750,000 6,500,000 6,850,000 Gross Margin to date Contract (Total Est. Costs - Contract Price/Revenue Price) 6,500,000 920,000 6,500,000 500,000 6,500,000 (430,000) 6,500,000 1,750,000 6,500,000 6,500,000 (350,000) Gross Profit/Loss for Year 2 920,000 500,000 (430,000) 1,750,000 4 5 6 (350,000) Year 3 Estimate 1 2 Cost Incurred 1,350,000 3,000,000 2,800,000 1,300,000 2,350,000 3,300,000 Previous Year 4,230,000 3,000,000 4,230,000 3,800,000 3,800,000 3,800,000 3 Total Estimated Cost Incurred 5,580,000 6,000,000 7,030,000 5,100,000 6,150,000 7,100,000 Actual Costs 5,580,000 6,000,000 7,030,000 5,100,000 6,150,000 7,100,000 Gross Margin to Date Contract (Total Est. Costs - Contract Price/Revenue Price) Gross Profit/Loss for Year 3 6,500,000 920,000 920,000 6,500,000 500,000 500,000 6,500,000 (530,000) (100,000) 6,500,000 1,400,000 1,400,000 6,500,000 350,000 350,000 6,500,000 (600,000) (250,000) 4 5 6

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions