Form spt 1770 s excel. This free inventory tracker template is designed for small businesses which manufacture or assemble products from raw materials. You can use this to automatically calculate the current raw material stock as well as determining how many units of each product you can make using the raw materials available. We can input simple Bill of Materials (BOM) where we define how we can manufacture a products from its raw materials. Manufacturing Inventory Tracker – Free Inventory Excel Template FREE DOWNLOAD VIDEO TOUR HOW TO USE THE INVENTORY TRACKER? There are five sheets in the Excel template: 1) Home 2) Products 3) Raw Materials 4) BOM and 5) Orders Overview of steps • Enter Products in Products sheet • Enter Raw Materials in Raw Materials sheet • Enter Bill of Materials in BOM shet • Enter orders in Orders sheet after checking availability • View Current raw material stock in Raw Materials sheet Steps in Detail I will use an example of a Juice/Smoothie company which creates juices from fruits & vegetables. However, this template can be used in any industry.