Periodic and Perpetual Systems —Calculating Ending Inventory and Cost of Sales using Average Cost, Moving Average, FIFO,...

60.1K

Verified Solution

Question

Accounting

Periodic and Perpetual Systems —Calculating EndingInventory and Cost of Sales using Average Cost, Moving Average,FIFO, LIFO, and Dollar-Value LIFO

The inventory records of Mod Oil Company for January 2020 showedthe following data for an item of its merchandise for sale (assumethat the six transactions occurred in the order shown).

DateUnitsUnit CostTotal
Beginning inventory (Jan. 1)900$6.00$5,400
Jan. 3 Purchases1,0806.106,588
Jan. 5 Sales (1,620 units)
Jan. 10 Purchases1,0806.206,696
Jan. 20 Sales (900 units)
Jan. 25 Purchases7206.304,536
Jan. 28 Sales (540 units)
Total available for sale3,780$23,220

Its ending inventory of 720 units can be specifically identifiedas follows: 180 units from the January 3 purchase, 90 units fromthe January 10 purchase, and 450 units from the January 25purchase.

Compute ending inventory and cost of goods sold for the monthended January 31 using the methods indicated below.

  • Round your final answer to the nearest whole dollar.
  • Do not round per unit costs in your calculations.
e. Moving average (perpetual)AnswerAnswer
f. FIFO (perpetual)AnswerAnswer
g. LIFO (perpetual)AnswerAnswer
h. Dollar-value LIFO*AnswerAnswer

*Assume that the beginning inventory is the base layer at a costof $6.00 per unit. The price index for

Answer & Explanation Solved by verified expert
4.2 Ratings (636 Votes)
Moving average Method Date Purchases Sales Ending inventory Units Unit Price Amount Units Unit Price Amount Units Weighted Cost Amount 1Jan 900 600 540000 3Jan 1080 61 6588 1980 605 1198800 5Jan 1620 605 980836 360 605 217964 10Jan 1080 62 6696    See Answer
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