Gambino cleaning products salesman Essay Example for Free

Gambino cleaning products salesman Essay Description of the proposed system Description of the problem A new system of calculating and reporting on cleaning products salesmen is to be designed and implemented. Cleaning products salesmen commission is based on a set of data which is the monthly sales of cleaning products sold by the salesmen. Objectives The new system must: Â  Be automated as far as possible, needing no thorough knowledge of spreadsheets, databases or any other software in order to operate it. Â  Have fitted controls to ensure precision and completeness of data input. Â  Take into account commission payments from monthly sales. Print commission reports for each of the salesmen, and a summary report showing total paid to each salesman and overall total. Include an option to delete commission records previous to a given date so that the file does not increase for an indefinite period. The proposed new system can be shown in a level 0 data flow diagram as follows: A level 1 Data Flow Diagram of the proposed system is as follows: User functions 1. The Commissioning Salesman in the Sales Department will be responsible for entering all details of new cleaning products salesman and new products. 2. An Accounts clerk will have special responsibility for the commission system. 3. The Accounts clerk will enter each month the sales of each product, giving quantity sold and gross sales value (i. e. quantity X cover price). 4. Every 6 months, the Accounts clerk will produce the Commission reports for each cleaning products salesman. This will show the commission that has been earned in the previous 6 months. A payment is then recorded and a cheque issued to each cleaning products salesman to whom commission is due, together with the Commission statement showing sales details, and the statement from the Accounts system the total amount due. Database specification Menu structure The many functions of the Commission System will be accessed by means of a front-end menu, which will have the following structure. The data model There are three main entities in this system related in the entity relationship diagram shown below. Because a many-to-many relationship cannot be applied in a relational database, an additional entity named Salesman/Product is introduced. The ERD can now be drawn as follows: The database for Gambino cleaning products salesman system specification will have the following tables: tblSalesman (SalesmanID, Surname, FirstName). Foreign key in tblSalesman/Product ProductName Text (40) Product title tblProduct SalesTeam Text (40) All salesman who sell a product tblProduct Price Currency Product price tblProduct StandardCommission Number Percentage commission on each product sold 1-10 tblSalesman/Products BonusCommission Number Bonus percentage commission on each products sold 11-20 tblSalesman/Products SalesNumber Number 1=Standard commission 2=Bonus Commission 1 or 2 tblSales QuantitySold Number Number of products sold tblSales GrossValue Currency Data Dictionary Input Specification Three input forms will be required. frmProducts. This will be used to enter product details. frmSalesman This will be used to enter details of a salesman and all products on which they receive commission. The commission percentages for each product will be entered in a subform of the main form. Validation methods: The Product ID will be selected from a drop-down list of existing Product IDs. Once a Product ID is entered, the product name will be automatically displayed. frmTransaction This form will be used to enter transactions. Validation methods: Only valid dates will be accepted. The Product ID will be selected from a drop down list of existing Product IDs. Once a Product ID is entered, the product name will be automatically displayed. Selecting a radio button so that only a valid alternative can be selected will choose the transaction type. Process Specification Commission Calculations To calculate the commission for a given transaction, a query has to be performed to combine attributes from tblTransaction, tblProduct, tblProduct/Salesman and tblSalesman. The calculation of the commission is performed as follows: If TransactionType = 1 (i. e sales) ThenRate = StandardCommissionRate ElseRate = BonusCommissionRate endif Amount = Rate * GrossValue. These processes will be carried out in qryCommission. This query will be the source of both the commission report and the summary report. Maintenance Each year, transactions prior to a given date will be removed from tblTransactions. This prevents the transaction file from becoming too large and slowing down the system. The maintenance will be carried out as follows: Run a Delete query to delete records from tblTransaction. Test Plan Tests will be carried out using valid and invalid data and data at the extremes of acceptable values. The following test data will be used. tblSalesman Salesman ID Surname Firstname STEVED Stevens David. Test urpose Expected result 1 Select enter data from main menu, then select Products. To check if the menu options work and that a Products form opens at a new record. Products form opens at a new record. 2 Enter data from test data set. Try entering an invalid date i. e. 3/9/2001 To check the menu options work and that the Salesman form opens at a new record. Salesman form opens at a new record. 3 Select Enter Data from Main menu and then select Salesman. To check if the menu options work and that the Salesman form opens at a new record. Salesman form opens at a new record. 4 Enter data from test data set. To check if valid data is accepted. All valid data accepted. 5 Try entering product ID of BB113. Test that no product can be entered unless it exists on product table. Record rejected. 6 Select Enter Data from Main menu and select Sales To check the menu options work and that the sales form opens at a new record. Sales form opens at a new record. 7 Attempt to enter a new sale with date 3/9/2001 To test if date is validated. Error message will appear on leaving field. 8 Select reports from Main menu then select Product details. Test to see if the Product details display all products entered. All products appear on the report. 9 Select report from the Main menu then select Commission report. Check to see if Commission report details are correct. User is asked to enter start and end dates for report. All commission is calculated correctly. 10 Select Reports from Main menu the select Summary report. Check that Summary report is correct. User is asked to enter start and end dates for report. All totals are calculated correctly. 11 Add 2 transactions for dates in 1999. then select Maintenance from Main menu and identify deletion of records prior to 31/12/1999 Check that Maintenance option deletes records prior to date user enters. The two records are deleted from table. 12 Add a transaction for 31/12/1999. then select Maintenance from Main menu and identify deletion of records prior to 31/12/1999. Check that maintenance option deletes records for date user enters. The record is deleted from table. 13 Select Exit from Main menu To check if the main menu option works correctly. Database closes. Development Plan The planned schedule for development is given below. Week beggining Task Comments 29/01/2004 Detailed design spec 29/01/2004 Tables created 01/02/2004 Input forms created 15/02/2004 Queries and reports created Reports on products and salesman 21/02/2004 Standard commission report created 27/02/2004 Procedures for clearing file developed Clearing records prior to given date 29/02/2004 Testing and modifications 03/03/2004 Testing and modifications 06/03/2004 Documentation 08/03/2004 Installation and entry of master file data. A period of parallel running will follow with reports produced from old and new systems. Conclusion The system will be implemented by Microsoft Access 2000. It will run on any existing PC. The database will be accessible from any of the Departments which are responsible for keeping the data up to date. These departments include Accounts and Sales departments. The system is expected to be tested and installed by the end of April 2004. Sunit Dhadra 12K AVCE ICT AVCE ICT Unit 1 Sunit Dhadra 12K AVCE ICT.

