# Product Average cost

**URL:** <https://forum.manager.io/t/product-average-cost/18459>\
**Category:** Uncategorized\
**Created:** [October 7, 2018, 11:55pm UTC](https://forum.manager.io/t/product-average-cost/18459 "2018-10-07T23:55:20Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Santiago](https://avatars.discourse-cdn.com/v4/letter/s/3bc359/32.png) [@Santiago](https://forum.manager.io/u/Santiago)\
**Post date:** [October 7, 2018, 11:55pm UTC](https://forum.manager.io/t/product-average-cost/18459/1 "2018-10-07T23:55:20Z")

</div>

Hello guys im meeting with a new problem.

I have a distributor who sends me 2 types of products, ones that weight 100grams and others 140grams,  
my problem is that i use a freight in for shipping calculations which ones are based on the product weight.

After making that invoice in my inventory y have not precise numbers in the product costs in consecuence of the different weights they have.

Any ideas to make this work will be really good!

Thanks

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [October 8, 2018, 12:05am UTC](https://forum.manager.io/t/product-average-cost/18459/2 "2018-10-08T00:05:31Z")

</div>

Read this Guide: [Add freight-in to inventory item costs | Manager](https://www.manager.io/guides/9610). Use the manual method.

---

<div class="post-metadata">

**Author:** ![Santiago](https://avatars.discourse-cdn.com/v4/letter/s/3bc359/32.png) [@Santiago](https://forum.manager.io/u/Santiago)\
**Post date:** [October 8, 2018, 3:13am UTC](https://forum.manager.io/t/product-average-cost/18459/3 "2018-10-08T03:13:14Z")

</div>

Yes ive seen that,

The problem is that i purchase more than 30 products of each per invoice, and must make proper calculations as i also have fees included that affect the whole price leaving aside the shipping

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [October 8, 2018, 4:09am UTC](https://forum.manager.io/t/product-average-cost/18459/4 "2018-10-08T04:09:52Z")

</div>

You can mix the techniques on the same purchase invoice. For fees that are apportioned among all line items based on relative amounts of the line items, use the automatic method (entering the _Freight-in_ item). For fees that apply only to one line item, use the manual method.

For example, assume you buy inventory and have associated costs as follows:

- 20 units of A at 5 each, weighing 0.1 kg each
- 30 units of B at 10 each, weighing 0.2 kg each
- Shipping cost of 50, to be allocated by weight
- Insurance costs of 100, to be divided according to cost

So, total cost is 550. Total weight of A is 2 kg. Total weight of B is 6 kg. And total weight of shipment is 8 kg. The purchase invoice would be entered as below. Notice I have used the new calculator feature in the `Unit price` field. Lines #1 and #2 are standard inventory item entries. Lines #3 and #4 are manual entries of freight-in. Line #5 is an automatic entry of freight-in, distributed across all inventory items with quantities according to the figures in the `Amount` column:

 ![01%20PM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/3/a3cad92e0dbf43a4a125c93e4893d94eb0cd1c5a.png)

The completed purchase invoice looks like this:

 ![15%20PM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/1/d/1db5f749462f30270f381780ed551e692ab56d99.png)

With no other inventory transactions, the Inventory Items tab list looks like this:

![43%20PM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/0/00af374f0098a2ae8e1725fb893512a044b8b673.png)

As you see, average cost of A includes the 5 base cost, weight-based shipping of 0.625 [50 / 8 \* 2 / 20 = 0.625], and a 1.25 share of insurance [100 \* 100 / (100 + 300) / 20 = 1.25], for a total of 6.875. The average cost is rounded to two decimal places for display as 6.88. Item B is costed by similar methods. The total value of _Inventory on hand_ equals the total of the purchase invoice, because there are no other transactions in this test business.

---

<div class="post-metadata">

**Author:** ![Santiago](https://avatars.discourse-cdn.com/v4/letter/s/3bc359/32.png) [@Santiago](https://forum.manager.io/u/Santiago)\
**Post date:** [October 8, 2018, 4:28am UTC](https://forum.manager.io/t/product-average-cost/18459/5 "2018-10-08T04:28:34Z")

</div>

Wow ! that calculation feature is awesome!

Thanks so much for the example, really helped out to clarify my mind,

But my problem continues becouse i have 30 different items that weight 100grams, and 20 items that weight 140grams.

As far as i understand, i should generate 50 new lines for making freight in calculations… isnt a better way for doing it ?

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [October 8, 2018, 12:32pm UTC](https://forum.manager.io/t/product-average-cost/18459/6 "2018-10-08T12:32:37Z")

</div>

> [@Santiago](#):
>
> But my problem continues because i have 30 different items that weight 100grams, and 20 items that weight 140grams.

Then I would suggest that doing Freight-In via weight is not that practical, yes the alternative will cause an over / under allocation of Freight per Inventory Item but will that make such a “significant” variation to the Inventory Items Average Cost.

> [@Santiago](#):
>
> isnt a better way for doing it ?

You could create one purchase invoice for the 100g items and a separate purchase invoice for the 140g items and proportion the Freight-In charge on each invoice based on weight.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 2:49pm UTC](https://forum.manager.io/t/product-average-cost/18459/7 "2023-01-18T14:49:44Z")

</div>

Closed on January 18, 2023, 2:49pm UTC


