Off-Topic: Accounting question

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Off-Topic: Accounting question
Date: 2001-11-03 03:31:05
Message-ID: 3BE364F9.4F3CF7A7@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Aasmund Midttun Godal 2001-11-03 04:01:58 Re: Off-Topic: Accounting question
Previous Message JStanczak 2001-11-02 21:18:42 Problem starting as service. FIXED