Stage 4: Final System Report

1

2

Stage 3: System Design Specification

Nambo Francis

IFSM 461

November 23, 2021

Introduction

As an electronics company based in Kansas City, PEP produces precision electronic parts. The company has created precision electrical devices and replacement parts for hospital equipment utilized in hospitals, doctor's offices, and pharmacies for the past 20 years. The demand for PEP motors has risen significantly in recent months. Because of this, the Purchasing and Shipping Department is under much stress. In addition, the Accounting department is lagging in financial operations, and the Business Management system is struggling to keep up with the situation. Working with RedOrum LLC, a consulting firm, can help the PEP Company identify a business solution that aids and promotes efficiency. They would improve the receipt of payments, bills, and accounting by making the process more efficient. In addition, customers will be satisfied because of the system's integration with other IT elements in the organization, providing reports for all departments.

Output Layout

Every department at PEP is required to provide a monthly report. They also want to know how invoices are preserved and how customers' payments are collected (Hafez et al., 2017). These requirements specifications for the new system will quickly define the system's fundamental functioning as far as data gained from the device, data input into the computer, and how the data is processed in the proposed solution.

Output requirements

Account Receivable

Account Receivable (AR) delivers a wide range of up-to-date reports and can serve as a backup source of data. For example, consider the proceeds or payment the company receives from its consumers who purchased goods or services from the organization (How to Model Relational Database Design with ERD? n.d.).

Account Receivable Report

Customer ID	28
Client address	29010 lord’s ways. San Diego, DA 56783
Client Organization Name	Clade Children clinic
Description	parts
Product Type	Electronics
Product model number	QR56478
Product quantity	10
Product price	$729.59
Money due	$500.59
Money paid	($229.00)
Date paid	June 5
Client ID	28
Client organization name	SGHU Clinic
Client address	29010 lord’s ways. San Diego, DA 56783
description	Items
Item type	Pharmaceuticals
Item model number	QRJY805
Product quantity	10
Product price	$2,6986
Money due	$ 1,6000
Money paid	$1,0986
Date paid	September 8

Invoice

Invoice is acquired and sent to customers on time. Invoices would either be mailed to them or emailed to them, depending on their preference. This monthly report offers a glimpse of the unpaid invoices in the system. A person can also customize the report aside from the mode of payment, sale date, and place being changed.

Collections Billing Report

The Invoicing Department identifies overdue accounts. The Accounts receivable and Sales divisions receive these reports. In addition, the AR sector manages collections beyond 30 days, 60 days, and past 60 days overdue.

Precision Electronics Parts

5698 lords’ way phone: 101-656-2315

San Diego, DA 56783 Fax: 101-656-2315

Email: [email protected]

Collections/billing Report

Statement # 0021 Bill To Clade Children Clinic

Date: 5th June Clade Children Clinic

Customer ID: 001 29010 lord’s ways

San Diego, DA 56783

Order date	Items ordered	Order cost	Money paid	Money due	payment due date	30 days past due	60 days past due	Past 60 days
June 5	parts	$729.59	($500.00)	$229.00	July 6
10th June	parts	$3000.00	$229.00	$500.00	July 15

Input layout

The ITSC and anyone who requires access to the data will need accurate data entry to ensure that the system has all the information to generate the essential reports.

Layout 1

Accounts Receivable Report data requires that the following information be entered into the system.

Account receivable report
Month report	June
Date	5th
Client ID	Search by UPC
Client organization Name	Clinic
Client address
description
Item model no.	Search by UPC
Ordering date To
Ordering date from
Payment Date Due To
Payment Date Due From
Accounts Status	Pending
	current
	Past due
	All

Layout 2

For the Invoicing Report to be generated, the following information should be entered into the system.

Invoice Report (monthly)
Month	June
Date	5th
Client ID	5-Digit search
Worker ID	SEARCH WORKER #
Ordering Date To	6/5/20
Ordering Date From	12/9/20

Layout 3

The following data is required to be entered into the system correctly to build the Overdue Collections report.

Collections/ billing report
Month	June
Date	5th
Client ID	5-Digit search
Date To	6/5/20
Date From	12/9/20
Overdue	30 days past due 60 days past due 90 days past due 2 percent overdue

File/database design ERDs

The diagrams will depict entities and their relationships to show how data will be arranged in the new system. " An understanding of the data relationships used to input the required information can be gained from this. The entity-relationship diagram for every input/output unit will be different from others, but the database for every system will be the same.

Entity-relationship Diagram 1

Entity-relationship diagram 2

Entity-relationship diagram 3

References

Hafez, A. Z., Soliman, A., El-Metwally, K. A., & Ismail, I. M. (2017). Design analysis factors and specifications of solar dish technologies for different systems and applications. Renewable and Sustainable Energy Reviews, 67, 1019-1036.

How to Model Relational Database Design with ERD? (n.d.). Www.visual-Paradigm.com. Retrieved November 21, 2021, from https://www.visual-paradigm.com/tutorials/how-to-model-relational-database-with-erd.jsp

‌