7 STOCK CONTROL SYSTEMS7.1 Re-order level ("Two bin") system 7.2 Periodic review system The time interval which minimises the annual cost of acquiring and holding stock is called the "economic review period".7.3 Just in time ("JIT")7.3.1 Production
A production planning technique which emphasises acquiring materials and producing goods and services (both internally and externally) at the moment they are required.
7.3.2 Purchasing
A purchasing system in which material purchases are contracted so that receipt and usage coincided to the maximum possible extent.
 7.3.3 Necessary conditions
  • Co-operation/flexibility of suppliers and internal workers
 
  • Guaranteed quality of raw materials
 
  • Geographically close
 
  • Low stock levels and short production runs
 

 

7.3.2 Advantages 7.3.3 Disadvantages

 

  • Stocks kept to absolute minimum (stock holding costs )

 

  • Risk of "just too late"

 

  • Space saving

 

  • More frequent handling of smaller batches (re-order and set-up costs )

 

  • Less obsolescence on changes in product specification

 

  • Higher cost of monitoring and control

 

  7.4 ABC coding systems
  • ABC coding systems direct maximum stock control effort to most important (eg highest value) items.
 
  • Total purchase cost of each stock item needs to be estimated for a period

 

    • A items represent top 10% in terms of annual purchase cost
 
    • B items represent next 20%
 
    • C items represent remaining 70%
 
  7.5 Perpetual inventory methods
  • Up to date stock balance are always known therefore facilitates continuous stocktaking
 
  • A replenishment point frequently triggers an order system relies on accuracy of records

 

8 PRICING METHODS8.1 The problem
  • The cost of materials purchased will normally be derived from suppliers invoices, but where identical purchases have been made at differing prices, a decision must be taken as to which price is used.
 
 8.2 FIFO 8.3 LIFO 8.4 Weighted average 8.5 Standard cost
Example 5The following data relates to the receipts and sales of stock during the month of January. There was no opening stock.Required

Calculate the value of closing raw material stock using the following methods to price issues

(i) FIFO
(ii) LIFO
(iii) Weighted average.
 8.6 Comparison
Method Advantages Disadvantages
FIFO
  • Up to date closing stock value
  • Realistic reflection of physical movement of materials etc

·  Out of date cost of issues (if prices or old stock held)

·  Tedious record-keeping

·  Identical jobs may have different costs

LIFO
  • Up to date cost of issues

·  Out of date closing stock value (if purchased some time ago)

·  Unrealistic – oldest materials etc should be issued first

·  Tedious record-keeping

Weighted average
  • A compromise on stock valuation and pricing of issues
  • Assumes identical items have some value
  • Simpler record keeping

·  Tedious calculations of weighted average (on every receipt)

·  Fictitious issue price (ie not actual)

Standard cost
  • Simpler record keeping

·  Only "as good" (ie approx to actual)as standard costs employed ( keep up to date)

·  Differences from standard need to be written off to P&L a/c.

In periods of rising prices, FIFO shows higher profits than LIFO and vice versa.Solution 1 – Annual total cost(a) Q = 200Annual ordering cost = = 2 = £400Annual holding cost = = 1 = £100Total cost = 400 + 100 = £500(b) Q = 400Annual ordering cost = 2 = £200Annual holding cost = 1 = £200Total cost = 200 + 200 = £400(c) Q = 600Annual ordering cost = 2 = £133.33Annual holding cost = 1 = £300Total cost = 133.33 + 300 = £433.33Summary

 

(i) Order (ii) Holding (iii) Total
(a)
(b)
(c)
£400
£200
£133
£100
£200
£300
£500
£400
£433
  Solution 2 – EOQ(a) EOQ = = = = 400(b) 40,000 items are required p.a. = 100 orders need to be placed p.a.(c) 100 orders to be placed during 300 working days = 3Orders should be placed every 3 daysAlternatively, usage rate = = 133.33 per dayItems are ordered in batches of 400= 3 days worth of stockSolution 3 – Maximum stock levelsThe problem is to find a value for CH which can be used in the EOQ formula.Sundry holding costs £3 – based on average stock as normal.Warehousing cost – each unit’s worth of space which is used has an opportunity cost of the lost rental of £4.25 2 = £8.50BUT x units worth of space must be retained, not X/2 units worth, ie the cost of warehousing is £8.50 (= £17 X/2).Therefore the total value for CH to be put in the formula is £3 + £17 = £20EOQ = = 1,000 unitsSolution 4 – ROLROL = 4 30 = 120 unitsSolution 5 – Pricing material issues(a) FIFO
Date Receipts Issues Balance
5/1 100 @ £5 = £500

 

100 £500
16/1 50 @ £5.50 = £275

 

150 £775
17/1

 

40 @ £5 = £200

 

 

20/1

 

