Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from ssharifu on Jan 22 at 10:39 AM You have to develop custom program to perform inventory valuation based on weighted avg. Method.
Weighted avg. Method : closing stock quantity * closing stock value per unit.
When u calculate closing stock value per unit, MR21 will be used to valuate closing stocks. To calculate closing stock value per unit, following are the steps.
5) Closing stock value per unit = production value of product 1 + opening stock value of product 1 / production quantity of product 1 + closing stock quantity of product 1.
4) Production value of product 1 = weight of product 1 (%) * sum of all expenses (mostly)
3) Weight of product 1 (%) = weighted avg. Sale value of product 1 / sum of weighted avg. Sale value of all products
2) Weighted avg. Sale value of product 1 = production qty of product 1 * weighted avg. Sale unit price of product 1 group
1) Weighted avg. Sale unit price of product 1 group = total sold value of product 1 group / total sold qty of product 1 group
| | | ---------------Original Message---------------
From: Shinu
Sent: Tuesday, January 21, 2014 10:15 PM
Subject: Weighted Average Method in Inventory Evaluation
Moving Average and Weighted average are one and same. |
| Reply to this email to post your response. __.____._ |   _.____.__ |
