Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
Question:
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)
Answer:
Classification Levels                
Level Hourly Pay                
1 30                
2 40                
3 50                
4 60                
5 70                
6 80                
                   
                   
Employee Name Classification Level Hourly Pay              
                   
Paris Holton 5 70              
Ricky Mortini 4 60              
Jennifer Leepoz 6 80              
Selina Geemak 2 40              
Willard Smith 1 30              
Russell Creak 6 80              
Rafael Nooderly 4 60              
Novak Djoker 1 30              
Lara Bangle 3 50              
Kath Hudson 6 80              
                   
Employee Name Hours worked Regular Hours Overtime Hours Hourly Pay Base Amount Over-Time Total Pay    
                   
Selina Geemak 30 30 0 40 1200 0 1200    
Russell Creak 34 34 0 80 2720 0 2720    
Ricky Mortini 52 30 22 60 1800 1980 3780    
Rafael Nooderly 44 30 14 60 1800 1260 3060    
Paris Holton 45 30 15 70 2100 1350 3450    
Novak Djoker 37 36 1 30 1080 90 1170    
Lara Bangle 40 30 10 50 1500 900 2400    
Kath Hudson 52 30 22 80 2400 1980 4380    
Jennifer Leepoz 36 30 6 80 2400 540 2940    
Willard Smith 39 30 9 30 900 810 1710    
                   
Total 409 310 99 580 17900 8910 26810    
                   
3.b:                  
                   
Employee Name Total Pay                
Ricky Mortini 3780                
                   
                   
                   
                   
                   
                   
Classification Level Employee Name                
                   
Row Labels Sum of Over-Time              
Kath Hudson 1980                
Ricky Mortini 1980                
Grand Total 3960                
                   
                   
Employees at Level 4 and Above:              
                   
  Values                
Row Labels Sum of Hourly Pay Sum of Total Pay            
Jennifer Leepoz 80 2940              
Kath Hudson 80 4380              
Paris Holton 70 3450              
Rafael Nooderly 60 3060              
Ricky Mortini 60 3780              
Russell Creak 80 2720              
Grand Total 430 20330              
                   
                   
 Growth of business intelligence in past decades:        
Invention of business intelligence was done in early 1990s and there was evolvement over the past decades. The importance of self service in the concept of business intelligence (BI) has been identified resulting from its dramatic shift. There has been constant rise in revenue generated from the implementation of business intelligence along with the growth of tools of BI. It is expected that there will be further growth in this BI field. BI growth in terms of services offered by the adoption of technologies has resulted in its explosive growth over the years (Simkin et al. 2014).   
Adoption of BI tools has been accelerated due to factors such as large amount of data acquisitions and falling costs. Many organizations implement the BI technology in their production and service departments (Tazik and Mohamed 2014). Manufacturing, retain and financial service providers make use of BI tools for functions such as ordering shipment, claim analysis, detection of fraud and targeting of grocery coupons.  
It is illustrated from the present statistical data that there is a worldwide generation of revenue of $ 23.1 billion by the implementation of BI tools. BI can be defined as collection of software programs and application technologies that helps in effective and efficient performance of decision makers. Application of BI tools has led to enhancement of business decision making along with increase in demand of such tools globally. BI is a tool that strategically plans the prices of organization. BI is regarded as strategy of applying software that assist in implementing companies’ project plans.  
                   
Business tools commonly used and their characteristics:      
Tools of business intelligence are software that have been designed to perform the analysis, retracement and reporting of data. Effective management and easy access of data for enterprises of varied sizes are done by using tools of BI. Emergence of BI tool helps in further enhancement of business decisions by providing user friendly interface and improved analysis of data. The two common BI tools are as follows:      
Oracle Hyperion system- A centralized planning; forecasting and budgeting solutions are offered by this particular tool that integrates financial and operational planning process. The predictive capability of business is improved by the application of BI. Some of the benefits attributable to this tool involve cost ownership reduction, data integration and enhancing organization’s transparency. It helps in conducting an in depth analysis of key performance and operational indicators (Zhou 2015).      
SAP Business Intelligence- The main focus of this tool of BI is to make the analysis and provide assistance in decision making. It is regarded as an efficient tool because it has the capacity of accessing multiple sources of data using single pace and single access point (Prasad and Green 2015). It helps in efficient analysis of data at higher level because of its ability of collection several data and compiling it in the report form. Capability of performing the analysis of multidimensional sources of data is one of the key functionalities of this tool.      
                   
References list:                
Prasad, A. and Green, P., 2015. Organizational competencies and dynamic accounting information system capability: impact on AIS processes and firm performance. Journal of Information Systems, 29(3), pp.123-149.
Simkin, M.G., Norman, C.S. and Rose, J.M., 2014. Core concepts of accounting information systems. John Wiley & Sons.
Tazik, H. and Mohamed, Z.M., 2014, February. Accounting information system effectiveness, foreign ownership and timeliness of corporate financial report. In 5th Asia-Pacific Business Research Conference (pp. 17-18).
Zhou, Y., 2015. Research on the System for Government Accounting Information Quality Based on Information Transparency. Journal of Accounting and Economics, 3, p.001.
                   
Cite This Work

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

My Assignment Help. (2020). Demonstrate Technical Knowledge With MYOB And Excel Applications. Retrieved from https://myassignmenthelp.com/free-samples/acc-202-accounting-information-systems-introduction.

"Demonstrate Technical Knowledge With MYOB And Excel Applications." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/acc-202-accounting-information-systems-introduction.

My Assignment Help (2020) Demonstrate Technical Knowledge With MYOB And Excel Applications [Online]. Available from: https://myassignmenthelp.com/free-samples/acc-202-accounting-information-systems-introduction
[Accessed 25 July 2024].

My Assignment Help. 'Demonstrate Technical Knowledge With MYOB And Excel Applications' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/acc-202-accounting-information-systems-introduction> accessed 25 July 2024.

My Assignment Help. Demonstrate Technical Knowledge With MYOB And Excel Applications [Internet]. My Assignment Help. 2020 [cited 25 July 2024]. Available from: https://myassignmenthelp.com/free-samples/acc-202-accounting-information-systems-introduction.

Get instant help from 5000+ experts for
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing: Proofread your work by experts and improve grade at Lowest cost

loader
250 words
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Plagiarism checker
Verify originality of an essay
essay
Generate unique essays in a jiffy
Plagiarism checker
Cite sources with ease
support
Whatsapp
callback
sales
sales chat
Whatsapp
callback
sales chat
close