Maria Castigliani is head of the purchasing department of Ambrosiana Merceti, a medium-sized construction company. One morning
Question:
Maria Castigliani is head of the purchasing department of Ambrosiana Merceti, a medium-sized construction company. One morning she walked into the office and said, ‘The main problem in this office is lack of planning. I have read a few articles about planning, and it seems that forecasting is the key to an efficient business. We have never done any forecasting, but simply rely on experience to guess our future workload. I think we should start using exponential smoothing to do some forecasting. Then we can foresee problems and schedule our time more efficiently.’ Unfortunately, the purchasing department was having a busy time and nobody in the office had time to develop Maria’s ideas. A month later nothing had happened. Maria was not pleased and said that their current high workload was caused by lack of planning – and hence forecasting – and things would be much better if they organized their time more effectively. In particular, they could level their workload and would not be overwhelmed by periodic surges. To make some progress with the forecasting, Maria seconded Piotr Zemlinski, a management trainee, to work on some figures. Piotr examined their work, and divided it into seven categories, including searching for business, preparing estimates, submitting tenders, finding suppliers, and so on. For each of these categories he added the number of distinct tasks the office had completed in each quarter of the past three years. Collecting the data took six weeks, and Piotr summarized it in the following table. 
Now Piotr wants to forecast likely workload for the next two years. He knows a little about forecasting and feels that exponential smoothing may not be the answer. He is not sure that the data is accurate enough, or that the results will be reliable. He feels that it would be better to link the forecasts directly to planning, overall workload, and capacity. To help with this, he has converted the effort involved with different tasks into ‘standard work units’. After some discussion, he allocated the following number of work units to a typical task in each category of work. Category 1 2 work units Category 2 1.5 work units Category 3 1 work unit Category 4 0.7 work units Category 5 0.4 work units Category 6 3 work units Category 7 2.5 work units
Questions - What information has Piotr collected, and how useful is it?
What other information does he need? - How can Piotr forecast future workloads in the purchasing department?
How reliable are the results? Do they suggest any patterns of workload? -
What are the implications of Piotr’s work, and what should he do now?
