misspelledsearch.com:

inventory database design

information page

If you cannot find the information you are searching for on this page, we suggest searching Google with the correct spelling "inventory database design":

Google

This article is about business inventory. For other uses of the word "inventory", see Inventory (disambiguation).

In business management, inventory consists of a list of goods and materials held available in stock.

An inventory can also mean a self-examination, a moral inventory.

In computing, inventories can comprise physical and non-physical components.

Contents

  • 1 Business inventory
    • 1.1 Inventory examples
      • 1.1.1 Manufacturing
      • 1.1.2 Logistics or distribution
    • 1.2 Accounting perspectives
      • 1.2.1 Financial accounting
      • 1.2.2 FIFO vs. LIFO accounting
      • 1.2.3 Standard cost accounting
      • 1.2.4 Theory of constraints cost accounting
    • 1.3 See also
  • 2 External links

Business inventory

Each country has its own rules about accounting for inventory; this article concentrates on economic theory, United States financial accounting rules, and Eliyahu M. Goldratt's throughput accounting. National boundaries do not limit economics, and throughput accounting functions independently of national regulations because it affects public financial reports only indirectly.

Organizations in the U.S. define inventory to suit their needs within Generally Accepted Accounting Practices (GAAP), the rules defined by the Financial Accounting Standards Board (FASB) (and others) and enforced by the U.S. Securities and Exchange Commission (SEC) and other federal and state agencies. Inventory management affects organizations' internal operations through their cost accounting methods. Identification of goods using Stock Keeping Units (SKUs) assists in managing inventory.

While financial accounting uses standards that allow the public to compare firms, cost accounting functions internally to an organization and with much greater flexibility. A discussion of inventory from standard and theory of constraints-based (throughput) cost accounting perspective follows some examples and a discussion of inventory from a financial accounting perspective.

Inventory examples

While accountants often discuss inventory in terms of goods for sale, organizations - manufacturers, service-providers and not-for-profits - also have inventories (fixtures, furniture, supplies, ...) that they do not intend to sell. Manufacturers', distributors', and wholesalers' inventory tends to cluster in warehouses. Retailers' inventory may exist in a warehouse or in a shop or store accessible to customers. Inventories not intended for sale to customers or to clients may be held in any premises an organization uses.

Manufacturing organizations usually divide their "goods for sale" inventory into:

  • materials and components scheduled for use in making a product (Materials and Components or Raw Materials)
  • materials and components that have begun their transformation to finished goods (Work in Process, or WIP)
  • finished goods - goods ready for sale to customers.

For example:

Manufacturing

A canned food manufacturer's materials inventory includes the foods to be canned, empty cans and their lids (or coils of steel or aluminum for constructing those components), labels, and anything else (solder, glue, ...) that will form part of a finished can. The firm's work in process includes those materials from the time of release to the work floor until they become complete and ready for sale to wholesale or retail customers. Its finished good inventory consists of all the cans of food in its warehouse that it has manufactured and wishes to sell to food distributors (wholesalers), to grocery stores (retailers), and even perhaps to consumers through arrangements like factory stores and outlet centers.

Logistics or distribution

The logistics chain includes the owners (wholesalers and retailers), manufacturers' agents, and transportation channels which an item passes through between initial manufacture and final purchase by a consumer. At each stage, goods belong (as assets) to the seller until the buyer accepts them. Distribution includes four components:

  1. Manufacturers' agents: Distributors who hold and transport a consignment of finished goods for manufacturers without ever owning it. Accountants refer to manufacturers' agents' inventory as "matériel" in order to differentiate it from goods for sale.
  2. Transportation: The movement of goods between owners. The seller owns goods in transit until the buyer accepts them. Sellers or buyers may transport goods but most transportation providers act as the seller's agents.
  3. Wholesaling: Distributors who buy goods from manufacturers and other suppliers (farmers, fishermen, etc.) for re-sale work in the wholesale industry. A wholesaler's inventory consists of all the products in its warehouse that it has purchased from manufacturers or other suppliers. A produce-wholesaler (or distributor) may buy from distributors in other parts of the world or from local farmers. Food distributors wish to sell their inventory to grocery stores, other distributors, or possibly to consumers.
  4. Retailing: A retailer's inventory of goods for sale consists of all the products on its shelves that it has purchased from manufacturers or wholesalers. The store attempts to sell its inventory (soup, bolts, sweaters, or other goods) to consumers.

