HNHacker News
TopNewBestAskShowJobs

andrewlgood

150 karma · joined April 21, 2020

submissionscomments
andrewlgood··on Why Managers Fear a Remote-Work Future
That's a very different conversation - what is the value of having managers. Are you suggesting that companies do not need managers?
andrewlgood··on Why Managers Fear a Remote-Work Future
Why? I understand the author's claims that many managers are not properly suited for their job, but the author never claims that spans of control (how many people a manager can manage) are changing as we move to a fully/more remote work future.

Are people finding that managers have become more efficient in remote settings?

andrewlgood··on Restaurant workers quit at record rate
Just a quick looks suggests it is a big issue. Hard to get firm estimates (presumably because we only know about the people who get caught) but one estimate has it at 7% of total expenditures of $700 billion which puts it at around $49 billion / year.

https://safeatlast.co/blog/medicare-fraud-statistics/

andrewlgood··on Restaurant workers quit at record rate
Interesting statistic. The one year may be a bit of an outlier for the relationship. If you look at the 2010-2020 period in the data linked above, the US had a significantly higher growth rate in business formation (75% vs. 36%). This is not explained by growth in population which were identical over the period (7.2%, wikipedia).
andrewlgood··on Python for Excel: A Modern Environment for Automation and Data Analysis
Thank for the clarification. I did see the lambda announcement, but have not looked at it yet. Will move that up the priority list.
andrewlgood··on Python for Excel: A Modern Environment for Automation and Data Analysis
Back to permissions. Most office workers are not authorized to use those tools. They need the capability built into Excel.
andrewlgood··on Python for Excel: A Modern Environment for Automation and Data Analysis
Excel has become the de facto report writer. Look at how many products have Excel plug ins. This allows them to skip the UI development and the report writing portion.
andrewlgood··on Python for Excel: A Modern Environment for Automation and Data Analysis
Agree. This is why there is so much MS Access stuff out there. It came as part of the MS Office suite so office workers had it on their desktop and could use it without having to IT and work their way up the priority queue.

VBA is terrible, but it is the only programming-like option for most office workers outside of IT/Engineering

andrewlgood··on Python for Excel: A Modern Environment for Automation and Data Analysis
I wouldn't sell the financial analysts short. Pandas was developed by financial analysts to assist in their routine analytics work.
andrewlgood··on If you want to transform IT, start with finance
I think one of the communication challenges in this broad discussion is what is a "finance" person. Several people refer to them as people in Accounting (accountants) when I think they really mean Financial Planning & Analysis (FP&A analysts). Within most Finance organizations there is a big difference. Accountants (particularly early in their career) focus primarily on the past and properly describing it in the general ledger following accounting rules (e.g. GAAP / IFRS). FP&A analysts (should) focus on forecasting the future, then looking at what happens and describing why it differed from their forecast (variance analysis) so they can make a better forecast next time.

I agree with you that it is unlikely accountants will learn SQL/Python/R. They are tied to their ERP and Excel. My hope is the FP&A analysts will develop the SQL/Python/R skills to enable the better/faster development of complex models to forecast.

>The product that would've solved the problem (and then some) was IBM's TM1

I have not used TM1, but have heard many good things about it. Today I hear more people discuss Workday's Adaptive Planning than any other product in that class. Unfortunately most are still creating their primary forecast in a spreadsheet, then loading it into the TM1 or Adaptive which then has additional rules to build out the forecast.

I agree that using these types of products increases transparency and speed.

andrewlgood··on If you want to transform IT, start with finance
Ha. You are correct
andrewlgood··on Python for Excel: A Modern Environment for Automation and Data Analysis
Terribly misleading title. Packages to allow Python to create/manipulate Excel files have been around for a long time.

Like MeinBlutIsBlau, I thought this was going to be Microsoft finally ditching VBA for Python as its macro language.

andrewlgood··on If you want to transform IT, start with finance
Definitely SAP. If you believe the movie, Facebook. Trello/Stack Exchange (Foghat)
andrewlgood··on If you want to transform IT, start with finance
It is unfortunate you had such a bad experience. It's even more unfortunate that there a many more such companies out there.

As a CFO, I want to earn a seat at the table where decisions are made. Finance frequently has access to a significant amount of data about the company and if the Finance team does it job well, they turn that into useful information. Bringing key information to the executive team (and entire company at times) to facilitate the decision-making process is one part of how to earn that seat.

Finance does not have all of the information. The Technology (IT/Engineering/Product Dev/etc) team will have a unique perspective. Marketing will have a unique perspective. The People team will have a unique perspective. I think a company with a strong culture figures out how to embrace all of these perspectives and collaborates to develop world class products and services.

Finance does get tasked with evaluating the ROI question - does the proposed investment opportunity create more financial benefit (can be expansively evaluated) than the investment. That should be to ensure a consistent process and is frequently because Finance is viewed as independent from the group requesting the investment.

A good CFO, heck an average CFO, wants to support good investments. It is always more exciting to say 'yes' than 'no' and importantly the company grows by making smart investments. I have never seen a compensation structure for a CFO that provides for increased compensation for always saying 'no.'

andrewlgood··on If you want to transform IT, start with finance
IMHO, you are not wrong. The advantage of spreadsheets is they are incredibly flexible. The disadvantage of spreadsheets is they are incredibly flexible.

Over the years I have noticed a few conventions that make spreadsheets easier to read from a model perspective. - Inputs should have their own tab and ideally a name. Should also be a color-coded font (blue is popular). - A worksheet should work left to right, top to bottom. I am always frustrated when I try to work through someone else's spreadsheet and the formulas just drift across a tab rather than working in a pattern toward a conclusion/summary - Pretty print sections should be separate from the actual engine. Do the calculations in a manner that is easy to understand. Create an output tab to create the pretty report. - Flag with a bright background color when a formula changes (yellow is popular). This frequently happens when your boss asks you to create a scenario where you override a formula with a constant. I cannot tell you how many hours of my life have been lost tracking down an overridden formula.

These types of conventions make spreadsheets easier to inherit from someone else. They do not change the fact that there can be a lot of calculations happening through a multi-tab that you simply cannot see the bigger picture.

andrewlgood··on If you want to transform IT, start with finance
It is sad how much of Finance (primarily FP&A) gets run through Excel. There are many products out there today that can make the job easier, but as you point out, not all organizations are quick to embrace them.

My personal hope is financial analysts get more tech savvy over time. SQL should be a year one skill with Python/R soon after. These should complement spreadsheets which would still have an important role in ad hoc analyses. Combine this increased tech savvy with an understanding of a visualization tool such as Tableau/Power BI and I think financial analysts could be significantly more productive than they are today.

There would also be far fewer spreadsheets lying around on the network drives. It is amazing how many of those spreadsheets are simply the same model with the next month's data. Better use of databases would allow one spreadsheet with a database to store the changing inputs.

andrewlgood··on If you want to transform IT, start with finance
For clarity, when you refer to finance, I think you mean Financial Planning & Analysis (FP&A). I think you would agree that centralized Tax, Treasury, and Accounting functions are ok and should probably report to the CFO.

With respect to FP&A, I have seen several firms that simply embed them within a product line or business unit. They need to submit forecasts to a central group, but their primary mission is to support the product or business line.

andrewlgood··on If you want to transform IT, start with finance
When I have seen this done, it is because the CEO does not want to get into the details of IT. At that point IT needs to report to someone. There may or may not be a COO. Sometimes see it reporting to a Chief Administrative Officer (CAO), but as landryraccoon points out above, this is not the case when technology is the core product of the company.
andrewlgood··on If you want to transform IT, start with finance
They are, as are salaries. Let me propose it this way, how much do you think the company should spend on responsible waste disposal? 10 dollars? 10 thousand dollars? 10 million dollars? 10 billion dollars? Why do you pick the number you did? What is the benefit to the company of making the investment? Those answers should be the start of the conversation on whether to make the investment.
andrewlgood··on If you want to transform IT, start with finance
No. You actually get better tax treatment for opex as you can record the full amount of the expense immediately as a deduction against your income. Capex spreads the deductibility of the expense over years.

As I mention above, opex vs capex is usually a compensation issue.

andrewlgood··on If you want to transform IT, start with finance
This is not a Finance function issue. Finance has absolutely no preference between opex and capex. There are accounting rules that determine the appropriate classification and any reasonable CFO simply wants it done correctly.

The opex / capex argument is about compensation. Opex reduces income immediately while capex gets spread out over the projected life of the asset (software, power plant, computer, etc). By shifting items from opex to capex, a company temporarily increases its net income. Increasing net income often leads to higher bonuses.

This is what drives the silly behavior. To make matters worse, once a company goes down this path, it cannot get off as it is usually evaluated on a year-over-year basis.

As for accountability, CFOs of public companies can be found criminally guilty (i.e. go to jail) if they not only commit accounting fraud, but simply do not establish a robust enough control framework to ensure the financial statements are correct.

CFOs are always accountable ultimately to the CEO and sometimes to the Board of Directors. If you think the CEO was unaware the company was spending "two or three dollars in capex every year than a dollar of opex," your either mistaken or you had a clueless CEO.

andrewlgood··on If you want to transform IT, start with finance
And that man/woman is the CEO.

Cash flow is the actual movement of money - paying payroll, paying vendors, receiving cash from clients (not just sending out the invoice). Lack of cash flow is what makes companies go bankrupt.

Allocations are methods to attribute income and/or expenses to groups. It may be something simply such as dividing up an enterprise software license for email by the number of employees and allocating that expense to their department. It can be more difficult / squishy such as how to attribute brand marketing spend to various product lines. Generally, companies use allocations because they are trying to understand the profitability of something (a product, geography, client, etc).

Your example of the million dollar spend is a good one. Very easy to see where the cash flow went (Developers, Sales people, rent, etc) but the important question to assist on future investment decisions is how much should be allocated to Project X vs Y vs Z. One would also need to understand how much cash was generated by Project X, Y, and Z so they can determine the ROI (Return On Investment) for each project. Knowing the ROI is important in making future investment decisions.

andrewlgood··on If you want to transform IT, start with finance
I do not recommend getting an MBA or some other financial degree. Rootsudo's response is excellent. There are actually very few financial concepts involved in these types of analyses (e.g. discounted cash flows, IRR, and NPV).

IMHO, the best thing you can do is work with someone in your FP&A (Financial Planning & Analysis) group discuss your investment idea and why you think it is a good idea. If they are a decent analyst, they will help build a model to describe financially your investment opportunity. This is what they live for.

andrewlgood··on If you want to transform IT, start with finance
Full disclosure, I am a CFO and have spent much of my career in Finance. I have never worked in a place where I or anyone else there thought Finance is "any more intelligent than the other players in the company."

This article is disappointing in that it gives the impression that one department makes or breaks a company. To be clear, there are poorly run Finance organizations in the world and they can make the culture at a company less than fun. There are also poorly run IT organizations (to include product development) that can ruin a company culture. Even ones run by a CTO that reports to the CEO.

I have also never seen a company where the CFO does not ultimately report to the CEO. I have seen companies where the CFO reports to a Chief Administrative Officer (CAO) who reports to the CEO. I completely agree that the CEO ultimately sets the vision of the company and hires the executive team to deliver on it. That being said, a CEO is not Superman/Superwoman. They need a team surrounding them to deliver what you expect.

What the article could have emphasized is how software engineers can work with the Finance team to better describe investment opportunities like hiring production engineers to increase the productivity of application engineers. Yes, investment opportunities ultimately need to generate more cash returns than the investment. This may require serious thought around the benefits from increased software quality, faster cycle times, increased cybersecurity etc. Importantly the analyses do not have to be decimal level precise. But, if you cannot describe how your investment opportunity ultimately creates more cash flow than the investment required, your opportunity will likely not be funded.

andrewlgood··on MIT OpenCourseWare
They actually have a page on the site for this - https://ocw.mit.edu/give/other-ways-to-contribute/

Nothing exciting. Send them feedback on how OCW made a difference in your life and spread the word.

andrewlgood··on MIT OpenCourseWare
Let me start by saying I love OCW. It allows a connection to MIT far beyond simply donating money each year. As an alum of MIT, I find it interesting that the OCW video lectures are generally much better than what I recall the actual classes to be. I am not sure if this is because some classes had multiple instructors and only the best are presented on OCW and/or the Professors and students are especially good for OCW because they know they are being recorded.
andrewlgood··on Researchers chart path to drastically lower administrative costs of health care
The introduction of high-deductible health care plans has accelerated consumerism (shopping for best deal) in health care delivery driving down costs.

Deloitte study: https://www2.deloitte.com/content/dam/Deloitte/tr/Documents/...

andrewlgood··on Researchers chart path to drastically lower administrative costs of health care
We clearly differ on the USPS. FedEx, UPS, DHL, etc clearly provide superior service for overnight and courier service. Rural service could be solved - it simply has a cost. To your point, "as a country we've decided that it's in everyone's best interest to be able to go get mail." We have also decided to subsidize the cost of the service with metropolitan customers subsidizing the rural (similar to phone service). If the US used taxes to pay a FedEx, there would be better quality service at a lower cost.

Having the government provide the service introduces politics to the operation of running a business. Where should post offices be located, how often should mail be delivered, what products should we offer, should prices vary according to cost to delivery, etc. These issues make the USPS what it is today - a bureaucratic behemoth that is still delivering Christmas cards from 2020.

andrewlgood··on Researchers chart path to drastically lower administrative costs of health care
But they may be excessively worried that they are sick and demand excess testing and excessive stays in hospitals.
andrewlgood··on Researchers chart path to drastically lower administrative costs of health care
Like the IRS has streamlined taxes and the US postal service has streamlined mail delivery?
← PreviousPage 4 of 5Next →