if the answer is put in an organised excel table manner it would be greatly appreciated.

Derby Transportation Inc. designs and builds trains for rail networks across Canada. The company, which is publicly traded, has an October 31 year end. On March 15, 2020, Derby Transportation signed a contract with OM Corridor Corp. to design and build 10 high-speed trains, with each train consisting of seven passenger cars. The high-speed train will operate between Ottawa and Montreal. The following events took place in 2020 in relation to the contract: 2. 3. March 15: At the signing ceremony, officials from Derby and OM sign a contract, which is for $9,920,000. Derby is to design, manufacture, and deliver the 10 trains to OM's train yards in Montreal. Derby's management estmates that the design component of the contract would be valued at $1,641,370 if contracted for separately, while the manufacturing of the ten trains would be valued at a total $9,228,630 if they were purchased separately. Derby agreed to provide a two-year assurance-type warranty for the trains, and the company's management estimates that the warranty claims would total $500,000 based on experience. OM agrees to pay a $5,180,000 deposit within 14 days of signing the contract and to pay the balance within 45 days of the trains receiving final approval and certification from the Transportation Safety Board. March 29: OM pays the deposit specified in the contract. May 9: Derby's engineering staff complete the train design and it is approved by officials from OM as well as the Transportation Safety Board. August 1: Derby completes construction of the 10 trains. September 1: The 10 trains are delivered according to the contract to OM's Montreal train yards. September 30: After testing for safety compliance, the trains receive final approval from OM and the Transportation Safety Board and are certified to carry passengers. November 15: OM pays the balance owing on the contract. 4. 5. 6. 7. Revenue recognized on ta $ Date Account Titles and Explanation Debit Credit Sept. 1 (To record sales revenue) (To accrue warranty lability)