As part of our business at Sherwood Group Consulting, as Performance Management specialist consultants, we are often drawn in the tender process when it comes to working with large companies.
As a team we sometimes surprise ourselves when we win on our own. But of course we never do it alone as we join large vendors like Infor, Microsoft and other big guys and with large consulting firms like Deloitte, who all bring with them their brand weight that can make us attractive.
To lead too it often makes sense, as software is now less important in terms of risk than the ground advisors who actually make it happen. Many operators like us with corporate commercial experience on board with business and vendor tools knowledge can make the difference. Now unlike days gone we no longer sell software but we still stand together with our vendors of choice and lead on deals for the consulting component. That way as we assess a prospect or client needs and then recommend a vendor, we are now often sought out as clincher for their sale. Taking the lead also allows us to leverage better value for our client or prospect, which most often also gives greater value for everyone.
But enterprise projects these days are no place for the faint hearted Clients are ruthless and commercially oriented in the mature business software vendor market. On knowledge and paying for such things procurements processes often don’t bother to invest properly in understanding what they need and the risks. Instead they rely on the market to cover them as they push all the risk to vendors. So no matter how much you tell them they must do their homework, your contract will hang you out to dry if you don’t make it clear in the words and then fight for it as over and over again as you proceed.
When it makes sense to take the prime spot it also means joining all the players to win. That is equally tough and unrelenting as it adds bigger risks to carry the can if anyone fails.
Notwithstanding being advisors we often have no choice. Even as a minor players, be-it on design, integration, process change or the lot, if a vendor product fails, the whole project does.
Being advisory by nature always places us in the middle and we will wacked for sure if we don’t do our commercial and project homework well and know our game. It forces us to be very sharp so it is not a bad position as at least we can have some semblance of control and leverage for best options on the risk management .
This week I was doing an RFI response which I hope will then lead to being shortlisted and then requested for a proposal. From experience we know that deals are won and lost not on the tender but on the work that leads up to it. So if you are lucky to be invited to respond, the information and effort and sales skill to deliver it well at the RPI stage will count.
All RFI’s are different but having a standard boiler plate of responses can help a lot when you are slogging thru a tedious list of requirements. Also if the RFP is sloppy or ambiguous as an appendix it may also help to narrow the risk and swing any influencer bias built into questions.
As a baseline I dug out an old FPI. It was one of those few and hard to win big deals we all used to see in the good old days. On that occasion we lead and won, based a mostly our submission. I must add that we had quality input from our partners, especially the senior people who trusted us to represent them to protect their value.
If the RFI does its job well, the next step is to respond to a request for proposal. Winning was fun as was the outcome when we got sign off on what we had promised and delivered.
If you take on tendering seriously to win it is a project of no small proportions in itself and should be treated as such.
As a useful reference I also found this process and a diagram at invitation2tender.com
In the meantime would like to share that RFI with you now. The client name, a large multinational public listed group in Asia, has been withheld for various reasons.
Any business considering a PM or BI solution, here are some questions to ask your advisors and vendors, to see how they stack up. Even though the client name is suppressed the client questions are real. Some privacy editing has been done on our responses.
Dear Procurement Manager,
Thank you for your request for Information about an Integrated business Intelligence based performance management solution, referred to as IPMS.
As a Business Intelligence & Performance Management advisor and system implementers Sherwood Group Consulting since 1993 has been advising business on best practice in business performance management.
For your software selection we advise on the best solutions for your requirements. Once selected we would then work with you to configure and integrated your data so you have effective business intelligence tools and performance management controls in place.
Our overall approach integrates planning, budgeting and consolidated reporting. With world class performance management and business intelligence solutions we work with will you to get you up and running in a very short period.
Our general scope of service covers Strategy that charts a course and links key business activity; Planning that models sales & business processes for assessment of risks, Budgeting to agree and align resources and controls needed to deliver products and services; Reporting to provide consolidation & business results analysis with Forecasting that enables continued refocusing to keep it all on track.
With this in place Business Intelligence then allows access to the detail for analysis of large volumes of comparative data, on all aspects of the business. For example access to drill down on detail of critical measures such as sales product, services, customer feedback and external information will enable people in your organsaiati0n to manage the core business more effectively with transparent measures to deliver on the business performance objectives.
As specialists, working and solving performance management issues over a long period with very large down to medium size companies, we enjoy pedigree credentials. We have a long list which of well known and significant customers For your reference we would be happy for you to contact any of them.
Our team has high expertise in management, finance and a wide spectrum of business domains. With leader software we add change management and project delivery services using end to end consulting skills to the mix to make it all work for you.
Together with other relevant information our responses to you request for information on how to meet your functional requirements are enclosed in the following pages.
2.1.1 Strategic planning
|Provide Real time automated display of the Planning tools as follows :|
|1. Departmental Strategic Objective (DSO), Corporate KPI and multi layer Performance Agreement (PA).|
|1.1 Auto link standard templates and time line to the system.||The IPMS web topic and reporting interface is menu style driven and can be designed for timeline workflow access. Also timeline based and similar HTML web pages e.g. hot spots maps etc can be designed and placed on the IPMS web portal with in turn can link and publish any document standard view or process in the system.|
|1.2 Alert users to input within time line (directly or auto upload from user spreadsheet).||Alerts are triggered by events in the system such as variance in results views or date variances.These on turn are able to be linked to the email addresses so custom alerts can be sent to users to respond to timeline and other such variance driven events.|
|1.3 Approve by authorized persons via multi-step workflow (interfaced with MS Outlook).||The approval process in IPMS allows submitters and authorizing and/or review and rejection etc. to be interactively managed via the web with alert email triggers sent to respective parties at respective hand off event times.|
|1.4 Generate reports (including graphic and traffic lights) in 3 different categories i.e. standard, drill-down and user-defined).||IPMS native reporting tools allow users and or the administrator to define and multi-style, including graphics, lines and shapes. Traffic lights is a standard feature used within the reporting tools to show level or percentage of achievements based on pre-defined values. Other standard option within the report includes, drill-down, import, export, calculation and user-defined tools for optimal performance of the reports.|
|2. Work Program (WP) and Business Plan (BP).|
|2.1 Auto link standard templates and time line to the system.||As discussed in 1 above|
|2.2 Alert users to input within time line (directly or auto upload from user spreadsheet).||As discussed in 1 above|
|2.3 Approve by authorized persons via multi-step workflow (interfaced with MS outlook).||As discussed in 1 above|
|2.4 Capturing KPIs from BP.||Strategy management captures KPI’s as an element of the business planning capability of this tool.|
|2.5 Generate reports (including graphic and traffic light) in 3 different categories i.e. standard, drill-down and user-defined.||As discussed in 1 above|
|Reports:Reports delivered will reports for the strategic planning process, for which some reports may need to interface data from external systems e.g. Oracle, Maximo etc, these reports include, but not limited to the following.||General comment on linking reports to third party data. IPMS reports use data stored in the applications analytical database which loads data from the source systems. Data from Maximo, Oracle SAP, MSSQL and other sources including spreadsheets and other third party external systems etc. [such as partner systems] can be loaded via a generalized extract transform and load (ETL) & a mapping based data loader.This makes the data consistent for reporting using template to present target data via the web or excel.The web reporting is delivered by a portal manager that can be configured for multiple users and classes of user classes etc depending on their operational need.
In some cases transaction detail is required to support performance information. This is done by reporting the underlying detail using dimension driven parameter fed drill thru capability to query to source and return transactions onscreen. e.g. invoice details
In addition the web portal can deliver generalized web documents that manage and inform users on the process and arrange activities in logical workflow order.
This management of database and reporting in the web portal is designed to be done by the operational team (Finance and/Or Planning controller functions. This frees the IT from this onerous responsibility to allow it to focus on manage the general infrastructure.
|Standard strategic planning reports Report name||General comment on Report setup|
|1. Departmental Strategic Objective (DSO)||Document upload / Link to Strategy management Library|
|2. Key Performance Indicator (KPI)||Planning targets reported from inputs to Strategy management Module with actual and budget where relevant to be calculated by the database based on KPI elements contributing|
|3. Performance Agreement (PA)||Data stored in database together with documents uploaded as attachments to data submissions|
|4. Performance Review||Data extract report|
|5. Work Program (WP)||Data extract report based on dimension related|
|6. Business Plan (BP)||Data extract report based on detail dimension and version related|
|7. Business Plan summary by category||Data extract report based on detail category dimension and BP version related data|
The system must provide a Real time automated display of the Budgeting tools as follows:
|1. Budget preparation|
|1.1 Provide a capability to link with strategic planning module, to ensure that the detailed budget is provided base on approved DSO, PA, WP and BP.||Strategic planning mobile provides for direct hyperlinks links to budgeting module|
|1.2 Provide users an easy path for inquiry regarding strategic planning information.||Access and navigation is via the menu based on organization and other dimensions, the menu can be customized, categorized based on the inquiry requirements.|
|1.3 Provide a budget time table in CALENDAR format which able to remind, alert users what is due and when. The budget time table should also be easy to revise.||Budget system has a timetabling and workflow timetable management with email and onscreen alerting capability.|
|1.4 Provide a capability to prepare budget for several years such as 5 Years and project life.||The underlying data warehouse is configured such as to allow budgets for unlimited number of years e.g. also for 20 life project life.|
|1.5 Provide a multiple budget version to keep a budget data at any step of the budget process e.g.. user submission, Budget review meeting #1, Board, etc.||Additional budget versions can be added at any time by the administrator to accommodate work flow steps and any special reporting needs etc. There is no limit in the number of versions created as well.|
|1.6 Provide a capability to input budget in many currencies e.g.. AUD,SGD THB USD, etc. Report shall be provided for each currency portion and analyzable for impact when changing the exchange rate.||All data is stored in the local currency then this is translated to any nominated Currency for any nominated rate version maintained in the system e.g. Local and USD etc. Reports are then able to be configured to isolate currency impacts e.g. Actual at budget rate compared to Budget at budget rate and actual rate etc for any nominated currency|
|1.7 Provide a Budget assumptions / Global budget drivers input worksheet, together with standard analysis reports for COMPANY assumptions. These assumptions shall be able to revise during the budget preparation e.g.. FX .rate. Changes in these assumptions should not affect budget entity which was already submitted/completed.||Tables are configured in the system for either referencing globally or for specific time periods and classes of assets etc. Updates can be made at any time during the budget cycle with previous version snapshot options used to preserve and stored comparative information|
|1.8 Efficient budget input worksheet. •Provide users with 2 ways to input budget data: input directly into the application web-based and input using a Excel-based input worksheet.||General capability in the solutions allows data to be submitted via excel or the web. The application includes web and excel views access to the data. Both use the same underlying template manager which can be preformatted for the users for ease of processing including data entry.|
|. •The Excel-based input worksheet must provide users an easy input and automatically interface to the system.||Users may reconfigure and store views as private views to suit their own styles and work habit. They can do this either in excel or via the web.|
|. •Provide an off-line capability for Excel-based input worksheet.||Views in Excel are able to be disconnected (logoff) from the web for offline use etc and later reconnected and data upload. The excel file can be edited or changed offline.|
|. •Able to attach supporting documents to budget preparation worksheets e,g. Work programs, Presentations, Board agenda for individual projects.||Documents can be attached to any view using an upload function.|
|. •Able to add comments or crucial information to each cell, row, and worksheet.||Comments can be added and stored in the database on any enabled view for retrieval. This is like excel cell notes This feature is integrated to store notes captures for both web and excel interfaces.|
|. •Provide budget functions such as incremental (increase by fixed percentage)..||Varied of approaches to this can be achieved by users using onscreen / excel phasing tools, embedded rules based parameter driven inputs and references. Also planning tools allow for top down, incremental and spread capability such as fixed percentage, or incremental percentage.|
|. •Provide print-out in a good format and easy for users to set their printing layout..||Quality printing can be done via production reporting services, Microsoft reporting services and general generic local print and print file functions with user friendly functions such as one would be using standard Microsoft print-out tools/layout.|
|•Message alert when users perform a wrong function or forget to enter the required data.(validation)||IPMS has embedded message alerts for error and invalid operation. Critical specific workflow alerts can also be added to views using open and generic event based asp technology.|
|•User can create any format they need e.g. Different font sizes, font colors etc. in the Excel-based input worksheet, which will still exist after uploading the budget data to the system..||Users can generally customize views and save them as private views. In excel there great flexibility for user to customize any view without compromising the underlying data or the view.|
|•Able to input the data for both financial and non-financial items.||The database items are configured to recognize the differing data types and related behavior enabling to input data for both financial and non-financial items.|
|•Able to view any useful information for budget preparation such as COMPANY budget standard, procedure, guidelines, assumptions and contact person details.||Any document is are easily able to linked to be published on the web portal enable to view any useful information for budget preparation such as budget standard, procedure, guidelines, assumptions and contact person details.|
|Able to view historical data e.g.. Last year actual, Last year budget..||The database is dimensionalised to store and retrieve all such data for any period version etc. based on the selection of the user.|
|. •Able to view the input result on screen from budget input worksheet.||Screens views can be configured for multiple views, e.g Input and results enabling to view the input result on screen from budget input worksheet|
|. •Able to calculate in a supporting worksheet, for which results can be linked to the budget input worksheet..||Combining database linked data cells and other worksheet data facilitates linked worksheet for data entry etc. Data in a worksheet can generally be configured using all excel capability.|
|. •Able to upload the detailed budget from operator work program and budget (WPB) into the system. A mapping table is needed since COMPANY has many operators who employ various types of WPB format..||External Operator data can be uploaded by user using Open Link mapping tool provided with the software. A mapping table is provided to map various WPB formats.|
|• Able to set a different formula for each worksheet such as revenue formula..||Formula in a worksheet can be managed to suit any circumstance. Underlying database rules are not impacted by worksheet driven calculations. Where different database calculations are required, the administrator can apply conditional logic and rules filtering using the functions of the database rules engine|
|. •Able to set a different budget item for each worksheet and also able to show only the most-frequently used budget item.||The database can store multiple scenarios of inputs with the last submitted version being the default.|
|1.9 Provide multi-step workflow capability (interfaced with MS outlook) for budget submission, for which users can add a budget submission note and also allow executive responses to budget holders and also provide budget submission tracking and notify to users.||Submission tracking and approval process inked to MS outlook is a part of the tool. This is workflow deigned function that provides interactive submission forms and notes for submitters and executive responses capture within approval cycle.|
|1.10 Calculate salary budget by using salary tariff and manpower plan information and post the results into the budget input worksheet.||A detail Budgeting capability provide for event driven salary and manpower planning in detail with results auto linked to budget worksheets.|
|1.11 Calculate traveling budget by using the traveling tariff and travel detailed entered by users and post the result to the budget input worksheet.||Embedded detail worksheet cater for users to enter addition budget information e.g travel with total linked to tariffs and posted to the budget worksheet|
|1.12 Provide top-down budget input worksheet e.g. Training and Development budget, with its result should be automatically posted to each dept./project.||Top down budget worksheet posting capability using in spread capability in the IPMS application software automates top down posting. This uses a user defined reference to calculate the spread e.g last year or related results. Planning module also achieves this with lock spread and other complex modeling capabilities|
|1.13 Provide Multi-tier allocation (many factors and different formula for each project are allowed), with their results should be posted to the budget input worksheet. Allocation reports shall be provided as well.||The database includes allocation formula capability for iterative allocation on a multi tier basis. Reports on the embedded rules are provided on screen an demand.|
|1.14 Provide an on-screen standard analysis package for both Head office and Project proposed budget which are able to interface with a presentation file (MS PowerPoint).||Using combination of the embedded views. Web publishing capability and excel cell based reporting using PowerPoint for presentation is simply configured|
|1.15 Provide group consolidated budget capability.Provide a group consolidated budget for both revenue & expenditure.||This is a menu managed function to invoke consolidation of all dimension elements and hierarchy members. As a native function of the IPMS application it to deliver integrated consolidated results for all items in multiple currencies and after applying rules and journals etc.|
|Provide elimination capability for the specific Business Asset Project/Dept.||Departments and project within departments are configured as dimension elements with consolidation points for relevant hierarchy reporting. Inter-business eliminations can be configured to automatically eliminate at relevant consolidation levels.|
|Consolidated budget analysis and report|
|Provide multi-dimensional reports for analyzing the budget.||The analytical nature of the data base allows for any dimension and or element within to be reported and analyzed|
|Provide consolidated work plan e.g.. Seismic, drilling and facility construction.||This is configured as elements in the a custom dimension designed to capture drilling program information etc|
|Provide analysis reports for concerned budget item e.g.. travelling expenses.||Any selection can be customized or provide in ad-hoc views in select and rotate pivot style nested views|
|Provide analysis method/decision criteria to judge revenue or expenditure number.||Parameter selectable analysis driven reporting can be configured using rules and data combinations. E.g. unit cost performance related|
|1.16 Able to maintain budget review meeting information in the system e.g. meeting agendas, standard presentation template, minutes, presentation files etc. along with a convenient way to make any need inquiries||Meeting files agendas and access to files can be provided via the web in a secure manner. Online meeting agendas and minutes are able be stored in MSword and uploaded to the web for general access. Configuration of this is provided for in the tender to the extend that capability will be added so the system administrator and user can manage their own options.|
|1.17 Notify users of the approved budget amount with notes (comments from budget team/management)||Alerting functionality and submission controls provide for notification of events. Notes and comments are stored in alert targets. Custom inclusion of notes with alert emails would require defining and would likely require custom asp code and is not included in this tender.|
|2. Budget monitoring and reporting|
|2.1 Provide multi-step workflow capability (interfaced with MS Outlook), with results automatically posted into the system.|
|Request for Budget reclassification.||Enable user to update re-classification values via data entry screen and then invoke the approval process to and update the budget allocation.|
|Business plan (BP).||Use approval process with alerting to manage submission approvals|
|Authorization For Expenditure (AFE).||Use approval process with alerting to manage user inputs for request updates|
|Internal Authorization For Expenditure (IAFE).||Same as previous|
|Budget help desk.||Use approval process with alerting|
|Closing forecast preparation (System should calculate a closing forecast by the certain formula and also allow user to edit, use their own assumption).||Use approval process with alerting to alert user of significant variances to automated calculated closing forecast adjustments|
|Twelve-Month rolling cash forecast (System should calculate a cash forecast by the certain formula and also allow user to edit, use their own assumption).||Same as previous|
|2.2 Provide alert messages to concerned person, these messages included, but are not limited to the following.|
|. • Budget availability: When processing a Purchase Requisition in Maximo or Payment in Oracle, the system should compare commitment/actual to the approved budget and provide an alert message if the budget is not sufficient.||Variance report alerts trigger|
|. • Actual warning : When actual spent or the progress of activities meet a criteria, the system should provide an alert message for users.||Variance report alerts trigger|
|. • Distribution of reports : When a report is ready for access, an alert message will be submitted to users with a system link.||Update Flag driven alert trigger|
|2.3 Reports and Analytical views.|
|CONTRACTOR shall ensure an efficient the system interface between the new system and COMPANY existing system. The new system must be able to produce reports in accordance with COMPANY requirements.||The reporting and process interface is generally design for user management for this purpose|
|Provide sets of reports and analytical views / assessments for both financial and non-financial items which can help COMPANY ensure the effectiveness and efficiency of the budget.||This is generally the intent / objective of the application to provide analytical repotting capability to plan and manage performance|
|Provide a what-if analysis.||This function is provided by a what if module that is part of the system|
|Needed reports for all levels of users (President, VPs, Budget holder, Budget staff, User, etc.) should be defined during the report design.||Report interfaces are able to be configured this way so users are have access to relevant format only etc.|
|Reports should be able to be provided in many formats e.g.. In tables, graphs together with the drill-down capabilities. They should also provided a warning sign.||This is native functionality. Warnings are generally provided via variance color code and or/ alerts|
|Budget users should be able to click within the report to submit e-mails to executives together with their comments, clarification or feedback. Executives should also be able to respond to these e-mails.||This is not a standard function but can be simple added via custom asp add-in linking to the report dimensions to a email for recipient recovery|
|Provide a multi-currency report.||Provided via currency dimension selections|
|Provide a list of available reports with authorization.||Reports are authorized by user profile limited to unit or custom dimension etc. authorizations are listed via security profiles|
|Provide a most frequently used report.||This can be determined form the system log but information is not generally required as reports are user driven|
|Provide quick access to reliable information via the web.||Immediate web access to information provided as already calculated web from the underlying integrated data warehouse|
|Provide an effective on-screen display.||Onscreen display provides a range interactivity tools for user analysis.|
|Provide print-outs in an effective format and easy for users to set their printing layout.||Reporting services, excel and export functions all provides for user configured printouts|
|Provide an easy way for users to create their own reports.||Onscreen capability is provided for users to create/configure and save and publish private views and reports|
2.1.3 REPORTING & RELATED PROCESSES
Provider to deliver reports for the Budgeting process, for which some reports may need to interface/include data from external system e.g. SAP Oracle, etc., these reports included, but are not limited to the following.
|Standard budgeting reportsReport name||Complexity||Generally for all reports, unless they are required to be linked via excel to simplify for complex publishing, the data sill be supplied to views reference to dimensions elements. In addition where views require additional detail from Oracle or Maximo this will be provided via parameter linked drill thru query to an interim transaction table that is automatically update periodically as required from the source(s)|
|1. Business assumptions and administrative parameter||Low|
|2. Consolidated budget||Low|
|3. Consolidated actual vs. budget||Low|
|4. Consolidated closing forecast||Low|
|5. Twelve-Month rolling cash forecast||Medium|
|6. Additional budget approved by Board (during the year)||Low|
|7. Contingency budget||Low|
|8. Budget reclassification||Low|
|9. Consolidated trend analysis||Low|
|10. Project Analysis by major categories||Medium|
|11. Head office Analysis by major categories||Medium|
|12. Financial indicators + Drill-down to cost component.||Medium|
|13. Head office budget||Low|
|14. Head office actual vs. budget + Drill down to transaction||High|
|15. Head office closing forecast||Low|
|16. Head office daily report (Budget, Commitment, Actual)||High|
|17. Project budget + Drill down to AFE and IAFE||Low|
|18. Project actual vs. budget + Drill down to AFE and IAFE||Low|
|19. Project closing forecast||Low|
|Project management reportsReport name||Complexity||General comment on Report setup|
|1. Operating assets daily report (Budget, Commitment, Actual)||High||Refer previous|
|2. Asset Performance Review (B/S, P/L, Cash flow)||Medium|
|3. Production & Sale (Volume, Price, Revenue, etc.)||High|
|4. Sales Volume Performance ; by Project, and by product||Medium|
|5. Product Price Report; by project and by product||Medium|
|6. Asset Key Performance Indicators & Analysis||High|
|7. OPEX Status Summary.||Low|
|8. CAPEX Status Summary.||Low|
|9. Detail of CAPEX Movement||Low|
|10. Detail of CAPEX cost variance.||Low|
|11. Detail of OPEX costs (before & after allocation).||Low|
|12. Detail of OPEX cost variance.||Low|
|13. Asset owner and Service provider report.||High|
|14. Allocation Report (source & destination).||High|
|15. Well status||Low|
2.1.3 Financial reporting
Provider to deliver financial reports; these reports included, but are not limited to the following.
See comments in 2.1.2
|Financial reportsReport name||Complexity|
|1. Reserve report (Net share) by project||Low|
|2. BENOX Consolidated financial statements (B/S, P/L||Medium|
|3. Each Company financial statements (B/S, P/L)||Medium|
|4. Each Company financial statements (B/S, P/L net from elimination)||Medium|
|5. Detail of P/L items by projects (net from elimination)||Medium|
|6. Detail of B/S items by projects (net from elimination)||High|
|7. Details of Investment in subsidiaries + Drill down to asset||Low|
|8. Details of Investment in associates + Drill down to asset||Low|
|9. Details of cash and cash equivalent||Low|
|10. Details of sale and outstanding A/R||Medium|
|11. Segment reporting||High|
|12. PP&E report by segment||High|
|13. PP&E report by WIP and completed||Medium|
|14. PP&E report by category of asset||Medium|
|15.Capitalized costs relating to oil and gas producing activities (FAS69)||Medium|
|16. Costs incurred in oil and gas activities (FAS69)||Medium|
|17.Results of operation for oil and gas producing activities (FAS69)||Medium|
|18. Current tax / deferred tax by regime, by project||Low|
|19. Net profit(loss) by projects (net from elimination)||Medium|
|20. Total Revenues report by company by product||Low|
|21. Sales variance analysis||Low|
|22. Financial ratio||Low|
|23. Consolidated USD position report||Low|
2.1.4 Administrative System
|1. Support dynamic organization and matrix organization views e.g.. provide a drag-drop hierarchy.||Included in architect tools|
|2. Easy to create, maintain and control a user security and accountability.• Provide a user authorization control report.• Provide system protection for a conflict rule/role setting.• Provide a capability to set up an individual and group users.• Provide an easy to set a read-write permission.||The security process combines all of the attributes listed in an administration interface|
|3. Provide an audit trail for key actions such as insert/add/change/delete to the database, budget submission and approval.||Updates Provided by standard system reports|
|4. One time set up in the system for dimension value such as Repotting Center approx 8000 (RC) ,RC Parent RC,Budget item and then automatically updated this dimension value with structure to budgeting module (for all report/worksheet/formula).||Updates can be provides via XLM updates load on deferential elements However this requires consideration business rules audit, quality control and related administration intervention issues to be understood resolved before it can be agreed|
|5. Easy to create and maintain formulas.||System interface to the rules engine provides this|
|6. Provide user-friendly tools or standard programming language which is easy for non-programmers.||All system updates are generally open and interface control for non technical programming people to administer|
|8. Quick calculating process and data interface (with reliable output).||Included in application. IPMS performs a quick calculating process and data interface based on the platform and architecture of the user.|
|9. Provide efficient tasks running features such as scheduling and sequencing.||Scheduling is able to be included using job manager or other generic schedulers|
|10. Indicate any error details and solutions in the running result.||Application server log is used to Indicate any error details and solutions in the running result.|