i am posting this question third time. 2 time i got wrong answer and way also. please i need answer according to to given exercise exapmle ASAP.

Module 6 (Chapter 6) Assignment W V2 Q 2 The Hermetic Company had a fire March 15, 2022, that destroyed all of its inventory. During the last five years, the company's gross profit rate has averaged 60%. The following information, up to March 15th, was obtained from the accounting records: January 1 beginning inventory Purchases Purchase returns Transportation-In Sales Sales discounts $220,000 580,000 24,000 8,600 860,000 9,500 13,000 Sales returns Instructions: Use the gross profit method to prepare an estimate of the company's March 15th inventory lost due to the fire. Use the data entry form located in the Learn Assessment Dropbox. *EXERCISE 6.17 Net sales ($90,000 - $1,500 - $700). Less: Estimated gross profit (40% * $87,800) Estimated cost of goods sold.. $87,800 35.120 $52,680 $25,000 Beginning inventory. Cost of goods purchased ($51,200 - $2,400 - $1,300 + $2,200) Cost of goods available for sale. Less: Estimated cost of goods sold. Estimated cost of merchandise inventory 49.700 74,700 52.680 $22.020 LO8 BT: AP Difficulty: M Time: 20 min. AACSB: None CPA: cpa-t001 CM: Reporting