437x 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.