Free Essay

Cost Benefit Analysis Spreadsheet

In:

Submitted By lima2015
Words 301
Pages 2
| Be sure to review the live lecture recording (available Now) Appendix A: 1. The use-case diagram shown in Figure A-1 F captures the Student billing function but does not contain any function for accepting tuition payment from students. Revise the diagram to capture this functionality. Also, express some common behavior among two use cases in the revised diagram by using include relationships.Appendix B:1. When should you use an Agile method, and when should you use an engineering-based method for developing a system? Support your answer. Course Project:Create a Use-Case Diagram for the CRM System following the UML guidelines in Appendix A of the textbook. * Doc sharing Project Workbook - Week 7 folder, has instructions on how to create a Use Case using Visio (but you can use any MS Office application). * Need to include processes for Record Customer Activities, Send Promotions, Generate Point Redemption Coupons, and Generate Customer Reports processes. * The hint is to look at the external entities, processes, and data stores from the Level 0 DFD on page 187. * Actors: * The Customer is a source and a sink - and should be shown as one Actor on our Use Case. * The three data stores will be the other actors: * Customer Activity Records. * Marketing Database. * Product Database. * Process: Each of the sub process on page 187 will become a Process reflected in the Use Case. * So we have a total of four processes. * Send Promotions. * Generate Point Redemption Coupons. * Record Customer Activity. * Generate Customer Reports.Actors will interact with the processes on the Use Case based on the data flow arrows on the Level 0 diagram. For Example: Product Database Actor will connect to the Generate Customer Reports process as shown on the bottom right of the Level 0 diagram on page 187. |

Similar Documents

Premium Essay

Economics

...Alternative “C” Economic Analysis * Contains: 1. Tangible Benefits Worksheet 2. One Time Cost Worksheet 3. Recurring Cost Worksheet 4. Discount rates * Used to create Cost/Benefit Analysis Spreadsheets for possible alternative solutions. Cost/Benefit Analysis spreadsheet is located in doc sharing. * Description of Alternative C – Nova Corporation. (see page 151 in the book) 1. Industry Leader in CRM solutions 2. Large and complex 3. Pricing only based on modules purchased 4. License for the use of the system is middle of the row 1. Tangible Benefits Worksheet - Nova Nova - Alternative “C” Tangible Benefits Worksheet | A. | Cost reduction or avoidance | $12,500 | B. | Error reduction | $ 3,500 | C. | Increased Flexibility | $ 5,500 | D. | Increased speed of activity | $ 7,500 | E. | Improvement management/planning control | $15,000 | F. | Ease of interfacing with business partners | $16,000 | Total Tangible Benefits | $60,000 | 2. One Time Cost Worksheet – Nova Nova - Alternative “C” One Time Costs Worksheet | A. | Development Costs | $ 2,000 | B. | New Hardware | $ 1,000 | C. | Software License or Purchase cost | $19,500 | D. | User Training | $ 3,500 | E. | Site Preparation | $ 4,000 | Total One Time Costs | $30,000 | 3. Recurring Cost Worksheet – Nova Nova – Alternative “ C” Recurring Cost Costs Worksheet | A. | Software Maintenance | $ 2,500 | B. | Incremental Data Storage...

Words: 265 - Pages: 2

Premium Essay

Mngm340

...Week 1 Reading * Chapter 1: The Systems Development Environment * Chapter 2: The Sources of Software Problems and Exercises * Chapter 1, Problems/Exercises, Questions 1 and 8. * Chapter 2, Problems/Exercises, Questions 3 and 4. Submit your assignment (in a single MS Word document) to the Dropbox located on the silver tab at the top of this page. For instructions on how to use the Dropbox, read these step-by-step instructions or watch this Tutorial Dropbox Tutorial. The dropbox for this assignment is called "Week 1: Problems and Exercises". See the Syllabus section "Due Dates for Assignments & Exams" for due date information. Course Project Company Overview Package Petrie's Electronics Case * Petrie's Electronics Case, Chapter 2, Questions 1, 2, and 4. See Course Project tabs underneath this week and the Course Home. Submit your assignment to the Dropbox located on the silver tab at the top of this page. For instructions on how to use the Dropbox, read these step-by-step instructions or watch this Tutorial Dropbox Tutorial. The dropbox for this assignment is called "Week 1: Petries' Electronics Cases Ch 2". See the Syllabus section "Due Dates for Assignments & Exams" for due date information. Week 2 Reading * Chapter 3: Managing the Information Systems Project * Chapter 4: Systems Planning and Selection Problems and Exercises * Chapter 3, Problems/Exercises, Questions 2 and 4. * Chapter 4, Problems/Exercises...

