This Excel template can be used to keep track of cash flow for your project, helping you chart cumulative planned and paid invoice activity based on monthly payments.
50 items found
This template is designed to show projected budget costs for project human resources (a consulting team, for example) and provide a comparative analysis of actual money spent on those resources and hours used to date by those resources. It can be easily updated as desired (weekly, monthly, quarterly, etc.). The tool provides an immediate illustration of the state of the project at any point along the project life cycle by showing whether the money and hours utilized to date are above, at or below the projected budget amount.
This template is for creating a process inventory and detailed process descriptions for the purpose of Business Analysis prior to IT project implementation. Processes are analyzed step by step in order to identify software functional requirements that are necessary to execute the process. A companion to the article The Role of Business Process Design in Business Analysis on IT Projects.
This spreadsheet is used to calculate and compare the TCO (total cost of ownership) and CBA (cost benefit analysis) of multiple alternative solutions. This includes costs and benefits for not only the implementation, but also for additional years of maintenance.
Use this form to document the desired or future state for the business, its current state and identified gaps. An approval process may be instituted for stakeholders to accept this gap analysis/report, with procedures for the BA team to formulate solution options. Adapt this sample to your corporate needs prior to using the template. Use in conjunction with the Business Analysis: Solution Options Report.
Having identified business gaps (i.e., determined shortcomings and designed solutions), present the same as options that may resolve the gaps. This template guides reporting the solution options for deliberation post-gap analysis. Adapt this template to your corporate needs prior to using (e.g., include suggested approach to voting on the solutions). Use in conjunction with the Business Analysis: Gap Analysis Report.
The goal of this business case template is twofold: Clearly explain the project benefit to decision makers; and provide traceable, measurable and consistent data for benefit realization analysis after project implementation. This template has annotated instructions in blue to explain the intent or recommended use of the information. Organizations can adapt the template to their unique structure.
Planning business analysis activities helps reduce/eliminate conflicts and problems as BA work progresses and eventually develops into a project. Early planning and revisions will ensure BA plans stay relevant, recognized by stakeholders—and approved. Use this template to guide planning your BA tasks. Adapt this sample to your corporate needs prior to use.
This project financial analysis template includes four Excel sheets to help you make crucial project selection decisions based on return on investment (ROI), net present values (NPV), internal rate of return (IRR) and payback period.
This sample Excel worksheet includes a Gantt chart with resource estimation (man hour, machine hour) and cost estimation. It provides a quick way to calculate project budget and project selling price.