Human Genome Project :: essays research papers

Human Genome Project   Ã‚  Ã‚  Ã‚  Ã‚  Scientists are taking medical technology to new heights as they race to map all of the genes in our body. There are about 100,000, in the 23 chromosomes of the human body. In doing this they hope that they can understand the basis of the genes and maybe even develop methods of treating certain genetic diseases, such as Alzheimer’s and Muscular Dystrophy. The scientists identify the DNA sequence of someone with the disease and then compare it to a person without the disease. By doing this they can recognize which gene is abnormal and causes the disease. This entire process is called the â€Å"Human Genome Project† and is being done in more than 200 laboratories, with more and more labs joining each year. Most of these labs are located in France and the United States. The project started in 1990 and was predicted to take 15 years and cost $3 billion. It costs the United States about $200 million per year. The $200 million per year has only covered abou t 60% of the annual need. This has created some funding problems for the project. On the brighter side the project has made huge steps in gene mapping and continues to improve every year.   Ã‚  Ã‚  Ã‚  Ã‚  Researchers have successfully located the gene and the DNA sequence that causes Huntington’s Disease. It is located on Chromosome 4. Scientists have created a genetic test, which can determine whether someone carries these genes or DNA pattern. Every child of someone with Huntington’s Disease has a 50% chance of inheriting the gene, which then inevitably leads to the disease. Because of the high amounts of money it costs for treatment of this disease insurance companies see this test as an opportunity to screen potential clients for the probability of such diseases. This would allow them to deny certain people insurance if they are at high risk. This puts the people being screen in a position where they might not be able to receive treatment for their illnesses because they won’t be able to get insurance. This is morally wrong and also violates the patients right to privacy. This information must be safeguarded from insurance companies so they will not be able to discriminate against someone with â€Å"bad genes†. These actions also bring up several ethical questions. â€Å"Does genetic testing constitute an invasion of privacy, and would it cause discrimination against those born with genetic deficiencies?

Assess the efficiencies in Municipality budget plan to achieve organizational objectives Essay

