Information Systems in Accounting Report

Your Task

You are required to assist the proprietors of a small business by preparing appropriate reports that will support the evaluation of data.

Assessment Description

This assessment requires an Excel data file (provided) and case study background (provided). All requirements are to be completed by adding to and adapting the Excel data file.

Assessment Instructions

• You are required to access supplied data sets (provided in a single Excel file) and complete the assigned tasks by adding additional worksheets to the

• The updated workbook, including additional worksheets containing your reports, summary notes and evaluation, is to be uploaded via Turnitin

1. Prepare appropriate reports that will support the evaluation of data in Phase (10 marks)

There are many reports that may be produced from the data provided. You are to select reports that will help address the proprietor's concerns.

Some reports that may support your evaluation could include:

• For each location, number of jobs completed and total revenue
• A periodic summary (weekly/monthly/quarterly) of jobs completed and total revenue
• Identification of customers with repeat business
• Identification of queries that didn't result in a sale

The reports are to be produced in a single additional Worksheet labelled Phase 1 reports

1. For one of your reports, outline the steps taken to select, prepare and format the (3 marks)

This should be presented in dot point format.

This is to be completed by adding an additional Worksheet labelled Phase 1 report process

1. Prepare a brief written summary of your evaluation of the data in Phase (7 marks)

Each of the reports that you have prepared should be used as the basis for an expanded summary note including:

• A statement explaining the information in your report (i.e., numerical)
• Why the information is important to the business
• A description and explanation of a suggested improvement to the data collected (may relate to inputs, processes, or outputs)

This is to be completed by adding an additional Worksheet labelled Phase 1 evaluation summary

2. Prepare appropriate reports that will support the evaluation of data in Phase (10 marks)

With additional data provided, you are to select reports that will help address the proprietor's concerns. Some reports that may support your evaluation could include:

• Reports suggested for Phase 1
• Payroll variances or discrepancies
• Jobs completed and hours worked by staff members
• Service and customer mix (e.g., Standard v Premium; Private v Business)

1. For one of your reports (that is different from reports produced for Phase 1), outline the steps taken to select, prepare and format the (3 marks)

This should be brief and presented in dot point format.

2. Prepare a brief written summary of your evaluation of the data in Phase (7 marks)

Each of the reports that you have prepared should be used as the basis for an expanded summary note including:

• A statement explaining the information in your report (i.e., numerical)
• Why the information is important to the business
• A description and explanation of a suggested improvement to the data collected (may relate to inputs, processes, or outputs)

Academic Integrity Policy

KBS values academic integrity. All students must understand the meaning and consequences of cheating, plagiarism and other academic offences under the Academic Integrity and Conduct Policy.

What is academic integrity and misconduct? What are the penalties for academic misconduct? What are the late penalties?

How can I appeal my grade?

This Accounting and Finance Assignment has been solved by our Accounting and Finance Expert at Exam Question Bank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Styles. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. Theres one thing to be noticed you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.