60 @ £5 = £300

 

 

 

 

10 @ £5.50 = £55 40 £220
23/1 50 @ £6 = £300

 

90 £520
30/1

 

40 @ £5.50 = £220

 

 

 

 

30 @ £6 = £180 20 £120
 (b) LIFO
Date Receipts Issues Balance
5/1 100 @ £5 = £500

 

100 £500
16/1 50 @ £5.50 = £275

 

150 £775
17/1

 

40 @ £5.50 = £220 110 £555
20/1

 

10 @ £5.50 = £55

 

 

 

 

60 @ £5 = £300 40 £200
23/1 50 @ £6 = £300

 

90 £500
30/1

 

50 @ £6 = £300

 

 

 

 

20 @ £5 = £100 20 £100
(c) Weighted average
Date Receipts Issues Balance
5/1 100 @ £5 = £500

 

100 @ £5 = £500
16/1 50 @ £5.50 = £275

 

150 @ £5.17 = £775
17/1

 

40 @ £5.17 = £207 110 @ £5.17 = £568
20/1

 

70 @ £5.17 = £362 40 @ £5.17 = £206
23/1 50 @ £6 = £300

 

90 @ £5.62 = £506
30/1

 

70 @ £5.62 = £394 20 @ £5.62 = £112
1 LABOUR1.1 Direct v indirect labour cost
  • can be specifically traced to or identified with a particular product/service

·  not charged directly to a product

·  Egs

·  wages of operatives assembling parts into finished products

·  machine operatives engaged in production process.

·  Eg

·  instruction and supervision

·  idle time

1.2 Accounting categories
1.2.1 Payroll accounting 1.2.2 Labour cost accounting
  • records amounts due to employees, taxing authorities (eg Inland Revenue), etc

·  identifies amounts to be charged to individual jobs and overhead accounts

2 PAYROLL ACCOUNTING2.1 Payroll
  • A record showing, by each employee
 
    • gross wages/salaries

 

    • deductions (eg tax, social security employees’ pension contributions, etc).
 
  • May include details of employer’s associated employment costs (eg employer’s pension contributions).
 
 2.2 Accounting entries 2.3 Source documents 2.4 Payroll analysis 3 LABOUR COST ACCOUNTING3.1 Source documents 3.2 Job costing system 4 LABOUR TIME AND WAGE ROUTINES4.1 Clockcards
  • "Gate timekeeping" records are needed to record time at work.
 
  • Modern time-recording systems may not use physical cards.
 
4.2 Time sheets 4.3 Job cards 5 REMUNERATION METHODS5.1 Fixed salaries 5.2 Time rate   5.3 Piecework rate
  • A fixed amount per unit of output achieved.

 

  • Often operated based on standard time per unit (eg bricklaying) (although a higher rate may be paid for higher levels of output).
 
 
Illustration 2Tim Kowalski carves wooden animals for a small company supplying the tourist market. In week 26 his production was as follows.He is paid £6 per standard hour of production (irrespective of actual time worked).RequiredCalculate Tim’s earnings for week 26
 Solution

 

 

£
Deer
Mink
Owls
Eagles
6 2 £6
5 1.5 £6
12 1 £6
6 2 £6
72
45
72
72
___
261
___
    
Illustration 3Standard rate per hour = £4Guaranteed minimum per week = 35 hoursActual production in week 6: 10 units @ 3 hours per unitPiecework rateStandard hours = 10 × 3 = 30 hoursPay = 30 × 4 = £120Subject to guaranteed minimum pay = 35 × 4 = £140 Therefore week 6 pay = £140
   5.5 Overtime 6 MEASURES6.1 Labour turnover6.1.1 Meaning = 100%6.1.2 Reasons for
  • Low rates of pay
  • Lack of supervision and/or training
  • No job and/or promotion prospects.
 
 6.1.3 Costs arising
  • Leaving costs – administering documentation and possible disruption of work
 
  • Recruitment costs – advertising, selection and engagement.

 

  • Learning costs – retraining costs and lower productivity (initially)

 

  • Lower productivity – due to low morale and/or high incidence of absenteeism

 

 

Illustration 5An assembly department employs 30 direct workers and a supervisor at the beginning of a period. During the period six workers left, only four were replaced.RequiredCalculate labour turnover for the period.
 SolutionAverage number of direct workers = 1/2 (30 + 28) = 29Labour turnover = 4/29 100 = 13.8%
  • % can be compared with past figures, targets, industry averages etc.

 

  • Usually closely linked to

 

    • remuneration
    • working conditions
    • training opportunities
    • promotion.
 
  • Other contributory factors – retirement, illness, death, pregnancy.
 
  6.2 Efficiency and utilisation 6.2.1 Production volume ("activity") ratio 6.2.2 Efficiency "productivity" ratio

 

6.3 Idle time