Cupboards Manufacture Study (2)
Refer to Example 14.6 for the problem description.
Management Questions
1 Using the Laspeyres weighted average of quantity relatives method, construct a composite quantity index for the average change in the quantity of carpentry materials used (cold glue, wooden boards, paint) between 2010 (as base period) and 2011.
2 Using the Paasche weighted average of quantity relatives method, construct a composite quantity index for the average change in the quantity of carpentry materials used (cold glue, wooden boards, paint) between 2010 (as base period) and 2011.
1 Using the Laspeyres weighted average of quantity relatives method:
Table 14.11 summarises the three-step approach (similar to the weighted average of price relatives method) using Formula 14.14, where the base value is found using (p_0 \times q_0).
Step 1: Find the quantity relative for each item in the basket, (\frac{q_1}{q_2}\%). Use Formula 14.11
Step 2: Find the base period value of each item in the basket
The base period value for each item is found using (p_0 \times q_0) if the Laspeyres method is used, or using (p_1 \times q_0) if the Paasche method is used.
Step 3: Weight the quantity relative for each item by its importance in the basket
Multiply each item’s quantity relative by its own base period value. Then sum these weighted relatives over all items. Finally, divide this sum by the base period value of the basket.
Management Interpretation
The ‘Quantity relatives’ column in Table 14.11 shows that the joinery used 15.56% more cold glue in 2011 than in 2010. Usage of paint also increased by 25% from 2010 to 2011. However, wooden board usage dropped by 9.84% over this same period.
In terms of the base period values, wooden boards are the highest-valued item in the carpentry raw materials basket (R7 686 out of R10 223 = 75.2%), followed by paint (R1 952 out of R10 223 = 19.1%), with cold glue being the lowest-valued item (only R585 out of R10 223 = 5.7%).
The weighting of each individual item’s quantity relative by its respective base period weight is shown in the ‘Weighted quantity relatives’ column. Finally, to derive the composite quantity index, the sum of the weighted quantity relatives (1 004 600) is divided by the base value of the basket (10 223).
Thus the Laspeyres (quantity relatives) quantity index = \frac{1\ 004\ 600}{10\ 233} = 98.3 (using Formula 14.14).
This result is the same as for the Laspeyres (weighted aggregates) composite quantity index (Example 14.6, Solution 1).
2 Using the Paasche weighted average of quantity relatives method
Table 14.12 summarises the three-step approach (similar to 1 above) using Formula 14.15 where the base value is found by weights derived from current prices (p_1 \times q_0).
Thus the Paasche (quantity relatives) quantity index = \frac{1\ 175\ 000}{12\ 069} = 97.4.
This result is the same as for the Paasche (weighted aggregates) composite quantity index (Example 14.6, Solution 2).
Table 14.11 Laspeyres (weighted average of quantity relatives) composite quantity index
Carpentry raw material | p_0 | q_0 | p_1 | q_1 | Quantity relatives (\frac{q_1}{q_0}\%) | Base value (p_0 \times q_0) | Weighted quantity relatives |
Cold glue (1 ℓ) | 13 | 45 | 15 | 52 | 115.56 | 585 | 67 600 |
Boards (m^2) | 63 | 122 | 77 | 110 | 90.16 | 7686 | 693 000 |
Paint (5 ℓ)) | 122 | 16 | 125 | 20 | 125.00 | 1952 | 244 000 |
10223 | 1 004 600 | ||||||
Laspeyres (weighted average of quantity relatives) quantity index | 98.3 |
Table 14.12 Paasche (weighted average of quantity relatives) composite quantity index
Carpentry raw material | p_0 | q_0 | p_1 | q_1 | Quantity relatives (\frac{q_1}{q_0}\%) | Base value (p_1 \times q_0) | Weighted quantity relatives |
Cold glue (1 ℓ) | 13 | 45 | 15 | 52 | 115.56 | 675 | 78 000 |
Boards (m^2) | 63 | 122 | 77 | 110 | 90.16 | 9 394 | 847 000 |
Paint (5 ℓ)) | 122 | 16 | 125 | 20 | 125.00 | 2 000 | 250 000 |
12 069 | 1 175 000 | ||||||
Paasche (weighted average of quantity relatives) quantity index | 97.4 |