Inventory Analysis Checklist

You do not need to enter anything into them.,,, ,,, , Product A , Product B , Product C , Product D ,Total ,Inventory unit analysis:,,, ,Number of units in inventory beginning of period,1200,1000,1200,1300,4700 ,Production,700,800,600,600,2700 ,Units available for sale,1900,1800,1800,1900,7400 ,Units sold,800,600,500,750,2650 ,Number of units in inventory end of period,1100,1200,1300,1150,4750 ,,, ,Cost of goods sold analysis:,,, ,Beginning inventory,800000,750000,900000,1200000,3650000 ,Add: purchases,400000,400000,450000,600000,1850000 ,Cost of goods available for sale,1200000,1150000,1350000,1800000,5500000 ,Less: ending inventory,770000,900000,925000,1000000,3595000 ,Total cost of goods sold,430000,250000,425000,800000,1905000 ,,, ,Inventory costing:,,, ,Cost per unit beginning of period,"666,666666666667",750,750,"923,076923076923","776,595744680851" ,Cost per unit end of period,700,750,"711,538461538462","869,565217391304","756,842105263158" ,Variance,"-33,3333333333334",0,"38,4615384615385","53,5117056856187","19,7536394176932" ,,, ,Weighted average cost (Cost of goods available for sale/Units available for sale),"631,578947368421","638,888888888889",750,"947,368421052632","743,243243243243" ,,, ,Ending inventory breakdown:,,, ,Value of ending inventory (from above),770000,900000,925000,1000000,3595000 ,,, ,Finished goods inventory,400000,375000,450000,600000,1825000 ,Work in progress,300000,325000,350000,300000,1275000 ,Raw materials,70000,200000,125000,100000,495000 ,Total ending inventory,770000,900000,925000,1000000,3595000.