Category: Data modeling, visualization & reporting

Executive dashboard design and development – U.S. Government Agency

Challenge.  U.S. Government Agency Program had incurred excessive overtime expenditures in recent fiscal years and, as part of a Headquarters-directed, enterprise-wide initiative, Region leadership was charged to reduce overtime expenditures in the current fiscal year to 25% of base year levels.  To help evaluate its effort, Region leadership sought a simple, user-friendly labor execution reporting…
Read more

Event re-design and management – U.S. Government Agency

Challenge.  The monthly customer meetings (hereafter, “Event”) hosted by U.S. Government Financial Management organization generated sparse and irregular attendance among the target audience – extra-organization personnel responsible for budget management in their respective programs.  The meetings seemed to lack structure and there wasn’t much enthusiasm among leadership. Approach.  Sensing an opportunity for improvement, I proposed…
Read more

Product cost analysis and report development – Global Supply Chain Technology Co.

Challenge.  Global Supply Chain Technology Co.’s supply chain operations team was entering contract re-negotiations with a key overseas vendor and needed a baseline cost analysis of products at both part and configuration levels.  They had concerns with the integrity of existing data coming from internal sources and needed reliable information quickly in preparation for their…
Read more

Resource allocation model design – International Humanitarian Aid Organization

Challenge.  International Humanitarian Aid Non-Profit Organization’s strategic planning director needed a resource allocation model for one the organization’s key products.  One of her requirements was that she wanted an optimal distribution of resources based on certain key factors and constraints.  The sources of information she was working with had copious amounts of data, not all…
Read more

Product forecast model design – Niche Consulting Firm

Challenge.  The client, a product management consultant at a niche business consultancy, needed a financial forecast model for her clients’ prospective new product launch.  She wanted a two-year revenue and expense model that accurately reflected the product’s expected performance in the market and incorporated multiple customer and revenue streams and user-controllable variables.  Furthermore, she was…
Read more

How Much Is Your Business Worth?

Business Valuation Explained It’s said that your business is worth what a buyer is willing to pay for it, but in a competitive, free-market economy in which people have varying degrees of information and limited time to make decisions, how does a prospective buyer determine how much he or she is willing to pay for…
Read more