Assess the efficiencies in Municipality budget plan to achieve organizational objectives. Background of the study                  In the recent past, UA E has received continued development and prosperity. Municipality is a government sector responsible for infrastructural development across the city. Western region Municipality has several departments that have common objectives of fulfilling the organization’s work process. The accounting department plays a key role in development. Municipality is therefore dependent on the accounting sectors as well as other sectors in meeting its objectives. The UAE department of finance and the Municipality must collaborate in achieving the objectives. The UAE finance department has to avail funds to the Municipality. Funds management is a crucial factor in an organization. The accounts department should plan effectively and forecast the expected expenditures. The research aim is to assess the effectiveness in Municipality budget plan to achieve organizational objectives. Municipality ensures development within towns. Development would entail; construction of roads, bridges and drainage systems just to mention a few. Construction of a bridge in the Western region Municipality was halted. The construction was halted due to the budget constraints Municipality was experiencing. This necessitates a research to find out the constraints and give recommendations to the budget planners. A comprehensive budget will ensure; organizational goals and objectives are attained. Municipality will be in a point of completing projects timely, without budget challenges. The research will also help scholars aware of factors considered when coming up with an effective budget plan. The research will be guided by the financial theory and the budget concept. The financial theory entails the cash flows and budgeting. Budgeting involves the computation of budget statements. Budget statements contain numerical figure that help the business plan ahead. The organization performance is checked against the budgeted figures. The budget concept will be use to help in forecasting future operations that will help in attainment of objectives. The budget concept will be guided by the results obtained from the financial theory. With proper budgeting, UAE department of finance will acquire the forecasted budget from the municipality and accomplish its goals. According to the industry expert, there are three challenges facing the accounting industry; unqualified accountants in the accounting industry, online accounting technology and firm consolidation. Unqualified accountants misguide organizations. Online technologies pose a great threat to the accountancy field. Business owners may now likely question why they need to solicit the services of an accountant when they can do a large number of functions for themselves (Economia.icaew.com, 2014). According to Mitten another challenge of the accounting industry is consolidation of firms. The study will be conducted with an aim of evaluating the effectiveness of the municipality budget plan in a bid to come up with ways of attaining the organization’s objectives. From the discussions with the industry expert, the municipality should; Carryout interviews when enrolling accountants seek financial advices from competent accountants on the budget plan computation, give all their departments specific roles. For instance the accounting department should only deals with accounting. Research plan                  Quantitative research approach will be used where data will be obtained from various accounting departments in the municipality. A survey questionnaire will be issued across the accounting departments in the regions of the municipality. The results obtained from the research will be analyzed and presented in graphs. To come up with comprehensive findings in a research a researcher should; identify the problem, identify the objectives, review literature, design a research methodology, collect data, analyze data, discuss the data, deduce recommendation, give a conclusion then give a final report. The researcher should then present the information. Research timetable Task Name Duration Start Finish Development of the proposal 6 days Tue 2/17/15 Tue 2/24/15 Literature review 7 days Sun 3/1/15 Mon 3/9/15 Data Collection and analysis 5 days Sat 3/14/15 Thu 3/19/15 Discussions, Recommendations and Conclusions 6 days Sun 3/29/15 Fri 4/3/15 Final Report 10 days Sun 4/12/15 Thu /4/23/15 Presentation 2 days Tue 5/19/15 Wed 5/20/15 References Economia.icaew.com,. (2014).  Top three challenges facing accountants today | Economia. Retrieved 24 February 2015, from http://economia.icaew.com/opinion/october-2014/top-three-challenges-facing-accountants-today Source document

Criminology Crime And Deviance - 1705 Words