Accounting perspectives

Financial accounting

An organization's inventory can appear a mixed blessing, since it counts as an asset on the balance sheet, but it also ties up money that might serve for other purposes and requires additional expense for its protection. Inventory may also cause significant tax expenses, depending on particular countries' laws regarding depreciation of inventory. (See Thor Power Tools Decision.)

Inventory appears as a current asset on an organization's balance sheet because the organization can turn it into cash by selling it. Some organizations hold larger inventories than their operations require in order to inflate their apparent asset value and their perceived profitability.

In addition to the money tied up by acquiring inventory, inventory also brings associated costs for space, for utilities, and for insurance to cover staff to handle and protect it, fire and other disasters, obsolescence, shrinkage (theft and errors), and others. Such holding costs can mount up: between a third and a half of its acquisition value per year.

Businesses that stock too little inventory cannot take advantage of large orders from customers if they cannot deliver. The conflicting objectives of cost control and customer service often pit an organization's financial and operating managers against its sales and marketing departments. Sales people, in particular, often receive commission payments, so unavailable goods may reduce their potential personal income.

FIFO vs. LIFO accounting

When a dealer sells goods from inventory, the value of the inventory reduces by the cost of goods sold. For commodity items which one cannot track individually, accountants must choose a method to identify the nature of the sale. Two popular methods exist: FIFO (first in - first out) and LIFO (last in - first out). FIFO regards the first unit which arrived in inventory the first one sold. LIFO considers the last unit arriving in inventory as the first one sold. Which method an accountant selects can have a significant effect on net income and book value, and in turn on taxation. Using LIFO accounting for inventory, a company generally reports lower net income and lower book value, due to the effects of inflation. This generally results in lower taxation. Due to LIFO's potential to skew inventory value, UK GAAP and IAS have effectively banned LIFO inventory accounting.

Standard cost accounting

Standard cost accounting uses ratios called efficiencies that compare the labor and materials actually used to produce a good with those that the same goods would have required under "standard" conditions. As long as similar actual and standard conditions obtain, few problems arise. Unfortunately, standard cost accounting methods developed about 100 years ago, when labor comprised the most important cost in manufactured goods. Standard methods continue to emphasize labor efficiency even though that resource now constitutes a (very) small part of cost in most cases.

Standard cost accounting can hurt managers, workers, and firms in several ways. For example, a policy decision to increase inventory can harm a manufacturing managers' performance evaluation. Increasing inventory requires increased production, which means that processes must operate at higher rates. When (not if) something goes wrong, the process takes longer and uses more than the standard labor time. The manager appears responsible for the excess, even though s/he has no control over the production requirement or the problem.

In adverse economic times, firms use the same efficiencies to downsize, rightsize, or otherwise reduce their labor force. Workers laid off under those circumstances have even less control over excess inventory and cost efficiencies than their managers.

Many financial and cost accountants have agreed for many years on the desirability of replacing standard cost accounting. They have not, however, found a successor.

Theory of constraints cost accounting

Eliyahu M. Goldratt developed the theory of constraints in part to address the cost-accounting problems in what he calls the "cost world". He offers a substitute, called throughput accounting, that uses throughput (money for goods sold to customers) in place of output (goods produced that may sell or may boost inventory) and considers labor as a fixed rather than as a variable cost. He defines inventory simply as everything the organization owns that it plans to sell, including buildings, machinery, and many other things in addition to the categories listed here. Throughput accounting recognises only one class of variable costs: the operating expenses like materials and components that vary directly with the quantity produced.

Finished goods inventories remain balance-sheet assets, but labor efficiency ratios no longer evaluate managers and workers. Instead of an incentive to reduce labor cost, throughput accounting focuses attention on the relationships between throughput (revenue or income) on one hand and controllable operating expenses and changes in inventory on the other. Those relationships direct attention to the constraints or bottlenecks that prevent the system from producing more throughput, rather than to people - who have little or no control over their situations.

