Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

When using perpetual inventory in MYOB Business, your inventory's monetary value is tracked using the average costing method.

Unlike other valuing methods, such as First in First Out (FIFO), the average costing method values your inventory by calculating its weighted average value, using the formula: Average Cost=Total Value of the item÷Total Quantity of items.

Let's take a look at an example of how this would work in everyday business.

UI Text Box
sizemedium

Example

Let's say you purchase 10 wine glasses for $10.00 each. This will result in an average cost of $10.00 per item.

The following day, 10 more wine glasses are purchased, this time for $12.00 each. Your inventory looks like this:

  • Total Quantity of wine glasses: 20
  • Total Value of wine glasses: $220.00
  • Average Cost: $11.00 ($220.00÷20)

From this example, you'll notice your average cost rose by $1.00 after purchasing the second lot of glasses. This number will be automatically calculated and updated after each purchase. Another transaction that can impact the average cost is inventory adjustments

What affects average cost?

As shown in the example above, average cost is calculated after each purchase.

An item's average cost will also be recalculated if you make any of these changes to a recorded bill:

  • enter a memo

  • update the ship to address on the bill screen

  • change the date

  • change the purchase number

  • enter a supplier invoice number

Need to adjust the average cost? You'll need to make an inventory adjustment.

HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Inventory items and services

Making inventory adjustments

Units of measure

Choosing an inventory method

HTML Wrap
classacademyBanner