Desk lamps: Inventory on Hand Purchases Cost of Goods Sold Total Unit Total Unit Total Unit Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost 2,000 S 9 $ Sep. 30 18,000 7 S 28,000 18,000 4,000 S 2,000 $ 9 $ Oct. 1 4,000 S 7 $ 28,000 800 S 9 S 1,200 S 9S 15 7,200 10,800 4,000 S 28,000 7 $ 1,200 S 9S 3,000 $ 7 $ 21,000 Nov. 1 10,800 1,000 S 7 S 7,000 4,000 S 10 S 3,000 S 7 $ 40,000 5 21,000 4,000 S 40,000 10 $ 7 S 13,300 1,900 S 1,100 S 7 $ 7,700 15 4,000 S 10 S 40,000 1,100 S 7 S 2,500 S 10 S Dec. 27 7,700 25,000 1,500 S 10 S 15,000 5 S 10 S 2,495 S 10 $ 31 50 24,950 S 61,050 24,950 68,000 S Totals 8,000 7,505 2,495 Table lamps: Purchases Cost of Goods Sold Inventory on Hand Total Total Unit Unit Total Unit Quantity Date Cost Cost Quantity Cost Cost Quantity Cost Cost 4,200 $ 16 S Sep. 30 67,200 4,200 S 6,000 $ 18 108,000 16 S Oct. 1 67,200 6,000 S 18 S 108,000 4,200 $ 16 S 5,200 S 18 S 12 67,200 93,600 800 $ 18 $ 14,400 18 18,000 1,000 $ 4,200 S 18 S 28 75,600 21 $178,500 8,500 $ 4,200 S 18 S Nov. 5 75,600 8,500 S 21 S 178,500 2,500 $ 18 45,000 1,700 S 18 S 30,600 18 8,500 S 21 178,500 18 30,600 21 S 140,700 1,700 S 6,700 S Dec. 27 21 $ 37,800 1,800 S 21 S 140,511 9 S 21 S 6,691 S 31 189 S 140,511 S 286,500 $ 213,189 Totals 12,009 6.691 14,500 Floor lamps: Purchases Cost of Goods Sold Inventory on Hand Total Unit Unit Total Unit Total Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost 67,200 2,400 $ 28 $ Sep. 30 Oct. 1 5,000 $ 29 $ 145,000 2,400 $ 28 67,200 29 $ 145,000 5,000 $ 1,900 $ 28 S 53,200 500 $ 28 $ 28 14,000 5,000 $ 29 145,000 32 320,000 10,000 S 500 $ 28 $ Nov. 5 14,000 5,000 $ 29 145,000 32 320,000 10,000 $ 500 S 28 S 14,000 3,300 $ 29 $ 18 95,700 1,700 $ 29 S 49,300 32 320,000 10,000 $ S 465,000 S 415,700 $ 116,500 13,300 Totals 15,000 4,100 Requirement 7. Provide a summary for the month, in both units and dollars, of the change in inventory for each item. Does the sum of the ending balances in the inventory records match the balance in Merchandise Inventory in the general ledger? If not, review the transactions to find your error. 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 Number Dollar of lamps Amount of lamps of lamps Amount Amount Beginning Balance Add: Purchases Less: COGS Ending Balance Enter any number in the edit fields and then click Check
