Analysis and Design of Accounting Information System for Marcia's IT

This report provides a comprehensive analysis of Marcia's IT Development and Support, focusing on the challenges of their current manual information storage system and proposing an ICT solution to address these issues. The report includes a problem definition, outlining issues such as manual calling, slow response times, and manual data entry for tasks like invoicing and payroll. The proposed solutions involve a centralized database system with features like call management, account receivables tracking, and customer and payroll management. The report also includes user requirements, data flow diagrams for both the current and new business systems, and an ER diagram for the proposed payroll and revenue systems, demonstrating the relationships between entities. The investigation aims to improve Marcia's stock control and overall business efficiency.

Running head: ACCOUNTING INFORMATION SYSTEM
ACCOUNTING INFORMATION SYSTEM
Name of the Student:
Name of the University:
Author Note

1
ACCOUNTING INFORMATION SYSTEM
Problem Definition and Solutions Objectives
Problem Definition
The case study of the Marcia’s IT Development and Support has been taken into account. It is
being known that there are four branches for the organization currently. These branches are located
around the Lithgow, Eastwood, Fairfield and Wollongong area and Marcia the owner of the business is
looking to expand their business.
The organization currently makes use of the manual methods for their information storage
system. Therefore, Marcia is required to spend huge amount of time of record keeping, updating and
monitoring process. However, due to expansion this can become a major threat for her organization
and hence, there is a need for the development of an ICT solution.
 Manual Calling: In the existing system, manual calling is done by the customers. The staffs of
the organization receive their call and note down the details of the support manually. In
addition to this, the customer data are evaluated manually and then the customer receives a call
back.
 Response Time: After all the details for the customers have been recorded the support staff
then would be checking with the inventory for all the equipment necessary for the task. All the
tasks are required to be performed manually by the staffs.
 Manual Entry: Additionally, the working hours are entered manually by the support staffs and
on the basis it the invoice and payroll are developed. It becomes very difficult for Marcia to
monitor over the entire situation manually.
Solutions Objectives
As a solution to this a centered database system is to be developed.

2
ACCOUNTING INFORMATION SYSTEM
 Call Management: This system would be providing the users with the option to view, update
and manage data automatically. This would increase productivity by 10%.
 Account Receivables: This would be useful in tracking the data for Marcia and reduce the
overall burden which she has to face. This would decrease loss by 15%.
 Solution for response time: An online portal can be introduced for the customers and linked
directly with the database so that they support request can be managed efficiently. This would
increase customer satisfaction buy 5%.
User Requirements List
 Call Management: This automated system should be able to provide the customers with the
option to submit their request online. The data is to be stores in the database and then the staffs
would be able to manage the data as per their convenience.
 Account Receivable: The account receivable sub system would be able to tall all the records
done in the system and provide reports to Marcia accordingly.
 Customer Management: The customer management data would be recording all the details of
the customers associated with the system and would be validating the data sent from the
customers. The system would also be able to generate automate mails for the due payments.
 Payroll Management: The work hours for staffs on a particular support should be recorded by
the system with help of timestamp. This would be helpful in generating the payroll for the
employees.
 Warehouse Management: The details of the equipment and stocks should be stored and
managed by the system.

3
ACCOUNTING INFORMATION SYSTEM
Data flow diagrams
Logical data flow diagram of the current business system

4
ACCOUNTING INFORMATION SYSTEM
Logical data flow diagram for the new business system

5
ACCOUNTING INFORMATION SYSTEM
ER Diagram

6
ACCOUNTING INFORMATION SYSTEM
Bibliography
Dennis, A., Wixom, B. H., & Roth, R. M. (2018). Systems analysis and design. John wiley & sons.
Oyelere, S. S., Suhonen, J., Wajiga, G. M., & Sutinen, E. (2018). Design, development, and evaluation
of a mobile learning application for computing education. Education and Information
Technologies, 23(1), 467-495.