Question

Background:

Y Ltd produces and sells a single product, Y1. The unit specifications of the product are as follows:

Direct material AY:                              12 kg at £4 per kg

Machine time:                                       2 running hours

Machine cost per gross hour:                   £50

Selling price per unit:                             £180

Y Ltd is required to fulfil orders for 8,000 units of Y1 per year. There are no stocks of product units at the beginning or the end of the year. Also, the stock level of the material AY remains unchanged throughout the year.

The following additional information affects the costs and revenues:

1. Production quantity is increased to allow for returns from customers which are replaced free of charge. Returns are due to specification failure and account for 5% of units initially delivered to customers.

2. Production quantity is further increased to allow for the downgrading of 16% of product units at the final inspection stage.

3. 6% of the material AY input to the machine process is wasted due to processing problems.

4. 7% of the incoming material AY from suppliers is scrapped due to poor receipt and storage organisation.

5. All of the returned units from customers are rectified using 0.5 hours of machine running time per unit.

6. Machine running time is 80% of gross machine hours and 20% of gross machine hours is machine idle time.

7. Both downgraded production units found at the inspection stage, and rectified units returned from customers are sold at a discount of 25% on the standard selling price.

Y Ltd is aware of the problem of excess costs and it is planning a quality management programme to prevent a number of such problems from occurring. The programme will cost £75,000 and it is estimated that the programme will have the following impact:

1. A reduction in returns of products from customers to 2% of the units initially delivered.

2. A reduction in the downgrading of product units at inspection to 4% at the final inspection stage.

3. A reduction in the material AY losses in process to 1% of the input to the machine process.

4. A reduction in stores losses of the material AY to 2% of the incoming materials.

5. A reduction in machine idle time to 10% of gross hours used.

Question:

Prepare summaries showing the calculations of (i) total production units (pre-inspection), (ii) purchases of material AY (kg), (iii) gross machine hours and (iv) total sales revenue for the year. In each case the figures are required for the situation both before and after the implementation of the quality management programme, in order that the order for 8,000 units of the product may be fulfilled.

Answer 1

	Existing	After TQM Prog
Total Production Units (Preinspection)
Total Sales requirements	8000	8000
Specification Loss	400 (8000*5%)	160 (8000*2%)
	8400	8160
Downgrading at inspection	1600 (16/84*8400)	340 (4/96*8160)
Total Units before inspection	10000	8500
Purchase of Material AY (kg)
Material required to meet pre inspection production requirement	120000 (12*10000)	102000 (12*8500)
Processing loss	7659 (6/94*120000)	1030 (1/99*102000)
Total Purchases	127659	103030
Gross Machine Hours
Initial requirement	20000 (10000*2)	17000 (8500*2)
Idle Time	5000 (20000*20/80)	1889 (17000*10/90)
Gross Time	25000	18889
Sales Revenue	14,40,000 (8000*180)	14,40,000 (8000*180)