Please consider registering
guest

Log In Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 4 characters - maximum search word length is 84 characters

iReap Lite POS Calculation of Moving Average Costing Method
November 12, 2015
9:45 am
andy djojo budiman
andy djojo budiman
Admin
Forum Posts: 26
Member Since:
January 19, 2015
Offline

Moving Average is one of the Costing Method (Main Menu | Setting and Parameters | Costing Method | Moving Average) that can be selected by user in iReapLite POS application. Other costing method that can be selected to is Standard Costing Method.

Under the moving average inventory method, the average cost of each inventory item in stock is re-calculated after every inventory purchase. The average cost is computed by dividing the total cost of goods available for sale by the total units available for sale. This gives a weighted-average unit cost that is applied to the units in the ending inventory.

The formula of Moving Average Inventory Calculation Method:

Moving Average Rate = ( (Available Qty in stock * Average Rate) + (Incoming Stock * Incoming Rate)) / (Available Qty in Stock + Incoming Stock)

In this session, we will give you 2 example of Moving Average Calculation.

EXAMPLE 1. Moving Average inventory Valuation Method for Positive Stock

Item :Beras Pandan Wangi 5kg
Beginning Balace :10 Sack @ 20.000
Sales :3 Sack
Purchase :5 Sack

EXAMPLE 2. Moving Average Inventory Valuation Method for Negative Stock

Item :Beras Pandan Wangi 5kg
Beginning Balace :12 Sack @ 22.083,33
Sales 1 :12 Sack
Sales 2 :5 Sack
Purchase :2 Sack @ 22.000
Sales 3 :1 Sack

You can get the attachment for the calculation of Moving Average Inventory Valuation Method by click this link below

May 25, 2016
8:39 am
Wongso
Member
Forum Posts: 7
Member Since:
April 10, 2015
Offline

andy djojo budiman said

Moving Average is one of the Costing Method (Main Menu | Setting and Parameters | Costing Method | Moving Average) that can be selected by user in iReapLite POS application. Other costing method that can be selected to is Standard Costing Method.

Under the moving average inventory method, the average cost of each inventory item in stock is re-calculated after every inventory purchase. The average cost is computed by dividing the total cost of goods available for sale by the total units available for sale. This gives a weighted-average unit cost that is applied to the units in the ending inventory.

The formula of Moving Average Inventory Calculation Method:

Moving Average Rate = ( (Available Qty in stock * Average Rate) + (Incoming Stock * Incoming Rate)) / (Available Qty in Stock + Incoming Stock)

In this session, we will give you 2 example of Moving Average Calculation.

EXAMPLE 1. Moving Average inventory Valuation Method for Positive Stock

Item :Beras Pandan Wangi 5kg
Beginning Balace :10 Sack @ 20.000
Sales :3 Sack
Purchase :5 Sack

EXAMPLE 2. Moving Average Inventory Valuation Method for Negative Stock

Item :Beras Pandan Wangi 5kg
Beginning Balace :12 Sack @ 22.083,33
Sales 1 :12 Sack
Sales 2 :5 Sack
Purchase :2 Sack @ 22.000
Sales 3 :1 Sack

You can get the attachment for the calculation of Moving Average Inventory Valuation Method by click this link below

Saya translate ke Indonesia ya pak:

Moving Average adalah salah satu metode perhitungan Harga Pokok(Main Menu | Pengaturan Sistem | Harga Pokok | Moving Average) yang bisa dipilih oleh pengguna di aplikasi iReapLite POS. Metode perhitungan lain yang bisa dipilih adalahMetode Standard.

Dengan metode Moving Average, harga rata-rata dari masing-masing barang dihitung ulang setelah setiap pembelian barang. Harga rata-rata dihitung dengan membagi nilai barang yang ada dengan jumlah barang yang ada. Hal ini menghasilkan harga rata-rata yang berlaku ke semua barang.

Formula Metode Perhitungan Moving Average:

Moving Average = ( (Jumlah barang awal * Harga rata-rata) + (Jumlah barang masuk * Harga barang masuk)) / (Jumlah barang awal + Jumlah barang masuk)

Di sesi ini, kami akan memberikan 2 contoh perhitungan harga rata-rata.

CONTOH 1. Metode Moving Average untuk stok positif

Barang :Beras Pandan Wangi 5kg
Saldo Awal :10 Sak @ 20.000
Penjualan :3 Sak
Pembelian :5 Sak

CONTOH 2. Metode Moving Average untuk stok minus

Barang :Beras Pandan Wangi 5kg
Saldo Awal :12 Sak @ 22.083,33
Penjualan 1 :12 Sak
Penjualan 2 :5 Sak
Pembelian :2 Sak @ 22.000
Penjualan 3 :1 Sak

Anda bisa mendapatkan file contoh untuk kalkulasi Moving Average dengan mengklik link ini

Dapatkan versi terbaru dengan mengklik URL berikut ini: https://play.google.com/store/apps/details?id=com.sterling.ireap
Untuk informasi lebih lanjut klik link ini: http://www.sterling-team.com/i.....plite.html
iReap Lite POS dirancang dan dikembangkan oleh PT. Sterling Tulus Cemerlang (www.sterling-team.com). Sterling-team adalah partner SAP dan konsultan ERP yang berfokus pada bidang Retail, Distribusi, dan Manufaktur.

Forum Timezone: UTC 0

Most Users Ever Online: 244

Currently Online:
2 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Wongso: 7

yohanes300589: 2

bayu: 1

Member Stats:

Guest Posters: 0

Members: 141

Moderators: 0

Admins: 3

Forum Stats:

Groups: 2

Forums: 7

Topics: 23

Posts: 35

Newest Members: Hasriati nur saputri, Dicky, nugiserang, Hadi, Ahmad rizki w, Suparno, MAULIDIN, beadsndesign, detu, TOKO JOGJA

Administrators: andy djojo budiman: 26, Admin: 0, Siddharta: 1