Question

In: Accounting

Problem 5-10 Part 4 4. Calculate the amount of revenue and gross profit (loss) to be...

Problem 5-10 Part 4 4. Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years assuming the following costs incurred and costs to complete information. (Do not round intermediate calculations and round your final answers to the nearest whole dollar amount. Loss amounts should be indicated with a minus sign.)

2018 2019 2020
Cost incurred during the year $ 2,184,000 $ 3,860,000 $ 3,260,000
Estimated costs to complete as of year-end 5,616,000 3,160,000 0
2018 2019 2020
Revenue $2,800,000
Gross profit (loss) $616,000

UPDATE: Total Contract price is $10,000,000

Solutions

Expert Solution

  • All working forms part of the answer
  • Answers

2018

2019

2020

Revenue

$                2,800,000.00

$               3,766,710

$                    3,433,290

Gross Profit (Loss)

$                   616,000.00

$                   180,000.00

$                     (100,000.00)
  • Workings

Working

2018

2019

2020

A

Contract Price

$             10,000,000.00

$             10,000,000.00

$                  10,000,000.00

B

Cost Incurred to Date

$                2,184,000.00

$               6,044,000.00

$                    9,304,000.00

C

Estimated cost yet to be incurred to complete the contract

$                5,616,000.00

$               3,160,000.00

$                                         -  

D = B+C

Total Cost

$                7,800,000.00

$               9,204,000.00

$                    9,304,000.00

E = (B/D) x 100

% of Completion

28.00%

65.67%

100.00%

F = A x E

Revenue to date

$                2,800,000.00

$               6,566,710.13

$                  10,000,000.00

G

Revenue of Previous year

$                                     -  

$               2,800,000.00

$                    6,566,710.13

H = F - G

Net Revenue this year

$                2,800,000.00

$               3,766,710.13

$                    3,433,289.87

I (=B)

Cost to date

$                2,184,000.00

$               6,044,000.00

$                    9,304,000.00

J

Cost to date of previous year

$                                     -  

$               2,184,000.00

$                    6,044,000.00

K = I - J

Net Cost for the year

$                2,184,000.00

$               3,860,000.00

$                    3,260,000.00

L = A - D

Estimated Gross Profit (Loss)

$                2,200,000.00

$                   796,000.00

$                        696,000.00

M

Gross Profit (Loss) to be recognised

$                   616,000.00

$                   180,000.00

$                     (100,000.00)

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years.
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,610,000   $ 3,162,000   $ 2,230,800   Estimated costs to complete as of year-end   6,390,000     2,028,000     0   Billings during the year   2,100,000     3,672,000     4,228,000...
Calculate the amount of revenue and gross profit (loss) 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,000. The road was completed in 2023. Information related to the contract is as follows:   2021 2022 2023 Cost incurred during the year $ 2,610,000   $ 3,162,000   $ 2,230,800   Estimated costs to complete as of year-end   6,390,000     2,028,000     0   Billings during the year   2,100,000     3,672,000     4,228,000...
Profit and Loss Statement 2018 Revenue 34,290 percent of growth 0.0% Gross Profit 34,290 Gross Margin...
Profit and Loss Statement 2018 Revenue 34,290 percent of growth 0.0% Gross Profit 34,290 Gross Margin 100% SGA Costs (2,500) EBITDA 31,790 EBITDA Margin 92.7% Depreciation (7,500) % of Sales -21.9% EBIT 24,290 EBIT Margin 70.8% Interest (2,500) % of Sales -7.3% EBIT 21,790 EBIT Margin 63.5% Net Income 21,790 Net Income Margin 63.5% Balance Sheet 2017 2018 Cash 9,000 12,000 Inventory 0 0 A/R    0 3,179 Current Assets    9,000 15,179 Fixed Assets 747,300 763,800 Total Assets   ...
Gross profit $ and gross profit % for Walgreens Gross profit for 2018 = Revenue –...
Gross profit $ and gross profit % for Walgreens Gross profit for 2018 = Revenue – Cost of Goods Sold = 131,537 – 100,745 = $30,792 Gross profit % for 2018 = Gross profit / total sales * 100 = $30,792 / $131,537 *100 = 23.41% Gross profit for 2017 = 118,214 – 89,052 = $29,162 Gross profit % for 2017 = $29,162 / $118,214 *100 = 24,67% Gross profit for 2016 = 117,351 – 87,477 = $29,874 Gross profit...
Problem 6-2A Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four...
Problem 6-2A Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four inventory methods (LO6-3, 6-4, 6-5) [The following information applies to the questions displayed below.] Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost March 1 Beginning inventory 20 $ 250 $ 5,000 March 5 Sale ($400 each) 15 March...
Problem 6-2A Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four...
Problem 6-2A Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four inventory methods (LO6-3, 6-4,6-5) [The following information applies to the questions displayed below.] Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost March 1 Beginning Inventory 20 $215 $4,300 March 5 Sale ($330 each) 15 March 9 Purchase 10...
Problem 6-2B Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four...
Problem 6-2B Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four inventory methods (LO6-3, 6-4, 6-5) [The following information applies to the questions displayed below.] Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the month of August. Pete’s Tennis Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost August 1 Beginning inventory 8 $ 152 $ 1,216 August 4 Sale ($185 each) 5 August...
Its gross profit(loss) equals
A company has sales of $7,22,200 and cost of goods sold of $2,89,200.Its gross profit (loss) equals (a) $1,011,240 (b) $2,89,200 (c) $7,22,200 (d) $4,33,000  
what is the amount of the gross profit
During the current year, merchandise is sold for $3,15,800 cash and $12,25,000 on account.The cost of the merchandise sold is $8,75,000.What is the amount of the gross profit
What is the amount of the gross profit?
During the current year, merchandise is sold for $315,800 cash and $1,225,000 on account. The cost of the merchandise sold is $875,000. What is the amount of the gross profit?
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT