Nobody downloaded yet

A2 EXCEL DRAFT - Assignment Example

Comments (0) Cite this document
The cost benefit analysis is aimed at changing the way benefits are provided on an experimental basis. An experiment (pilot) study was carried on the human resource department of…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER93.6% of users find it useful
Read TextPreview

Extract of sample "A2 EXCEL DRAFT"

Download file to see previous pages These figures provided the basis for calculation of the individual employee earnings, contributions and benefits as well as the FICA deductions. To provide a cost benefit analysis, both the expenditures incurred by the department and the benefits translated to savings must be computed.
The personnel based expenditures include the salaries and wages and Employee benefits contributed by the department. Values for these two items are obtained from the 2014 adopted budget. The company is obliged to make social security contribution of 6.2% and Medicare contribution of 1.45% of the salaries and wages respectively. Additionally, each employee is given a retirement related benefit of 7.5% of salaries and wages. Once these figures are calculated, the recurring costs, one-time costs and recurring savings are calculated based on the assumptions that the pilot experiment will run for a transition period of six months and involves 5 employees only. Additionally, the experiment will be projected for a period of five years after the transitional period. This eventually provides values for present value of costs and the present value of benefits that are then used to calculate the net present Value and the Benefit/cost ratio.
Essentially, the figures used for the calculations were obtained from the adopted budget for the county for the 2014 financial year. According to the report the human resource department has a staff FTE of 14, calculated salaries and wages of $993,967 and employee benefits amounting to $255,692. These figures are used to derive the employee benefits, FICA tax withholdings, social security and Medicare contributions. Social security is computed by multiplying 6.2% (rate of withholding) by the salaries and wages. On the other hand the Medicare contributions are calculated by multiplying the salaries and wages by a withholding rate of 1.45%. It is important to note that all categories of deductions (contributions by employer) except ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
(“A2 EXCEL DRAFT Assignment Example | Topics and Well Written Essays - 1250 words”, n.d.)
Retrieved from
(A2 EXCEL DRAFT Assignment Example | Topics and Well Written Essays - 1250 Words)
“A2 EXCEL DRAFT Assignment Example | Topics and Well Written Essays - 1250 Words”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document


Excel Project

...from that, the rest of the companies reported the positive returns in the given time frame. Results One basis of the results computed on the Microsoft Excel sheet along with the graphs, the analysis of 120 trading days’ activity clearly reflects that SAP performed remarkably well earning a gain of around $90,000, whereas Microsoft turned out to be the worst among all five participants reporting a net loss of around $55,000. The other three software designing firms produced mediocre results, presenting net gains $15,000, $9,000 and ?12,000 by oracle, Intuit and Sage respectively. Source Yahoo! Finance was used as the data source from the stock price data was retrieved. The reason for choosing this financial database is...
6 Pages(1500 words)Essay

How to Write a Thesis

..., math coursework, English coursework, French coursework, media coursework, Romeo and Juliet coursework, AS coursework, A2 coursework, Macbeth coursework, coursework evaluation - which we develop. Our coursework writing is characterized by stringent approaches that follow existing academic standards. And let us admit it; everybody wants to get high marks out of their coursework essays. In this regard, we are pleased to say that our writers are equipped with the necessary knowledge, skills and training that could achieve for you excellent grade. How do we do this, you may ask? To impart one trade secret: It has been proven by our experience and confirmed by our commissioned research that while the...
31 Pages(7750 words)Essay


...Introduction: The report gives a detailed discussion of the procurement strategy followed for providing the procurement for the road project including the bridges, under the ECC (Engineering and Construction Contract). The report also contains the organizational chart according to which the procurement will be carried out along with the time-frame for the tendering process. At the end the possible risks involved in the execution of the procurement strategy are mentioned along with the solutions to the problems. Different types of contracts under the ECC are discussed briefly and some of the specifications regarding the road project are given. The choice of the procurement strategy is justified and maintained throughout the report... The...
9 Pages(2250 words)Essay


