i need assistance preparing a perpetual inventory system. the inventory is posted below as well...

50.1K

Verified Solution

Question

Accounting

i need assistance preparing a perpetual inventory system. the inventory is posted below as well as the FIFO, LIFO, and weighted average inventory methods that need to be filled out. I am unsure of how to fill out the LIFO and COGS form.
image
image
image
image
image
image
C D 1 Inventory Flow Assumptions 2 3 4 5 Date 5 Jan 1 Jan 3 DATA Description Inventory on hand Purchase Sale Purchase Sale Per Unit $ 4 $ 5 Jan 6 Jan 15 Jan 22 Units 1,000 3,000 2,750 5,000 4,500 $ $ $ 10 6 10 Post. Ref. Debit Credit Account/Explanation Date January 03 to record purchase of 3,000 units of inventory at $5 per unit. 06 to record sale of 2,750 units at $10 per unit. 1 8 to record weighted average cost of 2.750 units of inventory sold. 15 to record purchase of 5,000 units at $6. 3 22 to record sale of 4,500 units of inventory at $10 each. 22 1 5 5 to record weighted average cost of 4,500 units of inventory sold. B 3 Instructions inventory worksheet Journal Entries FIFO Journal Entries LIFO Journal Entries Wt Avg Ready LIFO COGS Unit cost Purchases Unit cost Date Jan 1 Quantity Total Cost Quantity Inventory on Hand Unit cost Total Cost Quantity Total Cost Jan 3 & Jan 6 Jan 15 Jan 22 $ 8,250.00 5 Purchases Unit cost Weighted-Average COGS Quantity Unit cost Inventory on Hand Unit cost Total Cost GT Quantity Total Cost Total Cost Quantity Date Jan 1 E8 70 Jan 3 TS Jan 6 75 77 TR TO Jan 15 3 31 R2 R3 Jan 22 34 BS NE 17 Account/Explanation Post. Ref. Debit Credit Date January 03 . to record purchase of 3,000 units of inventory at $5 per unit. 3 . 06 . to record sale of 2,750 units at $10 per unit. 1 2 3 to record LIFO cost of 2,750 units of inventory sold. 15 5 5 7 B to record purchase of 5,000 units of $6. 22 - to record sale of 4,500 units of inventory at $10 each. 22 to record LIFO cost of 4,500 units of inventory sold. Instructions inventory worksheet Journal Entries FIFO Journal Entries LIFO Jo Account/Explanation Post. Ref. Debit Credit 1 2 3 4 Date January 03 5 6 to record purchase of 3,000 units of inventory at $5 per unit. 06 to record sale of 2,750 units at $10 per unit. 7 8 9 20 11 12 3 to record FIFO cost of 2,750 units of inventory sold 15 to record purchase of 5,000 units at $6. 22 5 -6 7 8 9 0 1 2 3 1 5 5 to record sale of 4,500 units of inventory at $10 each. 22 to record FIFO cost of 4,500 units of inventory sold. 7 3 3 3 3 . . Instructions inventory worksheet Journal Entries FIFO Journal Entries LIFO

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students