=>it would consider the remaining 300 of the 500 bought on bought on FEB 10, and 700 of the 1000 bought on FEB 14 ![]() ![]() =>the 100 bought on FEB 1, the 200 of the 500 bought on FEB 1, and the 100 bought on FEB 13 is depleted so it can't consider those quantities =>for the 2000 sold on FEB 19, it knows that: =>for the 100 sold on FEB 13, the 100 bought on FEB 13 is depleted =>for the 300 sold on FEB 12, 100 bought on FEB 1 is depleted and 200 of the 500 bought on FEB 1 is depleted. ![]() Basically where the quantity and price is derived from.īought 100 on FEB 1 500 on on FEB 10 300 on FEB 12 100 on FEB 13 100 on on FEB 14 400 on on FEB 19 this, the formula/function would know that: I would like to know how to make excel calculate which inventory is left in the FIFO method, quantities that are bought first are the first to be sold.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |