Free Essay

Financial Data Analysis

In: Business and Management

Submitted By Alaphia
Words 1870
Pages 8


1. General:
The attached analysis shows actual performance of the wage bill for the period January to December 2010. The total actual payroll cost incurred during the period under review amounted to Le541.511 billion. The profiles indicate the expenditure pattern for MDAs, Teachers, Police, Foreign Missions, the Military, Salary Grants, Pensions/Gratuities and Government contributions to Social Security on a monthly basis.

The total wage bill expended in 2010 compares unfavourably with the annual total projection of Le514.974 billion. The deficit of Le26.537 billion (representing 5.15% over the annual projection) was mainly due to excess expenditure as follows:

* Pensions, Gratuity and other Retirement Benefits: Actual expenditure amounted to Le34.737 billion that is Le9.237 billion or 36.22% excess of the 2010 projection (Le25.500 billion). This was largely attributed to payment of arrears during the year.

* Government’s Contribution to Social Secruity: Actual expenditure was Le34.674 billion which was Le3.568 billion or 11.47% more that what was projected (Le31.106 billion) for the financial year. The implementation of the free health care programme which resulted in the introduction of new salary structure for health workers largely triggered the rise in total payment made to NASSIT.

* Teachers: Total actual expenditure for teachers amounted to Le164.874 billion. This was Le2.788 billion or 1.72% higher than the projected figure (Le162.086 billion). Reasons for the deficit were mainly due to the eight months back-log pay (Le3.126 billion) to 1,597 newly recruited teachers for the period September 2009 to April 2010. In addition to the one-off payment (Le3.494 billion) made to teachers in December 2010.

* Miscellaneous: Le5.755 billion was expended in respect of unbudgeted salary and salary related claims.

Despite the high wage bill expended during the year, it is worth noting that the overall payroll process was executed under strict internal control procedures to minimise wastages. The use of various payroll reports to review data inputs, validation checks, variance analysis, etc were being used to ensure efficiency. It is important also to note that the nature by which the payroll was being process affects the status of the total monthly workforce and cost. The fluctuations shown on the attached analyses were as a result of the various advices received from the employing authorities (HRMO, MEYS, MoD, Police, etc) which involve additions, deletions or terminations of employees as the case may be. Variation in total monthly workforce for the period under review was relatively low (i.e. from 70,745 in January 2010 to 73,646 as at December 2010).

The attached payroll profiles also indicate that Teachers (Le164.874 billion – 30.45%) constitutes the bulk of the payroll cost (Le541.511 billion) incurred during the period under review, followed by MDAs (Le120.364 billion – 22.23%), Subvented Institutions (Le61.869 billion – 11.43%), the Military – Joint Force Command (Le45.723 billion – 8.44%), Foreign Missions (Le36.535 billion – 6.75%) and Police (Le36.000 billion – 6.65%). Pensions/Gratuities, NASSIT contributions and Wages Arrears - miscellaneous amounted to Le34.737 billion (6.41%), Le34.674 (6.40%) and Le5.755 billion (1.06%) respectively. 2. Expenditure Pattern:
Monthly expenditures have been reconciled with related figures in the Statement of Financial Performance/Report produced by Main Accounts Unit of the Accountant General’s Department to ensure consistency in the performance of the wage bill. Monthly percentage contributions to the total wage bill for the period under review are shown in the profile below:

Month | Actual Wage Bill Le M | % Contribution | Workforce | January | 38,131 | 7.04 | 70,745 | February | 37,041 | 6.84 | 71,995 | March | 34,063 | 6.29 | 68,510 | April | 49,581 | 9.16 | 71,057 | May | 50,204 | 9.27 | 72,799 | June | 38,068 | 7.03 | 73,038 | July | 52,691 | 9.73 | 73,563 | August | 50,355 | 9.30 | 73,328 | September | 45,696 | 8.44 | 73,381 | October | 47,568 | 8.78 | 73,726 | November | 46,541 | 8.59 | 73,503 | December | 51,572 | 9.53 | 73,646 | Total | 541,511 | 100.00 | |

