For instance if a company had five drink brands in the market but notices that Brand A, which has a profit margin of at least twice the others is in greatest demand, they could (a) focus production efforts on that brand, so that more bottles go out to trade (b) Apply Best Practice/Continuous Improvement initiatives that would result in lower costs of producing each bottle of Brand A so that even though the market price remains fixed, the company is able to earn increasing profit margins per bottle.
Get Maximum Returns On Your Investment In Spreadsheet Automation By Developing "In House" Expertise. Organisations can deliberately expose their employees to learning events(or self_help tutorials) on spreadsheet solutions development. Such employees can then be challenged to develop in_house solutions that effectively address the business' peculiar data analysis/report_generation needs as they arise.
A DIFFERENT Type Of Automation. The approach to spreadsheet automation that I refer to, is one that seeks to provide functional spreadsheet automation alternatives for ANY spreadsheet user task(s). Typically, solutions like this would require the developer to study existing manual data recording, analysis and report generation systems, then plan _ in consultation with users _ for incorporation of automation into the spreadsheet to replace them, where possible.
For the purpose of creating custom financial and business management solutions that solve your identified problems, and give you control/ownership, without burning a hole in your pocket, Excel VB offers an amazing variety of possibilities, in the hands of an adequately skilled user.