Phase3 decision table and decision tree
UMUC NEW BILLING AND PAYMENT SYSTEM
UMUC New Billing and Payment Systems
Paul Dela Cruz
IFSM 461 Systems Analysis and Design
University of Maryland University College
24 March 2015
UDO, MARIAN, AND UDUAK CORPORATION (UMUC) is experiencing growth with the business. The current system is incapable of servicing the expanded customer base satisfactorily. Billing has not been updated to accommodate online bill-pay, such a service has been largely adopted by many business. The company must adapt current best practices to improve operations, ensure that the finance department is able to keep track and relay their findings with administration timely and securely, a more practical and improved billing and payment system must replace the old one. In addition, the new system should provide UMUC with security that the new system would be able to accommodate their growing needs and support their customers.
Because the technology UMUC is fast becoming obsolete, the purpose of the new system is to incorporate today’s technology as well as emerging technologies in the field. I envision a Point of Sale (POS) System that effectively relays business operations in real-time that are vital to administration and defer as relevant to their database. This would tackle efficiency issues and can make drastic difference for how top management allocate funds. For example, assets can be readily invested when prices in the manufacturing fluctuates. The system will also feature heavy encryption for security so that customers will be at ease accessing self-service points of access in billing and payment. Provider-Client relations would be at its finest because the direct link should eliminate communicational noise allowing for an open conversation with higher level clarity and accuracy.
System
Customer End
Online bill-pay
Online Orders
Balance
Delinquencies
Auto Reminders
Administration Dept.
Sales Inquiries
Pending
Paid
Product Inventory
Finance Dept.
Sales
Stock
Billing
Payment
Price Inventory
The idea behind the new system is incorporating a database both accessible to the organization and its clients. But there will be different interface for the clients focused on their needs. It would have a layout for them to have a view of their account and it’s standing with UMUC providing information on their Balance and an inventory of products. It would be an online marketplace dedicated to UMUC related technology. They would have to register an account through their email. The registry will serve a purpose for UMUC to be an efficient, safe, and reliable seller. The sales history information would give UMUC prediction charts to plan for enlargement of inventory if necessary for example. The buyers can store sensitive material online through secure bill-pay website with extra encryption that is standard in online billing that uses credit cards or third party payment platforms like paypal or square.
The Interface for the organization would also be curtailed depending on their needs. The Finance department would be able to access relevant data. And the data would be stored in smart database that can easily pull up records with key queries such as based on customers orders, frequency of order, addresses by zip code. The Administration department would have real-time view on sales and liquid assets in per month basis. This would help in making executive decisions such as doubling up inventory for next quarter in anticipation of expanding sales.
System
Orders
Online bill-pay
Online Orders
Balance
Delinquencies
Auto Reminders
Administration Dept.
Sales Inquiries
Pending
Paid
Product Inventory
Finance Dept.
Sales
Stock
Billing
Payment
Price Inventory
My diagram shows how three of the facets of the company would interact through the new system. It describes what can be accessed by the finance department, administration department, and Orders exclusively or tailored according to their needs. Exclusively, for example, knowing the core strengths in sales could be just for the Administration, while Finance needs to know billing related items such as overdue accounts. Tailored views into the database is having a customer able to view their account only while the finance department can see their account and be able to concurrently compare it with others to find patterns on what the whole customer base is buying more of and buying more frequently.
Customer checklist information
Process – The business of correlating input data with stored database inventory, pricing and accounting data and forwarding results via system associated outputs.
1) _________ Products Ordered
2) _________ Product Ordered Date
3) _________ Product price
4) _________ Products Shipped
5) _________ Product Ship Date
6) _________ Requested Shipping Method
7) _________ Quantity
Output – Produce a data or record related to the input data that was processed.
1) _________ Product Invoice/Receipt
2) _________ Product Price
3) _________ Calculated Price (Calculated Field)
4) _________ Amount Due (Calculated Field)
5) _________ Amount Paid
6) _________ Date Paid
Input - Located at the business premises and a central data processing facility and takes in information defining customer information and order details.
1) _________ Customer Organization Name
2) _________ Customer Street Address
3) _________ Customer City
4) _________ Customer State
5) _________ Customer Zip Code + 4
6) _________ Primary Contact First Name
7) _________ Primary Contact Last Name
8) _________ Primary Contact Phone Number
9) _________ Primary Contact Email Address
10) _________ Secondary Contact First Name
11) _________ Secondary Contact Last Name
12) _________ Secondary Contact Phone Number
13) _________ Secondary Contact Email Address
Performance - Provides feedback on how well the system process performed certain actions.
1) _________ Orders Processed
2) _________ Actual Delivery Date
Control - are methods with the systems that helps guide the input data processed throughout the system based upon response.
1) _________ Department for item purchased.
2) _________ Shipping Method
The Checklist serves to produce query driven searches in the database that ensures customers are appropriately notified about their business transactions. The queries would be serving the customers immediately and help them find the data they need. The efficiency would prove very convenient and useful for the customers and would encourage them to retain their business with UMUC as it strives to better serve the clients.
FDD
System
Orders
Inventory
Sale
Shipment
Administration
Input Data Processed
Input Data
Customer Access
Finance
Product Cost and Payment
Invoice-Receipt
Product Release
Works Cited
Malhotra, Y. (2005). Integrating knowledge management technologies in organizational business processes: getting real time enterprises to deliver real business performance. Journal of knowledge management, 9(1), 7-28.
Sharpe, M. S., Bryson, E., Manduley, F., Eben, M. R. I., & Flesser, B. D. (1993). U.S. Patent No. 5,222,018. Washington, DC: U.S. Patent and Trademark Office.
Kebschull, U., Schubert, E., & Rosenstiel, W. (1992, March). Multilevel logic synthesis based on functional decision diagrams. In Design Automation, 1992. Proceedings.,[3rd] European Conference on (pp. 43-47). IEEE.
