I am struggling to solve for the missing values. please provide guidance on how to solve

save HW Score: 85.1%, 17.02 of 20 pts core: 0 of 1 pt X E6A-27 (similar to) Consider the data of the following companies which use the periodic inventory system: (Click the icon to view the data.) Read the reguirements. Requirement 1. Supply the missing amounts for each of the following companies: 20 of 20 (20 complete) O Data Table Net Sales Revenue $ 103,000 $ (b) 90,000 79,000 Beginning Merchandise Inventory Net Cost of Purchases 62,000 $ 96,000 61 ,ooo Company Ash Net Sales Revenue $ 103,000 $ Beginning Merchandise Inventory Net Cost of Purchases Ending Merchandise Inventory 18,000 Cost of Goods Sold 19,000 $ 62,000 $ Gross Profit 40,000 Company Ash Elm Fir Oak 19,000 $ 22,000 (d) 13,000 print Ending Merchandise Inventory 18,000 (c) 27,000 4, 000 Cost of Goods Sold 92,000 64,000 (g) inter any number in the edit fields and then click Check Answer. parts remaining QI docx (10) .docx Done Gross Profit 40,000 41 ,OOO (e) 49,000 Show all