Rum is the base ingredient for the world famous Cuban cocktails including the Daiquiri, Mojito, Ron Collins, Pina Colada, and Cubata. Excellent draught beer is available everywhere in Cuba as well as local and imported soft drinks.
We recommend a monthly inventory closing when you use the weighted average inventory model. In Microsoft Dynamics AX, the weighted average inventory costing method is calculated by the following formula: Weighted average = (Q1*P1 + Q2*P2 + Qn*Pn) / (Q1 + Q2 + Qn) Inventory transactions leaving the inventory issues.
It is then multiplied with number of units sold and number of units in ending inventory to arrive at cost of goods sold and value of ending inventory respectively. In perpetual inventory system, we have to calculate the weighted average cost per unit before each sale transaction. The calculation of inventory value under average cost method is explained with the help of the following example: