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

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

5 Pages
Management

Companies are continuously changing the composition of their assets and liabilities. Assets such as inventories are acquired on a regular basis while plant and equipment is acquitted less often. In ot ...

Type

Assignment

Subject

Accounting

8 Pages
Accounting

Question 1A ‘Profession’ or a ‘Trade’ Are accountancy and the accounting profession helped or hindered by the now existing (and increasing) voluminous number of regulatory stat ...

Type

Home Work

Subject

Accounting

2 Pages
Business Management

Identification and discussion of the theory and concepts relevant to the selected article Analysis and demonstrated level of understanding of key issues and theory presented in the article Identificat ...

Type

Assignment

Subject

Accounting

41 Pages
ACCT20080 Ethics and Governance

Question: Case Study: A difficult client The following short story analyses the thoughts and actions of three people during one episode at a fictional public accounting firm. Fiona Willis Fiona ...

Course

ACCT20080

Type

Assignment

Subject

Accounting

University

Central Queensland University

CISM4000 Accounting Information Systems

Question

Answered

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

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.

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.

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:

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.

CISM4000 Accounting Information Systems

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

14 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com strives to provide best quality assignment writing services to students in USA. With a pool of 3000+ assignment experts, we are capable of offering premium quality assignment writing help in 100+ subjects. Our talented and hardworking assignment writers are capable of understanding individual needs and provide custom University assignment help on students demands.

More CISM4000 CISM4000 Accounting Information Systems: Questions & Answers

Q

Management

Companies are continuously changing the composition of their assets and liabilities. Assets such as inventories are acquired on a regular basis while plant and equipment is acquitted less often. In other circumstances groups or bundles of assets or net assets are acquired. In order for AASB 3 to be ...

View Answer
Q

Accounting

Question 1A ‘Profession’ or a ‘Trade’ Are accountancy and the accounting profession helped or hindered by the now existing (and increasing) voluminous number of regulatory statutes and accounting standards?Question 2.Here are the top 12 things bad auditors do:1.   & ...

View Answer
Q

Business Management

Identification and discussion of the theory and concepts relevant to the selected article Analysis and demonstrated level of understanding of key issues and theory presented in the article Identification and analysis of strengths and weaknesses of the article leading to conclusive identification of ...

View Answer
Q
icon

We aren't endorsed by this University

ACCT20080 Ethics and Governance

Question: Case Study: A difficult client The following short story analyses the thoughts and actions of three people during one episode at a fictional public accounting firm. Fiona Willis Fiona Willis had a lot happening in her life right now, and she didn't really need an angry client on the ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

student rating student rating student rating student rating student rating
Steve Fernandez

Management Magician

1411 - Completed Orders

Hire Me
student rating student rating student rating student rating student rating
Dahron Blair

Reliable networking expert

1455 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Justin Meredith

Master of Healthcare Management

2327 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Kerry Ryan

MBA with specialization in Operations

219 - Completed Orders

Hire Me

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
27 Jan 2022

Psychology

Home Work: 2 Pages, Deadline: 1 day

This is a really good service, It is rare to have them miss the assignment. I always come back with at least an 85

flag User ID: 4***21 Charlotte, United States

student rating student rating student rating student rating student rating
27 Jan 2022

Psychology

Assignment: 1 Page, Deadline: 1 day

This is a really good service, It is rare to have them miss the assignment. I always come back with at lease an 85

flag User ID: 4***21 Charlotte, United States

student rating student rating student rating student rating student rating
27 Jan 2022

Maths

Assignment: 2 Pages, Deadline: 4 days

helped me so much when I was at a time crunch, and they really pulled through for me

flag User ID: 5***12 Charlotte, United States

student rating student rating student rating student rating student rating
26 Jan 2022

Statistics

Assignment: 5 Pages, Deadline: 12 days

Great service and perfect work and fast feedbacks as well i have no doubt in the work

flag User ID: 2***25 Khobar, Saudi Arabia

student rating student rating student rating student rating student rating
26 Jan 2022

Marketing

Assignment: 1 Page, Deadline: 6 days

