domingo, 2 de octubre de 2016

Why Budget Automation?


I start this issue by asking how many advantages do I get automating the budget of the company?  There are many answers, but let’s see some that have been observed over the years of experience:

• Increased Budget Control and therefore better financial results to make the right decisions at the right time.
• Increased ability to foresee risks in the immediate and medium term.
• Ability to assess and anticipate financial scenarios.
• Increased financial efficiency margins.
• Ability to better align my team. Determine their functions and focus on the real objectives of the company.
• A strategic vision aligned to financial and operational objectives of the company is observed.
• Uniqueness of the financial issues of the company. "We talk about the same."
• Etc…

Now, how do I begin to build the initiative to automate the budget?

We must look at different aspects and how these aspects help me in that determination.


Let's see what I have to do to determine the important aspects of each agent.

• Me: I represent the thrust of the initiative; I am the owner and beneficiary of the solution. I must explain as from me benefit each other agents.
• My team: must be convinced of the direct benefits that brings this initiative and offer you a reorientation of duties that allow them to have more time to analyze and less time to execute operational activities.
• Collaborating teams: every month, those teams help to financials to understand the industry movements, the hard competition and the general news about I+D. We can say Marketing, Sales, Business / Product, Risk and Compliance. All are geared to form a united team to make a single message to the shareholders of the company. Now this gear does not flow by itself, it requires effort and extra work. How to convince these teams to support and participate in this initiative? Will they benefit from new package of information in short time? Will the better understand the financial aspects of their areas? Etc. Convince them!
• IT Tem: the enormous efforts of the IT team should be directly benefited with this initiative, perhaps 50-80% reduction of work to be achieved. They will support you if you offer a work plan with reduced activities, increased efficiency, more control and less work. Remember, without their support you can hardly successfully push the proposal.
• Sponsor: the biggest beneficiary of these initiatives, the sponsor must see in these projects the ability to light the numbers that were in the shadows. Should be able to make decisions based on facts to tack or maintain the course of the company. If the sponsor is not able to achieve this, then reformulates the project.

The company's financial statements should speak for themselves, actions and turns must be appreciable finally here. The shareholder must clearly see that investment is in good hands.

Show me what you offer.

Asks the consulting firm to show you what they refer to processes automation, watch it and judge it with your team. Ask a lot of questions. Try to put your business culture in this new process and prepares a report with the results to your potential sponsor. Do not let them convince you without evidence.
Ask for an ideal team of consultants to achieve the objectives. Evaluate the ability of team to communicate. This is very important to achieve the expected results of the project.

Test what they say.

Try to emulate an activity inside the consultant demo where are involved all agents described above and estimated results with the deliverables you expect to receive and their results.


Data Load
Process Visualization
Time
Activities
Reports
Me
N/A
All
Decrease 100%
Decrease 20%
Online
My team
Decrease 150%
All
Decrease 200%
Decrease 150%
Online and Control
Collaboration Teams
Decrease 80%
Now On
Decrease
50%
Decrease 1 day
Online and same data
IT Team
Decrease 200%
No
Decrease 120%
Decrease 3 days
Independence
Sponsor
N/A
All
10x faster decisions
Less meetings and 10x faster
Online
The Company
Decrease 5 days to close books
All
Financial Statements 10x faster
Business plan 95% accurate
Online

  

Calculates and calculates.

Analyzes the ROI of the project, asks for help to consultants. Determine with sponsor:

• How many bad decisions could have been avoided last year and translate it into money.
• How many good decisions could increase the value of bad decisions and translate into money.
• Check Compliances assessment with regulatory indicators and measure how many goals were breached and its financial impact.
• Analyze the market share of the company and calculates the impact of the next 36 months assuming you keep in the same trend. Now, calculate present value.
• Compare the budget with reality and determine the absolute variance.
• Others.

Take those figures and add it all, result must be multiply it by the opportunity cost of the company. If the company is in the Stock Exchange, take previous number and multiply with the beta of the industry and by two (annual basis) .
This result is the photo in terms of inefficency of the company in two years without your new proposal. Discuss it!.

lunes, 7 de marzo de 2016

SAAS or OnPremise?

I want to share with you a simple analysis noting differences of IT investment on SAAS and OnPremise infraestructures. Both are in the same starting conditions, i.e. capabilities HW / SW are similar and period is estimated in10 years.
In this study I have considered HW, SW, Staff, Training, COB, Upgrades, Inflation, ,consulting, training and support factors. For a more conservative analysis it has not been considered a decrease in prices due to increase in SAAS new customers expected in next 3 years nor to the entry of new competitors with new  database technologies . 
In order to obtain a valid approximation of the SAAS services we have considered a company that provides those services and calculated the approximate amount with a public tool from a web site and the other information has been taken from field experience.
We have not considered devaluations nor currency depreciations.

Example, COB = 10M, then 10% 1M must be added to your recurrent Outflow of OnPremise infrastructure (2M).

Now, total OnPremise outflow = 2M + 1M = 3M. This figure must be compared at same Time (t) with SAAS outflow to verify what the company priority due to current situation is.

As we can see, a break point is observed in year 5, when a OnPremise scenario turns out to be more expensive  assuming HW replacement . I see an onCloud investment should be studied as long term and not short term.

If you want to make a trial before long term contract of SAAS then you can estimate your COB ( continuity of Business) and take 10 % of the outflow and assign to total OnPremise contract with the aim to retire in case of having obtained a disservice in first year.

I suggest use 10% in “normal” conditions, but you can increase to 50% in social, 
Economic or other stressed conditions.
Example, COB = 10M, then 10% 1M must be added to your recurrent Outflow of OnPremise infrastructure (2M).

Now, total OnPremise outflow = 2M + 1M = 3M. This figure must be compared at same Time (t) with SAAS outflow to verify what the company priority due to current situation is.
  
We have calculated the present value of both types of investment over a period of 10 years and the result establishes that if you intend to migrate to technologies SAAS is best do it based on the consideration of evidence of 10 % of the COB and gradually decreasing of expenses incurred in  the OnPremise infrastructure. 
If we observe how the cash flows are distributed over the years and compare between them, we can check are inversely proportional, therefore we would have lower volatility in SAAS cash flow than OnPremise cash flow which is better for Finance Team.

It has also been observed that as IT costs in terms of infrastructure move faster or in other words,  paid faster ( cases of weak-currency countries ) , showing the breaking point is reached sooner, specifically in year 3 due to slower indexation of SAAS services in US$ currency than other solutions used to build infrastructure OnPremise in local currency and local inventory. 

A conclusion:  You must go to cloud the way you prefer but do it at least three years if you want to save money
(This conslusion is personal, it does not suggest at any time make or take decisions of any person or company based on it.)


Next more...

Daniel Juvinao