Managing cooperative inventories effectively is crucial for the smooth operation and financial health of cooperative societies across Kenya. Inventory management ensures that stores hold the right quantity of goods, minimizing losses through spoilage, theft, or obsolescence. Accurate stock records enable cooperatives to plan procurement, control costs, and meet members' needs promptly. This chapter focuses on the preparation and maintenance of stock ledger cards, essential tools for tracking stock movements and balances in cooperative stores.

3.1 Methods of Stock Ledger Cards Preparation

Stock ledger cards are fundamental records that document all transactions related to inventory items. Their preparation must be systematic and accurate to reflect real-time stock status. Different methods of preparing stock ledger cards suit various cooperative environments, depending on the volume and complexity of stock handled. In a county referral hospital pharmacy, for example, precise stock ledger cards help prevent medicine shortages or expiries, while a retail cooperative may use simpler formats due to less complex stock types.

3.1.1 First in First Out method

The First in First Out (FIFO) method assumes that the stock received first is the stock issued first. Issues are therefore priced at the cost of the oldest goods on the card, and the closing balance is made up of the most recent purchases. It matches the physical movement of goods that expire or deteriorate. Example: a dairy cooperative store that holds packaging sachets and cleaning chemicals with shelf lives issues the oldest delivery first, so the card prices each issue at the cost of that oldest delivery.

Procedure for FIFO

1. Enter the opening balance as the first layer, showing quantity, unit cost and value.
2. Enter each new receipt on its own line with its own unit cost, so that every layer keeps its separate price.
3. When goods are issued, identify the oldest layer that still has stock.
4. Price the issue at the unit cost of that oldest layer until the layer is used up.
5. If the issue is larger than the oldest layer, take the balance from the next oldest layer at its own cost, and record each part separately.
6. Record the total quantity and total value issued, then show the remaining layers as the new balance.

Worked Example for FIFO

Example (figures are illustrative): the card shows an opening balance of 100 units at Ksh 50, a receipt of 200 units at Ksh 60 and a later receipt of 100 units at Ksh 80. Then 250 units are issued.

Formula: Value issued = (Units from layer 1 × Cost 1) + (Units from layer 2 × Cost 2)
Substitution: Value issued = (100 × Ksh 50) + (150 × Ksh 60)
Working: 5,000 + 9,000 = 14,000
Result: Value issued = Ksh 14,000

Closing balance: 50 units at Ksh 60 = Ksh 3,000, plus 100 units at Ksh 80 = Ksh 8,000, giving 150 units valued at Ksh 11,000.

Advantages of FIFO

• Matches physical flow: It reflects the way perishable and dated goods are actually used, so old stock does not remain on the shelf.
• Realistic closing stock value: The balance is priced at the latest costs, so it is close to current replacement cost.
• Accepted for reporting: It is allowed by accounting standards for financial statements.
• Simple logic: The rule of using the oldest cost first is easy for storekeepers to follow and for auditors to check.
• Supports expiry control: Because oldest layers are issued first, it encourages rotation of stock.

Disadvantages of FIFO

• Layers must be tracked: Many receipts at different prices mean many lines on the card, which takes more time.
• Issue costs lag behind prices: In a period of rising prices, issues are charged at older, lower costs, so costs of use are understated.
• Higher reported profit in inflation: Low issue costs raise profit, which may increase tax payable.
• More chance of error: Splitting an issue across several layers creates room for calculation mistakes.
• Not suited to mixed stock: Where items are blended in a bin, such as bulk liquids, the oldest layer cannot be identified easily.

3.1.2 Last in First Out

The Last in First Out (LIFO) method assumes that the most recently received stock is issued first. Issues are priced at the latest purchase cost, and the closing balance is made up of the oldest purchases. It makes the cost of issues close to current prices. Example: a hardware store holding bulk cement and sand, where the newest delivery sits on top and is taken first, prices each issue at the cost of the latest delivery.

