Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Finance & Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=411)
-   -   Determine the ending inventory under a perpetual inventory system (https://www.askmehelpdesk.com/showthread.php?t=328883)

  • Mar 13, 2009, 04:26 PM
    candaycanes
    Determine the ending inventory under a perpetual inventory system
    Hi ! I've honestly spent a long time trying to figure this out, but I keep getting the answer wrong and I'm not sure how I should go about this question. I'm not asking for you to just give me the answer, if you have time to give a little explanation that would be nice so I could understand what I'm doing :) thanks !

    http://i4.photobucket.com/albums/y11...bows/wiley.jpg
  • Mar 13, 2009, 06:30 PM
    asastring

    try this:
    Fifo - first in first out first example.

    7/1 - 7 @ $93
    7/6 - sold 3
    4 @ $93 remain
    7/11 - 4 @ $99
    7/14 - sold 3 (@ $93)
    7/21 - 3 @ $106
    7/26 - sold 5 (1 @ $93, 4 @ $99)

    Looks like you have ending inventory of 3 @ $106

    Lifo - last in first out

    7/1 7@ $93
    sold 3 @ $93, remaining 4 @ $93

    7/11 - 4 @ $99
    7/14 - sold 3 @ $99, remaining 1 @ $99

    7/21 - 3 @ $106
    7/27 - sold 3@ $106, sold 1 @ $99, sold 1 @ $93-
    Inventory 3 @ $99

    Average cost

    average cost of 14 units is $1365 / 14 = $97.50
    3 units left = $292.50

  • All times are GMT -7. The time now is 05:51 AM.