See also

  • Manufacturing
  • Distribution
  • Logistics, Transportation
  • Wholesaling
  • Retailing
  • Accounting
  • Cost accounting
  • Throughput accounting
  • Eliyahu M. Goldratt
  • List of theory of constraints topics
  • Just in time
  • Vendo-managed inventory
  • Economic order quantity
  • Operations research

External links

  • Inventory Operations

This inventory database design index site has been developed to help wayward users find the information they are looking for, no matter how they are mistakenly spelled or mistyped. This site is designed to help users find inventory database design information for the following query variants:

inventory database inventory database deign inventory database desine inventory database desin
inventory database din inventory database dein inventory database diegn inventory database deslgn
inventory database desigm inventory database desing inventory database desgin inventory database deisgn
inventory database dseign inventory database edsign inventory database desig inventory database desgn
inventory database dsign inventory database esign inventory design inventory daabase design
inventory datbase design inventory dataase design inventory databse design inventory databae design
inventory dtabase design inventory databahse design inventory databas design inventory databahs design
inventory dtabas design inventory daabas design inventory datbas design inventory dataas design
inventory databs design inventory databaes design inventory databsae design inventory dataabse design
inventory datbaase design inventory daatbase design inventory dtaabase design inventory adtabase design
inventory atabase design database design inventolie database design inventery database design
iventory database design inventerie database design inentory database design invntory database design
invetory database design invenory database design inventry database design inventoy database design
inventorie database design eignvantorie database design eignventory database design iegnviegntery database design
inviegntorie database design eignveigntery database design iegnvantorie database design iegnventory database design
eignventoly database design iegnviegntorie database design inviegntolie database design eignveigntorie database design
inveigntory database design iegnventoly database design eignventery database design inviegnterie database design
iegnveigntory database design inveigntoly database design iegnventery database design eignvantory database design
invantory database design eignviegntory database design iegnveigntoly database design inveigntery database design
iegnvantory database design eignvantoly database design invantoly database design eignviegntoly database design
iegnveigntery database design inveigntorie database design iegnvantoly database design eignvantery database design
invantery database design eignviegntery database design iegnveigntorie database design inveigntolie database design
iegnvantery database design eignventorie database design invantorie database design eignviegntorie database design
inviegntory database design inveignterie database design iegnventorie database design eignventolie database design
invantolie database design iegnviegntory database design inviegntoly database design eignveigntory database design
iegnventolie database design eignventerie database design invanterie database design iegnviegntoly database design
inviegntery database design eignveigntoly database design iegnventerie database design inventoly database design
inventur database design inventor database design iventor database design inentor database design
invntor database design invetor database design invenor database design inventr database design
inventer database design eignvantor database design eignviegntor database design eignveignter database design
iegnvantur database design eignvantol database design invantor database design eignviegntol database design
iegnveigntor database design iegnvanter database design eignvantur database design invantol database design
eignviegntur database design iegnveigntol database design inveigntor database design eignvanter database design
invantur database design eignviegnter database design iegnveigntur database design inveigntol database design
iegnventor database design invanter database design iegnviegntor database design iegnveignter database design
inveigntur database design iegnventol database design eignventor database design iegnviegntol database design
inviegntor database design inveignter database design iegnventur database design eignventol database design
iegnviegntur database design inviegntol database design eignveigntor database design iegnventer database design
eignventur database design iegnviegnter database design inviegntur database design eignveigntol database design
iegnvantor database design eignventer database design inviegnter database design eignveigntur database design
iegnvantol database design inventol database design lnventory database design imventory database design
inventoyr database design inventroy database design invenotry database design invetnory database design
invnetory database design inevntory database design ivnentory database design niventory database design
nventory database design

If you would like to add or correct the content of this site, or if you are interested in supporting the efforts of misspelledsearch.com by placing your product information on these inventory database design pages, please contact mistype@gmail.com for details.

This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article "inventory".