This free inventory tracker template is designed for small businesses which manufacture or assemble products from raw materials. Download the free template from https://indzara.com/2016/08/free-manufacturing-inventory-tracker/
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.
There are five sheets in the Excel template: 1) Home 2) Products 3) Raw Materials 4) BOM and 5) Orders
Overview of steps
1. Enter Products in Products sheet
2. Enter Raw Materials in Raw Materials sheet
3. Enter Bill of Materials in BOM shet
4. Enter orders in Orders sheet after checking availability
5. View Current raw material stock in Raw Materials sheet
Simple and Effective Excel Templates: https://indzara.com/
Free Excel Templates: https://indzara.com/free-excel-templates/
Premium Excel Templates: https://indzara.com/shop/
Small Business Management Templates: https://indzara.com/small-business-excel-templates/
Project Management Templates: https://indzara.com/project-management-excel-templates/
HR Templates: https://indzara.com/hr-excel-templates/
Free Excel Course: https://indzara.com/useful-excel-for-beginners/
Social:
Subscribe to YouTube: https://www.youtube.com/user/theindzara?sub_confirmation=1
Facebook: https://www.facebook.com/theindzara
YouTube: https://www.youtube.com/user/theindzara
LinkedIn: https://www.linkedin.com/company/indzara
Twitter: https://www.youtube.com/user/theindzara