CISM4000 Information Systems in Accounting Report Sample

CISM4000 Information Systems in Accounting

Assignment Task

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

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 workbook. Your adapted file is to be uploaded to myKBS. Your report, including summary notes and evaluation, is to be uploaded via Turnitin.

Detailed instructions:

PHASE 1

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. This is to be completed in Excel.

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.

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:

o A statement explaining the information in your report (i.e., numerical)

o Why the information is important to the business

o A description and explanation of a suggested improvement to the data collected (may relate to inputs, processes, or outputs)

Parts b & c are to be completed in Word or PDF.

PHASE 2

a) Prepare appropriate reports that will support the evaluation of data in Phase 2. With additional data provided, you are to select reports that will help address the proprietor’s concerns. This is to be completed in Excel.

b) For one of your reports (that is different from reports produced for Phase 1), outline the steps taken to select, prepare and format the report. This should be brief and presented in dot point format.

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

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

o A statement explaining the information in your report (i.e., numerical)

o Why the information is important to the business

o A description and explanation of a suggested improvement to the data collected (may relate to inputs, processes, or outputs)

Parts b & c are to be completed in Word or PDF.

Solution

PHASE 1

b) Steps taken to select, prepare and format the report

The steps which were taken for the purpose of selecting, preparing and formatting the report of “Number of Customers by Region” in the Excel have been discussed below:

● Step 1: Prepare data

The first step was linked to preparation of the data for the purpose of ensuring that the data is effectively organised in columns to support evaluation.

● Step 2: Insert Pivot Table

The next step was to select the data range and insert a ‘Pivot Table’.
Insert -> PivotTable

● Step 3: Configure Pivot Table

The next step was to drag the fields appropriately to Rows, Columns, and Values related to the region and customers in that region.

● Step 4: Insert Bar Chart

The next step was to select data from the table and insert a bar chart.
Insert -> Bar Chart -> Clustered Bar Chart

● Step 5: Format Chart

The final step was to add the title of the chart and adjust settings.

c) Summary of evaluation of the data in Phase 1

Three different reports have been developed, using Excel, completely aligned with the concerns of Pieter, owner of Complete Car Care (CCC) which has been thoroughly evaluated for the purpose of providing a summary note which can significantly allow in the case of understanding the current situation of the business in Phase 1.

Report 1: Number Of Customers By Region

The first report which was developed in the process of effectively presenting the performance of CCC in the Phase 1 was associated with understanding the number of customers that the company serves based on the location of their customers. From analysis of the data provided in the Excel regarding the business operations of CCC, it was found that the number of customers from each region were from Inner City - 164, River Valley - 74, Southern Beaches - 67, Jacaranda North - 47, Harbourside - 43 and Northeastern Ranges - 30. Studying this information, it can be stated that the highest number of customers comes from the region of ‘Inner City’.

This report can provide significant information to the business regarding the best performing region which can completely allow the company in the process of strategic planning regarding the management of the business. This information is significantly important for the business in the case of thorough planning for expansion in addition to providing valuable information regarding effective allocation of resources. Benchmarking allows in the case of measuring and comparing the performance of an organisation with the best performing organisation (Erdil & Erbıyık, 2019). The report can also provide a valuable opportunity to consider the best performing region as a benchmark that can significantly provide guidance to the business in the process of effectively understanding consumer behaviour and preferences for increasing the chances of success in other regions for MBA assignment expert.

With consideration of the data presented in the report, one of the significant recommendations for improvement which can be provided is associated with suggesting the business in making quality improvements in the service provided in other regions to increase customer satisfaction (Ali et al., 2021). It can be said that the CCC should focus on investing in the processes of other regions which can support in the case of effectively supporting the overall success of the business.

Report 2: Customers By Vehicle Type

In the context of effectively analysing the performance of CCC in the Phase 1, the second report which was developed was associated with the presentation of the number of customers and the type of vehicle. Using the data which was provided in the given Excel regarding the case study organisation, the number of customers with different types of vehicles were SUV - 124, Sedan - 78, Hatchback - 68, 4WD - 64, Utility - 53 and People Mover - 38. It was found that the number of customers in the category of SUV type of vehicle was the highest which indicates that most of the car detailing services are used by SUV owners.

This information can be considered to be significantly important for CCC in the context of effectively marketing these services to target consumers that can completely allow in increasing the consumer base. Marketing of best-selling and value providing services offered by a business can be beneficial in the case of developing competitive advantage for that business in the market (Darmawan & Grenier, 2021). In addition to this, the report also provides significant ideas regarding the demand for a particular service that generates the highest revenue which completely allows in effective planning regarding optimum resource allocation.

One of the effective improvements which can be suggested to CCC in the process of driving customers is offering personalisation with the significant use of data. Personalisation can significantly allow a business to provide better value to their customers (Zanker, Rook & Jannach, 2019). Hence, making improvements in the existing services offered to these customers in addition to investing in creating new detailing services specifically for SUV vehicles can be suggested as useful recommendations.

Report 3: Monthly Revenue

