CISM4000 - Information Systems in Accounting Assignment

Assignment Task

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

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.

Phase

a) Prepare appropriate reports that will support the evaluation of data in Phase 1.

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

b) For one of your reports, outline the steps taken to select, prepare and format the report. This should be presented in dot point format. This is to be completed by adding an additional Worksheet labelled Phase 1 – report process.

c) Prepare a brief written summary of your evaluation of the data in Phase 1.

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 CISM4000 – Accounting and Finance has been solved by our PHD Experts at My Uni Paper.