CISM4000 Information Systems in Accounting Report 3 Sample
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.
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)
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)
Solution
PHASE 1
(b) Presentation of the steps which have been considered in the process of selection, preparation and formatting the report in Excel
In this section of the report, the complete development of the steps that have been allowed for the purposes of preparing, selecting, as well as formatting the overall report particularly for “Number of Customers by Region” are clearly described here.
- Step 1:
The complete preparation of the data or information has been thoroughly allowed here as a part of step 1 ensuring the overall data must be organised efficiently with respect to the columns and rows that can support the overall evaluation process.
- Step 2:
As a part of Step 2, the insert of ‘Pivot Table’ is thoroughly allowed with the help of selecting the complete data range for university assignment help.
Insert -> PivotTable
- Step 3:
‘Pivot Table’ configuration has been done in step 3 by dragging the respective fields in an appropriate manner to the columns, rows, and values to maintain relevance to the customers and regions significantly.
- Step 4:
In step 4, the incorporation of a bar chart has been allowed with respect to the data or information by selecting the entire table that can enhance the overall visibility of the analyse data.
Insert -> Bar Chart
- Step 5:
Bar chart formatting is completely followed as a part of this particular state with the help of determining appropriate title of the chart as well as adjusting their settings to improve the visibility of data.
(c) Summarisation of the Phase 2 reports
With the help of considering the information or data that are gathered in the Excel sheet developed by Pieter, owner of Complete Car Care (CCC) for the purpose of analysis has been allowed that can enhance the ability of addressing the concerns of Pieter for their future business growth by understanding the present situation of phase 1.
Analysis 1: Number of Customers by Region
- Report Information Explaining Statement
As a part of the first analysis, the complete determination of each and every region along with the numbers of customers are thoroughly allowed considering the below table with appropriate seduction of columns and rows regarding the information of business operations of CCC provided by the Excel sheets.
.png)
Figure 1: Number Of Customers by Region
(Source: Developed from Excel)
- Importance of the information to the business
According to the statement of Hutt & Speh (2021), developing the knowledge about the number of customers with respect to the region can help the business in tailoring their marketing strategies as well as allocating the required resources in an effective manner. Considering this, It can be stated that from the above table of analysed data, the Inner City is a more effective region in maintaining businesses efficiently throughout the time whereas a significant focus of CCC is truly needed for Northeastern Ranges.
- Suggested Improvement to the Data Collection Description and explanation
Allowing automation is one of the significant approaches in maintaining the data gathering and analysis for the business in a more efficient manner (Sarker, 2022). For this instance, the incorporation of automation for the future data collection method is thoroughly recommended here for CCC.
Analysis 2: Customers By Vehicle Type
- Report Information explaining Statement
The below mentioned table is completely focused in addressing the types of vehicles along with adhering to the number of customers that can represent the most preferable types of vehicles with respect to the requirement or needs of consumers in the market. Following the table, it has been noted that SUV is the most selected vehicle with respect to the demands of markets that are followed by Complete Car Care (CCC) in Phase 1, whereas, People Mover is the lowest one in this particular segment.
.png)
Figure 2: Customers By Vehicle Type
(Source: Developed from Excel)
- Importance of the information to the business
With the help of considering the market data with respect to the customer demand in a business leads to developing better targeting, increasing customer satisfaction, and improving the overall cells that can ultimately drive a profitable business (Lessmann, Haupt, Coussement, and De Bock, 2021). Following these aspects, with the help of above table’s information, the business of CCC can be able to tailor their marketing strategy by optimising their inventory along with enhancing overall customer experience through developing a clear and transparent understanding about the market trends and preferences.
- Suggested Improvement to the Data Collection Description and explanation
During collecting the data or information of the customers, the data personalization is one of the effective approaches that can allow the business to develop better understanding about their customer preferences (Zanker, Rook & Jannach, 2019). Therefore, it is completely recommended here for CCC in their future data handling approach enhancement.
Analysis 3: Month Revenue ($)
- Report Information explaining Statement
Following the concern of the owner of CCC, this analysis is completely focused on highlighting the monthly revenue that has been developed by the business of CCC. Considering the below table, it has been evaluated that, in the month of November, 2022, comparatively high revenue has been obtained by the business of CCC, whereas, it was down in the initial month, July, 2022.
.png)
Figure 3: Monthly Revenue
(Source: Developed from Excel)
- Importance of the information to the business
The high growth of revenue along with increasing sales volume place a significant role behind the success of a business (Cooper, 2019). For this instance, the complete analysis of the month wise revenues of CCC indicates the growing demand of their services or products in the market that can help in achieving long term growth in business.
- Suggested Improvement to the Data Collection Description and explanation
Big data analysis can be allowed with the help of incorporating AI and machine learning is truly profitable in managing the vast amount of data in the limited time span (Attaran & Deb, 2018). Hence, the efficacy of utilising AI and machine learning is recommended here for CCC in their future data collection, analysis, as well as mining cases.
PHASE 2
(b) Presentation of the steps which have been considered in the process of selection, preparation and formatting the report in Excel
The steps which have been followed for the purpose of effectively developing the Excel report related to ‘Vehicle Type Sales by Region’ based on the given Excel file and the case study in the context of selection, preparation and formatting have been presented below:
- Step 1:
The first step which was considered to be followed is completely aligned with the effective organisation of the data within the structure that supports effective analysis and evaluation to answer the questions.
- Step 2:
The next step was completely associated with insertion of a Pivot Table by effective selection of a particular data following the pathway of Insert -> PivotTable.
- Step 3:
In this step, appropriate fields were dragged to relevant columns, rows and values related to type of vehicle and associated sales by region.
- Step 4:
The fourth step was completed by the process of developing a bar chart with proper selection of the data range with the following step of Insert -> Bar Chart.
- Step 5:
The final step was completely aligned with providing a suitable title to the bar chart along with adjusting the settings as required.
(c) Summarisation of the Phase 2 reports
In total, three reports associated with the performance of Complete Car Care (CCC) in the Phase 2 were effectively generated with the appropriate use of information provided in the case study as well as the Excel data. For the purpose of providing valuable information regarding the concerns raised by the owner of CCC, the reports developed in the Excel have been summarised below:
Analysis 1: Vehicle Type Sales by Region
- Report Information explaining Statement
A suitable statement regarding the explanation of the information which has been provided in the Excel based on which a chart has been draft have been effectively presented with the help of the table below:
.png)
Figure 4: Vehicle Type Sales by Region
(Source: Developed from Excel)
With consideration of CCC’s data, the above table allowed in the process of determining the cases of portraying the information about the sales of several types of vehicles with respect to the particular regions in from which the customers belong to. It is evident from the table that the most popular vehicle segment is ‘Hatchback’ for detailing service with the highest number of customers from ‘Inner City’ region.
- Importance of the information to the business
Data-driven decisions can allow the business in the process of improving the overall business performance (Awan et al., 2021). With the aid of this valuable data, CCC can effectively analyse the data and allow in the case of making data-driven decisions in the process of managing the business which can be beneficial in increasing the overall rate of success.
- Suggested Improvement to the Data Collection Description and explanation
An important recommendation regarding improvement related to data collection which can be suggested to the CCC can be based on the findings of Iqbal et al. (2020) in which it has been stated that use of data analytics can completely allow in modernisation of business processes improving the overall efficiency.
Analysis 2: Staff Performances
- Report Information explaining Statement
The information which has been considered in the process of developing the report has been effectively presented in the table below as a statement of the data related to the performance of the employees.
.png)
Figure 5: Staff Performance
(Source: Developed from Excel)
Matt Waters is the best performing employee who has received $224,349 in fees. In addition to this, the table also shows that the performance of other employees has not been good when compared with the performance of Matt Waters.
- Importance of the information to the business
With respect to a business, employee performance has a crucial role to play in ensuring business sustainability (Riyanto, Endri & Herlisha, 2021). Hence, it can be stated that with the aid of the information related to the staff performance can allow the business in the context of identifying effective strategies to improve the performance of their employees allowing in the context of achieving long-term business success.
- Suggested Improvement to the Data Collection Description and explanation
Automation with use of robotics can allow in the case of improving the overall competitiveness and efficiency of the business (Siderska, 2021). Therefore, it can be suggested that CCC should focus on automation with the use of robotics in the case of improving the performance of the business.
Analysis 3: Staff Efficiency
- Report Information explaining Statement
A significant report associated with the analysis of the staff efficiency of the employees was presented with respect to the fees received and time taken by them. With the aid of the given data from the excel given with the case study, a significant table have been developed in the Phase 2 Excel that has been given along with the name of the employee and the fees received by them in addition to providing the time taken by the employees to effectively complete the jobs related to a particular service.
- Importance of the information to the business
The information related to the time taken and the fees received by the employees can be effectively compared with the estimated time needed by an employee which has been developed by Pieter. The information of tracking the staff efficiency lies in the fact that it can allow in the case of increasing the overall productivity and delegation of the employees (Trivedi & Patel, 2021).
- Suggested Improvement to the Data Collection Description and explanation
Training can be beneficial in the case of increasing the aptitude and capacity of the employees (Aldhukair & Abunar, 2021). Hence, one important suggestion which can be provided to CCC is providing suitable training to the staff as it can be effective in the case of improving the efficiency of existing staff.
References
Aldhukair, H., & Abunar, M. (2021). Employee training and development for improved performance. PalArch's Journal of Archaeology of Egypt/Egyptology, 18(12), 107-116. https://archives.palarch.nl/index.php/jae/article/download/7852/7360
Attaran, M., & Deb, P. (2018). Machine learning: the new'big thing'for competitive advantage. International Journal of Knowledge Engineering and Data Mining, 5(4), 277-305. https://www.researchgate.net/profile/Mohsen-
Attaran/publication/327215281_Machine_Learning_The_New_'Big_Thing'_for_Competitive_Advantage/links/5ba4322a45851574f7dabf33/Machine-Learning-The-New-Big-Thing-for-Competitive-Advantage.pdf?_sg%5B0%5D=started_experiment_milestone&origin=journalDetail&_rtd=e30%3D
Awan, U., Shamim, S., Khan, Z., Zia, N. U., Shariq, S. M., & Khan, M. N. (2021). Big data analytics capability and decision-making: The role of data-driven insight on circular economy performance. Technological Forecasting and Social Change, 168, 120766. https://osuva.uwasa.fi/bitstream/handle/10024/12928/Osuva_Awan_Shamim_Khan_Zia_Shariq_Khan_2021.pdf?sequence=2&isAllowed=n
Cooper, R. G. (2019). The drivers of success in new-product development. Industrial marketing management, 76, 36-47. https://doi.org/10.1016/j.indmarman.2018.07.005
Hutt, M. D., & Speh, T. W. (2021). Business marketing management: B2B. South-Western, Cengage Learning. http://dspace.vnbrims.org:13000/jspui/bitstream/123456789/4877/1/Business%20Marketing%20Management%20B2B.pdf
Iqbal, R., Doctor, F., More, B., Mahmud, S., & Yousuf, U. (2020). Big data analytics: Computational intelligence techniques and application areas. Technological Forecasting and Social Change, 153, 119253. https://pureportal.coventry.ac.uk/files/23233843/Binder2.pdf
Lessmann, S., Haupt, J., Coussement, K. and De Bock, K.W., 2021. Targeting customers for profit: An ensemble learning framework to support marketing decision-making. Information Sciences, 557, pp.286-301. https://www.econstor.eu/bitstream/10419/230723/1/irtg1792dp2018-012.pdf
Riyanto, S., Endri, E., & Herlisha, N. (2021). Effect of work motivation and job satisfaction on employee performance: Mediating role of employee engagement. Problems and Perspectives in Management, 19(3), 162. https://www.academia.edu/download/69819906/PPM_2021_03_Riyanto.pdf
Sarker, I. H. (2022). AI-based modeling: techniques, applications and research issues towards automation, intelligent and smart systems. SN Computer Science, 3(2), 158. https://doi.org/10.1007/s42979-022-01043-x
Siderska, J. (2021). The adoption of robotic process automation technology to ensure business processes during the COVID-19 pandemic. Sustainability, 13(14), 8020. https://doi.org/10.3390/su13148020
Trivedi, S., & Patel, N. (2021). Virtual employee monitoring: A review on tools, opportunities, challenges, and decision factors. Empirical Quests for Management Essences, 1(1), 86-99. https://researchberg.com/index.php/eqme/article/download/49/53
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
Would you like to schedule a callback?
Send us a message and we will get back to you
Highlights
Earn While You Learn With Us
Confidentiality Agreement
Money Back Guarantee
Live Expert Sessions
550+ Ph.D Experts
21 Step Quality Check
100% Quality
24*7 Live Help
On Time Delivery
Plagiarism-Free
81 Isla Avenue Glenroy, Mel, VIC, 3046 AU