Note that LIFO is not permitted for financial statements under International Financial Reporting Standards, so it is used mainly for internal management purposes and for teaching comparison.

Procedure for LIFO

1. Enter the opening balance as the first layer, showing quantity, unit cost and value.
2. Enter each new receipt on its own line with its own unit cost.
3. When goods are issued, identify the most recent layer that still has stock.
4. Price the issue at the unit cost of that latest layer until it is used up.
5. If the issue is larger than the latest layer, move back to the previous layer and price the rest at its cost, recording each part separately.
6. Record the total quantity and total value issued, then show the remaining older layers as the new balance.

Worked Example for LIFO

Example (figures are illustrative): using the same card as before, with 100 units at Ksh 50, 200 units at Ksh 60 and 100 units at Ksh 80, 250 units are issued.

Formula: Value issued = (Units from latest layer × Cost) + (Units from next layer × Cost)
Substitution: Value issued = (100 × Ksh 80) + (150 × Ksh 60)
Working: 8,000 + 9,000 = 17,000
Result: Value issued = Ksh 17,000

Closing balance: 100 units at Ksh 50 = Ksh 5,000, plus 50 units at Ksh 60 = Ksh 3,000, giving 150 units valued at Ksh 8,000.

Advantages of LIFO

• Current costs in issues: Recent prices are charged to issues, so the cost of use reflects today's market.
• Lower reported profit in inflation: Higher issue costs reduce profit, which may reduce tax in rising price periods.
• Suits stacked stock: Where new deliveries are placed on top of old ones, such as sand or bulk grain, taking the latest first matches practice.
• Layer records are clear: Each layer keeps its own cost, so issues can be traced to purchases.
• Useful for management comparison: It shows managers the effect of price increases on the cost of materials.

Disadvantages of LIFO

• Not allowed for financial reporting: Accounting standards do not permit it, so figures must be restated for published accounts.
• Outdated closing stock value: The balance is priced at old costs, so stock may appear far below its present value.
• Old stock may stay unused: Oldest goods remain at the bottom, risking deterioration or obsolescence.
• Complex records: Moving back through layers is slower and more error-prone than other methods.
• Distorts profit: If old layers are suddenly used, past low costs may be charged and profit can swing sharply.

3.1.3 Simple average

The simple average method prices every issue at the arithmetic average of the unit prices on the card, without considering how many units were bought at each price. Prices are added together and divided by the number of prices. It is quick to calculate, but it ignores the quantities bought. Example: a school kitchen store that buys cooking oil in three deliveries at different prices may use the average of the three prices to value each issue.

Procedure for Simple Average

1. List the unit prices on the card, including the opening balance price and each receipt price.
2. Add all the unit prices together.
3. Divide the total by the number of prices listed to get the simple average price.
4. Multiply the units issued by the simple average price to obtain the value issued.
5. Multiply the units remaining by the same average price to obtain the value of the balance.
6. Recalculate the average each time a new receipt at a different price is entered.

Worked Example for Simple Average

Example (figures are illustrative): the card shows 100 units at Ksh 50, 200 units at Ksh 60 and 100 units at Ksh 80. Then 250 units are issued.

Formula: Simple average price = Sum of unit prices ÷ Number of prices
Substitution: Simple average price = (50 + 60 + 80) ÷ 3
Working: 190 ÷ 3 = 63.33 (rounded to two decimal places)
Result: Simple average price = Ksh 63.33 per unit

Formula: Value issued = Units issued × Average price
Substitution: Value issued = 250 × Ksh 63.33
Working: 250 × 63.33 = 15,832.50
Result: Value issued = Ksh 15,832.50

Closing balance: 150 units × Ksh 63.33 = Ksh 9,499.50. The issue and balance together come to Ksh 25,332.00, which differs from the actual cost of Ksh 25,000 of the goods held. This difference arises because quantities were ignored.

Advantages of Simple Average

