$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

Guaranteed Higher Grade!

Free Quote

ACC 202 Accounting Information Systems Introduction

tag 0 Download6 Pages / 1,279 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
  • Course Code: ACC 202
  • University: Kaplan University
  • Country: United States


Learning Outcome 3: Demonstrate technical knowledge with MYOB and Excel applications. Introduction to the individual assignment: This 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. Assignment Information: The assignment consists of two 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. You can suitably embed the research report into the Excel file on a separate sheet.
You will be submitting only ONE Excel file for this assignment as an electronic assignment via the ACC 202 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. 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. . . .
_______________________________________________________________________ ACC 202 T3 2017 Excel and Case Study Page 2 QUESTION 1 (55 marks) The following employees work for Super Contracts Ltd, a public company specialising in contract labour force for different IT projects. The employees are paid an hourly rate, based on their Job Classification level. If an employee works more than 37 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: The overtime hourly rate is $ 90 per hour for ALL employees, regardless of their classification level. Simple Contracts Ltd has the following employees: TABLE B: Employee name Classification Level Paris Holton 5 Ricky Mortini 4 Jennifer Leepoz 6 Selina Geemak 2 Willard Smith 1 Russell Creak 6 Rafael Nooderly 4 Novak Djoker 1 Lara Bangle 3 Kath Hudson 6 Classification Levels Level Hourly pay 1 $ 30.00 2 $ 40.00 3 $ 50.00 4 $ 60.00 5 $ 70.00 6 $ 80.00
_______________________________________________________________________ ACC 202 T3 2017 Excel and Case Study Page 3 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 36 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. (10 marks) 21. Using Table C data and keeping employee order unchanged, set up a payroll table to calculate the total payroll for each employee.
Your main payroll table should have the following headings: Employee Name Hours worked Regular Hours Overtime Hours Hourly Pay Base Amount Overtime Total Pay a) Use the IF function and absolute referencing to calculate the Regular Hours column. b) Use a suitable formula to calculate the Overtime hours. c) Use the VLOOKUP function with reference to the range created earlier to determine the Hourly Pay for each employee. d) Use suitable formulae to calculate the Base and Overtime amount for each employee. e) Use a formula to calculate the Total Pay f) Sort the table in order of employee names. All columns must be totalled as required. (30 marks) _______________________________________________________________________
ACC 202 T3 2017 Excel and Case Study Page 4 3
a) Using another formula, identify the employee(s) that earned the maximum overtime.
b) Discuss and illustrate one more function that can be included, in a case like this, to help with decision making.
c) Using Drop down function and Vlookup, prepare a separate summary table to display, one employee at a time, as follows Employee Name Total Pay (15 marks) Q 2 [20 marks] Research 1 - 2 commonly used Business Intelligence Tools that help extract intelligence from the business data to support decision-making through modelling and analysis. 1 List and briefly illustrate at least 2 features of commonly used Business Intelligence Tools that can support decision-making. (20 marks)
Your report need be:-
? Professionally presented, in your own words. Your research should include at least 2 references, 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 : 450 ( excluding references, diagrams)
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Unique Document

Under Evaluation

Get Money
into Your Wallet

Total 6 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). ACC 202 Accounting Information Systems Introduction. Retrieved from

"ACC 202 Accounting Information Systems Introduction." My Assignment Help, 2020,

My Assignment Help (2020) ACC 202 Accounting Information Systems Introduction [Online]. Available from:
[Accessed 20 October 2020].

My Assignment Help. 'ACC 202 Accounting Information Systems Introduction' (My Assignment Help, 2020) <> accessed 20 October 2020.

My Assignment Help. ACC 202 Accounting Information Systems Introduction [Internet]. My Assignment Help. 2020 [cited 20 October 2020]. Available from:

With time, has become one of the best college essay writing services. Our all rounded services give students the confidence to overcome assignment related issues. Our services are fast enough to meet most urgent deadlines. We are capable of delivering fast essay writing services with the help of our specially designed provisions and writers' teams. Our urgent essay help services guarantee most rapid delivery of assignment solutions. Some of our most popular essay services are application essay help, exploratory essay help, literary review essay help and argumentative essay help.

