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

Error goes here

CISM4000 Accounting Information Systems

tag 0 Download5 Pages / 1,048 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

The following employees work for Simple 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:
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 

_______________________________________________________________________
CISM 4000 T1 2018 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)

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
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 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 and Total pay for
each employee.
e) Sort the table in order of employee names. All columns must be totalled as required.
f) Ensure that your work is professionally presented, with suitable borders and labels
 (30 marks)

_______________________________________________________________________
CISM 4000 T1 2018 Excel and Case Study Page 4
3 a) Using another formula, identify the employee(s) that earned maximum overtime.
b) Using Drop down function and Vlookup, prepare a separate summary table to
display, one employee at a time, as follows
Employee Name Overtime Earned
 (10 marks)
4 Discuss, justify and illustrate two more functions that can be included, in a case like this,
to help with decision making.
 (10 marks)
Q 2 (40 marks)

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 decade. You can use graphs, tables,
success stories, as you deem fit, to present your cases.
 (20 marks)
2 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 3
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 : 1000 ( excluding references, diagrams)

Cite This Work

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

My Assignment Help. (2020). Accounting Information Systems. Retrieved from https://myassignmenthelp.com/free-samples/cism4000-accounting-information-systems/sales-performance.html.

My Assignment Help (2020) Accounting Information Systems [Online]. Available from: https://myassignmenthelp.com/free-samples/cism4000-accounting-information-systems/sales-performance.html
[Accessed 01 August 2021].

My Assignment Help. 'Accounting Information Systems' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/cism4000-accounting-information-systems/sales-performance.html> accessed 01 August 2021.

My Assignment Help. Accounting Information Systems [Internet]. My Assignment Help. 2020 [cited 01 August 2021]. Available from: https://myassignmenthelp.com/free-samples/cism4000-accounting-information-systems/sales-performance.html.


MyAssignmenthelp.com has become one of the leading assignment help provider in New York City and Boston. We provide top class auditing assignment help. Not only auditing, but we also cover more than 100 subjects and our writers deal with all types of assignments with utmost expertise. To make writing process faster and accurate, we have segmented our assignment experts' teams as per their expertise on writing different types of assignments. We guaranteed that students who buy our assignment online get solutions worth their investment.

Latest Accounting Samples

ACC3AFA Advanced Financial Accounting

Download : 0 | Pages : 3

Answer: Background Of Business Description of business Shine café will be built upon the success stories of various Australian casual dining and coffeehouses venues. The Café will have its store near the Hyde Park Sydney and will provide accessible and affordable coffee and burgers, especially chicken avocado sandwich and southern burgers. The Café aims to establish itself as a ‘destination’ of choice to many...

Read More arrow

ACCG924 Taxation Law

Download : 0 | Pages : 3

Answers: Part A. As on 21st July 2013, the equipment cost included Good and Service Tax (GST) worth $44,000. The GST is calculated as 10% of the purchase amount of the equipment. (i.e. $44,000/110*100 = $40,000). Therefore, the GST amounted to $44,000 - $40,000 = $4,000. This implies that $4,000 input tax credit is claimable in this case (Australian Taxation Office, 2015). Hereunder, is a detailed working of the capital allowance on the ...

Read More arrow Tags: Australia Marsfield Management Business Administration University of Sydney MBA 

BU5571 Management Accounting

Download : 1 | Pages : 10

Answer Introduction  This study deals with the concept on management accounting and explains the nature, source as well as purpose of management information in a business context (Suomala, Yrjänäinen and Lukka 2014). Addition to that, Management accounting refers to a function that is used for tracking the interior cost for any trade procedure and helps an association, firm that gets related with the production, operations as wel...

Read More arrow Tags: United Kingdom London Management Business Management Information University of London MBA 

ACCT20074 Contemporary Accounting Theory

Download : 1 | Pages : 10

Answer True and Fair View Introduction Financial reporting is the process whereby all relevant business financial and accounting information is openly availed to the public. Members of the public are therefore should be free to scrutinize the information. At the same time, the manager is expected to have provided the true and accurate accounts and information in the availed records. Financial and accounting records are not meant for the stak...

Read More arrow

ACCT3303 Cost Accounting Principles

Download : 0 | Pages : 9

Answer: This report presents the user about the comparison of two companies which are ford motors and General Motors on the basis of various financial data and the figures. For this report, various financial tools have been used. Ford motors: Ford Motors Company is an American company which is operating its business into international market. Headquarter of the company is in Dearborn, Michigan. This company has been founded in June, 1903. Th...

Read More arrow
Next

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?