Reference no: EM132365430

Accounting Information Systems Assignment

Spreadsheet and Case Study Report

Your Task

The Assignment consists of these questions:

1. Students are to formulate possible solutions in practical scenarios using appropriate software like Excel, with a range of formulae and functions for basic income, expense and profitability analysis.

2. A brief Research Report to explore the impact that emerging technologies like Business Intelligence, Cloud Computing can have on accounting and business decisions.

3. A brief Research Report outlining the steps taken by a selected organization to promote business ethics

Assessment Description

• Learning Outcome 5: Demonstrate data analysis, data manipulation and information presentation skills through the use of a commercially available spreadsheet package.
• This individual assignment must be completed using Microsoft Excel. These introductory excel skills you learn will be used in later units and in your professional life. Employers expect students to have good worksheet skills

Assessment Instructions

• The assignment is to be submitted electronically via the CISM 4000 T 2 2019 subject page on the student portal. Instructions are on the front page of the portal. Ensure that your work can be clearly identified with your student ID and FULL student name.
• 2 separate submissions are required
o One Excel Spreadsheet
o One Research Report
• Late penalties will apply for all late submissions.
• Any work which has been copied or shared between students will result in a Fail grade. This assignment must be your own work.

QUESTION 1 Excel Case

The following employees work for Hi-Tech Contracts Ltd, a public company specialising in contract labour force for different projects in construction industry. The employees are paid an hourly rate, based on their Job Classification level. If an employee works more than 35 hours, they will be paid the overtime rate for the additional hours.

The following table summarises the classifications and level of pay per classification:

TABLE A:

Classification Levels
Level	Hourly pay
1	30.00
2	40.00
3	50.00
4	60.00
5	65.00
6	75.00

The overtime hourly rate is $ 85 per hour for ALL employees, regardless of their classification level. Hi-Tech Contracts Ltd has the following employees:

TABLE B:

Employee name	Classification Level
Paris Holton	5
Ricky Mortini	4
Jennifer Leepoz	2
Selina Geemak	2
Willard Smith	1
Russell Creak	6
Rafael Nooderly	4
Novak Djoker	1
Lara Bangle	3
Kath Hudson	6

The hours worked for the week ended 30th June, 2017 are as follows:

TABLE C:

Employee name	Hours worked
Novak Djoker	37
Willard Smith	39
Lara Bangle	40
Kath Hudson	52
Selina Geemak	30
Paris Holton	45
Russell Creak	34
Jennifer Leepoz	41
Ricky Mortini	52
Rafael Nooderly	44

REQUIRED: One worksheet must be used to provide answers to this question.

• No marks will be awarded if the correct function or formula is not used or if data has been manually entered.
• Take care regarding professional presentation of your work at every step. All dollar amounts must be provided in currency format and 2 decimal places.

1

a) Copy Table A into your worksheet. Set up a ‘range' for the data. Name the range ‘classification level'

b) Copy Table B to the same worksheet.
• Add a third column titled ‘hourly pay'. Use the VLOOKUP function to pick up the correct hourly pay rate for each employee from the ‘classification level' range set up above.
• Create a ‘range' for the data in these 3 columns. Name the range ‘pay rate table'. This range will be used in a question below.

2 Using Table C data and keeping employee order unchanged, set up a payroll table to calculate e total payroll for each employee. Your main payroll table should have the following headings:

Employee Hours Regular Overtime Hourly Base Over- Total Name worked Hours Hours Pay Amount time Pay

a) Use the IF function and absolute referencing to calculate the Regular Hours column. Use a formula to calculate the Overtime hours.
b) Use the VLOOKUP function with reference to the range created earlier to determine the Hourly Pay for each employee.
c) Use suitable formulae to calculate the Base and Overtime amount and Total pay for each employee.
d) Sort the table in order of employee names. All columns must be totaled as required.
e) Using another formula, identify the employee(s) that earned maximum overtime
f) Ensure that your work is professionally presented, with suitable formatting, borders and labels.

3 Discuss, justify and illustrate two more functions that can be included, in a case like this, to help with decision making regarding (Choose any 2 points)
• Customers who are likely to default
• Employees who are putting in long hours
• Items that are providing outstanding returns
• A model to forecast demand for the next quarter.