Words: 1057 - Pages: 5

Free Essay

International Human Resource Management

... 9 -Learning or Cognitive Outcomes 9 -Behavior and Skill-Based Outcomes 9 -Affective Outcomes 10 -Results 10 -Return on Investment 10 Determining Whether Outcomes are Appropriate 11 -Relevance 11 -Reliability 13 -Discrimination 13 -Practicality 14 Evaluation Practices 15 - Which Training Outcomes Should be Collected 16 - Evaluation Designs 18 - Threats to Validity 18 - Types of Evaluation designs 21 Consideration in choosing an Evaluation design 24 Determining return on investment 25 - Determining Costs 25 - Determining Benefits 26 Other Methods for Cost-benefit Analysis 27 Practical Considerations in Determining ROI 28 Success Cases and Return on Expectations 28 Measuring Human Capital and Training Activity 28 Sources 29 Training Evaluation Training evaluation is a continual and systematic process of assessing the value or potential value of a training program, course, activity or event.  Results of the evaluation are used to guide decision-making...

Words: 3530 - Pages: 15

Premium Essay

Movs

...hristy  This was a good start but the project description could be more detailed. The cost-benefit analysis was missing – it should be like the one seen in the week 2 assignment from Husky and should have all three alternatives in a spreadsheet. Cost estimates for salaries, hardware, software should be researched and source cites used. For a good example - ask Stephen Van Mil for a copy of his work. Consider the example MOV below that is fairly detailed – at least one MOV should address the loss of students ... EXAMPLE  MOV: Customer satisfaction, as measured by a validated survey that we have been using to measure customer satisfaction, will increase by 45% and will be responsible for increasing the number of student enrolments and for increasing student retention – this will result in 4 students per month  being at the school who would otherwise would not be there. This result will come from losing only .5 students per month (on average) and from the gain of 3.5 new students per month (on average).  The increase is expected to be gained in the first year and remain steady at this rate for at least 3 years. As supported by our customer satisfaction survey, we will increase customer satisfaction by 45 to 50 percent and increase student enrollment and retention. Enrollment and retention would result from higher customer satisfaction numbers would lead to a client loss of .5 students monthly, and a new customer draw of 3.5 per month. The growth is expected to remain the same...

Words: 540 - Pages: 3

Premium Essay

Law Cases

...progressive experience in the analysis of financial / economic data supporting enterprise decision making including marketing and investments; financial planning, forecasting, and modeling; company valuation; credit underwriting; and portfolio management. PROFESSIONAL EXPERIENCE Financial Analyst, OppenheimerFunds, Denver, CO 2014 - 2015 Successfully secured $100 Million in additional funding by developing a profitability / financial viability model of company’s 350 stores Evaluated and recommended an in-house delivery system in OppenheimerFunds, CO, which resulted in a $100,000 annual savings by eliminating need for outside carrier Created an optimal staffing model for stores resulting in annual payroll work hours savings of 20% Streamlined the corporate planning process, creating a centralized planning platform that reduced budget preparation time by two weeks despite the budget doubling in size over a two-year period Conducted cost benefit analysis to outsource the store’s in-house packaging facility resulting in a $1.5 million savings Produce annual budgets exceeding $500 million and forecast models on a departmental, business segment and consolidated basis working with functional department heads and senior management Analyze and interpret monthly variances and trends between budgets, actual and prior results in developing projections and forecast Track and review gross and net sales including gross margins in producing forecasts and trend analysis on an on-going basis ...

Words: 428 - Pages: 2

Premium Essay

Rsytvboub

...Utility Management System Cost and Time Benefits and Implications from the Local Agency Perspective Downloaded from ascelibrary.org by Indian Inst of Technology - Mumbai (IITM) on 05/11/16. Copyright ASCE. For personal use only; all rights reserved. Mark Lee, P.E. 1; Jorge A. Rueda-Benavides 2; Douglas D. Gransberg, Ph.D., P.E., M.ASCE 3 Abstract: Utility management systems (UMSs) have become more common for government agencies, and their use has recently been advocated by AASHTO on a statewide basis. By identifying current utility locations and correlating utility-related information between ongoing and upcoming projects, UMSs can reduce the occurrence of unexpected delays and cost overruns resulting from unforeseen utility conflicts found during construction. This paper presents an analysis of a two-part survey of local agency professionals in the transportation industry, regarding perceptions of UMS cost and time benefits and implications associated with implementation. The paper evaluates two hypotheses regarding local agencies’ perception on two key areas: (1) impact of UMS cost and time implementation requirements on implementation decisions; and (2) difference in cost and time benefits and implications for different types of local agencies. The study finds that despite its obvious potential benefits, UMSs are not being widely implemented at the local level because the cost to adopt them is perceived to be high. Additionally, this study found opportunities...

Words: 7270 - Pages: 30

Premium Essay

Product Development Report

...Practical Cost-Benefit Analysis for Financial Regulators Version 1.1* Financial Services Authority Central Policy © June 2000 This document was prepared, originally in 1998, for the use of policy makers within the FSA. Foreword to edition 1.0 To demonstrate our performance to Government, consumer groups and the industry, the FSA will have to meet the benchmarks set out in the document “Meeting Our Responsibilities”. As we said there, a key benchmark for judging our regulatory standards will be the balance struck between the interests of our stakeholders. Undertaking cost-benefit analysis, which will in any event be a statutory obligation under the terms of the new legislation, will help us to strike the right balance. And publishing the results will demonstrate to stakeholders that their views are given a fair hearing in the process of setting regulatory standards. It is therefore clear that any cost-benefit work we undertake should be able to stand up to external as well as internal scrutiny. Thus, as part of our effort to become a world leading financial services regulator, we have developed and had validated externally an approach to cost-benefit analysis that can be applied systematically across our various activities and regulated businesses. The approach is set out in this new guide “Practical Cost-Benefit Analysis for Financial Regulators”, prepared in the Central Policy directorate. I believe that adherence to the principles, tools and techniques set out...

Words: 13965 - Pages: 56

Free Essay

Agri Sba Template

...MANNING’S SCHOOL AGRICULTURAL SCIENCE DEPARTMENT AGRICULTURE SBA TEMPLATE Guidelines for Cost Analysis of Farm Production Project (Crop Production) Item | Description | KCMarks | Total | (I) Introduction | Name of projectLocationDurationDescription of activities, sketch of layout of plot,materials and equipments Schedule of operation | 3 1 | | (ii) Complete budget | Projected income (output x price)Projected expenditure (itemized)surplus | 1 1 1 | | (iii) Actual income And expenditure | Income (from sale to produce) ExpenditureSurplus or shortfall | 2 2 1 | | (iv) Analysis (v) Language | Comparison of projected and actual income,Expenditure and surplus or shortfallGeneral commentConclusionRecommendationsCommunication of information in a logical manner using correct grammar | 2 2 1 1 2 | | TOTAL | | 20 | | NAME OF PROJECT: Crop Production LOCATION: Manning’s School Farm DURATION: Six –Sixteen Weeks (or you can write the date started and the date when project completed) Description of Activities This will include activities that will be carried out during the production period that are important for growth and development of the chicken. These include: * Site Selection * Land Preparation * Seedling production seed bed Management * Planting and transplanting * Irrigation * Weed control * Fertilizer/Fertilizing ...

Words: 847 - Pages: 4

Free Essay

Paper

