Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sound Investing, Chapter 18 - Significant Accounting Policies And Changes In Them

Authors: Kate Mooney

3rd Edition

0071719407, 9780071719407

More Books

Students also viewed these Accounting questions