ACCT6001-Accounting Information Systems Report Writing - Accounting & Finance Assignment Help

Assignment Task

Task 

Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include:
(a) Apply technical knowledge and skills in creating information for the workplace using spreadsheets and relational databases.
(b) Communicate with IT professionals, stakeholders and user groups of information systems. 

Context
The spreadsheet is a powerful tool that has become entrenched in business processes worldwide. A working knowledge of Excel is a crucial skill for accountants. This assignment aims to assess the client’s ability to create spreadsheets. Clients will be using raw data and summarising them in a user-friendly format to aid decision making. Clients will need to recommend additional excel-based analysis that facilitates business decision making. 

Task Instructions
A large accounting software support business has recently launched an online customer support service called Terrens. The business provides online education services to clients from around the world. In an effort to improve the services offered to clients, a job management system was developed to improve the responses provided to client queries. At the end of every week, a manager from the Support team archives an excel file that contains data about client queries for that week. The manager of the Support team believes that the data within this spreadsheet would be valuable for business decision making. However, employees within the team lack the technical knowledge to analyse and interpret this data. Subsequently, the manager is unsure how to utilise this data to gain insights on how to improve response times and outcomes for clients.
The Support team manager decided to hire you to assist in analysing and interpreting the data. The table below shows a data file that was archived containing information on client queries for one week.

While only a small number of queries were received from clients in the first week of the month, client queries are expected to go up over the remainder of the month. However, before getting actual data from the job management system in the coming weeks, Terrens business has asked you to explore the possible analyses that can be performed if using the current output. Terrens provided you with a document listing specific instructions on what you are expected to do in Excel. The instructions are listed below.

Requirements
(1) Open an Excel Workbook and name it as ‘Client ID_ Client Name_ ACCT6001 Assessment 3’ (i.e. 0009989t_Adam Smith_ACCT6001 Assessment 3). Create a worksheet labelled as ‘Job Data’. Make a table similar to the one above using hypothetical details for 50 clients. The table should include the following columns: Job Code, Client ID, Client Name, Date Opened, Date Closed, Job Type, Job Priority, Job Status.

In your hypothetical data, assume:
a) at least 20 jobs with a job status of “Closed”
b) only 10 jobs with a job status of “Re Process”
c) at least one of each Job Status is included in the data set for each Job Type. For example, 
include at least:
? “open”, “in process”, “re process”, and “closed” entries for “Development”,
? “open”, “in process”, “re process”, and “closed” entries for “Training”, and
? “open”, “in process”, “re process”, and “closed” entries for “Support”
d) All queries are made between 01/09/2021 and 28/09/2021.
e) Each client has no more than one job in the job management system for each Job Type (for example, a maximum of three jobs were lodged by “Icare Ltd” in Table 1).

(2) In the ‘Job Data’ worksheet, add a column labelled as ‘Time taken to close job. This column should show the time spent resolving each job (e.g. client query). The values for this column should be reported using the “number” format and calculated using a: 

a) combination of the date opened and date closed columns.
b) formula that only includes entries with a “Job Status” equal to “Closed”. 

(3) Create a new worksheet in your workbook and label it as ‘Job Duration’. In this worksheet:
a) Report the descriptive statistics (i.e. mean, median, maximum, minimum) for both the “Time taken to close job” column added to the ‘Job Data’ worksheet and the “Hours Charged” column. A brief commentary on the results should be provided.

b) Include another table in this worksheet showing for each week the:

•  Total number of jobs,
•  Total number of jobs “Closed”,
•  Total number of “Important” jobs “Open”, and
•  Average time taken to close “Important” jobs.

The values for each week should be calculated using Excel formulas based on values from the ‘Job Data’ worksheet (e.g. the values in your table should change if values in the ‘Job data’ table change). The table may look like Table 2. 

The Support team believe that the problem with Key Performance Indicators focused on the number of jobs closed each week was that “important” jobs were not being prioritised. Do you find support for this belief? Use a chart(s) to report the results for correlation to support your answer.

(4) Create a worksheet labelled as ‘Job Type’. Include a table in this worksheet showing the number of jobs for each week grouped by the three different job types. The values should be directly linked to the ‘Job Data’ worksheet. The table may look like Table 3. 

(5) Create a worksheet and label it as ‘Pivot Tables and Charts’. Build tables and charts that show the average Job Duration by Job Type and Job Priority. Provide these by creating 2 pivot tables/charts (one for each Job Type and Job Priority). Place both of these tables and charts on the same worksheet. A sample for output of Job Duration by Job Type is shown in Figure 1.  

For each table/chart, comment on whether you think the business would be able to introduce a policy of no more than 2 working days (48 hours) to resolve clients queries. 

(6) Of the employees directly responsible for resolving client queries, the business currently has 3 contract-employees working in the Support team, 2 in the Training team, and 1 in the Development team. Contract employees from the Support team charge the business $40 per hour, Training team employees charge $80 per hour and Development team $120 per hour. The Support team manager, who receives a salary of $72,000 per annum, asked you about using data from the job management system to develop a monthly budget. The following information was gathered for you to use in developing this budget.

1. “Hours charged” for “Support” jobs are invoiced by the Support team 80% of the time and the remaining 20% of the “Hours charged” are not able to
be invoiced.

2. “Hours charged” for “Development” jobs are invoiced by the Development team 60% of the time while the remaining 40% of the “Hours charged” are
not able to be invoiced.

3. “Hours charged” for “Training” jobs are invoiced by the Training team 70% of the time while the remaining 30% of the “Hours charged” are not able to be invoiced.

Create a ‘Budget Summary Report’ worksheet. Include a table with a column for the Team, Estimated hours, Total Costs charged and Total Costs not charged. The values for the estimated hours charged column should be linked to the ‘Job Data’ worksheet. Use appropriate functions to fill out the remaining cells of the table. A sample table is shown in Table 5. 

Each client pays a fixed monthly fee for unlimited Support services and an hourly rate for services performance by the Development and Training teams. Provide advice on appropriate prices to charge for each service (job type) provided by the teams and suggest strategies to improve business performance.

(7) Create a worksheet labelled as ‘Analysis and Recommendation’. This worksheet should contain the following three sections.

a. Findings – Briefly summarise your findings based on the analysis performed in requirement 2 to requirement 6.
b. Recommendation for additional analysis – In this section, you should comment on whether additional analyses can be performed using the types of data that the Support team manager currently receives from the job management system. You should provide one example of an additional analyses that can be performed using the given data and explain how to perform the analysis. Comment on how the additional analysis would help the Support team manager to make business decisions.

c. Recommendation for additional data – Currently there is an option for the Support manager to get other types of data from the job management system. Provide one practical example of an additional type of data that should be collected about client queries (e.g. jobs). Suggest the type of analysis that can be done using the additional data. Comment on how the analysis on additional data would help the Support team improve business decision making. 

This ACCT6001-Accounting & Finance Assignment has been solved by our Accounting & Finance Expert at My Uni Paper. 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 Style. 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. There’s one thing to be noticed that 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.