Movement in the wage bill and work force is further illustrated by the linear graph shown below.

* January 2010
From the attached analysis and the profile above, the actual wage bill incurred in January amounted to Le38.131 billion. This was 7.04% of the total actual payroll cost for the year ended 31st December 2010 with an active work force of 70,745. Advance annual rent allowance of Le2.578 billion was paid to Ministers and Judges during the review period.

Pensions/Gratuity and Social Security payments during the month amounted to Le0.312 billion and Le2.030 billion respectively. Total salary grants incurred was Le4.649 billion.

* February 2010
Actual expenditure in February was Le37.041billion constituting 6.84% of the total wage bill incurred for the period January to December 2010. The active workforce for the month was 71,995. Though there was an increase in active workforce, actual expenditure for the month was 2.86% lower than that expended in the previous month in which annual rent allowance was paid to Ministers and Judges.

During the review month, Le6.337 billion was paid to subvented agencies as salary grants. Le0.276 billion and Le1.978 billion were expended in respect of Pensions/ Gratuity and Government/Employees’ contributions to Social Security.

* March 2010
According to the above expenditure table and linear graph, the month of March recorded the lowest wage bill (Le34.063 billion). This constitutes 6.29% of the total actual wage bill expended as at 31st December 2010. The actual workforce for the month was 68,510. The drop in cost and workforce was mainly due to instructions received from HRMO relating to the verification exercise carried out by Booz and Co. Consultants to clean up the MoHS payroll.

Pesions/Gratuity and salary grants amounted to Le0.370 billion and Le1.880 billion respectively. Le3.326 billion was paid to NASSIT in respect of Social Security contributions. Military and Foreign Missions contributions (Le0.956 billion) for the month of February 2010 were paid to NASSIT in the month of March 2010.

* April 2010
Actual amount expended during the month of April was Le49.581billion representing 9.16% of the total expenditure during the financial year 2010. The actual work force during the month was 71,057.

The sharp increase in the total actual payroll cost was mainly due to the implementation of the ‘Free Health Care’ initiative. In addition to the payment of Le3.988 billion and Le7.631 billion as ‘End of Service Benefit’/ ‘pension arrears’ to Ex-Ministers and salary grants to subvented institutions respectively. Social Security payments for the period totalled Le2.662 billion.

* May 2010
Actual wage bill of Le50.204 billion was recorded in May 2009 which represents 9.27% of the total actual wage bill for the period ended 31st December 2010 with an actual workforce of 72,799. This was 1.26% higher than that incurred in the previous month. The high variance was mainly due to the implementation of the 2009/2010 recruitment process of Teachers (including backlog payments for the period September 2009 to April 2010).

The sum of Le5.692 billion was also incurred by the Pension Unit in respect of End of Service Benefit, pension arrears to NASSIT, Ex-Gratia, etc. Salary Grants and NASSIT contributions amounted to Le5.119 biliion and Le2.550 billion respectively.

* June 2010
The actual payroll cost for the above period was Le38.068 billion representing 7.03% of the total actual wage bill incurred during 2010. Comparatively, the wage bill for the month was lower than what was spent in April (23.22%) and May (24.17%) respectively due to reasons stated above. The actual work force reported for the month was 73,038. Government/ Employees’ contributions to Social Security was Le2.409 billion, salary grants (Le1.932 billion) and Pensions/Gratuity (Le0.911 billion).

* July 2010
Comparatively, the highest payroll cost of Le52.691 billion (9.73%) was recorded in July 2010 with an actual work force of 73,563. The payroll cost for the reported month was 38.41% higher than what was expended in the previous month. This was largely due to the payment of salary grants (Le12.389 billion) to most of the subvented institutions for quarter 3. In addition to the payment of Government Pensions/ End of Service benefits amounting to Le1.732 billion and salary grants (Le1.932 billion).

Government/ Employees’ contributions to Social Security was Le4.098 billion. Military and Foreign Missions contributions (Le1.050 billion) for the month of June 2010 were paid to NASSIT during the review month.

