INCREASE IN TAMAD CAUSES INCREASE IN MASAMA PHILIPPINES: USBONG CONTINUES TO PROVIDE COMPUTER SERVICE ASSISTANCE BY SHARING KNOW-HOW ON MAPARAANG PAGBIBILANG December 2020 To eliminate
excess steps and inefficient time usage, Marikina Orthopedic Specialty Clinic
(MOSC) requested Usbong's
services to automate routine, monotonous tasks and share with unit
members know-how on computers. Here are Key Action Items that we executed in this updates list. 1) Continued to update Knowledge Management System (KMS) 1.1) added: in Non-medicine Item Page, computation for each transaction in the Cart List --> We executed this action based on feedback after actual use by Unit members.--> Example Item Price with Value-Added Tax (VAT): (250.00+30.00) x 1 = 280.00 --> This action is to speed-up entering of amount by hand into Cash Register Machine and the Computer Database. --> At present, the Cash Register Machine is not yet automatically connected to the Computer Database. --> In addition, this action assists Unit members with Official Receipts (OR), which we still answer by hand. --> After computation, it takes at least 5mins per patient to finish answering an Official Receipt. --> From observation, a patient who is waiting at the Cashier Unit tends to also request for an OR. --> This is after seeing another patient request for it. --> Therefore, waiting time at the Cashier Unit for all the remaining patients increases. --> Example: 3 patients waiting (for OR only) at the Cashier Unit; --> patient#1: 5mins --> patient#2: 10mins --> patient#3: 15mins NOTE (from SYSON, MICHAEL B.): 1.2) fixed: problem with medicine, non-medicine, and snack items not correctly classified to be purchased by patients who are classified to be Senior Citizens (SC) or Persons with Disabilities (PWD) --> This is due to we did not yet update the medicine, non-medicine, and snack item pages to execute instructions to auto-classify. --> Previously, we did not need to add the patient who is buying the items in the Cart List. --> However, to solve problems with Official Receipts (OR) having "None" as the name, we executed this update as action. NOTE (from SYSON, MICHAEL B.):
1.3) updated: computer database to include the total count sold of each item --> This noticeably speeds-up computation of the remaining quantity of each item. --> Previously, the computer had to verify all transactions in the database to compute the count. --> We add that this verification includes among others: identifying and classifying the item if such exists in the transaction. --> At present, the total number of item variations in the database is at 819. --> Classification as item type includes medicine, non-medicine, and snack items. --> This does not yet include variations in expiration dates and entered quantity of in-stock items in the inventory list. --> Writing the number of the total count sold until the day before the present clinic day eliminates excess steps. --> The computer simply verifies the stored number and only counts the transactions for the day. --> +added: set of instructions for computer to automatically update the database when it starts before the clinic opens --> We use Microsoft Windows' Task Scheduler to assist in the automation. |