CASE STUDY

SHOWDOWN PHARMACY INVENTORY MANAGEMENT SYSTEM

There are approximately $22,000$ independent pharmacies in Africa. The modern pharmacy landscape is constantly changing and growing to serve communities large and small, while facing hurdles including reimbursement issues, complex medication regimens, and narrowed patient access. Given these challenges, pharmacy managers must choose wisely when investing in equipment and technology intended to maximize space, accuracy, and productivity. The TCGRx Beacon Pharmacy Inventory Management System supplies a range of scalable technologies and strategies to meet pharmacy needs and improve operations no matter the size or scope of a particular facility.

In $2016,$ Kwesi Twum was working at an independent pharmacy in the San Francisco Bay Area and seriously considering pharmacy ownership in Africa. His direction shifted a bit when a job posting appeared for a startup pharmacy manager in his hometown of rural Dodowa, Accra. The SHOWDOWN Health & Wellness Center is an African Herbal and Orthodox Health Service pharmacy owned and operated by the local tribesmen. Serving a unique community can change some of the usual assumptions of pharmacy management, including the common constraints around relying upon a specific formulary.

Our philosophy is not the same as a typical retail pharmacy, Kwesi Twum noted. For example, he said, We dont have a strict focus on lean inventory. We try, instead, to have everything in stock to provide the best customer service possible. Maintaining an expansive inventory, however, can create spatial, organizational, and access challenges that could potentially contribute to inefficiency and dispensing errors. The right solution would provide storage, enable speed, and enhance safety, all at the same time.

The Decision

Kwesi Twum was a decision maker involved in choosing equipment for SHOWDOWN before the doors even opened in June $2017.$ He researched shelving options and found that the TCGRx Beacon Systems variety of high$-$density storage cabinets were a very attractive feature for a new startup pharmacy with large storage needs. They provided us with a lot of space to start with, Bokor said, and we have room to grow. Beacon also provides the ability to pull medications directly from storage, without having to rely on or bypass a robotic dispensing system. This was a key point for us$,$ Kwesi Twum said.

The Results

SHOWDOWN has been accepting commercial, national, and mutual insurance plans since December $2017.$ They currently average $250$ prescriptions a day, and they are only picking up speed. We have a lot of patients with complicated drug regimens and those who live in remote areas, Kwesi Twum said. When they come in for their visits, efficiency is nice. We try to button everything up and can usually get things answered pretty quickly. Working from a number of formularies means the need to shelve a vast inventory. The Beacon storage system consolidates the pharmacys footprint through minimizing on$-$hand inventory, increasing inventory turns, and reducing expired medications.

SHOWDOWN is able to provide a high level of service thanks to their ability to consult with in$-$house providers combined with a comprehensive inventory, stocked and dispensed via a tailored TCGRx pharmacy storage solution.

SHOWDOWN currently employs the Beacon high$-$density storage solution as well as the companys associated DeliverRx will$-$call cabinet. The will$-$call system utilizes the same directed by light and bar$-$code identification technology that other TCGRx solutions rely on$,$ minimizing staff members learning curve. DeliverRx securely contains all will$-$call prescriptions in a single, easy$-$to$-$find location, further reducing customer wait times and making pick$-$ups clearer and less prone to error. Kwesi Twum hopes to purchase a compatible refrigeration unit as well. The pharmacy is also incorporating the TCGRx SmartCardRx blister$-$packaging system within the next year. We currently have $30$ or so patients on manual$-$fill blister packs, Kwesi Twum said, and we want to establish a solid client base.

Finally, SHOWDOWN will be expanding to include a long$-$term care facility on the reservation, which will require an automated medication dispensing system. TCGRxs PharmLoc cabinet would be the perfect segue for us$,$ Kwesi Twum said. When a single company provides a comprehensive, configurable system, growing a pharmacy is easy and quality control stays in sync$.$ I have worked in pharmacies doing less that felt much busier, Kwesi Twum said. We save footsteps and we get prescriptions to people quicker and safer. For SHOWDOWN, Kwesi said, relying on TCGRx and Beacon means increased efficiency along with greater dependability. Thanks to Beacon, a larger inventory actually means we are less harried and more accurate. Our error binder is thin because there just isn't much going into it$.$

The Proposed System

SHOWDOWN Pharmacy has appointed you as the Systems Analyst to lead a team of software engineers to design, develop and implement a robust, user$-$friendly web$-$based pharmacy management system for use in its operations

REQUIRED:

$1.$ Create a comprehensive list of interview questions $($arranged into three categories: questions about processes, questions about data, and general questions about the organization$)$ that you would ask the Administrator and other staff of the Pharmacy.

$2.$ Create and explain a list of opportunities and objectives of the proposed SHOWDOWN Pharmacy System.

$3.$ Provide the functional requirements and non$-$functional requirements for the SHOWDOWN Pharmacy System; and justify them.

$4.$ Discuss the software acquisition strategy that you would recommend for this project; and provide justification for it$.$

$5.$ Design Use Case Diagram$($s$)$ for the scenario outlined for the above case study.

$6.$ Design five reports that should be generated from the proposed SHOWDOWN Pharmacy System for the above project.

$7.$ Construct Entity Relationship Diagrams for the scenario outlined for the above case study.

AP$[10$ marks$]$

AP$[5$ marks$]$

AN$[10$ marks$]$

EV$[10$ marks$]$

CR$[10$ marks$]$

CR$[10$ marks$]$

CR$[15$ marks$]$