0 ITEMS
Full Inventory Management System
The user has the ability to enter inventory movements, track it in a clean database based on macro input, and then query this to see average cost, net count, net value on date ranges as well as a consolidated monthly summary/running balance.
| All Industries, eCommerce, Financial Model, General Excel Financial Models, Manufacturing, Retail |
| Accounting, CFO, Excel, Inventory |
Video Tutorial:
**Recent updates for version 2 include showing revenue/cogs/gross profit. The cogs feature does a weighted average cost per item per sku/product id based on a date range chosen to be queried from the database tab to pull the cost of items sold in a given month.
Tab 1: User enters all relevant information about an inventory movement. Could be an item being added or removed.
Tab 2: Allows user to enter any date range in order to see the average cost, net count, and total value of any inventory item. Also, you can enter a single date and see the total value of inventory as of that date.
Tab 3/4: Showing monthly summaries of all inventory items and keeps a monthly running balance of these items.
Tab 5: Visual that showing inventory level by month based on $ and count.
*Note the full version includes instructions. Video available if requested.
Write a Review
Get these templates too for a discount!
Manufacturing Financial Model Templates Bundle
Price: $149.95This is a collection of financial model templates in Excel for businesses in the Manufacturing industry and its related sectors.
Retail Financial Model Templates Bundle
Price: $170.00This is a bundle of financial model templates for financial plan templates related to Retail Shops. The following are…
SaaS & E-Commerce Financial Models Bundle
Price: $69.90This bundle of financial model templates provides you a package of relevant SaaS, eCommerce and Online Marketing financial model templates