...Utilitarianism is a moral principle that holds that the morally right course of action in any situation is the one that produces the greatest balance of benefits over harms for everyone affected. So long as a course of action produces maximum benefits for everyone, utilitarianism does not care whether the benefits are produced by lies, manipulation, or coercion (Andre,Velazques). Gene G. James in his book Business Ethics:Readings and Cases in Corporate Morality, defines whistle blowing as, “the attempt of an employee or former employee of an organization to disclose what he or she believes to be wrongdoing in or by the organization” (Griffin). How does one choose if wrongdoing has happened in a utilitarianistic view? To present the process of utilitarian theory in a whistleblowing case, I ran across documentation referencing Ford Motor Company’s manufacturing of the Ford Pinto the early 1970’s. Petersen and Farrell discuss the ethical dilemmas faced by engineers highlighted by the 1980 Winamac, Indiana trial of Ford Motor Company (1986, p.3). The Pinto was created as a response to the Japanese competition emerging in the US. Due to competition, Ford was eager to get the subcompact car released in 1971. Changes were made, and Ford was able to reduce the lead time of production by a year and a half to get the car on the road. Frank Capps, a principal design Engineer charged that management’s weight and price goals along with time requirements resulted in engineers having to place...

Words: 744 - Pages: 3

Premium Essay

Essay

...the materiality thresholds used on individual audit engagements? Would it be feasible for auditors to conceal this information from their audit clients? Absolutely, auditors should do their utmost in concealing such critical audit aspects as that of materiality thresholds because they can very well jeopardize the genuinity and conclusion of the audit engagement as was evident in the case. Of course, it is nearly impossible to eliminate such doubt because of the fact there is so much interaction between the client and the auditors, whether it be handle inquiries or prepare documents. Clients can very use such interaction to their advantage and develop a sense as to how the auditors work and what accounts they will look into. The cost benefit analysis would come into play...

Words: 555 - Pages: 3

Premium Essay

Cost Benefits Analysis of Employee Trng. Program

...Cost/Benefit analysis of Employee Training programs University of Phoenix HRM/531 Training is a process that can provide significant value and rewards that far outweigh its financial costs. The effects of training touches the lives of employees from the first day of a new job through retirement The purpose of this paper is to show how employee training benefits not only the organization but also the environment as well. The reader will be introduced to an oil distribution company undergoing costly problems because of poorly trained employees. These problems have resulted in repeated environmental violations. An analysis of the company was conducted to weigh the cost/benefits of incorporating an effective employee-training program to address the problem. The outcome of the analysis will determine whether the training is financially feasible, or if another project should be pursued. In addition, the effect of management behavior on productivity, the definition and use of behavior costing, effects of high performance work policies on business financial performanceas that relate to the company; along with recommendations based on researched data gathered will be given in this paper. Training is defined as an activity leading to skilled behavior. Employee training involves a set of planned activities that organization will have their employees complete in order to increase their job knowledge, skills, and abilities. In practice, training gets employees accustomed...

Words: 2346 - Pages: 10

Premium Essay

Widget

...the company and come up with two alternatives, which will help determine the best choice to maximize labor productivity for Taylor Inc. The cost-benefit matrix below will show which alternative management technique will maximize productivity with less worker’s compensation claims. Cost Benefit Matrix Current Alternative One Alternative Two Number of employees 17 6 9 Payroll costs per 8 hour day $5,848.00 $2,064.00 $3,096.00 Payroll costs per week $29,240.00 $10,320.00 $15,480.00 Payroll savings per week 0 $18,920.00 $13,760.00 Payroll costs per year (52 weeks) $1,520,480.00 $536,640.00 $804,960.00 Claims per year 4 0.3 1.9 Claims costs per year $436,000.00 $32,700.00 $207,100.00 Claims costs savings 0 $403,300.00 $228,900.00 Wages and claims per year $1,956,480.00 $569,340.00 $1,012,060.00 Wage and claims savings per year $0.00 $1,387,140.00 $944,420.00 Physical lifting in pounds 42 12 23 Capital expenditures $0.00 $1,300,000.00 $967,000.00 Cost difference in capital expenditures $1,300,000.00 0 $333,000.00 Outputs of finished widgets 208 392 288 Life in equipment 0 7 5 Wasted motion in % 27% 1% 7% Effect of Alternative on Productivity Based on the above cost-benefit matrix, the best option for Taylor Inc. would be Alternative One. Although Alternative One is the more expensive management technique, it is more cost-effective over the course of seven years. Alternative One requires a capital investment of $1,300,000.00, which is $333,000.00 more than...

