273x Filetype XLSX File size 0.34 MB Source: katanamrp.com
Free Inventory Management Spreadsheet This inventory management spreadsheet is ideal for small-scale manufacturers looking for a basic inventory management system. It automatically updates inventory levels for products and materials based on your sales, purchasing, and manufacturing orders. You can insert each of these in the respective sheets. If your manufacturing business is scaling fast, we recommend upgrading to cloud inventory and production management software that will require fewer manual updates and keep your growing team aligned. Try Katana's live inventory management software for 14 days free. This inventory management spreadsheet includes the following sections (click to go to each sheet): Products Insert your product details to track inventory levels Materials Insert your materials to track raw material inventory levels Sales Insert your sales orders Purchasing Insert your purchase orders Manufacturing Insert your manufacturing orders Product recipes Insert you product recipes or bill of materials (BOM) VAT % options Add a range VAT values to select for sales and purchase orders Free Inventory Management Spreadsheet Manufacturing ERP Software www.katanamrp.com This inventory management spreadsheet is ideal for small-scale manufacturers looking for a basic inventory management system. It automatically updates inventory levels for products and materials based on your sales, purchasing, and manufacturing orders. You can insert If your manufacturing business is scaling fast, we recommend upgrading to cloud inventory and production management software that will require fewer manual updates and keep your growing team aligned. Try Katana's live inventory management software for 14 days free. This inventory management spreadsheet includes the following sections (click to go to each sheet): Insert your product details to track inventory levels Insert your materials to track raw material inventory levels Insert you product recipes or bill of materials (BOM) Add a range VAT values to select for sales and purchase orders Products Note: columns marked as Automatic cannot be edited. In stock, Expected, Committed, Missing/excess, and Total manufactured cells update automatically based on sales and manufacturing data. Values for Material cost are taken from product recipes. Product name Category Product code Initial stock Lightsaber / Blue Jedi swords LS-B 20 Lightsaber / Green Jedi swords LS-G 100 Lightsaber / Red Jedi swords LS-R 70 Smart Manufacturing Software for Small Business www.katanamrp.com Automatic Automatic Reorder point Material cost Sales price In stock Expected Committed 20 $ 510.00 $ 120.00 22 5 4 100 $ 100.00 $ 70.00 99 0 0 80 $ 480.00 $ 150.00 75 0 1
no reviews yet
Please Login to review.