Inventory comprises goods held by a business for sale or production. It does not include fixed assets, such as equipment or buildings. Nor does it include tools or consumable supplies used during operations. The value of inventory is an asset, because it can generate future income. Therefore, it appears on a company’s balance sheet.
So inventory must be counted and valued. It must be tracked as it is produced, bought, or sold. Manager includes many features to help manage inventory. Some are essential; others are optional. Program behavior changes, depending on which tools are used. This Guide explains how various tools and capabilities interact so you can decide which to use in your situation. It is divided into three parts: Introduction, Continuation, and Conclusion. You are reading Part 1 Introduction.
The three parts of this Guide do not furnish detailed, step-by-step instructions for enabling functional tabs, completing transaction forms, or generating reports. Those can be found in other Guides, to which hyperlinks are provided. Instead, they focus on relationships between the inventory management features of the program:
Purchase orders and sales orders are not included in this discussion because they are not actual financial transactions and have no impact on inventory. They are convenient shortcuts for recording orders to suppliers or from customers. And they can by copied to other transactions that affect inventory. But in the current version of Manager, purchase orders do not adjust inventory availability or backorder status. Nor do sales orders commit inventory to a particular customer or future sales transaction.
All three parts of this Guide illustrate various aspects of inventory management using an example company, Brilliant Industries. Brilliant Industries sells electric lamps and lamp parts at wholesale. It is not required to collect or pay any taxes on sales or purchases in its jurisdiction. Brilliant has 6 different items in inventory and assigns 3-digit item codes:
Brilliant currently has two customers and two suppliers:
So far, Brilliant Industries has enabled just three tabs related to inventory management (Reports is always enabled for all businesses):
Inventory can be purchased with purchase invoices or cash payments.
Brilliant Industries buys an initial stock of inventory via a combination of purchase invoice and cash payment. ACME Distributing presents its sales invoice upon delivery of the merchandise. So as soon as Brilliant enters the corresponding purchase invoice, the items are considered to be in stock. Edison Electrical Supply sells only over the counter. So Brilliant’s owner leaves Edison’s warehouse with purchased items in hand, having written a check on the spot.
Brilliant enables the Purchase Invoices tab. The Bank Accounts and Receipts & Payments tabs were enabled when the company’s bank account was established. (As Brilliant enables tabs, it sets up all forms for automatic sequential reference numbers under Form Defaults.) The two transactions are entered as below:
Since all transactions were complete when they were entered, there is no need for Brilliant Industries to enable the Goods Receipts tab. The Inventory Items list shows the results of the two purchases:
Manager employs the perpetual average cost method for inventory valuation. This method divides the total acquisition cost of units of an inventory item in stock by the number of that item in stock. Thus, if more units are acquired at a cost higher than the current average cost, the average cost of all units will go up, no matter how many units are acquired or in stock or what their individual costs were.
When items are produced, the cost of inventory consumed is transferred to the new finished goods at the average cost of each input item. Any non-inventory costs are also apportioned among the finished goods.
When inventory items are produced in-house, production orders record consumption of resources and output of new finished goods.
Brilliant Industries can buy finished table lamps from ACME Distributing. But it can also produce them from parts purchased from various suppliers. It decides to manufacture a batch of 3 table lamps. So it enables the Production Orders tab and enters the following production order:
The inventory listing shows the increase in finished table lamps, as well as reductions in the three items that went into production. Also notice that average cost of table lamps has declined because of the production order. The cost of input items for a lamp (87.00 + 24.35 + 3.25 = 114.60) plus labor (75.00 / 3 = 25.00) is less (139.60) than the purchase cost of a finished lamp (195.00). In other words, Brilliant Industries can assemble table lamps itself for less than it can buy them, potentially allowing more profit:
Also note that total value of inventory has risen because of the 75.00 labor cost to manufacture 3 lamps. The company now has more invested in its inventory. But it can also sell that same inventory for much more because of the value added through manufacturing operations.
Inventory can be sold with sales invoices or cash receipts.
Brilliant Industries sells products to Bob’s Hardware. It enables the Sales Invoices tab and records the sale on the following sales invoice:
It also sells 1 case of LED bulbs to Lumen Lighting for cash, and enters that transaction as a receipt:
Quantities on hand have decreased for table lamps, 60 Watt bulbs, and LED bulbs:
Because the goods were delivered immediately and either accompanied by a sales invoice or a cash receipt, Brilliant Industries did not use the Delivery Notes tab. Manager treated all inventory movements as having happened immediately.
When you have sold more inventory items than you own (have on hand) the situation is described as a backorder. That term is somewhat misleading, because additional stock has not necessarily been ordered. This situation shows up in Manager as negative inventory quantities. The negative quantity indicates how many units of the inventory item must be purchased or produced to satisfy existing sales.
If Brilliant Industries had sold 3 cases of LEDs to Lumen Lighting in the previous example, a backorder situation would exist, because only 2 had been purchased and were on hand. The inventory list would show a quantity on hand of -1:
Notice that total cost of this item has dropped to zero, and average cost is non-existent because there is no inventory.
Four reports became available when the Inventory Items tab was enabled:
Brilliant Industries began the year with no inventory, made initial purchases, produced some lamps, and made sales. Its Inventory Value Movement report is shown below. Notice that only the 2 cases of LEDs actually delivered are included; the backordered merchandise will not appear until more are purchased and delivered:
Brilliant Industries’ matching Inventory Quantity Movement report is below. Note the backordered LEDs second from the bottom of the list:
Brilliant Industries sold only 3 different items during the reporting period, so only those show on the Inventory Profit Margin report:
Brilliant Industries’ full current price list is show below:
Brilliant adds a custom field for inventory categories. It filters the report for Finished lamps, with a corresponding title:
The resulting report appears below:
Because Inventory Value Summary and Inventory Quantity Summary reports are related to transactions within a specified time period, they will not necessarily reflect total value or quantities of inventory on hand. That information can be obtained by drilling down on the Inventory on hand account in the Summary tab or by clicking on the Inventory Items tab. Both resulting lists can be exported to a spreadsheet program.
Subscribe to our newsletter and get exclusive product updates you won't find anywhere else straight to your inbox.