Words: 542 - Pages: 3

Premium Essay

Ford Pinto

...Ford's Risk/Benefit Analysis The main controversy surrounding the Ford Pinto case was The Ford Motor Company's choices made during development to compromise safety for efficiency and profit maximization. More specifically, it was Ford's decision to use the cost/benefit analysis detailed in section 11 to make production decisions that translated into lost lives. During the initial production and testing phase, Ford set "limits for 2000" for the Pinto. That meant the car was not to exceed $2000 in cost or 2000 pounds in weight. This set tough limitations on the production team. After the basic design was complete, crash testing was begun. The results of crash testing revealed that when struck from the rear at speeds of 31 miles per hour or above, the Pinto's gas tank ruptured. The tank was positioned according to the industry standard at the time (between the rear bumper and the rear axle), but studs protruding from the rear axle would puncture the gas tank. Upon impact, the fuel filler neck would break, resulting in spilled gasoline. The Pinto basically turned into a death trap. Ford crash tested a total of eleven automobiles and eight resulted in potentially catastrophic situations. The only three that survived had their gas tanks modified prior to testing.55 Ford was not in violation of the law in any way and had to make the decision whether to incur a cost to fix the obvious problem internally. There were several options for fuel system redesign. The option most seriously...

Words: 428 - Pages: 2

Premium Essay

W.C.Wood Companies

...Written Analysis and Communication I Submitted to Prof.Rohini Patel Ms.Pooja Thomas By Prabu.T Parmar Niravkumar R. Section-D On 23rd July, 2011 Letter of Transmittal To Mr. Paul Stevenson, Vice-President, Manufacturing, W. C. Wood Company. Subject: Analysis report on proposal to change the packaging of the Company’s product line With reference to your request for a report on the proposal to change the packaging of the Company’s product line, please find attached the same. After careful analysis and consideration of the options, I recommend that we should adopt clear pack packaging and install Lachenmeier equipments simultaneously at all plants. Detailed analysis is presented in the enclosed report. Regards, XYZ, Assistant to the VP, Manufacturing, W. C. Wood Company, 8th January, 2004. Executive Summary W. C. Wood Company has been considering a proposal to change the packaging of their product lines from cardboard to ‘clear pack’. A shift to clear pack would bring down the high expenditures on damage warranty claims and increase ease of handling. But the huge capital expenditure involved with the shift should also be taken into account. We should decide whether to shift to the new packaging and if so the timeline for the implementation. The strategy could involve a one-time or phased implementation. This should be done after taking the cost benefits...

Words: 1523 - Pages: 7

Premium Essay

Hsa 510 Assignment #1

...found in most previous studies. We use these results to estimate coverage expansion under the Affordable Care Act, with and without an individual mandate. We estimate that 39 million uninsured individuals would gain coverage and find limited evidence of adverse selection. In the United States, the economy shapes the complex interactions among employment, health coverage, and costs, as well as financial access to care and health outcomes. In economic downturns, few employers drop health coverage or restrict employee eligibility. More commonly, they reduce costs by changing benefits and cost-sharing provisions. Employees in low-wage jobs, working in small firms, and those in certain industries have been far more likely than others to have been uninsured when they lost their jobs, but this recession is affecting a broader swath of the workforce. Research on the effects of economic cycles on health status is confusing. Apart from the current economic downturn, the design and cost of employer-sponsored coverage have also changed over time, and more people are finding work that does not offer health benefits. The recession has kept patients from seeking inpatient and elective services. Physicians and...

Words: 616 - Pages: 3