# adding average production costs to products.

• 0
• Question
• Updated 3 years ago

Is there a good way to average production costs and add them to the final price for each item ordered? Order has 2 line items at \$3 ea x 100 pcs = \$300/item, the [Freight] field = \$500, divide the \$500 by 2, factor in \$250 per line item. \$250 divided by 100 (ext pcs) = \$2.50 so actual cost each is \$5.50 not \$3 ea.

• 0 Points

Posted 3 years ago

• 0

QuickBaseCoach App Dev./Training, Champion

• 64,342 Points
Are the line items a child table to the order?  ie what is your table setup.
• 150 Points
Yes they are. They are child records of Purchase Orders. PO's have line items and they incur costs when being stored at a drop location and also when the product is re manufactured to fit specific order requirements. So I need to disperse these costs as mentioned in my initial question. Thanks for asking!

QuickBaseCoach App Dev./Training, Champion

• 64,342 Points
Are you wanting to allocate the cost by dollar value?  That would be the easiest way.  Sum the total extended cost of all line items and then look that up down to each line.

The allocate the freight based on the % of each respective's line's cost vs the total PO cost.

[Freight Cost] * [Extended line value] / [Total of all Line values]