unit price - Cost price with condition (date, price, and stock)

**ferrylukito** · 01-02-2013, 11:23 AM

Hii everyone,

I need your help

in attach file, i already figure out which several table
which is sales table, purchase table, and inventory table (knowing stock items)

in sales table i have profit column where (unit price - Cost price)

anyone can help ?

Regards,
Ferry L.

Book1.xlsx

**Kevin UK** · 01-02-2013, 11:31 AM

Deleted post.

**bebo021999** · 01-02-2013, 11:39 AM

Welcom to the forum,
The Inventory, what is the date taken? before purchasing, or after sales?
what kind of cost of your inventory? average cost or other?
for instance, 10-Jan, you sale 3 tables, the cost will be taken from 3 tables purchased in 1-Jan (10000) or from average cost (11000)?
You define What, and we will help you How

Note: Sorry I found the notice just after replying has been sent

**ferrylukito** · 01-03-2013, 12:32 AM

hallo bebo,,

thanks for help

inventory is taken after purchasing and also after sales
if any purchase so the stock inventory will increase depend on quantity in purchase
and vice versa

for instance,
10 Jan, i sale 3 tables so the cost price is using old stock which is purchase date 1-Jan (10.000)
and 11 Jan, I sale 1 table, so the cost price is using new stock which is purchase date 2-Jan (12.000)

so the sales table like this
Date Item Qty Unit Price Profit
10-Jan Table 3 20000 20000 - 10000 = 10000
11-Jan Table 1 20000 20000 - 12000 = 8000

again Really Thanks..