Kelsie Rumsey Brian Wolf Sociology 260: Crime and Deviance May 7, 2017 Double Jeopardy The criminal justice system isn’t perfect, much like any largescale system it has its flaws. Sadly, some of the criminal justice system flaws are bigger than others and the smaller ones don’t get any attention from the public and go unresolved. That is not to say that all the problems with the criminal justice system shouldn’t be dealt with, but some of the problems aren’t even being considered. A problem that has rocked the boat on a public scale, but has never really been questioned would be the flawed double jeopardy law. The law that protects people from double jeopardy is a difficult one to undo because it is sealed in the U.S. Constitution. The†¦show more content†¦In the book it is written, â€Å"Now picture this—and keep in mind, this is hypothetical†¦Ã¢â‚¬  (Simpson). O.J. then goes on about that night claiming he doesn’t remember the actual attack itself. He was quoted, â€Å"Now I was standing in Nicole s courtyard , in the dark, listening to the loud, rhythmic, accelerated beating of my own heart. I put my left hand to my heart and my shirt felt strangely wet. I looked down at myself. For several moments, I couldn t get my mind around what I was seeing. The whole front of me was covered in blood, but it didn t compute† (Simpson). There you have it, a hypothetical confession from a man that had committed two horrible murders but wouldn’t pay for the crime because of a flawed law. It is summed up by Vermont General Attorney, William Sorrell, â€Å"You only get one bite of the apple† (Findlaw, â€Å"Suspect confesses to murder after acquittal.†). There will be no justice for Nicole and Ron Goldman because the court can’t charge O.J. again because he was found to be not guilty the first time. The O.J. Simpson case is just a little bit of proof that the amendment needs to be changed. The confession of a criminal should be enough to send them to prison regardless i f they have been tried and found not guilty. A solution to this flawed law would be changing the law to have this exception. The process isn’t as easy as just snapping the fingers and the amendment is changed.Show MoreRelatedCrime Is a Social Construct1370 Words   |  6 PagesCrime is a social construct Discuss. This composition will look at crime and its different criminological interpretations. Crime is an umbrella word which covers a diverse range of issues and is dependant upon the theoretical stand point of the writer. Although the wordings of the explanations differ, the implications are consistent (Newburn, 2007. Doherty, 2005). Mclaughlin et al (2006) seems the most relevant for the purpose. They separate crime into three key constituent parts. These are harmRead MoreMarx and Durkheim’s Views Contributed to our Understanding of Crime and Deviance? 899 Words   |  4 PagesUnderstanding of Crime and Deviance? Karl Marx’s Marxist theory and Emile Durkheim’s functionalist theory were both significant in their own ways and therefore made a large contribution to our perception and understanding of how crime and deviance occurs and is dealt with in society. The Marxist theory on crime was focused on the concept that the huge shift towards a capitalist society was the root cause and driving force behind the formation of social divisions and subsequent increase in crime and conflictRead MoreCriminology And The Social Theory Essay1726 Words   |  7 Pagesmean the study of criminology is micro in nature because behaviour can be analysed in depth form different angles of approach. According to Sellin, criminology can include the realms of politics (such as left and right realist approaches to criminal behaviour and prevention strategies), psychology (such as biological and social theories for the onset of criminal activity), law (such as drug laws and government strategies to overcome street crimes) and sociology (such as the deviance amplification model)Read MoreEvaluate the usefulness of Marxist theory to our understanding of crime and deviance1201 Words   |  5 PagesEvaluate the usefulness of Marxist theory to our understanding of cr ime and deviance (40 marks) Synopticity - Crime Deviance sociological theory Marxist explanations of crime and deviance, like their work on other areas like the family and education, rest on an economic and structural analysis of society that sees a class struggle between the proletariat and the bourgeoisie. This struggle comprises the attempts by the proletariat to free themselves from the domination of the bourgeoisieRead MoreIp3 Crime Causation1535 Words   |  7 PagesUnit 3 Crime Causation CRJS105-1201A-03 By Erika.Esquer1 1/22/2012 American InterContinental University Online Abstract This essay will focus on sociological theories of crime and their description, the strengths and weaknesses of each; sociological control theory, strain theory, differential association theory and neutralization theory. This essay will also focus on Rajartnam who was convicted for inside trading in 2011. Introduction A different approach to criminological theory wasRead MoreBiography of Emile Durkheim1258 Words   |  6 Pages He is arguably the most influential figure in western sociology and also immensely significant in criminology. He lived until the age of 59 when he suffered a stroke after he had recovered for a sufficient amount of time he then continued with his work however he eventually died, in Paris, on November 15th, 1917. He was, and is still today, one of the many key thinkers in the field of criminology. Durkheim said himself that it was mainly influenced by the philosopher August Comte. He wrote aboutRead MoreMarxian vs. Positivism Perspectives851 Words   |  4 PagesPerspectives Crime and deviance are issues that dominate the public’s imagination; the study of which involves a number of contributing disciplines, criminology, statistics, psychology, biology to name a few but the largest contributor is sociology. There have been major changes in the way Sociologists perceive and study deviance over the years. In this essay the author will briefly compare and contrast the perspectives of Marxian and Positivism as they relate to the issues of crime and deviant behaviorRead MoreA Norm Is A Rule Of Behavior Of Individuals In Society1491 Words   |  6 Pagesanger for correcting an action that may lead to crime. Responding to a crime is way to escape from strain to seek revenge against the strain of alleviate negative emotions (â€Å"Strain theories - criminology - Oxford bibliographies - obo,† 2017). Major strains of theory describe strain’s that leads to crime, increase of crime and the factors leading to the individuals or dissuade appea ring to respond to strains of crime (â€Å"Strain theories - criminology - Oxford bibliographies - obo,† 2017). Emile DurkheimRead MoreSocial Disorganization Theory And Cultural Deviance Theory1325 Words   |  6 Pagessociological theories as it relates to the social structure, social process and the impact of social life. There is still room to compare and contrast the social structure theories that include social disorganization theory, strain theories and cultural deviance theory. The social disorganization theory was first referenced with the displacement among immigrants. Scholars believed this was due to the immigrants inability to transfer norms and values from their first homes in the old country to the new cultureRead MoreA Marxist Understanding Of Society1719 Words   |  7 Pagesconclusions on his main era that surrounded crime and law, known as the Historical Materialism era. The essay will then look at how these conclusions relate to crime. Five different the orists work, who use Marxist ideology as their main school of thought, will then be looked at. First the essay will look at Willem Bonger and explore his contributions, making note of his ability to connect the links between capitalism and a patriarchal society. Secondly ‘The New Criminology’ by Taylor, young and Walton will