Off-Topic: Accounting question

Поиск
Список
Период
Сортировка
От Mike Mascari
Тема Off-Topic: Accounting question
Дата
Msg-id 3BE364F9.4F3CF7A7@mascari.com
обсуждение исходный текст
Ответы Re: Off-Topic: Accounting question  ("Aasmund Midttun Godal" <postgresql@envisity.com>)
Re: Off-Topic: Accounting question  ("Aasmund Midttun Godal" <postgresql@envisity.com>)
Re: Off-Topic: Accounting question  ("Oliver Elphick" <olly@lfix.co.uk>)
Список 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@mascari.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: deleting a child table
Следующее
От: "Aasmund Midttun Godal"
Дата:
Сообщение: Re: Off-Topic: Accounting question