You can use any sample data for the purpose of illustration.

QUESTION 2 Business Intelligence Case

Making better decisions, improving operational efficiencies, growing revenues and increased competitive advantage are the top four Business Intelligence objectives organizations have today (Forbes, 2018).

Research 2 commonly used Business Intelligence Tools that help extract intelligence from the business data to support decision-making through modelling and analysis.

1 Describe the growth of Business Intelligence in the past few decades. You can use graphs, tables, success stories, as you deem fit, to present your case.

2 List and briefly illustrate at least 2 features of commonly used Business Intelligence Tools that can support decision-making.

QUESTION 3 Business Ethics Case

Ethics is central to the study of all business disciplines, including accounting - as also discussed in the prescribed text book Accounting Information System 2016 by Considine B. et al. All types of business (including not-for-profit) and government entities need to consider the ethical implications of their actions. Businesses and governments have control of the world's resources, and managers make decisions every day that affect those resources and the lives of millions of people. It is important that those who operate in the business world have an understanding of ethical theories and philosophies to help guide their decision making.

It seems that, despite technological advances in business and communications, ethics is still a fundamental issue to be explored and debated. In fact, due to the business world becoming more globally focused and the community becoming more educated and aware, the subject of ethics and, in particular, business ethics, is gaining increasing attention. The changes in people's value systems over the past few hundred years have meant that old rules and expectations (e.g. how we deal with corporate governance, the environment or each other) cannot be relied upon to seek solutions; instead, thoughtful, reasoned consideration needs to be given to the facts at hand in each circumstance.

Select a case of reported and recorded breach of Code of Conduct or Business Ethics.

Prepare a brief report outlining:
- the nature of breach of Code of Conduct or Business Ethics, outlining the issues involved.
- changes introduced in the recent years in the organisations to mitigate the risk.

Few points regarding your report: -
• It should be professionally presented, in your own words. It's helpful to include diagrams and tables, as appropriate, to highlight your key points.
• Your research should include at least 2 references for each of Q 2 and 3, such as the professional body articles as well as text books and peer reviewed academic journals. Vendor websites are not appropriate sources of information for this task. Use appropriate referencing in your report.
• Word limit for Q 2 and 3: 750 each (excluding references, diagrams)

Financial Accounting and Reporting Assignment

Assessment Description

Learning Outcome 4: Develop information gathering (research) and communication strategies to enable the provision of professional advice to a client.

Objective: The objective of this assignment is to learn to effectively research a technical aspect of accounting and communicate professional advice to a client, via a business letter.

Background to the case study:

Assume that you are a graduate accountant working for McKenzie and Associates a public accounting firm situated at 668 George Street, Melbourne, VIC 3000. The manager of your firm, Ms Maria McKenzie has asked you to draft a letter in response to an email received from a client - Mr Con Pewter, the Managing Director of Pewter Ltd, raising a key accounting issue regarding his company - see the copy of the email at the end of this document. The maximum length of the letter is 1.5 pages. You should address all the technical issues/discussion after the letter on separate pages.

• Part A: Technical component - This mark covers the technical content of your advice and the explanation on each of the issues, the calculations and the sources used.

• Part B: Communication Skills - Letter Writing - This mark covers the generic skills of business letter writing; layout, clear meaning, structure and organisation, appropriate tone and grammar, spelling and punctuation etc.

• Part C: Communication Skills - Presentation - The individually presented 5 minute video presentation will need to keep the audience engaged, containing only the student's advice; the presentation should be well-rehearsed and all supplementary material, such as slides and visual aids must be of a professional standard.

The assignment is designed to test the following skills:

1. Your knowledge and your ability to research the issues and then apply the information appropriately using judgement to correctly identify the relevant standards and legislation that relate to the issues raised by the client.
2. Your written communication skills - business letter writing.

Please note: Any work which has been copied or shared between students will result in a Fail grade for both students concerned. Therefore, please make sure that the answer to this individual assignment is your work and not copied or bought from any source. In completing this assignment make sure you follow the guidelines for assignments especially those relating to the presentation of written work, late assignment policy and academic integrity.

Attachment:- Accounting Information Systems.rar