Dublin Here I Come

I have prepared a paper for an international education conference to be held on and between 29th and 31st October.

The paper is on my work in Kabul: the setting up of a TVET college there.

The conference is being held in the centre of the city.

This is my first trip to Dublin and if you are in or going to be in Dublin at that time, why not say hello!

DW

Six Thinking Hats

In the course I ran this week I built in a Six Thinking Hats exercise and I believe it went well from all points of view. I intended to carry out at least one more 6 Hats exercise during the course but ran out of time.

In at least one of my up and coming courses I have made the 6 Hats even more central and will report back.

One of my motivations for using the 6 Hats technique takes me back a couple of years when we had meetings for the project I was part of and I suggested that we start one of our meetings ONLY with positive news and statements! It was a brilliant move even though some of the team found it challenging initially!

Duncan Williamson

This will Shock you!

I read this in an article in the Economist the other day and whilst I knew the essence of the situation, I had no idea that the values involved were so massive:

"All told, the world’s airlines spend $7 billion-8 billion a year taxiing between passenger gates and the runway, says Yehoshua Eldar, who is in charge of business development at IAI."

That article then goes on to describe one possible solution to this massive waste of energy:

"The TaxiBot, though, uses just 20-30 litres of fuel for a typical trip. It also reduces the risk of debris being ingested by the engines and causing damage. Germany’s Lufthansa will trial the system at Frankfurt Airport from May 2013."

Look here and then take a look at this video on YouTube on the taxibot. Fascinating!

Duncan Williamson

Book Three Arrived

My third book of the summer has just arrived ... Here it is and it's available from amazon.co.uk in Kindle and print format.

This is a much shorter book than The Excel Project book and it is aimed at beginners.

DW

Depreciation ... real case examples

In my new book, Introduction to Management Accounting, ready for publication within two weeks of so from now, I will provide up to date car price information for three cars:

• BMW 320d
• Volvo S80
• Porsche 911

I mention this because my web site includes a page in which I provide two examples of how to use real car price data to estimate a depreciation function. The reason for doing this is to test whether we are using the appropriate method of providing for depreciation.

There is nothing wrong with the examples on my web site but as I was writing the book I felt I ought to use up to date data ... I might leave the old data there too, I will decide later.

Anyway, watch out for the book and the updated web page; but there is nothing wrong with the web page as it is as the methods I use there are still appropriate.

Duncan Williamson

Book Number Three: Excel Work Book: introducing the basic concepts of Excel spreadsheets

I have just finished my third book of the summer, Excel Work Book: introducing the basic concepts  of Excel spreadsheets.

It's only one tenth of the size of my magnum opus, The Excel Project but it is full of great ideas and examples.

The book is, as the title suggests, aimed at beginners or raw recruits to the world of spreadsheeting and it will appear on Kindle at just GBP1.99 within 24 hours or so. I will add the link here as soon as I get it.

Take a look if you are a spreadsheet beginner, you won't be disappointed!


Duncan Williamson

Excel Book Submitted

I have finished my Excel book now and I have uploaded it to Kindle.

It is being reviewed now so I will have to wait to post full details here.

Within spitting distance of 600 pages.

DW

Excel Pivot Table Slicers: be excited!

This post has a two fold aim:

embedding an Excel file in a blog post
showing you how Pivot Table Slicers could change your life

Look at the work sheet that follows!

As far as I can tell, the embedded worksheet that you see below is not interactive in this post so ... Click on the icon in the bottom right hand corner of the embedded file here ... View full size workbook: you will see the whole Excel file then and it IS interactive.

Click on the buttons in the work sheets ... select two or more buttons by ctrl+left click ... then watch the way the chart changes ... take a look at the linked Pivot Table too ... it changes as you select and deselect the buttons ... click on the slicer buttons and see what happens to the Chart! The chart looks terrible when this file first opens ... it's meant to as it's all part of the effect!!


Feedback??
DW

The Proof of my Book Arrived

