OutlookSoft Corporation is the first provider of unified, predictive performance management solutions that enable the predictable enterprise. The company's flagship solution OutlookSoft provides a single performance management platform for strategic planning, budgeting, forecasting, statutory consolidation, reporting, analysis, predictive analytics, scorecarding, and dashboards.In addition to its software, the company delivers related consulting, training, implementation, and ongoing product/client support services, both directly and through a network of strategic partner, reseller, and distributor relationships. OutlookSoft is a Gold Certified Microsoft Solution Partner for Business Intelligence and a member of the Oracle PartnerNetwork.
MICROSOFT EXCEL is the de factor language of business. For nearly a quarter of a century, spreadsheets have helped businesspeople of all stripes communicate their past performance as well as their expectations for the future. In many companies, everyone from the CEO down to the financial analysts and the line of- business managers relies on Excel spreadsheets to analyze numbers, manage their budgets, forecast financial outcomes, and model what-if scenarios.
Essential Ingredients for Effective Microsoft Excel-Based BPM
• Unified application for all BPM processes,including planning, budgeting, consolidation,
reporting, analysis, and scorecarding.
• Centralized database for a single version of the facts, ensuring the highest level of data
integrity, reliability, and consistency.
• Full process management, including versioning, workflow, status tracking, collaboration, security, and administration.
• Real-time integration with multidimensional database for faster and better-informed
analysis, reporting, and decision-making.
• Ability to integrate and manage data from any general ledger, ERP system, or operational data source.
• Easy, intuitive end-user reporting that includes parameterized and ad hoc queries
• Real-time read/write access, providing immediate results for optimal planning and
Decision-making.
• High level of scalability and support for stakeholder collaboration.
• Ability to manage both financial and operational performance data.
• Open-standards technology that lets customers leverage and extend their current
systems, applications, and processes.
Friday, August 20, 2010
Wednesday, August 11, 2010
SAP BPC GOAL SEEK FUNCTIONS
SAP BPC GOAL SEEK FUNCTIONS
SAP BPC MS EXCEL FUNCTIONS
With BPC for Excel,
* Utilize the powerful and flexible formulas and functions within reports and input schedules to retrieve, display, and submit data for a real-time view of the financial position of your organization.
* Use predefined report and input schedule templates that you can also customize to meet your specific business requirements.
* Instantly change the information you see in a report or the entities, accounts, time period, and so on of input data simply by changing your current view.
* Display accurate, live data from the database within Microsoft Excel worksheets, Microsoft Word documents, and Microsoft PowerPoint slides.
* Analyze data in reports, perform data entry in input schedules, and distribute information based on user access rights when you are completely offline from the system.
* Submit budgets with a wide range of supporting attachments in the form of spreadsheets, documents, and presentations.
* Create hypothetical scenarios of future outcomes using powerful modeling functions.
* Post journal entries to carefully track changes to your data.
* Schedule and run Data Manager packages for loading, transforming, and manipulating financial data.
GOAL SEEK FUNCTION IN EXCEL
Goal Seek is a very powerful tool in Excel for finding break-even points or to perform tailored what-if analysis.
When you know the desired result of a formula but not the input value the formula needs to determine the result, you can use the Goal Seek feature in Excel available by clicking Goal Seek on the Tools menu. This back-solves the problem and finds the input value that satisfies your requested output value. You can change the value of a specified cell until the formula that is dependent on the changed cell returns the result you want. The Goal Seek function has thousands of applications and this tutorial looks at some specific solutions for mortgage or loan decisions. An accompanied workbook can be downloaded which illustrates the examples in this tutorial.
Goal Seek function
To use Goal Seek, a base model must to be set up in your Excel worksheet with the inputs and formulas already in place and working. The function is activated by clicking Goal Seek on the Tools menu.
* Set cell – The output cell
* To value – the target value of the output cell
* By changing cell - The cell that should change
The “Set cell” must always contain a formula or a function. The “By changing cell” must contain a value only, not a formula. Once you have already selected the “Set cell”, click to the “To value” cell and type in the desired value. Then finally click or tab to the “By changing cell” and select cell that you wish to change and click OK.
As soon as you select “OK” you will see that Goal Seek re-calculates the formula. Then you have options either to “OK” or “Cancel”. If “OK” is selected the new solved value will be inserted into the Worksheet. If “Cancel” is selected, the value in the worksheet will return to its original state.
Iterations in Goal Seek
Note that when goal seeking, Microsoft Excel backs into a solution using numerical iterations, so it won’t necessarily find the “exact” solution. It might come “close enough” and stop, or it might not be able to find the solution that you would like to achieve.
SAP BPC MS EXCEL GOAL SEEK FUNCTION EXAMPLE
How to Use Excel 2010's Goal Seek Feature
The Goal Seek feature in Excel 2010 is a what-if analysis tool that enables you to find the input values needed to achieve a goal or objective. To use Goal Seek, you select the cell containing the formula that will return the result you're seeking and then indicate the target value you want the formula to return and the location of the input value that Excel can change to reach the target.
The steps below follow a specific example for using Goal Seek to help you better understand how to use this feature. Refer to the figures for guidance. To use Goal Seek to find out how much sales must increase to return a net income of $300,000 in the first quarter, follow these steps:
1Select the cell containing the formula that will return the result you're seeking; in this example, cell C7.
This cell contains the formula that calculates the forecast for the first quarter of 2011.
2. On the Data tab, choose What-If Analysis Goal Seek in the Data Tools group.
This action opens the Goal Seek dialog box. Because cell C7 is the active cell when you open this dialog box, the Set Cell text box already contains the cell reference C7.
3. Select the To Value text box and enter the goal.
This is the value you want the formula in the Set Cell box to reach. In this example, it's 300000.
4. Select the By Changing Cell text box and select the cell that you want to change
Excel will change the value in this cell reference to try to reach the goal in the To Value box. In this example, cell C3 contains the first quarter sales. The absolute cell address, $C$3, appears in the text box.
5. Click OK.
Excel displays the Goal Seek Status dialog box along with the results. In this example, Excel increases the sales in cell C3 from $250,000 to $545,455, which, in turn, returns $300,000 as the income in cell C7.
6. If you want to keep the values entered in the worksheet as a result of goal seeking, click OK.
If you want to return to the original values, click the Cancel button instead. Notice that because all of the values in this table are formulas that ultimately are derived from the value in cell C3, all of the values changed when that cell value was updated during the Goal Seek process.
The Goal Seek Status dialog box informs you that goal seeking has found a solution and that the current value and target value are now the same. When this is not the case, the Step and Pause buttons in the dialog box become active, and you can have Excel perform further iterations to try to narrow and eliminate the gap between the target and current value.
To flip back and forth between the "after" and "before" values when you've closed the Goal Seek Status dialog box, click the Undo button or the Redo button on the Quick Access toolbar.
By Using the Goal seek function in EXCEL we can do different operations at SAP BPC
1. Import Online Data into Excel 2010 with a Web Query (Live Reports SAP BPC)
2.Split Data into Multiple Columns in Excel 2010 (Divide the Business Segmentation of Business Profits in SAP BPC)
3.Using Slicers to Filter Pivot Tables in Excel 2010 (Identify the Business Growth month to month or Q1to Q2, Yr to Yr with graphical Representation)
4.Create a Scenario Summary Report in Excel 2010 (Over all Business strategy)
5.Create a Two-Variable Data Table in Excel 2010 (New Business Positions)
6.Create and Format a Pivot Chart in Excel 2010 (Expand Of Business Segmentations)
7.Modifying a Pivot Table's Summary Function in Excel 2010(Work with Taxs across the Regions)
8.Setting Up Your Baseline in Excel Sales Forecasting (Know Sales Profit)
9.Filter an Excel 2010 Pivot Chart (Know about the Cost center values)
10.Evaluate Scenarios with Excel 2010's Scenario Manager (Analysis of the Operations Values)
Other forecasting techniques goal seek function
* Last months demand
* Average for the previous year
* Rolling average (i.e. 12 months)
* Gut-feeling (very popular)
* Simple or multiple regressions.
* Clustering by period
* Exponential smoothing
SAP BPC MS EXCEL FUNCTIONS
With BPC for Excel,
* Utilize the powerful and flexible formulas and functions within reports and input schedules to retrieve, display, and submit data for a real-time view of the financial position of your organization.
* Use predefined report and input schedule templates that you can also customize to meet your specific business requirements.
* Instantly change the information you see in a report or the entities, accounts, time period, and so on of input data simply by changing your current view.
* Display accurate, live data from the database within Microsoft Excel worksheets, Microsoft Word documents, and Microsoft PowerPoint slides.
* Analyze data in reports, perform data entry in input schedules, and distribute information based on user access rights when you are completely offline from the system.
* Submit budgets with a wide range of supporting attachments in the form of spreadsheets, documents, and presentations.
* Create hypothetical scenarios of future outcomes using powerful modeling functions.
* Post journal entries to carefully track changes to your data.
* Schedule and run Data Manager packages for loading, transforming, and manipulating financial data.
GOAL SEEK FUNCTION IN EXCEL
Goal Seek is a very powerful tool in Excel for finding break-even points or to perform tailored what-if analysis.
When you know the desired result of a formula but not the input value the formula needs to determine the result, you can use the Goal Seek feature in Excel available by clicking Goal Seek on the Tools menu. This back-solves the problem and finds the input value that satisfies your requested output value. You can change the value of a specified cell until the formula that is dependent on the changed cell returns the result you want. The Goal Seek function has thousands of applications and this tutorial looks at some specific solutions for mortgage or loan decisions. An accompanied workbook can be downloaded which illustrates the examples in this tutorial.
Goal Seek function
To use Goal Seek, a base model must to be set up in your Excel worksheet with the inputs and formulas already in place and working. The function is activated by clicking Goal Seek on the Tools menu.
* Set cell – The output cell
* To value – the target value of the output cell
* By changing cell - The cell that should change
The “Set cell” must always contain a formula or a function. The “By changing cell” must contain a value only, not a formula. Once you have already selected the “Set cell”, click to the “To value” cell and type in the desired value. Then finally click or tab to the “By changing cell” and select cell that you wish to change and click OK.
As soon as you select “OK” you will see that Goal Seek re-calculates the formula. Then you have options either to “OK” or “Cancel”. If “OK” is selected the new solved value will be inserted into the Worksheet. If “Cancel” is selected, the value in the worksheet will return to its original state.
Iterations in Goal Seek
Note that when goal seeking, Microsoft Excel backs into a solution using numerical iterations, so it won’t necessarily find the “exact” solution. It might come “close enough” and stop, or it might not be able to find the solution that you would like to achieve.
SAP BPC MS EXCEL GOAL SEEK FUNCTION EXAMPLE
How to Use Excel 2010's Goal Seek Feature
The Goal Seek feature in Excel 2010 is a what-if analysis tool that enables you to find the input values needed to achieve a goal or objective. To use Goal Seek, you select the cell containing the formula that will return the result you're seeking and then indicate the target value you want the formula to return and the location of the input value that Excel can change to reach the target.
The steps below follow a specific example for using Goal Seek to help you better understand how to use this feature. Refer to the figures for guidance. To use Goal Seek to find out how much sales must increase to return a net income of $300,000 in the first quarter, follow these steps:
1Select the cell containing the formula that will return the result you're seeking; in this example, cell C7.
This cell contains the formula that calculates the forecast for the first quarter of 2011.
2. On the Data tab, choose What-If Analysis Goal Seek in the Data Tools group.
This action opens the Goal Seek dialog box. Because cell C7 is the active cell when you open this dialog box, the Set Cell text box already contains the cell reference C7.
3. Select the To Value text box and enter the goal.
This is the value you want the formula in the Set Cell box to reach. In this example, it's 300000.
4. Select the By Changing Cell text box and select the cell that you want to change
Excel will change the value in this cell reference to try to reach the goal in the To Value box. In this example, cell C3 contains the first quarter sales. The absolute cell address, $C$3, appears in the text box.
5. Click OK.
Excel displays the Goal Seek Status dialog box along with the results. In this example, Excel increases the sales in cell C3 from $250,000 to $545,455, which, in turn, returns $300,000 as the income in cell C7.
6. If you want to keep the values entered in the worksheet as a result of goal seeking, click OK.
If you want to return to the original values, click the Cancel button instead. Notice that because all of the values in this table are formulas that ultimately are derived from the value in cell C3, all of the values changed when that cell value was updated during the Goal Seek process.
The Goal Seek Status dialog box informs you that goal seeking has found a solution and that the current value and target value are now the same. When this is not the case, the Step and Pause buttons in the dialog box become active, and you can have Excel perform further iterations to try to narrow and eliminate the gap between the target and current value.
To flip back and forth between the "after" and "before" values when you've closed the Goal Seek Status dialog box, click the Undo button or the Redo button on the Quick Access toolbar.
By Using the Goal seek function in EXCEL we can do different operations at SAP BPC
1. Import Online Data into Excel 2010 with a Web Query (Live Reports SAP BPC)
2.Split Data into Multiple Columns in Excel 2010 (Divide the Business Segmentation of Business Profits in SAP BPC)
3.Using Slicers to Filter Pivot Tables in Excel 2010 (Identify the Business Growth month to month or Q1to Q2, Yr to Yr with graphical Representation)
4.Create a Scenario Summary Report in Excel 2010 (Over all Business strategy)
5.Create a Two-Variable Data Table in Excel 2010 (New Business Positions)
6.Create and Format a Pivot Chart in Excel 2010 (Expand Of Business Segmentations)
7.Modifying a Pivot Table's Summary Function in Excel 2010(Work with Taxs across the Regions)
8.Setting Up Your Baseline in Excel Sales Forecasting (Know Sales Profit)
9.Filter an Excel 2010 Pivot Chart (Know about the Cost center values)
10.Evaluate Scenarios with Excel 2010's Scenario Manager (Analysis of the Operations Values)
Other forecasting techniques goal seek function
* Last months demand
* Average for the previous year
* Rolling average (i.e. 12 months)
* Gut-feeling (very popular)
* Simple or multiple regressions.
* Clustering by period
* Exponential smoothing
Subscribe to:
Posts (Atom)