• Easy to calculate: Only addition and division are needed, which suits stores with limited clerical time.
• No layers to track: One price is applied to all units, so the card is short.
• Smooths price changes: Sudden price swings in one delivery have less effect on issue values.
• Quick to teach and train: New storekeepers can learn it easily.
• Suitable for stable prices: Where receipts are of similar quantity and price, the result is close to the true cost.

Disadvantages of Simple Average

• Ignores quantities: A small purchase at a high price affects the average as much as a large purchase at a low price.
• Values do not reconcile: Issue and balance values may not add up to the real cost of goods available.
• Not recognised for reporting: It is rarely accepted for financial statements, since it can misstate cost.
• Misleading when sizes differ: Large differences in receipt quantities produce a distorted price.
• Recalculation needed: The average changes whenever a new price appears, so earlier figures must be reviewed.

3.1.4 Weighted average

The weighted average method prices issues at an average that takes quantities into account. The total cost of all units available is divided by the total number of units available, so larger purchases influence the price more than small ones. It gives a fair single price for goods that are mixed together. Example: a hotel housekeeping store that holds detergent bought in several deliveries calculates one weighted price per litre and uses it for every issue to the floors.

Procedure for Weighted Average

1. Record the opening balance with quantity, unit cost and total value.
2. When a new receipt arrives, add its quantity to the units on hand and its value to the value on hand.
3. Divide the new total value by the new total quantity to get the weighted average unit cost.
4. Price every issue at this average unit cost until the next receipt.
5. Multiply the units remaining by the average cost to find the value of the balance.
6. Recalculate the average each time a receipt is entered, and carry it forward on the card.

Worked Example for Weighted Average

Example (figures are illustrative): the card shows 100 units at Ksh 50, 200 units at Ksh 60 and 100 units at Ksh 80. Then 250 units are issued after the last receipt.

Formula: Weighted average cost = Total value of goods available ÷ Total units available
Substitution: Weighted average cost = (5,000 + 12,000 + 8,000) ÷ (100 + 200 + 100)
Working: 25,000 ÷ 400 = 62.50
Result: Weighted average cost = Ksh 62.50 per unit

Formula: Value issued = Units issued × Weighted average cost
Substitution: Value issued = 250 × Ksh 62.50
Working: 250 × 62.50 = 15,625
Result: Value issued = Ksh 15,625

Closing balance: 150 units × Ksh 62.50 = Ksh 9,375. The issue and balance together equal Ksh 25,000, which agrees with the cost of goods available.

Advantages of Weighted Average

• Accounts for quantities: Large purchases carry more weight, so the average reflects the real cost of the goods.
• Values reconcile: Value issued plus closing balance always equals the cost of goods available.
• Accepted for reporting: It is allowed by accounting standards for financial statements.
• Single price per item: The card stays short, with one rate used for issues and balance.
• Suits mixed stock: Where units are indistinguishable, such as fuel, grain or liquids, one average is practical.

Disadvantages of Weighted Average

• Needs recalculation: The average must be worked out after every receipt, which takes time on busy cards.
• Division may leave decimals: Rounding differences can occur and must be handled consistently.
• Hides price changes: Individual price increases are blurred, so managers may not notice them.
• Slow to reflect current prices: In fast-rising markets, the average lags behind present replacement cost.
• Careful arithmetic required: A single calculation error is carried into all later issues until it is corrected.

3.1.5 Purpose and Importance of Stock Ledger Cards

Stock ledger cards serve as the primary documents for recording stock inflows and outflows, providing a clear history of inventory movements. Their importance includes:

• Accurate Stock Control: They help maintain accurate records of quantities received, issued, and remaining, reducing the risk of stockouts or overstocking.
• Financial Accountability: Ledger cards support auditing processes by providing evidence for stock valuation and verifying physical counts.
• Decision Making: Managers use ledger data to make informed procurement and sales decisions, ensuring efficient stock turnover.
• Loss Prevention: Regular updates on ledger cards help detect discrepancies early, enabling measures against pilferage or errors.
• Operational Efficiency: They streamline stocktaking exercises, reducing time and effort during physical inventory counts.