* August 2010 The actual wage bill expended for the above period was Le50.355 billion (9.30%) with an actual work force of 73,328. The payroll cost for the reported month was 4.43% lower than what was reported in the previous month. Annual travelling allowance of Le1.412 billion was also paid to teachers during August 2010.

Total expenditure in respect of Pensions/Gratuity amounted to Le5.352 billion. Salary grants paid to subvented institutions during the month was Le3.723 billion. Government/ Employees’ contributions to Social Security was Le3.212 billion.

* September 2010
Total wage cost for the month was Le45.696 billion representing 8.44% of the total wage bill for 2010. Actual total workforce for the month was 73,381. During the review period Le7.057 billion was expended in respect of Government Pensions/End Service benefits. Salary grants for the period amounted to Le1.206 billion. Social Security payments sum up to Le3.038 billion for the reported month.

* October 2010
Total expenditure for the month under review was Le47.568 billion (8.78% of total expenditure). Actual total workforce was 73,726. During the month Le2.384 billion was recorded in respect of Government Pensions/End Service benefits. Reported expenditures for Salary grants and Social Security for the period amounted to Le8.919 billion and Le1.602 billion respectively.

* November 2010
Actual expenditure for the month under review was Le46.541billion (8.59% of the total wage bill). Actual total workforce was 73,503. The sum of Le0.699 billion was paid to junior staff of the MoHS to address the Health Workers Union’s enhancement demand. During the reported period Le1.276 billion was paid in respect of Government Pensions/End Service benefits and Salary grants (Le5.210 billion).

Government/ Employees’ contributions to Social Security was Le4.169 billion. Military and Foreign Missions contributions (Le1.203 billion) for the month of October 2010 were paid to NASSIT during the reported period.

* December 2010

Expenditure for the month under review was Le51.572 billion (9.53% of the total wage bill). Actual workforce was 73,646. During the review period a one-off payment totalling Le3.494 billion was paid to teachers. Le5.386 billion and Le2.874 billion were incurred in respect of Government Pensions/End of Service benefits and Salary grants respectively. Government/ Employees’ contributions to Social Security was Le3.597 billion.


Similar Documents

Premium Essay

Financial Data Analysis

...Financial Data Analysis Sharon M Flemming HCS 577 July 8, 2013 Dr. Patricia Jenkins Financial Data Analysis Financial management is an important aspect of health care financing. Whether for a hospital, medical group, or home care agency, long-term or short-term finance, maintaining accurate asset management records could mean the difference in failure or success for many organizations. The purpose of this assignment is to compare financial data for two consecutive years for Patton-Fuller Community Hospital from the 2008 and 2009 Balance sheets and Revenue and Expense sheets, and to identify significant changes between the years. I will also attempt to provide possible explanations for those changes based upon information provided within the Annual Report for that hospital. Patton-Fuller Community Hospital Financial Statements 2008-2009 Patton-Fuller Community Hospital (PFCH) is a large full service hospital providing cutting-edge medical care to Kelsey and the Northwest Valley since 1975. This is a physician owned organization with a fourteen member governing board in which each member with exception of the Chief Executive Officer (CEO) and the Chief Financial Officer (CFO) have equal voting rights. Each member serves a three-year term and elections are held each December, at which time four new members are voted in by the shareholders and profits are distributed among the owners (Apollo Group, Inc., 2013). According to the 2009 Annual Report the CFO indicates......

Words: 980 - Pages: 4

Premium Essay

Financial Data Analysis