Focusing on the concerns of the owner of CCC, the third report which was developed was completely aimed at analysing the revenue generated by the company in the seven months of operations in Phase 1. The information which was presented in the report shows the figures of revenue in accordance to every month which were July - $9810, August - $11880, September - $13320, October - $15245, November- $17014, and December - $16290 for the year 2022 and January - $12510 in 2023. Considering the figures given in the report, it can be said that the highest amount of revenue was generated in the month of November, 2022 with a significant growth trend noticed throughout the year.

Increasing growth of revenue and the volume of sales plays a crucial role in the success of the business (Haslindah, Hamdat & Hanafiah, 2021). Therefore, analysing the revenue growth every month is significantly important for a business in the case of planning effective strategies and focusing on achieving long term growth. Thus, the report can help the business in the process of understanding the trend in revenue growth and take future actions to increase the sales and revenue of the business.
In the process of addressing the reduction in the growth rate of revenue, one of the improvements in the input of CCC which can be suggested is focusing on use of data analytics. The application and big data and data analytics can significantly be beneficial to a business in the process of effectively understanding the needs of the customers and driving innovation (Ochuba et al., 2024). Hence, with the use of data analytics, CCC can effectively understand the preferences of the customers and develop new services which Can attract and retain the customers facilitating in increasing the overall revenue of the business.

PHASE 2

b) Steps taken to select, prepare and format the report

The steps which were taken for the purpose of selecting, preparing and formatting the report of “Staff Performance” in the Excel have been discussed below:

● Step 1: Prepare data

The first step which was followed was completely associated with ensuring that the given data are structured effectively in columns.

● Step 2: Insert Pivot Table

The next step was to select the data range and insert a ‘Pivot Table’.
Insert -> PivotTable

● Step 3: Configure Pivot Table

The next step was to appropriately drag the fields to relevant rows, columns, and values associated with the name of the staff and total fees received.

● Step 4: Insert Bar Chart

The next step was to select data from the table and insert a bar chart.
Insert -> Bar Chart -> Clustered Bar Chart

● Step 5: Format Chart

The final step was to add a suitable chart title and adjust settings.

c) Summary of evaluation of the data in Phase 2

Three different reports were created with the use of Excel in the process of addressing the concerns of the owner of CCC which has been thoroughly evaluated in the process of offering a summarised note that can significantly allow in the case of understanding the business situation in Phase 2.

Report 1: Vehicle Type Sales By Region

The first report which was developed considering the performance of Phase 2 of CCC was associated with analysing the type of vehicle with the number of customers as well as region of the customers. From the data which was given in the Excel regarding the business operations of CCC, the type of vehicle with the number of customers along with their region were:

Table 1: Vehicle Type Sales By Region
(Source: Self-developed from given Excel)

With consideration of the figures which have been presented in the report, it can be seen that the highest number of customers were from the region of ‘Inner City’ with most of the customers visiting CCC for detailing service of a ‘Hatchback’.

Data-driven decision-making allows a business in the process of effectively fostering growth and driving innovation (Moinuddin, Usman & Khan, 2024). The report can provide valuable insights regarding to CCC in the process of effectively making data-driven decisions regarding continuation or cessation of a particular service in a particular area based on the value generated by the business from that service.

The application of machine learning and artificial intelligence (AI) can thoroughly allow a business to analyse customer data and make decisions in an informed manner (Bharadiya, 2023). Thus, one of the suggested improvements related to the inputs can be use of machine learning and AI in the process of effectively analysing the data related to the customers and the most popular vehicle along with region for further investment decisions.

Report 2: Staff Performance (Total Fee Received)

The second report was developed with the purpose of analysing the performance of staff for which the name of the staff and the total fees received by them were considered. With regards to the data given in the Excel regarding the business operations of CCC, the table have been developed as below:

Table 2: Staff Performance
(Source: Self-developed from given Excel)

From the above table it is significantly visible that Matt Waters has received the highest amount of fees which is $224349. However, it can be seen that some of the staff have not performed well in comparison to Matt Waters’ performance.

The performance of the employees has a crucial role in the case of effectively supporting the growth and success of a business (Persada & Nabella, 2023). This report can allow CCC in analysing the performance of its employees in addition to providing opportunities for making better human resource decisions.
Automation of manual jobs can significantly provide opportunities for increasing the productivity, profitability and efficiency of a business (Coombs et al., 2020). Therefore, the recommendation for improvement that can be suggested is investment in automation of the detailing services offered by CCC.

Report 3: Staff Efficiency (Fee Received and Time taken)

The final report which was developed for the purpose of effectively analysing the performance of CCC in the Phase 2 was associated with analysing the efficiency of the employees by considering the fees received and time taken by them. From the given Excel data, a significant table was allowed to be prepared in which the name of the employee along with the fees receipt and the time taken by them to complete a particular service was effectively presented along with a chart.

Efficient employees can thoroughly be beneficial in the process of supporting enhanced productivity and improved customer satisfaction (Triansyah, Hejin & Stefania,2023). Thus, the report can allow CCC in analysing the efficiency of the employees which can be considered an important function of a business to increase its chances of success.

