1 ald Reference Sf Purchases Cost of Goods Sold Desk lamps: Total Unit Unit ad 1S tre Total Cost Cost Cost Date Quantity Quantity Cost Sep 30 Inventory on Hand Unit Total Quantity Cost Cost 2,200 $ 45 8,800 2,200 $ 45 8,800 3.000 4 $ 12,000 700 S 4 $ 2,800 3,000 $ 4 $ 12,000 2.700 $ 45 10,800 Oct 1 3,000 $ 4 $ 12,000 bala 4 $ 1,500 5 6,000 15 ford Nov. 1 700 S for til foc 4 $ 2,800 45 1,200 300S 2.700 45 10,800 5 3,000 $ 7 $ 21.000 itfiel Print Dono OUT 1 Reference 4 S 12.000 3,000 $ 2.700 Nov. 1 700 S 4 $ 10,800 4 S 4S 2.800 1,200 300 $ 5 3,000 $ 7 $ 21,000 15 1,600 $ 4 $ 6,400 2,700$ 3,000 $ 1,100 $ 3,000 $ 2,000 $ 4 S 10.800 7 $ 21,000 4 $ 4,400 7 $ 21,000 7$ 14,000 Dec 27 4 $ 1,100 $ 1,000 S 4,400 7,000 7 $ 31 16 S 1.984 $ 7$ 112 $ 27912 7 $ S 13,888 13,888 $ 33,000 Totals 6,000 6,216 1,984 Print Done 1 ar i Reference hc Cost of Goods Sold Purchases Table lamps: Total Unit Unit Total Cost Cost Quantity Cost Quantity Cost Date Inventory on Hand Unit Total Quantity Cost Cost 4,200 $ 21 $ 88,200 4,200 $ 21 $ 88,200 9,500 $ 21 S 199,500 8,700 $ 21 S 182,700 Sep 30 ir Oct. 1 9,500 $ 21 $ 199,500 12 4,200 $ 800 $ 4,500 $ 21 $ 88,200 21 $ 16,800 21 $ 94,500 4,200 $ 21 S 88,200 28 21 $ 4,200 $ 88,200 Nov. 5 12,000 $ 24 $ 288,000 Print Done - i Reference 800 S 21 $ 16,800 21 $ 94,500 21 $ 4,200 $ 88,200 4,500 $ 28 Nov. 5 12,000 $ 24 $ 288,000 21 $ 50,400 4,200 $ 12,000 $ 1,800 $ 12,000 $ 6,200 $ 21 $ 88,200 24 $ 288,000 21 $ 37,800 24 $ 288,000 24 $ 148,800 2,400 $ 18 Dec. 27 1,800 $ 5,800 $ 9 $ 21 $ 37,800 24 $ 139,200 24 216 $ 427,116 6,191 $ 31 24 $ 148,584 $ 148,584 $ 487,500 Totals 6,191 21,500 19,509 Print Done i Reference Floor lamps: Purchases Unit Total Cost Cost of Goods Sold Unit Total Quantity Cost Cost Quantity Cost Date Sep. 30 Oct 1 1,500 $ 26 $ 39,000 Inventory on Hand Unit Total Quantity Cost Cost 1,600 $ 29 $ 46,400 1,600 $ 29 $ 46,400 1,500 $ 26 S 39,000 500 $ 29 $ 14,500 1,500 $ 26 39,000 500 $ 29 $ 14,500 1,500 $ 26 S 39,000 3,000 $ 28 $ 84,000 28 1,100 $ 29 $ 31,900 Nov. 5 3,000 $ 28 $ 84,000 Print Done Reference Sep. 30 Oct. 1 1,500 $ 26 $ 39,000 28 1,100 $ 29 $ 31,900 1,600 $ 1,600 $ 1,500 $ 500 $ 1,500 $ 500S 1,500 $ 3,000 $ 100 $ 3,000 $ Nov 5 3,000 $ 28 S 84,000 29 $ 46,400 29 s 46,400 265 39,000 29 s 14,500 26 $ 39,000 29 $ 14,500 26 s 39,000 28 $ 84,000 26 $ 2,600 28 $ 84,000 S 86,600 18 500 $ 1,400 $ 29 $ 14,500 26 S 36,400 $ 82,800 Totals 4,500 $ 123,000 3,000 3.100 Print Done P Pearson First, complete the summary Review the perpetual record for desk lamps 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 Dollar Number Dollar Number Dollar Number of lamps Amount of lamps Amount of lamps Amount Beginning Balance Add: Purchases Less: COGS Ending Balance