In a SACCO managing stationery supplies, well-kept ledger cards ensure that the office never runs out of essential items, supporting uninterrupted operations.

3.1.6 Types of Stock Ledger Cards

There are various types of stock ledger cards, each designed to suit different record-keeping needs:

• Bin Cards: These cards are attached to storage bins and updated whenever stock is added or removed, providing immediate visibility of stock levels.
• Cardex System: A more detailed card that records stock description, quantities, unit cost, and value, useful for high-value or fast-moving items.
• Perpetual Inventory Cards: These maintain continuous real-time records of stock, facilitating instant stock level checks without waiting for physical counts.
• Periodic Inventory Cards: Updated at specific intervals, suitable for cooperatives with low transaction volumes or less frequent stock movements.
• Combined Ledger and Control Cards: These integrate ledger recording with control measures, such as approval signatures for stock issues, enhancing accountability.

In a university library cooperative store, bin cards may be used for stationery items, while cardex systems track expensive electronic equipment.

3.1.7 Key Elements in Preparing Stock Ledger Cards

Preparing stock ledger cards requires inclusion of essential information to ensure clarity and completeness:

• Item Description: Clear identification of the stock item, including name, specifications, and unit of measure.
• Date of Transaction: Recording the exact date when stock is received or issued.
• Reference Number: Linking transactions to purchase orders, delivery notes, or requisition forms for traceability.
• Quantities In and Out: Accurate recording of stock received into and issued from the store.
• Balance Quantity: Updated stock balance after each transaction to reflect current availability.
• Unit Cost and Value: For valuation purposes, recording the cost price and total value of stock held.
• Authorized Signatures: Spaces for staff responsible for recording and approving transactions to enhance accountability.

At a county government office, these elements ensure that procurement officers and storekeepers maintain synchronized records, preventing stock mismanagement.

3.1.8 Procedures for Preparing Stock Ledger Cards

The preparation of stock ledger cards must follow a systematic process to maintain consistency and accuracy:

1. Identify Stock Items: List all items to be recorded, ensuring each has a unique card.
2. Design Card Format: Choose or customize a card format that captures all necessary details, including columns for dates, quantities, and references.
3. Allocate Card Numbers: Assign card numbers or codes that correspond with stock item codes for easy retrieval.
4. Record Opening Balances: Enter the initial stock quantity and value as the starting point for the ledger.
5. Establish Transaction Recording Protocols: Define who records stock movements, how frequently cards are updated, and verification steps.
6. Distribute Cards to Store Points: Place cards in accessible locations such as bin shelves or store offices to facilitate timely updates.

In a cooperative farm supply store, following these steps ensures that fertilizer and seed stocks are accurately tracked throughout the planting season.

3.1.9 Comparison of the Four Pricing Methods

The same stock, priced by each method, gives different issue values and closing balances. The table uses the card from the worked examples: 100 units at Ksh 50, 200 units at Ksh 60 and 100 units at Ksh 80, with 250 units issued.

In a period of rising prices, FIFO gives the lowest issue cost and the highest closing stock, while LIFO gives the highest issue cost and the lowest closing stock. The method chosen must be applied consistently from one period to the next.

Chapter Summary

This chapter focused on managing cooperative inventories by exploring various methods of preparing stock ledger cards, including First in First Out, Last in First Out, Simple average, and Weighted average, each providing a distinct approach to valuing stock. It then discussed the importance of maintaining stock ledger cards accurately to ensure reliable inventory records. The process of receiving delivered goods was outlined, emphasizing careful inspection and verification to maintain stock integrity. Cataloguing of purchased goods was covered, highlighting systematic organization for easy retrieval and control. The chapter also detailed the recording of purchased goods in the stock ledger to reflect current inventory levels. Finally, it explained the continuous updating of stock ledger cards as stock is received or issued, ensuring that inventory data remains current and supports effective store operations.