...Financial Data Analysis A financial data analysis “provides a great deal of important information regarding financial condition, it often fails to provide much insight into the operational causes of that condition” (Gapenski, 2008, p. 561). Financial data analysis identifies an organizations strengths and weaknesses by proving the relationship among items of a profit and loss account and a balance sheet. Numerous techniques or systems are used in analyzing financial statements. One such technique is comparative analysis. Comparative analysis “identifies new trends when data or ratios for a specific item from multiple time frames are presented alongside of each for a straight across comparison” (Investor Words, 2014, para. 1). This method can also be used to compare outcomes of alternate solutions or processes applied in similar situations. Other methods for analyzing financial data include “schedule of changes in working capital, common size percentages, funds analysis, trend analysis, and ratios analysis” (Accounting for Management, 2014, para. 3). The Patton-Fuller Community Hospital: Financial Analysis At first glance of the Patton-Fuller Health Care Organization one would assume this organization is viable. This would be due in part to a recent upgrade in operations. The balance sheet of December 31 2009-2008 reflects an increase of revenue. In addition to the increase of revenue, some expenses were also increased. It has yet to be determined if these increase were......

Words: 714 - Pages: 3

Premium Essay

Financial Data Analysis

...Financial Data Analysis Patton-Fuller Community Hospital is a for-profit hospital that is owned by the physicians who currently works at the facility. Patton-Fuller was established in 1975 and has since provided innovative care to the surrounding communities of Kelsey. The key to this hospital's success is quality patient care and as shareholders their mission was to provide the best care to their patients (University of Phoenix, 2014). Patton-Fuller Community Hospital has been doing so well they were able to expand to an 600-bed, full-service facility. The hospital is directed by 14 board members, which consist of 12 physicians, the Chief Executive Officer and the Chief Financial Officer (University of Phoenix, 2014). The physicians are the only board members allowed to make any votes. Physicians would only serve 3-year terms, and four new members would come aboard every year in December during the annual shareholder meeting (University of Phoenix, 2014). Additional to the annual shareholder meeting, profits are dispersed to the physicians. Patton-Fuller Community Hospital made 80% of their revenue through inpatient services, which includes surgery, medical-surgical nursing, and intensive care unit. As 20% of their revenue made through outpatient services, the emergency department and other outpatient services (University of Phoenix, 2014). In the review of the financial statements, many events have occurred between the years of 2008-2009. Davis Geach, Chief Executive...

Words: 795 - Pages: 4

Premium Essay

Financial Data Analysis

