donmihaihai Wrote:Maybe someone with knowledge can point out that it is impossible to has 8,590 pair of shoes per worker per year.
Qingmei only makes the soles. The soles are formed by:
EVA I Midsoles: plastic injection moulding
EVA II Midsoles: foam injection moulding
RB Soles: stamping of synthetic rubber slabs
These are all machine-dependent processes.
Cycle time can be estimated given the hours, output and number of lines.
The prospectus has a full breakdown on page 106. They calculate capacity based on 23 hours/day, 29 days/month, and the actual number of months the machines were available.
Let's look at FY07:
EVA I:
===
Capacity = 15,306,000 pairs
Machine-hours available
= [(7 lines * 9 mths) + (2 lines * 3 mths)] * 29 days/mth * 23 hours/day
= 46,023 hours
Cycle Time per machine = 0.00301 hours per pair, or 10.8 seconds per pair
Output per hour per machine = 332.6 pairs per hour
How many workers would you need?
There is one new pair of soles to handle every 11s, if there is one worker working on the same cycle time then you only need one worker. But this goes on 23 hours/day, 29 days/month. So more realistically you need at least 3 workers, assuming each works ~8 hours/day. Suppose you decide to add some slack to allow workers to only handle soles every minute since they have to cut/trim the soles, so you need 5.5x the number of workers, or 16.5. Call it 17 workers. Let's add 6% more workers to account for the 3 golden week holidays (3 weeks out of 52). So we need 18 workers per machine, and 9 machines, to produce 15.3m pairs of shoes over 9 months (weighted for actual availability). Total is
162 workers.
EVA II Stage 1
===
Capacity = 17,290,000 pairs
Machine-hours available
= 3 lines * 9 mths * 23 hrs/day * 29 days/mth
= 18,009 hrs
Cycle Time per machine = 0.00104 hours/pair, 3.75 seconds per pair
Output per hour per machine = 960.1 pairs per hour
We need about 3x as many workers per machine as for EVA I i.e. 54 workers per machine, for 3 machines =
162 workers.
EVA II Stage 2
===
Capacity = 13,833,000 pairs
Machine-hours available
= [(15 lines * 9 mths) + (4 lines * 3 mths)] * 29 days/mth * 23 hours/day
= 98,049 hours
Cycle Time per machine = 0.00709 hours/pair, 25.5 seconds per pair
Output per hour per machine = 141.1 pairs
We need 40% as many workers per machine as for EVA I, so 7.2 workers per machine, for 19 machines, total
137 workers.
RB outsoles and shoe soles
===
Capacity = 27,813,000 pairs
Machine-hours available
= [(13 lines * 9 mths) + (3 lines * 3 mths)] * 29 days/mth * 23 hours/day
= 84,042 hours
Cycle Time per machine = 0.00302 hours/pair, 10.9 seconds per pair
Output per hour per machine = 330.9 pairs
We need about the same number per machine as for EVA I i.e. 18 workers per line, for 16 lines, total
288 workers.
This gives us a total production workforce of 162 + 162 + 137 + 288 = 749 workers
For FY07 Qingmei reported 2,986 workers. So we are off by a factor of 4x. This implies that on average it takes 4 min (as opposed to initial estimate of 1 min) for a worker to process 1 pair of soles. On the other hand, by the company's own figures, it only takes the machines 3.75-25.5s to make one pair of soles, inclusive of loading, injection, curing, unloading and cooling times.
Remember that the soles are made in large batches, especially the rubber soles which are just stamped from sheets of rubber. So one worker handling one sheet of rubber would effectively be moving dozens of soles at a time. Likewise for plastic/foam injection moulding where you can mould 3-4 pieces at a time.
Try to picture what this means on the factory floor:
The machines a new batch of soles every few minutes, each batch consisting of several pairs of soles (effective cycle time per pair is 3.75-25.5s). Workers pick up the batch for processing. Every 4 min, a worker finishes processing one pair of soles (cutting, trimming etc). The implication is that
the manufacturing process is highly labour-intensive, with far more time spent on human processing than on machine manufacturing. Therefore,
to increase output, it is more important to increase the workforce than to increase machine capacity.
This brings us back to the issue of manpower. Big changes in output, yet there was no change in value of plant/equipment and no meaningful change in manpower.
donmihaihai Wrote:3) Disappearing of PPE from B/S
IPO prospectus page A-4
Other payable and accrual - 149m, 144m, 48m
IPO prospectus page A-6
Increase in other payable and accrual - 16m, 7m , 18m
Payment for purchase of PPE - (130m), (52m), (53m)
IPO prospectus page A-27
Addition of PPE in note 13
IPO prospectus page A-32
Other payable and accrual in note 20
Please do the calculation.
Thanks. Yes, problem solved. The company recognized 191m of PPE in FY07 but only paid 130m. The shortfall was made up in FY08 and FY09. Most of it was the factory (construction cost).
donmihaihai Wrote:My point is when manufacturing overhead is as low as 12 - 15%, utilisation rate is not the key to margin. Direct material is.
I did a quick check in my master spreadsheet. Almost all the manufacturing companies in my investment universe charge less than 5% of sales to depreciation and amortisation, it seems to hover around 2-4%. For FY07-FY09 Qingmei charged 7.3%, 4.4% and 3.7%, not unusual.
Every manufacturing company I have ever talked to (which must be in the dozens by now) is focused on utilisation (which they can control) and not raw materials (which they cannot control).
Like I said, this is the first manufacturing company I have ever seen that can book a 16% net margin at only 42% utilisation, and 21% net margin at 56% utilisation.
As usual, YMMV.
mrEngineer Wrote:The problem may lie in the way you have calculated additions to PPE. Using your FY08 as an example,
Expected PPE at end of FY08
= 199.3m (from A-27) - 26.0m (from A-27) + 52.5m (from A-6 CF statement)
= 225.8m
The question is whether is it fair to use 52.5m from cashflow statement as addition to PPE. If we look back to A-27 for FY08, the stated addition was 22.9m. So if you take 52.5m - 22.9m, there you get your missing 29.6m.
Why does this happen? I guess this is because the cash outflow CFI for PPE in FY08 has some amounts relating back to FY07. FY07 addition of PPE was 191.2m (A-27) and compare to FY07 CFI cash outflow for PPE was 129.6m (A-6). This means that in FY07, QM has recognize 191.2m of PPE but only paid for 129.6m cash and has the remaining amounts to pay for the next following years.
Yes, mystery solved. The company got PPE in advance in FY07 and paid up in later years.