Here is the cover of my book ... proof copy. Found one error :(. Small mistake and so easy to correct.

Buy it from amazon.co.uk in Kindle and Print versions.

Duncan Williamson

My new book is available NOW!

I have published a new book: Business Cases for mSMEs.

So far it is available from the Kindle book store: just go to there to find it.

It costs just £5.99 and is available for instant download.

This book is for budding entrepreneurs looking for ideas, for teachers who teach entrepreneurship. There are cases on ecommerce, franchising and advertising as well as entrepreneurship.

The cases are short, easy to read and understand and every cases comes with questions to help you to review the case whether for the classroom or to help you with your own business ideas and business plans.

Available from the Kindle book store NOW!

Duncan Williamson

My New Book and Youth Unemployment

It is a sad fact that there are far too many young people unemployed in the UK. For a long time now I have felt that there are several reasons why young people are not getting jobs

• welfare state
• unrealistic ambitions
• poor education

Many young people who live at home are receiving unemployment and other benefits and they may well be satisfying: there is no drive for them to need work.

I talk to young people whose first ambition is to become a manager ... this is before they have any experience and, indeed, education, training and experience. Parents, teachers and others who discuss these matters with their young people need to convince them that starting at the bottom is the reality and not something that was fine in the old days ...

There is no doubt that young people are leaving school in the UK undereducated relative to a generation ago. The people who say, for example, that if someone can communicate, it doesn't matter whether they can spell and so on: complete tosh. This is a recipe for people to be trapped at the lower levels. After all, the average middle and senior manager in the UK needs good communication skills as they have to give speeches, write reports and so on. Mathematical abilities are nowhere near what they were: I have met 18 year olds who wanted to use a calculator to find the answer to the question, "What is 10 as a percentage of 100?"

New Case Study Book: a recipe for success

I believe there are, however, a lot of young people who should be encouraged to take hold of their lives and look after themselves. The book I am writing at the moment is a case study book: lots of examples of MSME businesses that even school and university leavers can take a look at and start. Many of the examples you can read about might even need no capital, or very little capital. One of the fascinating aspects of the cases is that most of them come from the Far East: the Philippines, Singapore, Vietnam, Thailand, Indonesia ... If you would like to see specimen examples from the book before it is published, just write to me at duncan_at_duncanwil_dot_co_dot_uk with Specimen Cases Please as the subject and I will send you three examples from the book free of charge.

DW

Target Costing: new page on my web site

I have written a page on Target Costing. I was inspired to write this page when I found a perfect example of target costing being discussed, accidentally, in a self building PC forum on the internet. The page includes this example and others, including the Mercedes M Class.

Go to this page on my web site and click on the target costing item in the menu under Cost Accounting.

Duncan Williamson

Using Monte Carlo Simulations with CVP/Break Even Analysis

Take a look at this video ... demonstrating the use of Monte Carlo Simulation for CVP/Break Even Analysis. The video is relatively low quality and I am working on uploading the full quality video.

Your feedback is eagerly awaited!

If you would like the spreadsheet that is featured in this video, please send me an email to duncan@duncanwil.co.uk and PLEASE spell out exactly what you want! Sorry but I have received BLANK messages before and messages that say send me the file ... so please be specific and you can have it!


DW

Graphs/Charts ... do it right!

On my web site you will find a lot of examples I put together a few years ago of drawing graphs and charts properly. Anyone who has read those guides will be interested in this page on the Economist web site ... I hope the page is not behind a paywall as it is a good set of examples:

http://www.economist.com/blogs/graphicdetail/2012/06/mis-charting-economic-history%20?fsrc=nlw|newe|6-21-2012|2278741|36353618|UK

DW

RyanAir ... gimme, gimme, gimme!

Take a look at this page from the Financial Times in which you will read about that odious little man at RyanAir who wants to grab money that he has no real right to grab at: it will come to him or not. The other company involved has essentially told him to eff off!

http://www.ft.com/cms/s/0/df47055e-95de-11e1-a163-00144feab49a.html#axzz1vcpWcg8d

Duncan Williamson

2.5 Days or Billion Days?

In my training sessions I often tell my delegates the following story:

20+ years ago someone went round the big car makers and asked them, if you had to make one of every car and combination of features of every car you make, how long would it take you?

Toyota answered 2.5 days
GM answered 2.5 billion years

I have to admit that I have lost and forgotten the source of my story although I try to find it from time to time. I think in general my story is correct. So, what now? Well, take a look here at the comparison between Android driven phones and Apple driven phones ... the key idea is complexity.

Complexity almost killed GM and I believe it should have. Apple is keeping things simple: is this a pointer to the future?

Android phones:
http://fortunebrainstormtech.files.wordpress.com/2012/05/screen-shot-2012-05-17-at-10-09-20-am.png

Apple Phones: essentially it has 3 platforms: iPhone, iPad, iPod Touch

In terms of resolution, scroll down this page and see how Android phones ooze complexity and choice compared with Apples supreme simplicity:

http://opensignalmaps.com/reports/fragmentation.php?

I find this very interesting!

DW

Continuous Improvement

This is a good read BUT you MUST read all of the comments as well as they include some very valuable and additional insights:

http://blogs.hbr.org/ashkenas/2012/05/its-time-to-rethink-continuous.html?cm_mmc=email-_-newsletter-_-strategy-_-strategy051512&referral=00210&utm_source=newsletter_strategy&utm_medium=email&utm_campaign=strategy051512

Duncan Williamson

It's as if I knew!

Everyone knows I am hardly a fan of Microsoft. So it came as a massive boost to me to read that MS is partnering its search engine Bing with Facebook and Twitter ... about a month after I had unregistered with both of them.

Phew! That was close.

Duncan Williamson

Emirates Flies Ever Upwards!

There are two reasons to go and take a look at the Emirates Group's web site, the home page of the Emirates Airlines Group:

• to see the financial and non financial results of a 24th successful year in a row for the group
• to see some lovely photos in their 2011 - 2012 Annual Report

Start here and follow your nose and eyes! www.theemiratesgroup.com/annualresults

Duncan Williamson

Facebook IPO

I have been reading about the Facebook Initial Public Offering (IPO) and here are just a couple of things that I have found  in the Prospectus document from which these extracts have come:


Facebook's Mission

We don’t build services to make money; we make money to build better services.

Culture The Hacker Way

As part of building a strong company, we work hard at making Facebook the best place for great people to have a big impact on the world and learn from other great people. We have cultivated a unique culture and management approach that we call the Hacker Way.

… The Hacker Way is an approach to building that involves continuous improvement and iteration. Hackers believe that something can always be better and that nothing is ever complete. They just have to go fix it: often in the face of people who say it’s impossible or are content with the status quo.

Hackers try to build the best services over the long term by quickly releasing and learning from smaller iterations rather than trying to get everything right all at once. To support this, we have built a testing framework that at any given time can try out thousands of versions of Facebook. We have the words “Done is better than perfect” painted on our walls to remind ourselves to always keep shipping.

(There's more to the Hacker Way in the Prospectus document from which these extracts have come ...)

Five core values for how we run Facebook

1 Focus on Impact

2 Move Fast

3 Be Bold

4 Be Open

5 Build Social Value

(There's more to these value in the Prospectus document from which these extracts have come ...)

From a financial point of view, the implied P/E ratio for Facebook when the shares are finally sold are as follows:

P/E Ratios based on an issue prices below and the EPS above	Based on results as at 31/12/11	As at 31/3/12
$28	57.14
29	59.18	72.50
30	61.22	75.00
31	63.27	77.50
32	65.31	80.00
33	67.35	82.50
34	69.39	85.00
35	71.43	87.50

Those P/E ratios are high, I think and are indicative of the hype surrounding this IPO. Take a look at the risk assessments in the Prospectus to see some of the things that Facebook is worried about. One such worry is that Facebook might not be here in 1 year's time or 5 years or 10 years ... They admit in the risk assessment section that significant parts of their business are already on mobile platforms and are moving to mobile platforms more and more and yet they have no real strategy for turning such connections into revenue and therefore profit: I find that scary!


If I were thinking of investing in a company I wouldn't pay such a vast amount for a share in this dot com company UNLESS I was merely going to try to make a major short term windfall profit.


Duncan Williamson

How Much is a Footballer Worth?

Most of us will agree that Premiership footballers' wages are too high. Far too high. Far, far too high! 

However, how should we decide what such a wage should be?

We hear that Wayne Rooney is paid £250,000 a week. Others are paid similar obscene amounts ... all the way down to marginal clubs whose players might earn as little as £20,000 a week.

 Is Rooney worth £250,000 a week and how do we know? Because of Rooney, Manchester United might be more

• successful than if he didn't play for them 
• exciting to watch 
• consistent from game to game 
• and so on

Can we quantify these effects? Yes, for example, if we can say how many more people watch United because of Rooney together with the money they pay over. We can quantify the number of Rooney shirts and boots that are sold by or on behalf of United. And so on; but this is all very pedestrian and it might be that Rooney has no marginal value.

After all, United has been very successful for decades so has Rooney made their position any better?

Let's look at JiSong Park now: Manchester United's South Korean player. I have found an estimate of his wage of £65,000 a week: much less than Rooney. Can we evaluate Park's worth? Well, I think we can evaluate Park's worth much better than we can evaluate Rooney's worth.

Take a look at this article: http://www.dailymail.co.uk/sport/football/article-2038633/Park-Ji-sung-Manchester-Unioteds-Korean-cash-machine.html That article sets out the reality that because Park is a United player AND is seen to be an all round good egg, he is adored in South Korea. A MILLION pounds worth of United shirts adorn a South Korean back, over a MILLION South Koreans carry a Manchester United credit card with Park's face on it, television audiences are massive because of Park. When Park was not played in the first team by United, South Koreans got a bit itchy about it!

 These Park related matters can be very easily quantified I think. The possibility is that the money rolling into United's coffers from South Korea could easily be just a tenth of what they are now ... that's a blind guess.

Let's see what happens when Park retires from United. Will there be a replacement South Korean at Old Trafford? If there is no replacement for Park will merchandise and credit card income from South Korea dry up?

 Fascinating, if you ask me!

 Duncan Williamson

Another airline tax? Get lost!

This is a simulcast with duncan's diurnal diatribe Read this article and then my comments below http://www.ft.com/cms/s/0/8d2ca858-92f2-11e1-b6e2-00144feab49a.html#axzz1tFw6P9cn --oo0oo-- This is a joke, yes? Cameron agrees so that's it? The reality is that politicians these days are so undereducated in the ways of the practicalities of running a country that all they can think about is to increase taxes and hope that a problem will then be solved. The reality is that this is a matter of planning, forecasting and management. Is it a surprise, for example, that today, an Emirates A380 will arrive from Dubai at Heathrow (and Manchester for that matter) and another one will arrive from Singapore? Is it also a surprise that there may be more than 500 people on each plane? Is it also a surprise that this happens every day of the year? The point is quite clear, airlines have their timetables and their slots at our airports. We all know all of this. Now, just take another step or two from here: on average, how many Brits are on these planes?; how many are from the EU and so on?; how many are from the rest of the world ... la la la. Passenger arrival statistics are a matter of fact and have almost certainly been analysed ... haven't they? Finally, we get the the nub of the matter: the Border Agency knows all of the above much better than I do but in the end it's a matter of staffing and management since the plans and forecasts have largely been taken care of. Like other people on this thread, I travel a lot and would resent most strongly if ever more taxes were loaded onto passengers. For example, a recent flight: cost of ticket £42, cost of taxes and other charges on that ticket £121. Easy target or what? Duncan Williamson

Just Eat

Here's a peculiar thing. I came across an article in the FT yesterday on a company called Just Eat. The essence of the story is that "Just-Eat, an online takeaway site, has raised $64m from private equity group Vitruvian Partners and other investors to help it gobble up smaller rivals, in Europe’s largest ecommerce fundraising yet this year." What's so good about that? I had never heard of the company! So I did a search for them and found that they are here in Halifax too. Well, they are everywhere: an online booking service. Not just a link to the local pizza shed but a restaurant's entire menu is online, you choose from it then Just Eat sends a message to the restaurant which then fulfills your order. Good idea and I am not being paid to write this: I am just surprised that I had never heard of it before! I am not sure if you need a subscription to the FT to read it but see the article Just-Eat raises $64m for acquisitions By Tim Bradshaw, Digital Media Correspondent at http://www.ft.com/cms/s/0/6c805dd2-9097-11e1-8adc-00144feab49a.html#axzz1tFw6P9cn Duncan Williamson

I really don't like this

The other day I asked a friend of mine a simple question: where does he buy his bow ties? Many years ago I went through a phase of wearing a bow tie until one day someone came up to me and said, "And my next trick is ..." I thought that was a fatuous thing to say but shortly afterwards I stopped wearing them. Then I had a conversation with someone a few works ago and she sent me to a web site where there was a very nice bow tie waiting to be bought. I bought that bow tie and have started to wear it ... Following advice from my friend I went to three web sites this week to look for other bow ties. Some really nice ties on offer too. Five minutes ago I clicked on a link in an email message and when I got to the page I wanted to read, there, top left hand corner of the page, was an advertisement for one of the three bow tie web sites I went to the other day. I don't like that. I know about cookies and so on. I know that google monitors my messages for advertising purposes and so on. These days, though, we are being monitored in a google like way outside our email as far as I can see. For similar reasons I stopped using Facebook and twitter recently: apart from the waste of time these sites encourage, they are far too intrusive now. Everywhere we go and everything we do has a facebook and twitter link. Now we are being hounded even beyond that. What can we do about this? Refuse to accept cookies? Can't do that unless you want to input some things over and over again ... In the end then, be aware of what is happening and watch out for the insidious. Someone, somewhere has made 5 pence out of my innocent click through, haven't they? Which takes me to another point: knowing the way google works, I NEVER click through any of their sponsored ads. NEVER. If I see a site that interests me I will copy and type the address of that site rather than click through it. Do I begrudge google their money? Not at all but it's another way in which the modern world is paying another tax without realising (I am sure that is true, by the way) it and without being able to control it. Duncan Williamson

Death wish

Anyone know why this worm might have been attracted to my hall only to get there and die?

Several worms of this type have done this over the last two years or so.

DW

New HR book from Tony Miller

There are at least two reasons for buying this newly published book: firstly, it's very practical and it's been written by a true master of his craft, DrTony Miller.

The second reason to buy is that the tables, charts and numerical analysis were driven by yours truly via Microsoft Excel.

Here's the link to Tony's site where you can buy the book.
http://www.tony-miller.com/the-new-hr.php

Duncan Williamson

Budgeting: Practical Problem

In the Gulf Times newspaper last week there was an article relating to the State budget for Qatar for 2011. What they said was that the budget for that year had been based on an average crude oil price of $55 per barrel. Over the year the average price of crude oil on the commodities markets was $112.83 per barrel. Imagine the implications for a company, let alone a country, of one's selling prices being around 105% greater than one had previously budgeted. I understand from a conversation today that Saudi Arabia's State budget was based on a crude oil price of $74 for 2011 ... the same applies to them as to Qatar except that the difference between actual and budget is not so high. Just goes to show that the Beyond Budgeting Round Table people have made some fair points in their time! Duncan Williamson

Value Chain Analysis: beyond Porter

For a few years now I have been required to discuss Value Chain Analysis. Like most people I start with Michael Porter's view of the value chain. However, what's wrong with Porter's analysis is that it concentrates only on the organisation.

There is a further analysis to add to Porter coming from John Shank and Vijay Govindarajan.

I have prepared a detailed review of Porter and Shank & Govindarajans' analyses and they can be yours free of charge. Just write to me at duncan@duncanwil.co.uk and put value chain in the subject and I will send you a PDF file that begins as follows:

--oo0oo--

Value Chain Analysis

Duncan Williamson

This article is concerned with value chain analysis and you should find it useful for you as you consider ways of enhancing the services that you provide to your clients. An understanding both of value added and analysis and value chain analysis will put you ahead of many accountants for whom these skills are elusive!

Having defined the term value chain, we will take a look at a series of examples that will illustrate the need for such analysis. Value chain analysis is best used when analysing a company’s competitive advantage, or lack of it. Michael E Porter suggests using the value chain to separate the company's activities in the value chain into detailed discrete activities. When broken down to a sufficient level of detail, the relative performance of a company can be determined. (Have et al)

Shank and Govindarajan provide fascinating insights into value chain analysis that take Porter’s seminal ideas a stage further. This article explores some aspects of value chain analysis using data taken from the annual reports and accounts of British Airways and easyJet.

The article starts, however, by distinguishing value chain analysis from value added analysis.

The following are the section headings I have used in the rest of the paper:

• Value Added v Value Chain Analysis
• Identifying Value Activities
• The Value Chain
• Value Chain Framework
• Strategic Implications
• Supplier Linkages
• Beneficial Linkages
• How Value Chain Analysis Works
• Value Chain Case Study: airlines
• easyJet
• British Airways
• Conclusions
• References

Duncan Williamson

Opportunities in Uganda

I have just spent 8 - 9 days in Northern Uganda and have seen that there are many business opportunities throughout the country. Do NOT write to me and ask me for a job, however: what I mean is that there are many gaps in the labour market and they need to be filled. Talk to any businessman you know and get him to invest in Uganda: there are examples of where investment on a massive scale has taken place so why not think a bit smaller and do your bit? Duncan Williamson

Peter Cochrane's Business Philosophy

I heard Dr Peter Cochrane speaking on BBC Radio 4's Today programme just now and at first I was irritated by his Americanised language but once I had explored his web site I thought I would share his business philosophy with you. I think Dr Cochrane would agree that his philosophy is not entirely his own but it is still well worth sharing:

"Another three failures followed until I learned a most valuable series of lessons:

Make sure every single facet of any business you wish start is in place and fit for purpose: technology, design, product, plant, production, market, marketing, sales, delivery, support, aftercare, people, finance etc must all be 100% at the same time. If any one element fails then so does the whole.

• Never assume people understand 100% anything you say.
• Never assume people do anything 100% you ask of them.
• Never believe or trust a customer 100%.
• Never believe or trust a financier 100%.
• Never neglect (4) & (5): they both need care and attention.
• Identify all your competitors: and their state of play.
• Look out for oblique threats from outside your immediate sector.
• Don't be blinded by enthusiasm for a technology or idea - especially if it is yours.
• Don't let pride get in the way.
• It is never too late to shout stop!
• It is never to late to rip it all up and start again.

By late 1998 I had learned a lot through the school of hard knocks, losing my own money; and the companies listed below started to emerge as the cream of the crop from a diverse number of directions. Things started to go right at last and at last I coined Cochrane's Law of start ups, as follows:

Any new company in which I participate and invest enjoys a success that is inversely proportional to my involvement.

This turns out to be an obvious and a self fulfilling law in that if I don't pay attention to the above, then I spend all my days trying to engineer a fix, or mounting a defence, later.

If I get it all right from the start, then I have to do almost nothing, the business largely looks after itself."
See: http://www.cochrane.org.uk/nav/start-up-experience/ 

DW

Back Home Again!

I returned from my latest trip but not in the rudest of health. I have fallen victim to air conditioning and I am hot and weak! I slept all morning and have come back to bed already ... It's only 18:18 but I feel comfortable with my bedside cabinet full of fluids.

DW

Do it right first time!

I went to the internet last night to download a large database of accounting data. I found the data and duly downloaded the data.

When I downloaded the data, it didn't paste in Excel very nicely. No problem, I can cope with that and did so with only a little difficulty. The two graphics below show the before and after. For the before work sheet I needed to copy from the web page and then Paste Special, Text but even so the result was a bit of a mess!

I moved things around and got the following, tidy result:

However, part of the way through my initial analysis of the data I noticed a feature of the data that I hadn't spotted before. I was torn: do I go through each of the eight thousand cells or do I go back to the web site and download the data and start again ... after all, I had cleaned the original database without copying and protecting the original work sheet.

Cut a long story short, I wasted some time last night with the first option, inspecting each of the eight thousand cells. This morning I had a rethink, went back to the web site, downloaded the data again and cleaned the data again ... the better solution.

The Moral of the Story

When downloading and copying data, keep the original data safe and unchanged somewhere: the father and son principle.

Duncan Williamson

Top Down Mathematics, Bottom up Reality

Please take a look at this lengthy article from today's Financial Times. The article concerns the quantitative financial model building taking place in the engineering faculty at University College London. I find it a little odd that this is taking place in the engineering faculty but not surprised that it is happening.


Years ago I wish I had followed the thought that I had in which I believed that mathematicians, physicists and other scientists and engineers had a lot to offer the accounting and economics profession. I have been proven right and in this article there is a telling insight into what I believed but did not know. 


"Mirghaemi was hired by BNP Paribas last summer. A few months later, her boss – a trader for 37 years – mentioned that he could never work out the simultaneous price and position of a trade. On the spot, Mirghaemi wrote down a cosine formula from physics useful for measuring electromagnetic waves. “He was just looking at it,” she said. Mirghaemi emphasised her respect for her seniors at the bank but she said that she felt different. “I think I come from the new generation,” she said, “looking at the finance, the economic, the engineering, the computing altogether.”"


The article can be found here and forgive me if you have to subscribe to read it: http://www.ft.com/cms/s/2/0664cd92-6277-11e1-872e-00144feabdc0.html#axzz1o3Mb7dBx

Duncan Williamson

Spreadsheet Ideas

Trip over to my Excel blog to see two new posts. Long but very useful explanations:

1 Building a population pyramid to compare business data
2 Interest based functions using Excel's built in functions

You need them both!

http://excel2007master.com/

Duncan Williamson

You WILL pay ... I WILL NOT!

Manchester Airport has been asking passengers to put a refundable one Pound coin in a slot to allow them to use their baggage trolleys for quite a while now. I have never used that "service" as I come home and quite often do not have such a coin with me. As I depart I found it very inconvenient to try to get rid of the trolley and get my Pound back: so I stopped doing it.

No great problem.

I just had a newsletter from Manchester Airport that tells me that from April this year there are going to be brand  new trolleys for us ... they are investing one million Pounds in them ... the Pound or two Euro coin will now be non refundable ... they will have GPS tracking in them!

They say

To continue making multi million pound investments in the airport when the cost of air fares are reducing, means that airports can't continue to provide services like trolleys for free. We know that charging for trolleys will not be a popular decision. This is why we are following the advice of consumer groups ...

http://www.manchesterairport.co.uk/manweb.nsf/Content/trolleys

Which consumer groups? No one asked me and I use the place more than most people!! Air fares are reducing are they: I'd like to see their evidence for that!

I will be independent of Manchester Airport's RyanAir style money making scheme.

Duncan Williamson

Swings and Roundabouts

I checked into an hotel from one of my favourite chains and was immediately disappointed. The check in experience was dreadful. The towels are grey and old. There was just one bar of soap in the bathroom (and yes, there is a bath in there!). And a few other annoyances. I was going to rate them as poor: excellent hotel with three star service.

Then bit by bit the staff have changed my opinion: chamberpersons couldn't be better, the egg chef at breakfast is excellent, the breakfast waiting staff are very good. Finally, I just went for a sandwich and not only did I get a brilliant veggie sandwich but one of the waitresses came and made me an offer of a free cake! I accepted and when THEY came I was overwhelmed: the carrot cake was really very good. I could only eat three of the five they gave me ... all small, by the way!

Well done the staff at the Sheraton Deira Dubai

Duncan Williamson

Cost Accounting ... YES!

I got a fascinating message by email today that I want to share with you all. At the end of the message is my reply. See what you think!

Message TO me:

Dear, Mr. Williamson!

I have stumbled upon your homepage via Google search. The reason why I have done that is because I am working on the Thesis. It is dealing with the problem of maximizing the profit of a company X, within a concern Y.

The thing is that I work for a manufacturing company, that is a producer of a household products. And I would like to use Excel modelling to help our managers with a sensible peace of advice, about maximizing profits. The fact that we are part of a bigger concern and deal with only production puts some limitations e.g. our transfer price is fixed. We sell all of the finished goods to a distribution center (so we have only one client) and the profit would be everything we produce cheaper than a transfer price. The problem I see is that our cost price was calculated many years ago and it utilizes outdated principle, when naked price of labor and materials is increased with a fixed percentage of transportation costs, marketing costs etc. I find it very disturbing to read such a cost price, and definition of additional expenses with a fixed rate percentage might be misleading for the management.

The question is can you please advice some good reading? I might say that all of the articles (like "Linear Programming and Excel's Solver") that could be found on your website are quite good, but nothing new to me, as this was a part of financial class at the college I study in. Any book with some insights and tools how to make a company more profitable would be of a use!

The second question is that ok, if I build a model for a whole factory this would be nice, but it does not cut our costs. If I would come up with a proposal how to economy on let's say painting (use thinner paint job for the products, with same level of quality) would be more useful, but the model itself does no tell you where to "tighten the screw". One of the solutions would be to make economies on taxes. With our existing cost price calculation we make around ~12% profits of net sales. And we should pay a company income tax. If we can build a costprice that would lead us to a 3-5% profit, we would economy a huge amount in income tax, and we could decide to make profit in an other unit (we are a concern and might utilise our Hong Kong branch where CIT is very low). But this is the only opportunity I see for company X to maximize it's profit within concern Y. Maybe you can advice me something better?

Any information would be helpful. And I would like you to thank you for the presentation found on your website :Cost Model Building: a simple example" because it explains cost model building in plain words and makes it easy to understand. I might use your ideas for a presentation if I write a good thesis.

Best regards,
A M

Message FROM me:

Thanks for your very interesting message A.

What you have found is typical of the situation in many companies and probably all over the world.

The problem is the lazy accountant who cannot and does not understand where he is and what his company is doing. So it's good to hear that you want to break the mould.

As for reading, I think the best advice is for you to read and consider the differences between traditional cost accounting that you seem to be describing and the more modern alternatives such as activity based costing, time driven activity based costing and even things like the balanced scorecard and so on. I think you already know about these things but if you think carefully about how you can apply them in your own situation you will benefit a great deal.

Again I think you already appreciate that you NEED to understand all products and processes at your place of work before you can solve the problems you have outlined to me. Your biggest ally, by the way, is probably not in your accountant's office but in the factory. Your engineers, production management, stock controllers ... they are most likely the people who are of most benefit to you: learn what they know and it will be a good start for you.

As for saving costs, I would take a different approach: you MIGHT convince someone to thin down the paint, to find alternative suppliers, cheaper labour and so on but think this way. By generating a proper, more rational and scientific cost accounting system, you will demonstrate and reveal the reality of the situation your company is in. If you can then convince your management that what you have prepared really is valuable then they would be stupid to ignore your findings. Your new costs per unit and so on, your departmental cost schedules and all of the other value adding material you will be providing will be an eye opener for them that they cannot resist!

I have worked with people who think that cost accounting is nonsense: that is until I show them that I understand what they do and what they need; I then show them my product cost model and what it can do for them. Then they wake up! Very satisfying!

I hope you find that useful and would love to hear more about your products and services and where in the world you are!

Best wishes

Duncan Williamson

The Bankers Bone Us

Thanks to PK Munro for the inspiration for the title of this post!

The RBS, OUR bank, was ready to shell out millions of Pounds in bonuses in spite of the fact that they seem not to have been earned and were among the least popular things to have done in recent weeks.

These people took jobs whose aims must have been to build and rebuild the bank: their normal duties. These people took jobs KNOWING that the bank is essentially a public sector bank and public sector people do not normally earn private sector bonuses.

I heard this morning that the contracts of these people are in the public domain but I have to say that I have not looked for them and have not read them. However, I would have liked one or more journalists and/or politicians to have set out the terms in these people's contracts that have triggered the potential for the bonuses that had been announced.

The most important thing for everyone to appreciate is that we need these banks to be planning for LONG TERM stability and prosperity. So if there are bonuses paid in three or four years' time then no one will object I think.

Paying bonuses in shares, however, is a bad idea as share prices rise over time, on average: this means that even if the bankers do a poor job the shares they are awarded will be worth a lot more in a couple of years and they will be paid a bonus far in excess of the merit of their recipients!

More nonsense from the banking world

Duncan Williamson

Managing and Interfering

Nick Edwards has written a very engaging autobiography that I recommend everyone to read. 

Edwards is a doctor in an A&E department at a General Hospital somewhere in the UK. The book discusses two main themes:

medical stories

management and interference stories

I enjoyed the book and reviewed it in full for my own web site: http://www.duncanwil.co.uk/book_reviews/edw.html

There are many business, management and even commercial lessons to learn in this book.

DW

Happy New Year

Dear All,

There aren’t many of you because I don’t post to this blog anywhere near as much as I want to. My resolution this year is to post here at least once a week.

Happy new year to you all anyway.

Duncan

Happy New Year

Dear All,

There aren’t many of you because I don’t post to this blog wnywhere near as much as I want to. My resolution this year is to post here at least once a week.

Happy new year to you all anyway.

Duncan