Archive for the 'Inventory' Category



Excel Cost of Goods Sold

Inventory

[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 – [...]

Excel Manufacturer Cost of Goods

Manufacturer CoGS

[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

Inventory System Comparison

Inventory System

[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

MRP

Excel MRP

[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

Inventory Managements

Inventory Management

[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