Thank you to South West Water (SWW) for the inspiration for this blog post. Like many homes in the UK, we have a water meter and pay for our water usage by the cubic metre. We pay quarterly, with a reading by SWW every six months and an estimated reading every three months. Over the past year (October - September) the annual usage was about 55 cubic metres; the meter is read to whole numbers of cubic metres. However, when I went to pay the latest bill, I was startled to see the graph below. It claims to show our average daily usage of water month by month for the last two years. How on earth can that be the case?
Let us leave aside the presence of 13 dots on the solid line, one of which claims to show the average consumption for the month (October 2024) which is only just starting. Let us also lay aside the x-axis which is labelled with month and year and then there is a dotted line for a different year. Let us lay aside the suppressed zero on the y-axis. And what does the line between dots really mean?
No, think about how the company claims to know about daily consumption when the readings are taken at such large intervals. How is it done?
Answer --- with great imagination. They use averages and scaling. Based on their supply data, they can assign fractions, f(1), f(2), ... f(12) to each month's demand for customers in my area of Devon. then they take my 55 cubic metres, scale it by those fractions and scale it by the length of the month and ... HEY PRESTO! ... we have this graph. I ran it through a spreadsheet and reverse engineered it to confirm that those dots do scale up to 55.
So, this is imaginative. Also wrong. Also pointless --- can it affect my behaviour? As I have remarked elsewhere, numerical information should be communicated clearly and accurately. Anything else is smoke and mirrors.
Back in the days when I was a postgraduate student of Operational Research, one of the compulsory modules was about communication. It was argued that people who do O.R. need to communicate their results with other people with clarity; that means explaining the results of O.R. studies to non-specialists.
Then, when I taught O.R. to undergraduates, we agreed to introduce a short "CommSkills" programme for the specialists in statistics and O.R.. There were lectures/presentations about written reports, interviewing techniques, making presentations (before Powerpoint, so it was with an overhead projector). For practice small teams had to interview a staff member who was playing a role of a manager with a problem, come up with a solution, and make a presentation to their peers and the staff. I invented a queueing problem associated with a fictitious supermarket filling station --- how many pumps should there be? Other colleagues were inventive with their "management" problems.
(We had a slight tussle with university red tape; this programme could have no credits in the scheme of things, and therefore could not be made compulsory for the students. We dealt with that with a very small stick and a bigger carrots. The stick was: "If you don't take part, we will mention it when we write a job reference." The carrots were a reward for the best final presentation, and the glowing reports from the previous cohort of students who had done the programme. And after a few years, we had reports from our graduates that it was the most useful part of their course, and that graduates from other universities were envious of the skills that had been in our programme!)
Which brings this blog to lessons on conciseness. Our programme emphasised that our students might be working with and for decision-makers who needed a clear, brief report. We could point to words of Sir Winston Churchill, UK prime minister: "Report to me on one side of a sheet of paper ..."; the industrialist Sir John Harvey-Jones "I will not read a report that is longer than one side of A4"
So I loved this story:
When most car companies come to replace a long-running and well-loved model they will create a lengthy and detailed brief setting out in many thousands of words what is required from the new model. When in 1985, Lamborghini finally realised that it needed a new flagship the brief from company president was as follows:
"Create a Countach successor"
His engineers did as they were told, and all for a budget of just ten million pounds which included re-tooling the production line and extending the factory. Bargain. (from "Boring Car Trivia volume 2)
And in my talk on the course, I produced some examples of poor communication in print. What do you understand by a headline "Councillors probe flat flood"? And I had a business graphic which had been produced for an internal readership and lifted without explanation into another document, intended for the shareholders of the company: lovely colour graphics, but what did they mean?
Behaviourconsumer relationsCost-benefit analysisinvestigationmotor industry
Show full content
My reading is often eclectic. I recently found an unusual book called: "Boring Car Trivia volime 2" by Sniff Petrol --- a pseudonym! This entry struck me:
In the early 2000s a Mercedes-Benz engineer spent a year scouring the world for the best button action. The conclusion of his research was that the ideal button "throw" was 1.4mm and future Mercedes switches were designed accordingly. All Benz button suppliers were issued with a finger pressure graph and soft-feel paint spec so that every single button felt the same no matter where it came from.
Let us assume that there is a bit of truth behind this. And then, let us perform a cost-benefit analysis of this year-long project. Cost: an employee's salary and travel expenses, then the engineering costs of producing the spec. Benefit: any button in the customer's car feels the same, irrespective of whether it is on the dashboard, in-car entertainment, steering wheel, door.
The benefit is in the reputation of the company. But why did it need a year's research? If the engineers can produce a sample, then they must know how to control a button under pressure. So why didn't they simply produce a variety of samples and make comparisons, possibly with a consumer panel? In the process the company could have investigated what the consumer wanted, not what that travelling engineer thought was best.
We will never know; but it seems to have been an experiment which would be quite hard to justify.
A couple of weeks ago, I spotted the book "Arriving Today" by Christopher Tims in our local library, and the blurb on the cover suggested that I might find it interesting to an O.R. reader. Essentially, the book is about the journey of a small item from manufacturer to customer in the 2020s, where so much commerce is done online. And in manufacturing, storage and transport, O.R. plays a part.
Having finished the book, O.R. does get a mention, but not enough to merit a place in the extensive index. As the UK O.R. Society repeatedly stresses, O.R. is "The Hidden Science". The mention in the book comes alongside queueing theory, and attributes to the O.R. world the concept of a "buffer stock". That said, buffer stocks are scarcely mentioned except at one stage in the supply chain.
So was it worth reading? The first half of the book deals with the shipping of that small item from a factory in Vietnam, to a container port in that country, across the Pacific to California and thence through warehouses and trucks to the customer. The research was done during the pandemic in 2020, which colours some of the text. Interspersed with the description of the movement of the item, there are vignettes of the people involved (I especially enjoyed the navigation of the container ship from ocean to its berth.) In the latter part of the book, a great deal of the text talks about the Amazon systems, their automation, and the pressure that the machinery and software puts on the employees. Maybe this could have fitted into a second book? The "last mile" of the shipping goes via UPS, and it is clear that the author prefers the management style of UPS to that of the aforementioned bigA. But nobody told Tims that the routing system at UPS had won prizes for the OR team behind it!
Would I recommend it to an OR readership? Yes, because anyone interested in or involved with the world of online shopping is bound to find something new. No, because there are no lessons on the process which leads to implementation of the work of OR people to the business practice here.
There have been numerous books and research papers on aspects of stock control, starting with the classical EOQ model (economic order quantity) and developing modifications to that and other models. Stock control models have led to the concept of Just In Time production --- something which backfired during the COVID pandemic when supply chains were disrupted and demand for many items was more irregular than in less troubled times.
Recently I went on a site visit which revealed an interesting variant on many of the usual introductory models. Let me explain. Here in Exeter, our domestic waste is collected by the local authority. We sort it into four categories:
(1) recyclables (paper, card, plastics),
(2) garden waste
(3) waste food
(4) non-recyclable stuff
Category (1) is sorted into its various categories, (2) is composted (in such quantities that harmful bacteria are killed by the heat), (3) goes to a digester system, (4) to the "energy from waste plant"
The site visit was to the energy from waste plant (EFWP), where the waste material is burnt in a very hot furnace to produce electricity. Now the output from the EFWP needs to be relatively constant, but the input is variable. So the stock control problem is concerned with the "stock" of stuff that is going to be burnt. It isn't collected on Sundays (and not always on Saturdays) so each week, the amount that is used has to be about 70% of what has come in, so that there is a supply at the end of deliveries on Friday evening to last to the following Monday. Except that the daily supply is variable, and there are seasonal variations. But on top of this, there are general holiday dates with no collections on one or more holiday dates. Fortunately, these are known in advance. So the basic amount of rubbish being held will follow a time line like this:
I didn't put a great deal of daily variation in that one. With a more variable daily variation, we get:
and it is apparent that the amount available at the start of the weekend is also variable.
But both clearly show that the storage space for "rubbish" has to be considerable.
The public holidays make things worse. That is left to the reader as an exercise.
How is the stock control managed? By rules of thumb; the controller knows about the holidays, and the daily "demand" so works to ensure that there is stock to meet the demand. And the controller does not have a degree in O.R.; I wonder what would ensue if an O.R. specialist tried to convince that team that a textbook formula would help!
footnote: but of course! This is a variant of the reservoir control problem! We looked at that ages ago in http://orindevon.blogspot.com/2011/09/water-supply-and-environment.html. There, each month had a target level for the water in the reservoir. If the water was below that, then the reservoir was allowed to fill up, if above, more water was released. Here, the problem is essentially the same, except that the target levels of waste in the incinerator are for each day, and those targets follow some kind of trend in the run-up to holidays.
I have been quiet on this blog for a while, not that I have gone away, but there have been so many other matters to deal with. Hopefully I can get back to the coalface soon. But today I was startled by this amazing statistic:
This company (a house agent) was so proud of their popularity that they could claim four-figure accuracy about their clients' delight. As usual, stop and think. The claim is that 98.96%, not 98.95%, nor 98.97% of clients were satisfied. As I closed my eyes in the dentist's chair (the glossy brochure had been in the waiting room), I thought about the sample size to give such raw data, and obviously one sample would be of 1250 clients of whom 1237 were pleased. Of course that would imply that the standard deviation would be quite large as well, and exactly 1250 clients being sampled seemed suspicious. So, back home I ran through other sample sizes, and, lo and behold, 476 out of a sample of 481 also gives the same percentage to four significant figures.
I don't know which is most impressive: the statistic, the ignorance of the company doing the survey for the client, or the folly of the copywriter for the house agent. What do you think?
Education in Operational ResearchJournalsLocationVehicle routing
Show full content
When I studied Operational Research, one of the two professors in the O.R. Department at the University of Lancaster was Professor Alan Mercer. Anyone who knew Alan will know that he was in amazing character, and I am delighted that I co-authored one paper with him. [https://doi.org/10.1057/jors.1978.188] (He wasn't my academic supervisor; I collaborated with him and his research associate Malcolm King on a project about the Church of England.)
Alan had a fund of stories; someone had once asked him why there was still the need for O.R. scientists; if O.R. was such a powerful tool, why were there still unsolved problems? His answer was that there will always be the need for O.R. in business, commerce, education and all areas of management, because new problems arise as a result of technological change, as a result of new industries, and as a result of twists to old problems, and (possibly most important of all) O.R. is needed to remind managers of techniques and results discovered years before.
Worldwide concern about Covid-19 has illustrated Alan's answer; there have been new problems identified across many sectors. Stock control, disease modelling and monitoring, ward scheduling, supply chain analysis, distribution and queue models, and much else.
Alan contributed work on location modelling, and distribution planning. More than once, he lamented that his paper "The Churching of Urban England" (which explored models for location of facilities, in this case, churches, and which was published in the proceedings of the IFORS conference in 1969) was overlooked because other researchers didn't spot the relevance of such models to other location problems.
A recent paper in the Journal of the O.R. Society illustrates Alan's point about technological change and new industries. Chunkmok Lee published "An exact algorithm for the electric-vehicle routing problem with nonlinear charge time" [https://doi.org/10.1080/01605682.2020.1730250] . New technology: electric vehicles. New industry: home deliveries. Twist to an old problem: location modelling of charging stations.
That same issue of JORS (JORS 2021, vol 72, no 7 (July)) had other papers which illustrate the ongoing need for Operational Research. Giuseppe Bruno and others look at the problem of collecting mail at a time when demand for postal services is declining[https://doi.org/10.1080/01605682.2020.1736446]. A.H. Kelte and others tackle the allocation of kindergarten spaces in Norway as the education system develops new constraints.[https://doi.org/10.1080/01605682.2020.1727786] Both are old problems; both have new twists.
There was a day, in my teenage years, when my parents bought a second car. I don't know whether they analysed that decision. It was probably prompted by the fact that my mother had passed her driving test (in the UK, in the fifties and sixties, not all married women could drive; driving cars was still a male preserve, and my mother, like so many others did not work after she was married). But their decision to increase the domestic resources of cars is an example of decisions which occur in many situations. Cars do not come in fractional parts; you either have one or you do not. And the jump from having one resource to having two is a big one.
Why?
In many situations for management, the demand for a single resource increases steadily. Suppose that a resource is being used 80% of the time now, and the demand increases to 90%. Forecasting suggests that the demand will continue to rise. So, sooner or later, the use of the resource will exceed its capacity. So a second resource will be needed. However, as soon as the second resource is available, the average demand for each one will fall to (say) 50% of capacity. And to an outside observer, that suggests inefficiency; there is unused capacity. So, in a sense, the decision maker who obtains the second resource is "damned if (s)he does, damned if (s)he doesn't". It is similar to Catch-22.
(note that with more resources, the drop in average resource usage going from N resources to (N+1) is much less; naively, if N resources are all being used 100% of the time, then N+1 will be used (100N/(N+1))% of the time.)
Vehicles are an obvious example of a discrete resource. But public facilities also fall into this problem of discreteness. When should a new surgery be opened? When should a new school be built? And on a personal level, during lockdown, when should a family buy a second computer?
The vehicle problem struck me in the city earlier. We have one council vehicle to empty the bottle-banks around us. It is well-used; we are rather good at recycling glass. And we don't have kerbside collection of glass in the city, yet. The vehicle is also used to empty the recycling bins for drinks cartons (tetrapaks). The city has chosen to stress the glass recycling over cartons, so there are many more places with glass recycling containers than carton recycling containers. Cartons can be all dealt with in one run around the bins; glass necessitates many runs around the many sites of the glass-bins.
So, should the city expand the number of bins for cartons? If so, then it will need a second council vehicle to empty those bins and some of the glass-bins. But, that's a capital cost or a vehicle, a capital cost for more carton-bins, plus wages, plus running cost, for a very small increase in the income from recycling material. What's to be done? At present, nothing. The status quo remains. But the problem will not go away. The population of the city is growing, so demand for all kinds of recycling facilities and equipment will grow.
And an added problem about this sort of possible expansion. There is a problem of recruitment of drivers qualified to handle heavy goods vehicles. According to one statistic earlier this month, in the UK there are 100,000 vacancies for HGV drivers. So even if we could justify a second vehicle, it might be hard to recruit a new driver.
Meanwhile, I will walk to the nearest glass bin, and occasionally cycle the 4 kilometres to the most convenient carton-bin, combining such a journey with a pleasure ride.
And I will never know how my parents justified the second car, because --- just like many two-car households --- the cars were only used for a fraction of the time. But back then, there were no car-sharing schemes, and our home in the village didn't have a very good public transport system.
Early in the Covid-19 pandemic, the British government encouraged local authorities to develop traffic management schemes which would encourage "greener" transport. This led to several cities rapidly creating "low traffic networks" (described here), sometimes with minimal public consultation.
Here in Exeter, the response was to prioritise cycling over motorised transport, and several roads were closed to all traffic except cycles and (sometimes) buses. Because the response had been partly to help those who needed to travel to keep physically distant from others, this aspect was highlighted.
One of the closures is very near our home. I have refrained from writing about it until some of the dust of controversy has settled, and because I was one of many letterwriters to the council about it. I also lampooned the person who had authorised the advance signage as it reminded me of the children's book character who was told "You ain't got the sense you were born with".
(To deal with the signage; the advance signs read "New road layout to assist social distancing". This may be a good reason, but is no help to a motorist who encounters it. That motorist wants to know what to do; the reason is not directly explained. If traffic is reduced in this road, it encourages walkers and cyclists to use it, and then they will be kept away from congested roads, so it will be easier for that sort of traveller to be 2 metres (or 6 feet) from others.)
Back to my local road closure. The road has been closed to all but buses and cycles. Before this, it was used as a rat-run by a small number of drivers, and by locals going to the local hospital, schools and shops.
Who benefits from the closure? Walkers and cyclists can use a quieter road without traffic (which often broke the speed limit). Local people who now have less noise from traffic and less pollution. Bus passengers gain from a route which has better time-keeping. Many motorists, since they are redirected to roads where there is automatic traffic control.
Who suffers? Local people who cannot use the road as a driving route from their homes to some businesses. Tradesmen and delivery drivers, who must now follow different (longer) routes.
And intangibles? Some people may change their behaviour. Will the changed traffic pattern mean more contributions to global warming or less? How is the closure to be monitored for violators?
And those are just the start of the conflicting objectives, just as in much of Operational Research. What makes this interesting is that the benefits are extremely small for each individual, and there are a lot of people who benefit, but most will not realise that they are benefitting. However for a few local people, the suffering seems big. Small gains for the many; large losses for the few. How do you balance these?
The council has made its decision, which has accepted the benefits, but has made a few small changes for the benefit of the few.
One of the recurrent problems of managing queues is randomness. And when human beings are involved, there is nearly always some randomness. And that's why queues involving machines are easier to deal with; machines are more predictable! Until the problem is scheduling emergency maintenance, due to a particular kind of randomness called failure.
Many analyses of control of human queues advise that to be efficient, the randomness must be reduced.
So, my day of second vaccination was an especially interesting experience for being in a queue which was very controlled for efficiency. I was there for my vaccination against Covid-19. The appointment was at 9:40am, along with about a dozen other people. But of course, we arrived at random times. We joined a single line to be checked in, one by one. Once past that point, control to deal with randomness started. Each patient was sent to a numbered chair, so there were ten of us, all ready to be called for a numbered "server'' (or vaccination nurse) That smoothed out the arrival process, by ensuring there was always a reservoir of people in the waiting area. Then our chair number was called, and we proceeded to a numbered room, where another chair awaited us outside.
So each nurse, in their room, always had a "customer'' being served and another waiting to be served. In queue parlance, the servers were working at 100% capacity. But of course, there was scope for each one to take a break.
All excellent control of a system, smoothing the arrival process at the servers so carefully. Well done, whoever devised this scheme!
All was well until Tina and I compared notes about our experiences, and it transpired that the "system'' found it hard to cope with people in wheelchairs and buggies, who couldn't use the numbered chairs. And the process of "serving'' for Tina and I was slightly different; she was asked different questions from me, and was given more documentation than I got. So, not quite full marks for planning, but still very good.
I know that there has been a great deal of modelling in the health service in the United Kingdom to streamline the vaccination process. The pandemic will provide plenty of case studies for O.R. researchers in that sector. But, I wonder, will there be any rivalry between the designers of different queue management systems?
covid-19CyclingDesignGardeningGovernmentMurphy's Law
Show full content
It is traditionally known as Murphy's Law; if something could go wrong, it will go wrong. The inference from knowledge of this is to imagine what could go wrong, then plan to deal with that. And here's where O.R. has a role to play. Help people to make decisions, help them to evaluate strategies, help them to design better systems, and then help them to build protection around these pieces of advice. This could be ways to prevent problems, or design ways to deal with them if they happen. I was reminded of this essential lesson in a few ways over the last few days. Tim Harford, writing for the Financial Times and the "i" newspaper, had a column "The power of negative thinking ", subtitled "Government could learn from city design about planning for the future ". He opened with the design of road signs which are increasingly being mounted on slip bases so that the uprights break away easily if hit by a vehicle. If something could go wrong... then you don't want the accident to be made worse by entanglement with street furniture. The subtitle refers to the U.K. government's serious difficulties with test and trace for Covid-19, which failed many people because it used a database in Excel. Never, never, never use Excel for a database! And this was a critical set of data. As the article reports: nobody with relevant expertise had been invited to consider the failure modes of the system. No one asked if Murphy had tested the system. Earlier this year, Tina and I bought a cycle carrier for the car. Because Tina rides an electric bike, we needed a carrier that was able to support the extra weight of her cycle, so we had a towbar fitted and the carrier fits onto it. We chose a towbar that could be removed, thinking that we would remove it in the winter when we wouldn't be taking the bikes out for the day. What is wrong with this idea? Yesterday, we discovered. Tina's bike had a puncture, six miles away from home, and on a cycle route, away from a public road. That's a long way to push the bike. On the spot repair is quite difficult, and it is advised that repairs are done by a cycle mechanic. So, yours truly rode those six miles, lifted the carrier onto the towbar and came to meet Tina who had walked nearly three miles. The weather wasn't very good, and I needed to change clothes when I got home because of the rain, and my top layer of waterproofs was in Tina's pannier. What can go wrong? Punctures. Bad weather. Remoteness. Our response. The towbar stays in place all the time. If Tina has a puncture, yesterday's scheme works. If I have a puncture, my bike will fit in the rear of the car so Tina can rescue me. If the weather is dubious, we each have a pannier with our own waterproofs. If need be, take a map. And last week, another "What can go wrong?" experience. Our wisteria hangs from a rope swag. The climber traps water, which rots the rope. After twenty years, the second rope rotted in rather less time than the first. Now the wisteria is established, it is more inclined to trap water in the rope, and is heavier. A third rope is needed. We know what can go wrong. So we react accordingly. The new rope has synthetic fibers, which won't rot so quickly. And, like most garden structures, we know that the wooden uprights will fail eventually. But we also know that they won't be hit by a vehicle!
The lockdown due to Covid-19 (Coronavirus) has led to a variety of Operational Research contributions and ideas. It is interesting to be on the sidelines and watch. One of the first problems for retailers was stockpiling - and toilet rolls disappeared off the shelves very quickly. The first analysis of this (from an O.R. perspective) was that there are two types of supply chain for toilet rolls. One serves the domestic market, and delivers domestic sized, soft paper. The other serves the commercial market and delivers larger rolls of poorer quality paper. Lockdown meant that the former was being stretched as people worked from home, and the two supply chains could not merge. A similar change in domestic arrangements affected the fast food industry, which relied on people buying food on their way to or from their workplace, or during the day. Demand for sandwiches dropped by over 80% in many parts of the U.K.. On social media, there were groups of home cooks vying with each other to produce the nearest approximation to the fast food sold by several well-known chains of "restaurants". A collection problem has also emerged in waste disposal, again because of non-overlapping distribution chains. With so many offices closed, the supplies of waste printer paper from offices has dropped, with adverse consequences for the recycling sector. Domestic waste paper is of lesser quality, and there has not been so much of it. However domestic waste now has a significantly higher content of packaging, as more shopping has moved online.
So here are three commercial sectors where lockdown has changed behaviour. If you were working in any of these areas, how would you forecast the "new normal"?
BicyclescommutersCyclingE-bikes. Bike-shareExeterLocationOperational Research in the homeSupermarketstransportWalking
Show full content
For a number of reasons, e-bikes have been on my mind this week. First there was an article by Simon Kuper of the (British) Financial Times (here) Simon argues that there is no multi-billion pound industrial lobby from bicycle manufacturers, in contrast to that for the motor industry. And therefore, moving people away from a car-centred transport pattern will affect GDP. He describes his investment in cycle-commuting as about 300 Euro, with minimal costs for repairs and spares, and an expected lifetime of use of perhaps 10 years. I agree. In my lifetime, my first new bicycle was a reward for passing an examination at age 11. That lasted me until I was nearly 30, when a car drove into me and wrote off the bike. The next two each lasted just over a decade each, and my present one is going strong after 17 years (I can be exact because the road accident which wrote off its predecessor is a vivid memory.) Annual repairs for the present bike. and new accessories, average less than 200 Euro per year. An annual service for my modest car costs about three times that, and there are running costs as well.
So, Simon concludes, although it is good for the planet to switch to cycling, pressure from companies that make a bigger contribution to the economy will affect government. (There is a cigarette industry ... but no walking industry, nor a cycling industry.)
And, soon after reading that, the INFORMS magazine ORMS Today for February 2020 hit my desk. It lists the most read OR-related posts on social media. And there is the article from Management Science about maximizing bike-share ridership. "It's all about location, location, location". To see the abstract in full, go here. The authors have looked at e-bike hire schemes in several large cities and reached the conclusion - obvious really - that the closer one is to a docking station, then the more likely one is to use the scheme. They took a radius of 300 metres (translated to 1000 feet for an American journal) and found that usage dropped off very rapidly if potential users needed to walk further than that. 80% of bike-share usage comes from people walking less than 300 metres in Paris. Hence a very dense network of docking stations - and an instilled belief in users that they would find an e-bike when they got there. So, "Bike-share operators with limited resources must prioritize building more stations closer to riders."
The paper echoes other research in London and other cities. Intriguingly, they suggest that bike docking stations should be sited at supermarkets. And, on reflection, that makes sense. If you are using bike-share for short commutes, some of those will be to the shops. And if you can dock the bike while you shop, then you don't pay for the time you are shopping. In Exeter, where the charge is £1 per 20 minutes, you could easily be charged £2 for the time you are in the shop(s) and that charge becomes a "tax" on top of the hire charge.
Now, clearly, Exeter is not London. In the suburbs of the city, bus stops are located at intervals of 300-500 metres. It would be lovely, but unrealistic, to have docking stations at every bus stop. But in the city centre, the distance between bus stops, and their location, could be used as a measure and a guide for siting docking stations. And then, add a few at major stores in the inner suburbs.
The research also looks at origin-destination data; docking stations need to be where people will start and end their journeys - railway and bus stations, major employers, and spread around industrial estates and business complexes.
Now, I need a map of Exeter and some 300metre radius circles to fit onto it to work out how to cover the city centre. Watch this space.
And finally, Cycling UK produced a page (here) about the law and practicalities of e-bikes. Towards the end, there is the comment: e-bike users also report higher travel satisfaction than car users. Once again, psychology enters into decision-making.
postscript ... well this is weird! Many years ago, my PhD student Shams Rahman and I published a survey paper on the location of health service centres in developing countries. It is a paper which has been cited in academic journals many times, making it one of my most "successful" publications. (For non-academics, the authors of most academic papers give a list - the citations - of earlier related work which they feel is relevant. Success in academe is measured by how often the earlier paper is cited within a short time, implying that you are doing cutting-edge research. Our paper has been cited repeatedly for 20 years - but would not feature if you measure success by counts of citation within a short time!) The newest citation of our survey paper of health-related location is in a paper about the location of bikeshare docking stations. ("Optimal locations for bikeshare stations: A new GIS based spatial approach" by S Bannerjee et al in Transportation Research Interdisciplinary Perspectives.) Operational Research results often transfer from one area of problems to another, but I do find it amazing that someone has found the relevance of locating health facilities in Bangladesh to locating bikeshare schemes in the USA! Life is full of surprises!
In The Times newspaper today (7th December 2019), this short item caught my attention. Note the remark: "British queueing etiquette only really working in single file".
Oh dear, I wonder if I can ever
stop being someone who "wonders about it all"? (And that quotation is not original; one of
my undergraduate tutors was the astronomer R.A. Lyttelton, and as students we
were amused and impressed in equal measure that this was his hobby in
"Who's Who" in the days of printed information like that.)
We have just returned from holiday,
our first cruise, and it has been memorable for several reasons. As it was a "first " for us, there
were many things to consider and experience.
Not all are relevant to this article.
But here is one relevant
bit. We ate meals in the principal
dining room for passengers - a much smaller one was used for superior
meals. Breakfast and lunch were buffet
service and, in the evening, we enjoyed being at an assigned table with two
other couples. The inevitable
introductions followed and so the others teased out of me that wondering about
queues and their management was a bit of a habit. So, I was challenged to think about how to
improve the buffet service.
Seven years ago, I blogged about
stock control in a hotel buffet breakfast room. It is here.
Since then I have observed hotel buffets in several countries, in small
and large hotels. Tina and I have
noticed both good stock control and appalling.
And we have observed rather too many badly laid out buffet systems for
comfort! However, seeing the problem and
working out how to do something are different.
There have been quite a few breakfast buffets where fresh loaves of
bread were on offer, with one board and one bread knife, at the centre of the
buffet display, so this was a bottleneck
for those collecting food as they progressed along the display, and a nuisance
for anyone wanting bread and having to cross the lines; how much better to have several bread boards
and knives in a place which did not get in the way of other people.
On the cruise, the problem was,
as usual, congestion. There were two
sides to each of two aisles, one side with hot food or salads, the other with
sweets, cutlery and soup. The two
aisles were not identical. They flanked
an aisle where kitchen staff delivered food to the hot trays. You could collect a hot meal from either
aisle, but one end of one aisle had cheese, cold meat and cold fish, while the
corresponding end of the other aisle had vegetables for salad. Each aisle was
just wide enough for three people to squeeze through. And they needed to, as there was no
"right way" along any of the four sides. The flow was, putting it mildly, chaotic.
But the aisles were fixed, their equipment was fixed, and the only way that the
chaos could be eliminated was to rearrange the order of the serving dishes to
encourage orderly flow.
In terms of queue theory, each
tray of food was a server, and customers were passing through a set of
sequential queues, for each of which they could be served or choose to
pass. So, the trays of food (not just
trays, but other sources of food such as bowls and jars) needed to be arranged
in an order which made sense for both the kitchen and the diner. As a very simple example, to make a cup of
tea, you had to:
1)
Collect a cup from point A
2)
Collect a tea bag in a sealed sachet from point B
3)
Unwrap the tea bag and dispose of the sachet in a bin
at point B
4)
Fill the cup with boiling water from a dispenser close
to point A and between points A and B
5)
Add milk from a jug and sugar (if desired) from near
point B
Making coffee was easier, as it
involved only step 1, and steps 4(the dispenser had a button for coffee) and
5. It is left to the reader to solve
this particular problem.
After being challenged to think about
the problem in the dining room, my thoughts turned to the interaction of system
design and system management. Long ago,
somebody had commissioned the cruise ship, and had specified dimensions, access
from the kitchens, power connections and equipment, storage space. But had the system designers considered the
day to day system management? They
could have iterated through possible designs with simulated consumers - even
though the behaviour of those consumers is varied, digital simulation could cope. In other environments, the interaction of
design and management is evident. (Famously,
London Heathrow terminal 5 is "a building designed around the flow of
luggage ".)
So, my solution to the queues in
the buffet is that the problems should have been resolved at design stage. But something could be done, by modelling
different meals and food choices in the present, fixed, layout of walls, aisles
and hot plates, with changed layout of the pinch points.
Using Google scholar, I looked
for any published academic studies of the problem, and there seem very
few. Maybe the cruise ships and related
industries have not employed operational research, or maybe the results are a
guarded secret? I wonder about it all!
I had a chance encounter today on my morning cycle ride. Stopped at the traffic lights, the rider next to me was riding one of Exeter's fleet of e-bikes. I turned and asked if he used the scheme often, as it seems quite popular, and I haven't had a chance to talk to a user before. His reply was that he managed the company, so was committed to it. In the next minute we chatted about the expansion of the scheme - obtaining more e-bikes, setting up new recharging points where bikes can be collected or returned, and - of course - moaning about the difficulties for cyclists in the city. Needless to say, there are O.R. problems here. There have been research papers from other e-bike hire schemes relating to the management of transfers between these recharging points. The location problem is another, with significant constraints - but O.R. has a history of analysing location problems with assorted constraints.
The interesting aspect of the e-bike location problem is that demand varies with time of day, so some methods which depend on using local population as a surrogate for demand (as in location problems for health facilities) isn't enough; you need to factor in the demand from residential areas and from business areas (during the working day) and the management of collection from car parks on the edge of the city.
Picture from co-bikes website - riding on the cobbles of Exeter's Cathedral Close
So the scheme is set to grow - I shall watch what happens with interest. And then, later on, the local weekly newspaper had this report.
During 2019, Tina and I had two holidays cycling in France. (One was a circular ride around the Loire valley, the second was from Paris to Le Mont St Michel.) It was "lazy" cycling, around 60-70 kilometres per day and our luggage was carried between hotels. There was time for sightseeing and leisurely days - though we encountered gales and heavy rain on a few days, so on those days, we weren't tempted to linger over our open-air picnics.
Some of our rides were along former railway tracks, which are pleasant because they are smooth and don't have steep gradients. One day I noticed that our gentle ascent through a cutting would have posed an interesting problem for the engineer - and I am sure that it was one met numerous times in the heyday of railway construction in the 19th century.
Suppose that the railway has to ascend or descend a ridge. The line could be engineered to run over the summit of the ridge with cuttings and embankments to create a steady gradient, or it could be engineered to cross the summit of the ridge through a cutting. The depth of the cutting (D) can be a variable, from 0 metres (summit - no cutting) to some maximum. For any value of D, the engineer can make an estimate of the cost of construction - the cuttings and embankments that need to be included. There will be constraints - especially the maximum gradient of the trackbed. So, for this simple model, the cost will be a function of D, which can be optimised.
This is simplistic, of course. Not every ridge is going to be as simple as this. A railway crosses other obstacles, but the engineer's problem is still one of optimisation - how to create a route which has (perhaps almost) minimal cost - with cuttings, bridges, embankments and tunnels, and acceptable gradients for the trains to negotiate. Famously, Isambard Brunel designed the line from London to Bristol with no gradient steeper than 1 in 50. The problems for those crossing the Alps, Rockies and Andes were more serious.
The same design problems are encountered for road-building, and canal-building. The Tiverton Canal (Grand Western Canal) follows a contour around a valley rather than cross on an embankment.
The Grand Western Canal
The canal stretch between Dudley Weatherley Jubilee Bridge and Greenway Bridge is known as the "Swan's Neck" and is about twice as long as the straight line distance. But much cheaper to build!
Some years ago, I wrote a paper on dynamic programming and board games, which looked at a number of references in the O.R. literature to the topic. One game that I didn't mention, though it had been in my mind while I wrote the paper, is Scrabble. Each week, a columnist in The Times writes about aspects of the game, and last Saturday (7th September 2019) the problem he studied has aspects of dynamic programming.
In any position of Scrabble, the player has to decide what letters to play from the rack and where, bearing in mind what the other player might do, what letters will be left on the rack, and what letters are in the bag to be chosen. In terms of dynamic programming, the state space is too large to consider, which is why I steered clear of it in my survey paper. But the problem in the column is interesting, nonetheless.
Imagine that it is early in the game, so the bag of tiles is almost full. And your rack has low value letters. Then your choice is "between scoring as many points as possible using the majority of such letters [hoping to get some high value letters] or playing one or two letters [because you might pick up letters which can make a seven letter word and score a bonus]" The columnist went on to present the rack with DELNRSU . It wasn't possible to play the word nurdles (or any other anagram) on the board so a bonus wasn't possible with that rack. So the player used the L in the hope of drawing a vowel, because the letters DENRSU combine with every vowel to form seven letter words, and with several consonants as well. With good fortune, early in the game, there will be a place for a bonus scoring move. (In the game analysed, the player drew a T and managed an eight-letter word using the opponent's play.)
But, as the column pointed out, in other circumstances, it may be worth clearing more of the rack. As in all sequential analysis (in the methodology of dynamic programming) "it all depends".
refs: "Scrabble column" by Paul Gallen [The Times (2019) 7 September 2019 Times2 - page 53]
"Dynamic Programming and Board Games: A Survey" by David K Smith [European Journal of Operational Research (2007) vol 176 p1299-1318]
DesignEngineeringKitchensOperational Research in the home
Show full content
Many years ago, when Tina and I were younger, we had camping holidays in Europe. On one of our visits to Germany we saw and bought a little kitchen gadget called an obst-entsteiner; the box still has the price (19.40 DM, as this was before the Euro became currency). What does it do? It removes stones from fruit, such as plums and cherries. Here it is:
Today we stripped one of our plum trees of fruit, and needed to remove the stones from 1500 grams of Mirabelle plums, ready to make jam. (Mirabelle plums are very scarce in the UK, but they make the most delicious jam.) However, these plums are very small - between 1 and 2 cm in diameter, the size of a large cherry. So the stone remover came into use, for the first time in ages.
In operation, one must place the fruit in one of the two cup-rings, press the orange plunger and a prodder hits the fruit and pushes the stone through and out of the hole at the bottom. Even for our small plums, we used the larger prodder (on the left in the picture) which has four blades to slice the fruit and a central recess between the blades to force the stone away. Very simple - but if the fruit isn't ripe, then the stone comes away with some flesh attached. So today's work saw repeated hits of the plunger, and quality control working with a small knife to remove the last bits of fruit flesh. It took about 20-25 minutes.
Somebody, somewhere, designed this tool. Someone chose the dimensions of the various parts to make it as versatile as possible, and imposed some constraints on their design. Consider: the cup-rings must hold assorted sizes of fruit and the sizes of stones that go with them. So the size of the cup and the hole are parameters to think about. Double those parameters for the two sides of the machine, and make a compromise between them so that the two prodders cover sufficient range of fruit sizes for most customers. Four parameters, several constraints, and an efficient design. Maybe the designer didn't stop to write down these aspects of the engineering, but they were there somewhere.
And good design engineering like this is part of the operational research universe.
I opened the newspaper and looked at the map, with its accompanying story and picture, and thought: "There's a TSP solution in the map" (TSP = Travelling Salesperson Problem). But it was an intriguing problem.
Let's start with a bit of background, though much of it is in the newspaper article pictured - with the map - below. The Lake District in north-west England is famed for its lakes (obviously, but very few of them are called "lake") and its mountains. By international standards, the mountains are not especially high, but ascending some of them can be challenging. In the mid-twentieth century, a local man, Alfred Wainwright, wrote a series of seven guidebooks to the mountains and hills. His books are still in print, reproducing his original hand-written notes, his hand-drawn maps and his detailed pen-and-ink sketches of the peaks. They have achieved a cult following, together with his books on the Pennine Way and other walks. The pictures below shows the style of his books.
Creating lists of geographical objects leads to challenges, and so there is the challenge to climb every one of the "tops" listed by Wainwright. There are 214 of them. And there is a long list, online, of those who have visited every one of them. But the ultimate challenge is to visit all 214 in as short a time as possible, on foot, in a continuous tour. And the news story described a new record being set.
As the 214 locations are located in two-dimensional space, the optimal tour must not be self-intersecting. However, as is evident, the route followed by Paul Tierney did pass through some points more than once, and occasionally used a link between points more than once. This too can be shown to be acceptable in an optimum strategy. There will be points which are not Wainwright peaks where access routes to the mountains converge. There are several peaks where the best way to visit them is to climb one peak, move to a second, a neighbour, and return to the first. There are several in the south-east corner, below.
So it is not a "pure" TSP where returns to previously visited spots are forbidden. What makes it especially interesting is that the time to travel between spots is (a) asymmetric and (b) depends on how long the competitor has been running for (tiredness creeping in!)
Well dome to Paul for setting a new record for completion time, and for providing an illustration of a well-known operational research problem in the press.
I have noted before the problems of setting the "stop"/"go" sequences at traffic lights. When the media quote the average time that a resident of X (X may be a city or country) spends in queues each year, invariably traffic queues feature as a source of delay.
So, the other day, I was stuck in a queue at one of Exeter's crossroads. It is one that I knew from my daily commute to the university, so I had measured its performance. Four roads are controlled by the lights. Let us call them North, South, East and West. The normal light sequence is:
A) Green for East and West, red otherwise B) Green for South, red otherwise C) Green for East and West, red otherwise
D) Green for North, red otherwise
E) All red to allow pedestrians to cross
Any of A)-D) may be omitted if the detectors show no traffic waiting and E) may be omitted if no pedestrians have pressed their signal. A)-D) are time-capped at 30 seconds, and are also capped if there is no detectable movement of cars (induction coils in the road surface). The latter appears to be a fail-safe mechanism, combining information from approaching traffic with information close to the crossroads.
What can go wrong? It looks like a good control scheme. And, generally, it is; it even detects my bicycle. But, there is one problem. The road I have called South is the main access route from the police station and ambulance station to the road East - which in turn is a major route to suburbs and out of the city. And when an emergency vehicle approaches the junction during phase B) above, the traffic stops to allow that vehicle priority and to overtake, the fail-safe mechanism detects no moving cars in a queue on the correct side of the road, concludes that there is no queue and switches to phase C). Result - longer delays for traffic on South. When I was stuck in the queue, I observed that normally about 16 cars get through on phase B) but the emergency meant only 2 did. Since the system is fairly well balanced, bringing the queue back to its normal state took several sequences of lights.
Nonetheless, the frustration did generate something - this blog!
I love the idea of surrogate measures. I love it where the "thing" (thing 1) you are trying to measure is hard or impossible to observe and/or quantify, and someone recognises another "thing" (thing 2) which can be measured and which is demonstrably correlated with thing 1. One needs to be aware of the value of surrogate measures in quantitative O.R. ... but also be wary of the dangers of relying on them. If they are used, then they need to be explained, and their correlation be clear both statistically and to the (possibly) non-numerate client.
So it was a delight to me to read in this week's New Scientist magazine of an obvious surrogate measure in response to a question posed by a reader. The question asked was: if there are three WC stalls in a washroom, which stall is most hygienic? The first one you pass, the second or the furthest from the door? The questioner was relating hygiene to usage, so the question becomes one of which stall has the most usage? And the question doesn't have to be limited to three stalls - the question applies for any N>=2 stalls.
One reply observed that because most washrooms are cleaned regularly, then the risk of infection is much less than using shared equipment in an office (landline telephone handsets and computer keyboards were cited as particularly unhygienic). Another suggested that those who use the washroom for a few moments peace and quiet will tend to get to the "security" of the furthest stall.
And then there was the respondent who gave us a surrogate measure. Which stalls use most toilet rolls? As a regular cleaner of washrooms, this respondent had observed that the least used stall was invariably the first one. So, instead of watching the use of stalls by people, measure the use of rolls in each one. Simple, easy to do, and quite obviously correlated ... unless you can think of a reason why the rate of usage should also vary between stalls.
I suspect that when N is large, there might be variations in this conclusion - why walk too far? - but the question was about N=3 and so the variation in distance to stalls is not significant.
Please note that this post is extremely frivolous.
Just before Christmas 2018, Nav, one of the few other operational research scientists in Devon, posted in Facebook that he had spent over five hours in a telephone call. It was about his research, but I commented, tongue in cheek, that such a long wait on the telephone at that time of year meant that Santa Claus needed more elves to be call handlers. Nav replied that this was clearly an O.R. problem, determining the staffing of a call centre. Could this blog examine the problem? he asked.
The literature on call centres is extensive; much of it starts from queue theory models. The literature on Santa Claus is extensive as well, and there is a recent mathematical monograph which has some related material. "The Indisputable Existence of Santa Claus" is subtitled "The Mathematics of Christmas". (Fry, H and Evans, T.O., 2016, ISBN 978-1-784-16274-0) However, there is no discussion of how Santa Claus's call centres operate. Even worse, the authors do not acknowledge the long-standing problem which has faced the Claus Team of managing postal enquiries within a limited turnaround time. Since these postal enquiries generally follow standard form letters "Dear Santa, I have been/have not been a very good child all year. I would like you to bring me ....... My address is .... There will be mince pies and a drink when you come. Love ....." the handling of them is quite mechanical. So the "service time" for the queue of postal requests is close to constant and this makes the queue models easier than those for stochastic service times. It is not surprising that the Claus Team solved this staffing problem long ago.
However, it is well known that telephone messages do not have constant service time, but their duration is a random variable. Thus, my suggestion that more elves are needed seemed to acknowledge limited analysis by the Claus Team. As the only data on hand was the queueing time of one call (Nav's "over five hours"), I found it rather hard to reach any well-defined conclusion about how the system could be improved, and so I mulled over the problem over some mulled wine.
In due course, my glass was empty. I did a little more research and discovered that the Claus Team had progressed from having a call centre, which is why that long queueing time had happened - the call centre is old technology. As is well known in O.R., one should not automatically solve the problem that is presented; it may be superficial, and there will be a deeper problem behind that which is presented. Here the deeper problem is how to satisfy enquiries to the Claus Team; the superficial problem was the size of the call centre.
Although I could not find definite evidence, it appears that the elves are being retrained. Why? The Claus Team has developed a suite of apps for tablets and smart phones which allow children to submit their requests without needing to contact an elf operator. All that is needed is to activate the app and follow the recorded instructions. On a smart phone, the app will simulate the experience of making a call, but it is the app that provides a spoken response, not an operator.
A further development has been trialled in several hundred thousand homes in 2018, and that is to use smart speakers. A child turns to a smart speaker and says "Alexa, I want to send a message to Santa Claus." This instigates a programmed response which is indistinguishable from a direct message to Lapland.
With these developments, it is likely that postal requests to the Claus Team will be reduced, and - in the not too distant future - the elf call centre will be closed down, and become a historical relic. Millions of children will miss it. But progress is progress.
Once again, I have come across an amazing item of statistical idiocy. In "The Times" (very trusted newspaper) yesterday, we could read that 35% of marriage proposals happen in December and 1 in 6 couples get engaged on Christmas Eve or Christmas Day. (The TV programmes must be so dull!) Read on and you find that the average ceremony costs £32,273.
First, who needs to know the exact pounds? What use is it to anyone? Second, how was it measured to such accuracy? Third, who did the measuring? Ah, we read on - the figure comes from "hitched" a wedding planning website. So, we are part way to our answer. This data came from those couples who registered with the website, used their facilities, and dutifully recorded their budget and expenditure. This is not a representative sample of weddings - and the financial figure is based on a series of items of data which are both incomplete and unverified.
Why didn't someone in the editorial office of the newspaper spot the absurdity of this story and rewrite it in a meaningful way?
About once a month, I walk with a small walking group. Earlier this year, while enjoying the wonderful landscape of Dartmoor, one of my fellow walkers turned and asked, "David, what is an algorithm?"
He knew that algorithms affected his daily life, and his experience of the internet, but nobody had ever explained what an algorithm really was. My starting point was cookery recipes, as an example of a sequence of instructions to be followed one after the other, in order to transform an "input" into an "output". Then we moved on to other kinds of instructions, including the apocryphal "hair shampoo infinite algorithm" ((1) Wet hair thoroughly; (2) Apply shampoo; (3) Rinse hair and repeat) which has no stopping rule.
I gave him some other examples, which hopefully allowed him to recognise that when he searches online for some item, then the search engine takes his key word(s) and matches them to pages which fit. Input: key word(s); output: a list of pages on the web.
Today my shopping activity has been scrutinised by an algorithm and it has left us curious because we don't know the output from the assorted inputs it has received.
Our local supermarket has loyalty cards, and a scheme where shoppers can "scan as they shop"
We scan the barcode of our loyalty card, and then the barcodes of each item. The scanner gives us a running total of our purchases, beeps if there are multi-buy discounts, and allows us to run through our purchases. So the input to the algorithm is the list of purchases and a profile of me as a previous customer (identified by the loyalty card). Output at the end is either a bill at the special checkouts, or a request to have all purchases rescanned. The latter option is triggered by what the algorithm considered to be "unusual" shopping, or a random check. After all, the shop doesn't want people to scan nine items and "forget" to scan the bottle of champagne.
Today we were asked to have all our shopping rescanned. Our shopping had included several items we don't normally buy, because we were trying a new recipe needing special spices, and because we bought some tinned food to go into our church's harvest gifts to the local Food Bank. So the algorithm seems to have flagged up unusual behaviour, which was unfortunate because we had packed our shopping as we went round the aisles, and we had to unpack everything.
The cashier is not told whether or not we have been honest, though presumably that is recorded as part of our profile on the records linked to the loyalty card. We had been honest, but ....
... the till receipt omitted one item. Saturday's newspaper had not been scanned by the cashier. (Because we had spent more than a certain amount, the newspaper was free, so the oversight didn't affect what we paid.) So the scanned list and the rescanned list didn't match, but not in the normal way of a mismatch. Normally a mismatch would be [scanned < rescanned]; today [scanned > rescanned].
And our question is: what are the outputs from the algorithm in such circumstances? Did the programmer consider such an experience? If so, what will go into our loyalty profile? And will the cashier's profile as an employee be affected?