Re: Off-Topic: Accounting question

From: "Aasmund Midttun Godal" <postgresql(at)envisity(dot)com>
To: mascarm(at)mascari(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Off-Topic: Accounting question
Date: 2001-11-03 04:01:58
Message-ID: 20011103040158.24383.qmail@ns.krot.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

this is not my field, I have read many books, and I still don't understand anything about accounting. However I do believe two things regarding your issue.

1. If you have too little of anything (money inventory or otherwise) you would not reduce the original input (I don't know what you mean by shrinkage but I assume that is what you meant), but rather introduce an adjustment record (as I am norwegian I do not know the proper english words for this).
2. You can adjust up as well. To illustrate it:

Product | Quantity | Date | Comment
Shoes | 100 | Juli 1. 2001 | Received shipment
Shoes | -1 | Juli 4. 2001 | Sold to customer
Shoes | -2 | Juli 5. 2001 | Sold to customer
Shoes | -1 | Juli 7. 2001 | Sold to customer
Sum | 96
Shoes | 2 | August 1. 2001 | Stock-Counting (98 shoes)
Sum | 98

This may not be what you wanted to know. If you have any good tips on books or websites about accounting please let me know!

Regards,

Aasmund.

On Fri, 02 Nov 2001 22:31:05 -0500, Mike Mascari <mascarm(at)mascari(dot)com> wrote:
> Hello.
>
> I have a quick accounting question. In the evaluation of Cost of
> Goods Sold, one can use 3 different methods for evaluating
> inventory: LIFO, FIFO, or Average Warehouse cost. In an application
> which allows the user to adjust inventory quantities, if the user
> discovers that the physical inventory in a cycle count is less than
> the electronic accounts, its easy to attribute the missing inventory
> as shrinkage. But what if the user discovers an on-hand quantity
> that is greater than the electronic accounts? For example:
>
> Jan 01, 2001 - Bought 1 Pencil for $3.00
> Jan 03, 2001 - Bought 1 Pencil for $3.50
> Jan 21, 2001 - Bought 1 Pencil for $4.50
>
> Total:
>
> 3 Pencils
> $11.00
>
> However, when the cycle count is performed on Jan 31, 2001, 2 more
> pencils are discovered. What do Generally Accepted Accounting
> Principles say regarding the value of the 4th and 5th pencils? If a
> sale of a pencil occurs on Feb 01, 2001, using LIFO, what is the
> COGS?
>
> Oliver?
>
> Sorry for the off-topic question. Any pointers would be greatly
> appreciated.
>
> Mike Mascari
> mascarm(at)mascari(dot)com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Aasmund Midttun Godal

aasmund(at)godal(dot)com - http://www.godal.com/
+47 40 45 20 46

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gunnar Lindholm 2001-11-03 07:34:37 Re: how do the pro's do this? (still a newbie)
Previous Message Mike Mascari 2001-11-03 03:31:05 Off-Topic: Accounting question