CVS Inventory Method

In accordance to the annual report of Woolworths Limited 2016, the current accounting practice that is applied to the business regarding its inventory disclosure includes; a perpetual inventory system which continually updates the information by increasing or decreasing inventory from reports throughout the year to verify accounting records (Bragg 2016). A perpetual inventory system in comparison to a periodic inventory system is more efficient and effective for larger corporations. With entities like Woolworths, many transactions occur between themselves and other stakeholders, so by utilising a perpetual inventory system, it saves time and also money (Woolworths 2016)

IT is centrally-managed for each of CTC’s specific divisions. Retail stores use software to keep track of inventory and prices regarding items in stores. The stores then transmit this information to make purchases from CTC. It is an integral part of their supply chain and retail operations. They are continuing to upgrade these internally developed systems, which could pose a risk for exceptions. These systems will require increased test of controls

Costco’s inventory management strategy focuses on three main points: (a) point-of-sales system (POS), (b) vendor managed inventory and (c) low volume of stock keeping units. Costco takes aid from innovative inventory system that provides real time inventory information called Collaborative Retail Exchange (CRX). The system monitors and re-orders at the optimum inventory as part of the continuous re-order system. The CRX system analyses the sales for the previous weeks and inventory level which acts as information to the suppliers. Costco Wholesale follows a Bulk-buying strategy. It aims at selling products in large volume and comparatively low prices. The company also follows lower number of stock keeping units (SKU’s), an average of ~4,000

(TCO 4) Inventory valuation methods determine the cost of goods sold and the inventory balance. (1) Explain how the Average Cost method is applied (15 points) and (2) provide an example of the application of this method. (10 points) (Points : 25)

There are four accepted inventory methods: Specific Unit Cost, Average Cost, FIFO, and LIFO. Unique inventory items are recorded in inventory by the cost of that unit or specific unit cost. Non-unique items use one of the other 3 methods. The average-cost method is: average cost = cost of goods available / number of units available. The first-in, first-out (FIFO) method assigns the first costs into inventory to the first cost of goods sold. The last-in, first-out (LIFO) method assigns the last costs into inventory to the first cost of goods sold. Since inventory costs can vary, companies may choose an inventory method based on tax advantages. When prices are falling, FIFO will have the lowest taxable income. When prices are rising, LIFO has the lowest taxable

6. 7. 8. Cost-flow assumption for inventory Base LIFO layer liquidations Loss recognitions on write-downs of inventories

Office Depot uses multiple inventory strategies to order products. 90% to 95% of goods are ordered through automatic replenishment, manual replenishment, pull replenishment, and global sourcing are also used depending on channel, volume, velocity and cost. (Office Depot, 2015). The accuracy of the inventory from both a DC and store perspective is critical to the organizations success. Heizer and Render (2014) state that record accuracy is a prerequisite to inventory management, production scheduling, and sales. Accuracy is maintained by either periodic or perpetual systems (p.479). In Office Depot, the stores are required to cycle-count technology items such as laptops, desktops computers, and tablets five days a week. Discrepancies are entered in the system and bounced off the local DC’s on-hand inventory discrepancies. Office Depot is a “blind receive” organization meaning the stores receive pallets of products and simply unwrap and put them away. The only way a store knows if a product is missing is through the cycle-count program. This system was put into place to speed up the receiving process and eliminate unnecessary steps once the product was received at the store level. Office Depot conducts a full physical inventory once a year through a third party and trues up the inventory shrink at this time.

The second types of inventory methods to value its inventory that CVS uses is the most common one used for most business the First-In, First-Out (FIFO). First-In, First-Out (FIFO) is defined as the first inventories bought are the first ones to be sold. CVS only uses FIFO for Some Retail Pharmacy and Rest of Business (Front store). CVS utilizes this method because; the fresher products have to be out the door first. Also, FIFO is an easier method than Weighted Average Cost. And most importantly it may over inflate cost because the last products bought and out the door first are usually the most expensive products.

2. The present value of the holding cost of inventory for the duration ofinitial replenishment cycle is

Before going into the exact numbers for this company it is important to make sure and use all tools available. One such tool would be “Electronic data interchange (EDI) connects the databases of different companies. In one early use, EDI allowed companies utilizing material requirements planning (MRP) to inform suppliers of upcoming orders by providing them with access to the database of planned orders” (Vonderembse & White, 2013, Ch. 5.3). Cycle counting is a way to “reconcile inventory records and correct errors, and many

I have taken it upon myself to test two inventory management systems and have found a system that will yield the least cost to Parts Emporium Inc. The two systems I have tested are the Continuous Inventory System and the Periodic Inventory System. Using data that I have gathered from the products DB032 and the EG151, I have compiled calculations and have concluded a continuous inventory system would be best for our corporation. Attached you will find said calculations; I would like to take this moment and present the continuous inventory system and recognize all of the relevant costs. The following is an explanation of each calculation under the continuous inventory system:

Managing what's in a warehouse or on the shop floor can be extremely complex if you're looking for optimal cost and supply chain management capabilities( Needleman, 2017 ). Inventory estimation and control is directly impacted a company’s profitability.

The inventory throughout the second quater each an every item is variable and it totals at about £4,009,800 and turns over every 3 months/90 days. Cash sales should amount to about £7,500,000 if the inventory of £4,009,800 valued at cost turns over once in 90 days and if the average mark-up is about £2004, 9000. This figure can be roughly checked by referring to the expenses on the income statement. A rough measure of the cash expenses can usually be obtained by using the operating expenses less any non-cash expenses such as depreciation. Overall this shows that it is very important for Doomy corporations to have cash budget planned for its business, because it can help them assess if they are over spending their money and if the money is going and where it is coming in.

Once they have their inventory under control, the purchasing department should complete a very detailed cost analysis to determine the total inventory cost, including all aspects and hidden fees. Once they have the