How to create a Inventory Analysis Checklist? An easy way to start completing your document is to download this example Inventory Analysis Checklist template now!
We provide this Inventory Analysis Checklist template to help professionalize the way you are working. Our business and legal templates are regularly screened and used by professionals. If time or quality is of the essence, this ready-made template can help you to save time and to focus on the topics that really matter!
Using this Inventory Analysis Checklist template guarantees you will save time, cost and efforts! Completing documents has never been easier!
Download this Inventory Analysis Checklist template now for your own benefit!
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.