adding average production costs to products.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

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.  

Photo of Todd

Todd

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 64,342 Points 50k badge 2x thumb
Are the line items a child table to the order?  ie what is your table setup.
Photo of Todd

Todd

  • 150 Points 100 badge 2x thumb
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!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 64,342 Points 50k badge 2x thumb
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]