Got help from this expert for this assignment. I got an A and was very pleased with the help and grade. Will use again.

flag User ID: 5***56 San Francisco, United States

student rating student rating student rating student rating student rating
26 Jan 2022

Property Law

Assignment: 12 Pages, Deadline: 12 days

Just received very good marks. Very happy with his service. Answer all questions nicely and all require points are included and good eassy writing sty ...

flag User ID: 6***34 San Francisco, Singapore

student rating student rating student rating student rating student rating
26 Jan 2022

Project Management

Assignment: 6 Pages, Deadline: 1 day

I got my assignment delivered before the deadline, and it was an excellent job done.

flag User ID: 8***21 San Francisco, Nigeria

student rating student rating student rating student rating student rating
26 Jan 2022

Healthcare

Assignment: 0 Pages, Deadline: 22 hours

great work and need more concise and explanation, provide feedback as soon as possible

flag User ID: 8***48 San Francisco, Saudi Arabia

student rating student rating student rating student rating student rating
26 Jan 2022

Management

Essay: 4 Pages, Deadline: 2 days

I was impressed with the adjustment made to the report to suit the APA 7 edition style with citations for all answers.

flag User ID: 8***17 San Francisco, United States

student rating student rating student rating student rating student rating
26 Jan 2022

Marketing

Assignment: 8 Pages, Deadline: 21 days

Thank you once again excellent paper, will use service again, extremely efficient understood the requirements.

flag User ID: 7***88 Melbourne, Australia

student rating student rating student rating student rating student rating
26 Jan 2022

Economics

Course Work: 4 Pages, Deadline: 6 days

Thank you for the constant support and understanding and work towards my project

flag User ID: 8***56 Melbourne, Canada

student rating student rating student rating student rating student rating
26 Jan 2022

English

Essay: 8 Pages, Deadline: 10 days

the expert who worked on this assignment did a great job of following all the instruction I provided for this assignment and delivered it perfectly. G ...

flag User ID: 3***04 Melbourne, Bahrain

student rating student rating student rating student rating student rating
25 Jan 2022

Finance

Programming: 2 Pages, Deadline: 23 hours

Good not bad. But if the solution with more analysis and explanation will be great

flag User ID: 8***49 Melbourne, Saudi Arabia

student rating student rating student rating student rating student rating
25 Jan 2022

Management

Assignment: 6 Pages, Deadline: 5 days

Perfect work was delivered by the expert, I have been using my assignment help for quite some time now and it has been very helpful in providing excel ...

flag User ID: 8***14 Mississauga, Canada

student rating student rating student rating student rating student rating
25 Jan 2022

Chemistry

Assignment: 1 Page, Deadline: 5 days

Assignment was completed as requested! Was very organized and neat. Included all the parts!

flag User ID: 2***50 Kitchener, Canada

student rating student rating student rating student rating student rating
25 Jan 2022

Psychology

Assignment: 4 Pages, Deadline: 1 day

It was a good one thank you. I did have to correct some of the mistakes. After that, everything was good.

flag User ID: 6***66 Kitchener, United States

student rating student rating student rating student rating student rating
25 Jan 2022

Statistics

Programming: 2.6 Pages, Deadline: 7 days

Fully trust this service with perfect score. Would recommend to friends and family. Keep up the good work. Will definitely use the service.

flag User ID: 6***65 Hughesdale, Australia

student rating student rating student rating student rating student rating
25 Jan 2022

Management

Essay: 6 Pages, Deadline: 2 days

Perfect score. Great results and the marks was as expected. I trust this service fully with all my assessments.

flag User ID: 6***65 Hughesdale, Australia

student rating student rating student rating student rating student rating
25 Jan 2022

Criminal Law

Thesis: 8 Pages, Deadline: 4 days

Great results and the marks was as expected. I trust this service fully with all my assessments.

flag User ID: 6***65 Hughesdale, Australia

student rating student rating student rating student rating student rating
25 Jan 2022

Nursing

Home Work: 1 Page, Deadline: 12 hours

Satisfied with the assignment solution. All is correct, no amendment needed.Thanks

flag User ID: 6***60 Hughesdale, United States

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?