Figuring out a Perpetual weighted cost method (moving average).?

C

Casanova

New member
Heres the information

Sales

Feb 150
March 200
July 200
Sept 300
Dec 150

Beginning Inventory 200 Unit Cost $10

Purchases in monthly order
300/$11 March 5th
400/$12 June 12th
250/$13 August 23rd
150/$15 October 2nd


So would it run something like

Beginning Inventory 200 @ 10
Less Sales 150 @ 10
Running Inv (2000+1500)/50= cost 70
Purchase 300 @ 11
Less Sale 200
Running Inv. (3300+2200)/100= cost 55
 
Back
Top