Cost of Ending Inventory and Cost of Goods Sold

During April, Leary Company sold 1,000 units of Product Q. Product Q’s beginning inventory and purchases during the month are shown below. (Assume the periodic inventory system is used.)

Assignment Template attached below.

April 1 Beginning inventory 200 units @ $1
April 5 Purchases 200 units @ $2
April 10 Purchases 200 units @ $3
April 15 Purchases 200 units @ $4
April 20 Purchases 200 units @ $5
April 25 Purchases 200 units @ $6

Required: Use the periodic inventory system to answer the following questions.

  1. Compute the total units available for sale.
  2. Compute the total cost of the units available for sale.
  3. Compute the FIFO cost of goods sold (COGS) in dollars.
  4. Compute the FIFO ending inventory (EI) in dollars.
  5. Compute the LIFO COGS in dollars.
  6. Compute the LIFO EI in dollars.
  7. Compute the weighted average COGS in dollars.
  8. Compute the weighted average EI in dollars.
  9. Prove the sum of COGS and EI for each method equals the goods available for sale for both units and dollars.
  10. Compute the gross profit (GP) for each method assuming the 1000 units were sold for $10 each.


Complete this assignment using an Excel spreadsheet, and date and explain each entry on your deliverable.

You can leave a response, or trackback from your own site.


13 Responses to “Cost of Ending Inventory and Cost of Goods Sold”

  1. Azure DevOps says:

    804606 458362Hey! Im at work surfing around your blog from my new apple iphone! Just wanted to say I love reading through your weblog and look forward to all your posts! Keep up the outstanding work! 836476

  2. cheap wigs says:

    303281 389365Its a shame you dont have a donate button! Id without a doubt donate to this brilliant blog! I suppose for now ill settle for book-marking and adding your RSS feed to my Google account. I appear forward to fresh updates and will share this blog with my Facebook group. Chat soon! 590679

  3. 670033 991129Ive the same issue sometimes, but I usually just force myself via it and revise later. Good luck! 619801

  4. 623252 552937Thanks for the auspicious writeup. It truly used to be a leisure account it. Glance complicated to much more delivered agreeable from you! Nevertheless, how can we be in contact? 295985

  5. 159094 413200 There is noticeably a bundle to know about this. I assume you produced certain nice points in capabilities also. 793902

  6. DevSecOps says:

    900632 253783 very good post, i certainly love this internet site, keep on it 375497

  7. 707354 781377excellent issues altogether, you merely gained a new reader. What could you recommend about your post which you made some days inside the past? Any positive? 277692

  8. 820179 982751I was suggested this website by my cousin. Im not positive whether this post is written by him as no 1 else know such detailed about my trouble. You are fantastic! Thanks! xrumer 894403

  9. IWC Flakenov has five news.

  10. dich vu seo says:

    646866 523695bathroom towels should be maintained with a good fabric conditioner so that they will last longer:: 61094

  11. 249334 639246A genuinely fascinating read, I may possibly effectively not agree totally, but you do make some quite legitimate factors. 424286

  12. 426837 9644Excellent paintings! This is the kind of information that really should be shared about the internet. Disgrace on Google for now not positioning this publish upper! Come on over and speak more than with my internet site . Thanks =) 129304

  13. says:

    588526 921248I was looking at some of your blog posts on this web site and I believe this internet website is real instructive! Maintain posting . 268924

Leave a Reply

Powered by WordPress | Designed by: buy backlinks | Thanks to webdesign berlin, House Plans and voucher codes