ending inventory

Examples of ending inventory in the following topics:

• Methods in Retail Inventory

  • The physical inventory is valued at retail, and it is multiplied by the cost ratio (or percentage) to determine the estimated cost of the ending inventory.
  • The advantage of this method is that companies can estimate ending inventory (at cost) without taking a physical inventory.
  • The steps for finding the ending inventory by the retail inventory method are:
  • Deduct the retail sales from the retail price of the goods available for sale to determine ending inventory at retail.
  • Multiply the cost/retail price ratio or percentage by the ending inventory at retail prices to reduce it to the ending inventory at cost.

• Average Cost Method

  • The value of the ending inventory on the balance sheet is USD 3,750 (150 units * USD 25).
  • At the end of the year, the last Cost per Unit on Goods, along with a physical count, is used to determine ending inventory cost.
  • On 12/31/12, sales for the period were 50 units and ending inventory is 150 units.
  • The Weighted-Average Method of inventory costing is a means of costing ending inventory using a weighted-average unit cost.
  • The ending inventory is carried at this per unit cost.

• LIFO Method

  • Despite numerous purchases and sales during the year, the ending inventory still includes the units from beginning inventory.
  • Applying LIFO on a perpetual basis during the accounting period, results in different ending inventory and cost of goods sold figures than applying LIFO only at year-end using periodic inventory procedure.
  • On the balance sheet, incorrect inventory amounts affect both the reported ending inventory and retained earnings.
  • Despite numerous purchases and sales during the year, the ending inventory still includes the units from beginning inventory.
  • Applying LIFO on a perpetual basis during the accounting period, results in different ending inventory and cost of goods sold figures than applying LIFO only at year-end using periodic inventory procedure.

• Reporting Inventories

  • Inventory is an asset and its ending balance should be reported as a current asset on the balance sheet.
  • In the periodic inventory system, sales are recorded as they occur but the inventory is not updated.
  • A physical inventory must be taken at the end of the year to determine the cost of goods.
  • Inventory is an asset and its ending balance should be reported as a current asset on the balance sheet.
  • In that situation the beginning and ending inventory does appear on the income statement.

• Inventory Techniques

  • It takes the weighted average of all units available for sale during the accounting period and then uses that average cost to determine the value of COGS and ending inventory.
  • A physical count is then performed on the ending inventory to determine the amount of goods left.
  • Finally, this amount is multiplied by Weighted Average Cost per Unit to give an estimate of ending inventory cost.
  • At the end of the year, the last Cost per Unit on Goods, along with a physical count, is used to determine ending inventory cost.
  • Inventories U.S.

• Gross Profit Method

  • An inventory valuation allows a company to provide a monetary value for items that make up their inventory.
  • While the best way to value inventory is to perform a physical inventory, in certain business operations, taking a physical inventory is impossible or impractical.
  • Calculate the cost of ending inventory as the difference of cost of goods available for sale and estimated cost of goods sold.
  • The following is an example on how to calculate ending inventory using the gross profit method.
  • The ending inventory on the balance sheet is $$5000 - $250=$4750$.

• Perpetual vs. Periodic Counting

  • Perpetual inventory updates the quantities continuously and periodic inventory updates the amount only at specific times, such as year end.
  • A company using the perpetual inventory system would have a book inventory that is exactly (within a small margin of error) the same as the physical (real) inventory.
  • Physical inventories are conducted at set time intervals; both cost of goods sold and the inventory are adjusted at the time of the physical inventory.
  • Most companies who use periodic inventory perform this at year-end.
  • While the perpetual inventory method provides a close picture of the true inventory information, it is a good idea for companies using a perpetual inventory system to do a physical inventory periodically.

• Efficiency Metrics

  • Efficiency ratios for inventory measure how effectively a business uses its inventory resources.
  • In addition, excess inventory increases the risk of losses due to price declines or inventory obsolescence.
  • Inventory Turnover Ratio = Cost of Goods Sold / Average Inventory (to calculate average inventory, add the balances of beginning and ending inventory and divide by 2)
  • The inventory turnover ratio is a measure of the number of times inventory is sold or used in a time period, such as a year.
  • The inventory conversion ratio is a measure of the number of days in a year it takes to sell inventory or convert it into cash.

• Conducting a Physical Inventory

  • Physical inventory is a process where a business physically counts its entire inventory.
  • In addition, inventory control system software can speed the physical inventory process .
  • A perpetual inventory system tracks the receipt and use of inventory, and calculates the quantity on hand.
  • The teams count the inventory items and record the results on an inventory-listing sheet.
  • An inventory control system ensures that the company's books reflect the actual inventory on hand.

• Inventory decisions

  • The key question that must be answered for inventory is "How much?
  • " Understanding the best inventory levels to carry is critical to the organization because too much inventory and too little inventory are both costly to the organization.
  • Inventory that exceeds what is needed to satisfy customer demand imposes unnecessary costs such as storage, deterioration, obsolescence, theft, and money tied up in inventory that cannot be used for other purposes.
  • For example, a restaurant that specializes in serving fresh fish needs to make careful purchasing decisions so it has enough fresh fish each day to serve its customers, but not so much that unsold fish must be severely discounted or discarded at the end of the day.
  • Computer companies such as Dell must carefully manage its computer chip inventory so it can meet current customer orders, but not be stuck with too much inventory if a new computer chip comes out or if vendors reduce prices.