Requirement 7. Provide a summary for the month, in both units and dollars, of the change in inventory for each iter. Does the sum of the ending balances in the inventory records match the balance in ledger? If not, review the transactions to find your error First, complete the summary Review the perpetual record for desklame you prepared above Review the perpetual record for table lamps you prepared above Review the perpetual record for floor lamps you prepared above Desk Lamps Table Lamps Floor Lamps Number Dollar Number Dollar Number Dollar of lamps Amount of lamps Amount of lamps Amount Beginning Balance Add: Purchases Less: COGS Ending Balance Enter any number in the edit fields and then click Check Answer px?homeworkid-574711975&questionid=1&flushed=false&cid=6170870¢erwin-yes oject 1 of 1 (1 complete) blar ang Reference sach n.) fo Desk lamps: Purchases Unit Cost Total Cost Cost of Goods Sold Unit Total Quantity Cost Cost Date Quantity Sep 30 Oct. 1 2,500 $ 5 $ 12,500 Inventory on Hand Unit Total Quantity Cost Cost 1.800 S 10 $ 18,000 1,800 $ 10 $ 18,000 2,500 $ 5$ 12.500 1,300 $ 101$ 13,000 2,500 $ 5$ 12.500 2,300 $ 5 $ 11,500 15 500 $ 10 $ 5,000 bale in TO Nov. 1 1,300 $ 200 $ 10 $ 13,000 5$ 1,000 5 2,500 5 B/S 20.000 2,300 $ 50 $ 11,500 15 1,500 $ 5 $ 7,500 2,500 $ 800 $ 2,500 $ 1,500 $ 8$ 20,000 5$ 4,000 B$ 20,000 n Dec. 27 8$ 12.000 800 $ 1,000 $ 25 $ 5$ 4,000 8 $ 8,000 8 $ 200 $ 38,700 31 1,475 5 BS 11,800 11,800 $ Totals $ 32,500 5,000 5,325 1,475 Print Done Clear All i Reference lamg sactic Table lamps: Purchases Cost of Goods Sold Unit Total Unit Total Cost Cost Date Quantity Sep. 30 Quantity Cost Cost Inventory on Hand Unit Total Quantity Cost Cost 3,400 $ 19 $ 64,600 3,400 $ 19 $ 64.600 9,500 $ 24 $ 228,000 7,900 $ 24 $ 189,600 Oct. 1 9,500 $ 24 $ 228.000 12 3,400 $ 19 $ 64,600 balan 1.600 $ 24 $ 38,400 28 4,500 $ 24 $ 108,000 3,400 $ 24 $ 81,600 Nov. 5 12,000 $ 25 $ 300,000 24 $ 81,600 3.400 $ 12,000 $ 25 $ 300,000 18 1,900 $ 24 $ 45,600 1,500 $ 12,000 $ 241 $ 36,000 25 $ 300,000 25 $ 147,500 Dec. 27 1,500 $ 24 $ 36,000 5.900 $ 6,100 $ 25 $ 152,500 31 8 $ 25$ 200 5,892 $ 25 $ 147,300 $ 147,300 Totals $ 528,000 21,500 $ 445,300 19,008 5,892 Print Done Clear All MacBook Reference - Floor lamps: Purchases Cost of Goods Sold Inventory on Hand Unit Total Unit Unit Total Total Cost Date Quantity Cost Cost Quantity Cost Cost Cost 32 $ Sep. 30 Oct. 1 4,500 $ 20 $ 90,000 32 $ 70,400 70.400 90,000 bala 201$ 28 1,300 $ 321 $ 41,600 Quantity 2,200 $ 2,200 $ 4,500 $ 9001$ 4,500 $ 900 $ 4,500 $ 9,000 $ 2,900 $ 9,000 $ Nov. 5 9,000 $ 21 $ 189,000 32 $ 28,800 201$ 90,000 32 $ 28,800 20$ 90,000 21 $ 189,000 20 $ 58,000 21 $ 189,000 $ 247,000 18 900 $ 1,600 $ 32 $ 28,800 20 $ 32,000 $ 102,400 $ 279,000 Totals 13,500 3,800 11,900 Print Done