1.Should be prepared using Excel.

2.Should incorporate any necessary formulas to calculate the correct solution.

3.Should use proper formatting so that the solution is visually appealing.Think a document you would prepare to present to your boss.

*E18.35 (LO 5) Excel (Gross Profit on Uncompleted Contract) On April 1, 2020, Dougherty Inc. entered into a cost plus fixed fee contract to construct an electric generator for Altom Corporation. At the contract date, Dougherty estimated that it would take 2 years to complete the project at a cost of $2,000,000. The fixed fee stipulated in the contract is $450,000. Dougherty appropriately accounts for this contract under the percentage-of-completion method. During 2020, Dougherty incurred costs of $800,000 related to the project. The estimated cost at December 31, 2020, to complete the contract is $1,200,000. Altom was billed $600,000 under the contract. Instructions Prepare a schedule to compute the amount of gross profit to be recognized by Dougherty under the con- tract for the year ended December 31, 2020. Show supporting computations in good form