To allocate the cost equally to all the product

[Lawrence]

Hi

I have table called Product listing.

Product listing
A
B
C

and my total overhead to produce all product above = $10
and my Total Output unit = 20 unit
Thus Unit cost = $0.5

wondering what query can allocate the $0.5 equally to product A, B and C.

Thanks in Advance

Lawrence
wondering can

 

[Lord Kelvan]

well technically it is impossible to divide .5 by 3 equally

what you should do is store the overhead and output for each item
seperatally then run a query to calculate the cost when you need to
know that inforamtion because it is technally impossible to build
6.6recuring products per listing

what are you actually trying to achieve because it seems to be
inaccurate data

regards
kelvan

 

[Lawrence]

hi,

Sorry i think you misunderstand, actually i want to put $0.5 to Product A to C

Thus

A = $0.5
B = $0.5
C= $0.5

and $0.5 been calculated by using other query

Lawrence

 

[Lord Kelvan]

then why not use thoes calculations and add the product listing into
that query

where are you trying to put thoes vaues in the table or in a query