Inventory Valuation-Periodic | FIFO | ||||||||
P | SLS | COST | TOT | C/G/S. | INVEN. | ||||
60 | 7.64 | 458.40 | |||||||
50 | |||||||||
70 | 7.61 | 532.70 | |||||||
75 | 7.59 | 569.25 | |||||||
65 | |||||||||
75 | |||||||||
80 | 7.56 | 604.80 | |||||||
60 | |||||||||
90 | 7.53 | 677.70 | |||||||
100 | |||||||||
100 | 7.50 | 750.00 | |||||||
100 | |||||||||
PURCHASE | SALES | COST | TOTAL | COGS | INVENTORY |
60 | 7.64 | 458.4 | 458.4 | ||
50 | 50*7.64=382 | 458.4-382=76.4 | |||
70 | 7.61 | 532.7 | 76.4+532.7=609.1 | ||
75 | 7.59 | 569.25 | 609.1+569.25=1178.35 | ||
65 | 10*7.64+55*7.61=494.95 | 1178.35-494.95=683.4 | |||
75 | 15*7.61+60*7.59=569.55 | 683.4-569.55=113.85 | |||
80 | 7.56 | 604.8 | 113.85+604.8=718.65 | ||
60 | 15*7.69+45*7.56=455.55 | 718.65-455.55=263.1 | |||
90 | 7.53 | 677.7 | 263.1+677.7=940.8 | ||
100 | 35*7.56+65*7.53=754.05 | 940.8-754.05=186.75 | |||
100 | 7.5 | 750 | 186.75+750=936.75 | ||
100 | 25*7.53+75*7.5=750.75 | 936.75-750.75=186 |
THANK YOU PLEASE UPVOTE
Get Answers For Free
Most questions answered within 1 hours.