...Financial Data Analysis HCS/577 July 14, 2014 Financial Data Analysis Patton - Fuller Community Hospital | Balance Sheet as of December 31 | 2009 and 2008 | (In thousands) | (Audited) | 2009 | 2008 | Assets | Current Assets | Cash and Cash Equivalents | $22,995 | $41,851 | Assets of Limited Use | $27,594 | $41,851 | Patient Accounts Receivable (1) | $58,787 | $37,666 | (net of Allowance for Bad Debts 2009: $11,757 / 2008: $7,533) | Other Receivables (3rd party payer settlements | - | $87 | Inventories | $18,396 | $8,370 | Prepaid Expenses | $95 | $201 | Total Current Assets | $127,867 | $130,026 | Other Assets | Funded Depreciation | $137,970 | $167,404 | Held under Bond Indenture | $73,584 | $75,332 | Property, Plant and Equipment, net | $248,346 | $175,774 | Total Assets | $587,767 | $548,535 | Liabilities and Equity | Current Liabilities | Current portion of long-term debt | $14,599 | $4,185 | Accounts payable, accrued expenses | $9,198 | $4,185 | Bond interest payable | $10 | $10 | Total Current Liabilities | $23,807 | $8,380 | Other Liabilities | Long term debt | $452,945 | $209,255 | less: current portion of long term debt | $14,599 | $4,185 | Net long term debt | $438,346 | $205,069 | Total Liabilities | $462,153 | $213,450 | Patton - Fuller Community Hospital | Statement of Revenue and Expense | 2009 and 2008 | (In...

Words: 1359 - Pages: 6

Premium Essay

Financial Data Analysis

...Week 5 What are the implications and effect of tough ethical beginning-of-life and end-of-life decisions? How do these decisions affect the individual, the family, society, and health care providers? The care of beginning-of-life and end-of-life decisions for patients has shifted from family, to community, to health care professionals. Medical professionals have sought ways to improve quality of life from a newborn to a person approaching the end of his or her life’s journey (Carrese & Rhodes, 1995). The effects of such situations on the families, community and health care professionals, can be a difficult decision regarding a patient’s medical treatment. These decisions can cause conflict between family members and health care professionals and community because of religious beliefs, moral principles and professional guidelines. These types of ethical issues arise when individuals are unclear about what is best for a patient and his or her quality of life. This is why it is important for a patient to have an advance directive in place so that he or she can communicate all end of life wishes. Family members should not be left with having to arrive at an appropriate decision When a decision pertains to a beginning-of-life dilemma the ethical principal of autonomy should be applied.  A parent’s decision regarding the care and treatment of their newborn should be based off what is best for the child and not on the parent’s personal morals or religious......

Words: 492 - Pages: 2

Premium Essay

Hcs577 - Financial Data Analysis

...Financial Data Analysis HCS/577 Financial Data Analysis Patton-Fuller Community Hospital (PFCH) is a for-profit health care provider for the Northwest Valley area. The hospital opened in 1975 and owned by the physicians practicing at the facility, PFCH is dedicated to providing cutting edge services with high quality patient care. Currently, the 600 bed facility received a majority of its revenue (80%) through in-patient services including surgical care, nurse services, both medical and surgical as well as their Intensive Care Unit (ICU). The remaining 20% of revenue is gained through Emergency Department visits and additional out-patient care. The remainder of this paper will determine the variances between the 2008 and 2009 fiscal year in attempts to determine where major gains and losses can be seen within Patton-Fuller’s financial environment. Variances between 2008 and 2009: The first area analyzed for variances between the 2008 and 2009 operating years, was the assets of Patton-Fuller Community Hospital. With both the stock market and real estate industries reeling during this most recent economic downturn, the return on these types of investments is much lower in 2009 than in 2008. Cash and Cash equivalents saw a depreciation of 45% going from $41,000,000 in 2008 to $22,000,000 in 2009. Based on long-term investment options, future projections estimate that this loss will ultimately be negligible as the stock market begins to rebound. Additionally,......

Words: 762 - Pages: 4

Premium Essay

Strategy Management

...1.0 INTRODUCTION This dissertation is based on a critical evaluation of training policies and procedures at The Maritime Financial Group South Branch- Training, Marketing and Sales service. This company was chosen because of its vast training of its workforce as compared to other companies within the region and always rises above other branches throughout the country annually and employs thirty five persons. This dissertation will give me the researcher the opportunity to define its objectives, compare pertinent theoretical frameworks and employ a methodology to attain the relevant information needed in order to analyze the findings and construct suitable recommendations. 1 1.1 CHOICE OF TOPIC This topic is chosen for many profound reasons. These consist of:  It is a major factor in many organizations worldwide. Organizations now seek to have a well- trained workforce to gain competitive advantage in the market place and be profitable.  I the researcher want to get hands-on experience in researching the topic as it is a field of interest. This will provide me with knowledge and understanding of the efficacy of training within companies.  Training seems to be very dominant in many organizations. It is something that is pushing organizations upwards. Therefore the knowledge of training will be beneficial for the researcher’s future plans in becoming an entrepreneur.  With established training theories, the research will experience growth in this chosen area of......

Words: 11639 - Pages: 47

Free Essay

Research & Decision-Making for Business

...OBJECTIVES TO BE ADDRESSED .............................................. 5 4. CRITICAL ANALYSIS OF THE METHODS ...................................................................... 6 5. RESULTS AND DISCUSSION ....................................................................................... 8 6. IMPLICATIONS FOR THE BUSINESS DECISION OR PROBLEM ........................................... 10 7. ETHICAL ISSUES .................................................................................................... 11 8. REFERENCES......................................................................................................... 13 9. APPENDIX ............................................................................................................ 14 The Learning Business Research Report | Campus: 10. 1 CHECKLIST OF ASSESSMENT CRITERIA .................................................................. 18 The Learning Business Research Report 1. Executive Summary This report discusses the rationale behind strategic decision taken by Royal bank of Scotland (RBS) in moving its headquarters from Glasglow to Leeds, Yorkshire. The benefits of financial clustering in the UK have been analyzed and assessed on the basis of theoretical evidences collected from literature review and qualitative data collected. There is an emphasis on financial information...

Words: 4438 - Pages: 18

Premium Essay

Analize the Impact of the Customer Retention to Company Profitability

...industry ABC is classified as one of the strongest players among the Non Banking Financial Institutions (NBFI’s) in Sri Lanka. The NBFI’s can once again be categorized into two main sectors and they are the Licensed Finance Companies (LFC’s) and the Specialized Leasing Companies (SLC’s) such as ABC. The NBFI sector in Sri Lanka consists of 48 LFC’s and 8 SLC’s as at2014. The total market of the Non Banking Financial institutions in Sri Lanka, it can be interpreted that the portfolio is divided into three major markets and mainly classified as Finance Leasing, Hire Purchase, Secured Loans and Advances. 1.2 Introduction to the Company “ABC Finance Company PLC is one of the most stable and reputed financial institutions in Sri Lanka”. The life time of the company spans over a period of nearly six decades and has served to add value and positively impact the lives of all its stakeholders. ABC Finance Company PLC (herein after referred to as ABC) started operations as a private limited liability company in the hill capital, Kandy in the year 1967. ABC is among the top 35 corporate entities in Sri Lanka consecutively for the last 12 years. As per the annual report of the company for the year 2014/2015, currently ABC employs 1244 employees, has a distribution reach of 87 branches and serves 124,917 customers. The core business of ABC is the finance leasing business whereas they also provide financial services like hire purchase, operational leasing, small and medium......

Words: 4103 - Pages: 17

Free Essay

Integration of Is and Business

...IS5111:Integration  of  IS  &  Business   Business  Intelligence  and  Analytics                     Abhishek  Kumar  Singh     Anbarasan  Thangapalam    R   Deepak  Chattani       Naadiya  Danapal       Ram  Vibhakar  S         [A0120022]   [A0119959]   [A0119975]   [A0119961]   [A0120054]   A  Case  study  on  Business  Intelligent  and  Analytics  Systems   in  NTUC  FairPrice   Table  of  Contents   Executive  Summary  .............................................................................................................................  3   Acknowledgments  ...............................................................................................................................  4   1.  Introduction  ......................................................................................................................................  5   2.  Business  Intelligence  in  Retail  Industry:  .................................................................................  6   3.  Combining  BI  in  CRM  ......................................................................................................................  7   3.1  Analytical  CRM  ..........................

Words: 6362 - Pages: 26

Premium Essay

Business Economics accounting are professionals which directly deal with financial matters and especially in cost control and budgeting. Controllers use statistics software to analyze and interpret data that helps them to make strategic and short term decisions. Question#2.a There are many issues related to controllers while making decisions on the basis of available data. Budget forecasting is very important for controllers because this tool is used to control costs and increase revenue. Deviation of budget from actual or real budget is primary issue and controllers strive hard to minimize deviations from mean. At the start of financial year, controllers are asked to prepare budget for the complete year through using realistic approach. Deviation in the budget occurs due to sensitivity of variables. Probability is very useful and important technique used in the forecasting process. Controllers use statistics and probability technique to reduce uncertainty and variance in the data. Although probability is very useful in the forecasting but when controllers inaccurately assign probability weightage to the variables then decision will not be accurate. b. There are many variables in the data file which are analyzed in different manners and through accurate analyses these variables can make decisions more accurate and meaningful. We have selected two variable which are growth and interest rate. When controllers analyze financial statements such as income statement and balance sheet......

Words: 937 - Pages: 4

Premium Essay

Excel Errors

...2. Spreadsheet Errors: What we think we can do What we know? 1. What are the leading causes of Spreadsheet errors? The leading causes of spreadsheet errors are a) Human incapability of doing complex cognitive tasks with accuracy, this is a limitation in human capability and this contributes partly to the errors that are caused in spreadsheets b) Lack of disciplined development practices is one of the most common reasons why spreadsheet contains errors. Many organization has policies in general about end user development in general, much less spreadsheet development c) Many developers build the models and hardwire it to one end result they are working without considering the constraints or different possible scenarios. This ultimately leads to the fact that the model doesn’t work for any other input variables other than the one that is being used to. d) Another common reason of spreadsheet errors is due to the overconfidence of the developers in the accuracy of the spreadsheets. They don’t spend time to test the spreadsheet for any possible errors e) We could also say innocence (in a sense of not knowing the excel capabilities) as one of the common reasons why spreadsheets has errors, people tend to learn from friends and coworkers without any proper training on Excel and its capabilities which ultimately lead in unstructured spreadsheet development 2. Why these errors are typically not detected? a)......

