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 & Webshops, 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.
Similar Products
Our customers were also interested in...
Trade (Merchandise) Company Financial Model â...
Advanced Financial Model providing financial & planning analysis for a startup or existing Trade... Read more
Accounting Financial Model Bundle
This is a combined collection of Excel and Google Sheets financial model templates for Accounting an... Read more
Lending Model Startup Forecast: 10-Year Scali...
This is a full 10-year startup lending business financial model, including a 3-statement model. Accu... Read more
Manufacturing 5-year Template – Custome...
A versatile template to forecast out a manufacturing or retail sales business that is built around c... Read more
Preferred Equity Cash Distribution Model R...
A 10-year joint venture model to plan out various scenarios for the way cash is shared between a GP ... Read more
Inventory Valuation Using FIFO – Automa...
Any accountant that needs to comply with IFRS will have to use the FIFO valuation method for calcula... Read more
Due Diligence P&L – Exhaustive Rev...
Model for in depth understanding of high level P&L and Revenue Analysis. Big-4 like book of due ... Read more
Online Clothing Store Financial Model Excel T...
Impress bankers and investors with a proven, solid Online Clothing Store Financial Projection Te... Read more
Advanced Financial Model with DCF & Valu...
New Version Updates: • Model is now dynamic. Users can select the desired forecast length for up ... Read more
3 Statement Financial Modeling with DCF &...
Financial Modeling Tutorial guides user via step by step approach on how to build financial models w... Read more