Latest Accounting Samples

ACC707 Auditing, Assurance & Services

Download : 0 | Pages : 11
  • Course Code: ACC707
  • University: Kings Own Institute
  • Country: Australia

Answers: INTRODUCTION The auditing concept has gained the importance when the incident of the global financial crisis have happened which have occurred in the middle of the 2007 and has been ended in the year of 2009 but has the after effects for so many years. Earlier the auditor was not bound in any manner for the reporting of the matters that can have the significant impact on the reporting of the financial statements have now been bound w...

Read More arrow

HA 3011 Advanced Financial Accounting For Investors

Download : 0 | Pages : 9

Answer: ASSESSMENT PART A Any information contained in the financial statement helps an investor or other user in the economic decision-making process. However not every and any information can be beneficial for the users of the financial statement. There are few qualities which this financial information should possess to satisfy their purpose of helping the users (Elimam, 2017). The following are all qualitative characteristics . ...

Read More arrow

HI5020 Corporate Accounting And Cash Flows Statement

Download : 0 | Pages : 10

  Answers :- Cash Flow Statement Requirement [i]             The cash flow statements is considered as a major financial statements that depicts the major changes in the accounts of balance sheet and income that affect the cash and cash equivalent of the companies. Cash Flow from Operating Activities: In Wesfarmers, the major items under Operating Activities are receipts from the ...

Read More arrow

HI5020 Corporate Accounting 17

Download : 0 | Pages : 9

Answers: INTRODUCTION Accounting is the basis of any concern that’s running an economic activity. Accounting involves presenting information to all the stakeholders of the business concern in a manner that enables them to make decisions full of worth to them. Entities present business financials to the public through the annual reports. These reports contain all the statements that are required to be presented to public. Out of all thos...

Read More arrow

HA 3011 Advanced Financial Accounting Introduction

Download : 0 | Pages : 10

Answer: Answer A:             In order to extend the financial performance of a firm, qualitative features of an organisation is required to produce their financial statement. These are made in such a way that that it can aim the qualitative ideologies of the same so as to guide the investors in their endeavours. According to the (Chaudhry, 2015), major parts that are considered under the...

Read More arrow

Save Time & improve Grade

Just share requirement and get customized Solution.

We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here




Overall Rating



Our Amazing Features


On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.


Plagiarism Free Work

Using reliable plagiarism detection software, only provide customized 100 percent original papers.


24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.


Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.


Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

134 Order Completed

95% Response Time

Thomas Nelson

MS in Information Systems Technology with Specialization in Database Administration

New Jersey, United States

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 4/5

248 Order Completed

100% Response Time

Lloyd Bernabe

MSc in Accounting

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

755 Order Completed

95% Response Time

Douglas Cowley

Masters in Finance with Specialization in Audit

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 4/5

2594 Order Completed

95% Response Time

Michael Johnson

Masters of MSc in Economics

Washington, United States

Hire Me

FREE Tools


Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.


Essay Typer

Get different kinds of essays typed in minutes with clicks.


GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.


Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.


Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability




Your Approx Earning

Live Review

Our Mission Client Satisfaction

Thank you for your effort and for taking notes I am very satisfied and I hope I can place more orders on your site


User Id: 522617 - 19 Oct 2020


student rating student rating student rating student rating student rating

Thank you again, it is done. good work, excellent job. eve thing it is perfect thank you!


User Id: 265909 - 19 Oct 2020


student rating student rating student rating student rating student rating

good work it was clear and self-explanatory, a good format I have a Bplus, thanks


User Id: 491037 - 19 Oct 2020


student rating student rating student rating student rating student rating

fantastic work, it was ready on time, good references and good format, they followed all the instructions, thanks


User Id: 491037 - 19 Oct 2020


student rating student rating student rating student rating student rating
callback request mobile
Have any Query?