Words: 1657 - Pages: 7

Premium Essay

Cpoe-Ehr-Implementation Partners Healthcare

...EHR/CPOE Implementation Executive Summary This thesis follows the implementation of Computerized Patient Order Entry/Electronic Health Record (CPOE/EHR) system implemented by Partners Healthcare System (PHS) during 2002-2003 for all its constituent practitioners. It looks at the problems faced during implementation of the system and identifies new potential problems that the system may encounter. Particularly in consideration is the effort it takes to convince healthcare professionals to switch to CPOE/EHR, the cost of installing the system, the potential of automating redundancies in the system and the potential of healthcare professionals getting skewed data out of the system suggestions. It looks at the management challenges faced by the administration when bringing about CPOE/EHR to PHS and divulges in some techniques that were used for tackling these issues. It defines ways in which the system is being used to improve patient healthcare and save millions of dollars for the government, healthcare facilities and patients alike. This thesis also finds ways to combat the potential problems that may arise later and the system and looks at related government policies and statutes which apply to the implementation. Finally some metrics of success are discussed their effectiveness in driving a result. Problem Definition CPOE/EHR Implementation can face a host of problems that can hinder the process flow and the acceptability of the system by the people involved. The......

Words: 7032 - Pages: 29

Premium Essay


...the financial analyst role there will be a BAPI based web service that assists the analyst in performing a detailed cost analysis. Ideally the BAPI will be able to pull major cost centers throughout the organization which will give the analyst an estimate of the expenses generated along with their breakdown 2) Also part of the role would be a web service that returns a financial position summary with current assets, liabilities of the organization credit ratings of vendors. All the above information can be looked at by month, by year or by department. This data gives the analyst valuable information of the company’s current standing compared to where it envisions being. 3) Analytical capabilities of SAP’s HANA which processes years’ worth of data in a matter of seconds will also be an integral part of the finance role. Maintaining cash flow is essential to keep the organization functioning on a daily basis. Data analytics can be used to conduct “Variance Analysis” which is a comparison of projected cash flow against actual cash flow. Such a comparison over different periods gives a financial analyst vital insight about cash flow requirements and helps him better anticipate times when greater cash flow is needed, for example purchasing bulk material, handing out bonuses. 4) i-Views containing SAP services will assist the financial analyst to view detailed reports before they are published. Access to these reports helps the analyst ensure that all financial......

Words: 254 - Pages: 2

Premium Essay

Business and Management

...doing this is by evaluating the consequences of each choice. Tradeoffs If you got this far without a solution, it’s probably because your decision is really tricky. It also means that it has conflicting objectives — and that you’ll need to consider some hard tradeoffs between them. Week 3 Data Quality Issues When transferring data from one program to another (ie from Excel to Access), you need to consider the following: * Uniformity (data has transferred in the same manner for all records in a file). * Version (ensure format of original data and variables has not changed when data was transformed). * Completeness check (all records are transferred in the file). * Conformity check (does data look right?). * Spot check (trace some records back to their source file eg. 10 random records to see they have transferred correctly). Cleaning Data One of first and most important steps in data analysis is to verify that your data values are correct, or conform to a set of rules. * For example a variable called Gender would be expected to have only 2 values (M or F). * You need to consider the variables and their values firstly to see they are appropriate for the data they contain. * MS Access and SAS have a number of ways you can use to check for...

Words: 3223 - Pages: 13