Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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. el Desk Lamps Table Lamps Floor Lamps Number Dollar Number Dollar Number Dollar Amount Amount of lamps Amount of lamps 2,20 of lamps 22,000 Beginning Balance 10 Add: Purchases 3,500 7 24,500 Less: COGS Ending Balance Enter any number in the edit fields and then click Check Answer. C 14 parts Clear All Check Answer remaining Desk lamps: Purchases Cost of Goods Sold Inventory on Hand Unit Total Unit Total Unit Total Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost Sep. 30 2,200 $ 10$ 22,000 Oct. 1 3,500 $ 7$ 24,500 2,200 $ 10 $ 22,000 7$ 24,500 3,500 $ 15 5000 $ 10$ 5,000 1,700 $ 10$ 17,000 3,500 $ 7$ 24,500 Nov. 1 1,700 $ 10$ 17,000 3,000 $ 7 $ 21,000 500$ 7 $ 3,500 5 3,500 $ 9$ 31,500 3,000 $ 3,500 $ 7 $ 21,000 9 $ 31,500 15 2,500 $ 7$ 17,500 500 $ 7$ 3,500 3,500 $ 9 $ 31,500 Dec. 27 500 $ 7$ 3,500 2,000 $ 9$ 18,000 1,500 $ 9$ 13,500 31 5$ 9 $ 45 1,995$ 9$ 17,955 $ 56,000 $ 7,000 60,045 $ Totals 17,955 7,205 1,995 Print Done Table lamps: Purchases Cost of Goods Sold Inventory on Hand Unit Total Unit Total Unit Total Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost Sep. 30 2,000 $ 14 $ 28,000 Oct. 1 8,500 $ 15 $ 127,500 2,000 $ 14$ 28,000 15 $ 127,500 8,500 $ 12 2,000 $ 14$ 28,000 7,000 $ 15 $ 105,000 1,500 $ 15 $ 22,500 28 5,000 $ 15$ 75,000 2,000 $ 15$ 30,000 Nov. 5 11,000 $ 16 $ 176,000 2,000 $ 15$ 30,000 11,000 $ 16 $ 176,000 18 1,700 $ 15 $ 25,500 300 $ 15$ 4,500 16/$ 176,000 11,000 $ Dec. 27 300 $ 15$ 4,500 4,500 $ 16$ 72,000 6,500 $ 16 $ 104,000 31 9 $ 16 $ 144 4,491 $ 16$ 71,856 $ 303,500 $ 259,644 Totals $ 71,856 19,500 17,009 4,491 Print Done Relerence Floor lamps: Purchases Cost of Goods Sold Inventory on Hand Unit Total Unit Total Unit Total Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost Sep. 30 2,400 $ 30$ 72,000 Oct. 1 4,500 $ 26$ 117,000 2,400 $ 30$ 72,000 4,500 $ 26 $ 117,000 28 2,000 $ 30 $ 60,000 400 $ 30$ 12,000 4,500 $ 26$ 117,000 Nov. 5 9,000 $ 28 $ 252,000 400$ 30$ 12,000 4,500 $ 26 $ 117,000 28 $ 252,000 9,000 $ 18 400 $ 30$ 12,000 2,500 $ 26/$ 65,000 2,000 $ 26/$ 52,000 9,000 $ 28/ $ 252,000 $ 369,000 $ 124,000 $ 317,000 Totals 13,500 4,400 11,500
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started