[enlarge] To determine CoGS of your products, you must understand your inventory system flow process. There are some excel spreadsheets that can be used to ease your understanding on determining your CoGS from the simple until complex inventory system. And this spreadsheet is a CoGS calculator for simple inventory system. Author : Florence Kirk – [...]
[enlarge] As stated by the author, the purpose of this spreadsheet is to provide a basis for understanding the “big picture” for the flow of costs in a factory and the methods for tracking that flow of costs in the accounting system. Author : Howard Godfrey
[enlarge] This is an excel spreadsheet that try to compare the Cost of Goods Sold calculation based on two method, periodic inventory system and perpetual inventory system. Author : Roberta Allen
[enlarge] This is another Material Requirement Planning (MRP) excel template that is created using macros. The guidance on how to use this spreadsheet can be found at the author website. Author : Webandmacros.net
[enlarge] This is an inventory/stock managements template that can be used for managing your inventory in your warehouse. Instead of using plain excel spreadsheet, this template is created using macros. Author : Webandmacros.net