In the context of improving the efficiency of the employees, it can be suggested that the company should focus on providing sufficient training to the employees (Karim, Choudhury & Latif, 2019). Training allows in the process of improving the performance and productivity of the employees and thus results in organisational success.

References

Ali, B. J., Gardi, B., Jabbar Othman, B., Ali Ahmed, S., Burhan Ismael, N., Abdalla Hamza, P., ... & Anwar, G. (2021). Hotel service quality: The impact of service quality on customer satisfaction in hospitality. Ali, BJ, Gardi, B., Othman, BJ, Ahmed, SA, Ismael, NB, Hamza, PA, Aziz, HM, Sabir, BY, Anwar, G.(2021). Hotel Service Quality: The Impact of Service Quality on Customer Satisfaction in Hospitality. International Journal of Engineering, Business and Management, 5(3), 14-28. Doi: https://dx.doi.org/10.22161/ijebm.5.3.2

Bharadiya, J. P. (2023). Machine learning and AI in business intelligence: Trends and opportunities. International Journal of Computer (IJC), 48(1), 123-134. https://www.researchgate.net/profile/Jasmin-Bharadiya-4/publication/371902170_Machine_Learning_and_AI_in_Business_Intelligence_Trends_and_Opportunities/

links/649afb478de7ed28ba5c99bb/Machine-Learning-and-AI-in-Business-Intelligence-Trends-and-Opportunities.pdf?origin=journalDetail&_tp=eyJwYWdlIjoiam91cm5hbERldGFpbCJ9

Coombs, C., Hislop, D., Taneva, S. K., & Barnard, S. (2020). The strategic impacts of Intelligent Automation for knowledge and service work: An interdisciplinary review. The Journal of Strategic Information Systems, 29(4), 101600. https://doi.org/10.1016/j.jsis.2020.101600

Darmawan, D., & Grenier, E. (2021). Competitive advantage and service marketing mix. Journal of Social Science Studies (JOS3), 1(2), 75-80. https://ejournal.metromedia.education/index.php/jos3/article/download/9/15

Erdil, A., & Erbıyık, H. (2019). The importance of benchmarking for the management of the firm: Evaluating the relation between total quality management and benchmarking. Procedia Computer Science, 158, 705-714. https://www.sciencedirect.com/science/article/pii/S1877050919312761/pdf?md5=4215afbbe0a2c5601d3e8fb5b717de22&pid=1-s2.0-S1877050919312761-main.pdf

Haslindah, A., Hamdat, A., & Hanafiah, H. (2021). Implementation Of Marketing Strategies In Increasing Sales Volume. International Journal of Science, Technology & Management, 2(5), 1449-1459. https://ijstm.inarah.co.id/index.php/ijstm/article/download/299/261

Karim, M. M., Choudhury, M. M., & Latif, W. B. (2019). The impact of training and development on employees’ performance: an analysis of quantitative data. Noble International Journal of Business and Management Research, 3(2), 25-33. https://www.researchgate.net/profile/Wasib-Bin-Latif/publication/331147751_THE_IMPACT_OF_TRAINING_AND_DEVELOPMENT_ON_EMPLOYEES'_

PERFORMANCE_AN_ANALYSIS_OF_QUANTITATIVE_DATA/links/5c677f1f4585156b57fff982/THE-IMPACT-OF-TRAINING-AND-DEVELOPMENT-ON-EMPLOYEES-PERFORMANCE-AN-ANALYSIS-OF-QUANTITATIVE-DATA.pdf

Moinuddin, M., Usman, M., & Khan, R. (2024). Strategic Insights in a Data-Driven Era: Maximizing Business Potential with Analytics and AI. Revista Espanola de Documentacion Cientifica, 18(02), 125-149. https://redc.revistas-csic.com/index.php/Jorunal/article/download/211/176

Ochuba, N. A., Amoo, O. O., Okafor, E. S., Akinrinola, O., & Usman, F. O. (2024). Strategies for leveraging big data and analytics for business development: a comprehensive review across sectors. Computer Science & IT Research Journal, 5(3), 562-575. https://fepbl.com/index.php/csitrj/article/download/861/1062

Persada, I. N., & Nabella, S. D. (2023). The influence of compensation, training, competence and work discipline on employee performance pt. Luas retail Indonesia. International Journal of Accounting, Management, Economics and Social Sciences (IJAMESC), 1(4), 291-303. https://ijamesc.com/index.php/go/article/download/37/26

Triansyah, F. A., Hejin, W., & Stefania, S. (2023). Factors Affecting Employee Performance: A Systematic Review. Journal Markcount Finance, 1(3), 150-159. https://journal.ypidathu.or.id/index.php/jmf/article/download/102/76

Zanker, M., Rook, L., & Jannach, D. (2019). Measuring the impact of online personalisation: Past, present and future. International Journal of Human-Computer Studies, 131, 160-168. https://doi.org/10.1016/j.ijhcs.2019.06.006