...11/13 Draft Reflection of Cultural, Tradition and Ritual Practices In African Society Introduction The common practice in South Africa is initiation, whereby it is considered rite of passage for both boys and girls. Moreover, this practice occurs every year in some cultures of African society, through ceremonies in a period of one to two weeks to a maximum period of three months. On the other hand, the term Ndebele is borrowed for the Sotho-Tswans tebele, which refers to a stranger. The article covered in class related to cultural, traditional and ritual practices in African society, whereby the ideas covered in the article indicated that numerous people in the African society have values and beliefs. Consequently, this brought... Draft...
2 Pages(500 words)Essay


...Discuss how and why language plays an important role in the Arabic culture. Language plays a very important part in human culture because it codifiesthe way that people see the world, giving them categories and descriptors that they share with each other, building up a collective perspective which circulates within and across tribes, nations and alliances over the centuries. In the case of Arabic, the language exerts an influence on modern Arab culture both in terms of retaining the old values of the past and building new connections in the globalized world of today. The rise of the Islamic religion with the life of the prophet Mohamed in the sixth century brought a sense of unity to speakers of Arabic in the region around... how and why...
2 Pages(500 words)Essay

In excel:

...My Business and Number of Answer Report For any business to realize an increase in profits at the end of a given duration, quite a number of factors can be varied. Two parameters were chosen for this business model and that is: sales and cost of sales while maintaining all the other factors constant, e.g. those relating to customers. To do this, a spreadsheet named “Profit Analyzer” was created that projects the expected profits depending on how these two chosen parameters are expected to vary quarterly i.e. their percentage rate of increase or decrease (Ken Kaufaman, 2010). When a percentage rate of change is entered under the “Variations” column for either of the two parameters, say 105% if sales are projected to increase... Business and...
2 Pages(500 words)Essay

Definition Rough Draft & Final Draft

...Number: Topic: DEFINITION ROUGH DRAFT & FINAL DRAFT A rough draft is the first piece of writing thatthe writer compose without worrying so much about grimmer, spelling mistakes and anything that may destruct the writer from writing. The main aim of coming up with a rough draft is to provide the writer with an opportunity of formulating a final draft without so much difficulties. On the other hand, final draft is a rough draft that has be written again while ensuring that there are no spelling mistakes and grammatical typos. The follow steps may be helpful when writing a draft namely; brainstorming,...
1 Pages(250 words)Assignment


...INFS 3100 EXCEL ASSIGNMENT DUE: Wednesday, February 11 (beginning After 12:50 pm the assignment is considered a day late. See syllabus for late policy. Helpful Hint: Don’t forget to “Lock Cells” (Use absolute cell references) as needed when doing calculations for this assignment. Instructions: (use formulas or functions unless otherwise noted) 1. Download and open the template found on D2L. (Filename: 3100 Excel Assignment 1 Outline Spring 2015) 2. Set the value of the January “Beg. Of Month Inventory” equal to the “Initial Inventory” Cell. 3. Set the value of January “Production” equal to the “Initial Production” Cell. 4. Set the value of January “Units Sold” equal to the “Initial Units Sold” Cell. 5. Management predicts... “Not...
1 Pages(250 words)Assignment


...MODULE: NBS-3F3Y WORK Colin al affiliation: Descriptive Statistics Part 1A Descriptive statistics involves the analysis of data that helps describe, show and summarize data in a meaningful way that patterns may emerge from the data. With reference to the descriptive statistics, the location and dispersion were taken into considerations in analyzing the Abbotts Laboratories together with two other companies, including Unilever and S & P 500. Abbott Laboratories has a relatively higher average return and lower risk when compared to Unilever and S & P 500 which has a higher average return than it but a higher risk rate. Therefore Abbott Laboratories is a better company to invest in based on its lower risks rate. But if the average... NBS-3F3Y...
11 Pages(2750 words)Essay


...DRAFT Literature Review Introduction This section examines the role of social media in crisis management within organizations. It will analyze the scholarly work on this function that includes scholarly publications, peer-reviewed journals and books amongst other educational resources. These are as argued and elaborated below: Social Media in Public Relations Social media has always been used by most organizations as a means of communicating with the masses as well as relating with the public or clientele served by the organization. To this end, Lattimore et al (2004) have attempted to define what public relations entail. According to Lattimore et al (2004) refers to the management and leadership function of the organization... that have...
9 Pages(2250 words)Research Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Assignment on topic A2 EXCEL DRAFT for FREE!

Contact Us