PFS Final
PFS Final
EXECUTIVE SUMMARY
The technical feasibility lays out the specifications and detailed plans/requirements of the
company to make CCMD operational. This segment includes details such as the service
processes, legal contracts and formal procedures, manpower requirement, headquarters
location, floor plan, and pre-operation activities. Ultimately, the technical feasibility is
crucial in determining the intricate details and technical decisions the company would
need to make in order to carry out the service to the hospitals. This chapter was able to
decide the manpower requirement of 31 total office employees for the year 2022, in which
it would be located in Subangdaku, Mandaue.
Lastly, the financial feasibility explicitly evaluates and analyzes the profitability of the
service in its short and long run. KUALA Analytics Group is ultimately a business, and
needs to ensure that CCMD would be a profitable venture. Major financial statements such
as the cash flow, balance sheet, and income statement are all reflected with respect to the
expenses incurred, tax payables, cost of sales, and other financial accounts. The total
project cost of Php 14,480,261.09 will be incurred in the year 2022. It is important to note
that the financial statements only cover the first 5 years of operations. Through financial
analysis, the company was then able to evaluate certain financial metrics and ratios.
Taking everything into account, the marketing, technical, and financial aspects of the
study, the proponents were able to conclude that Cebu Centralized Medical Database
(CCMD) is a business venture that is feasible and worth-pursuing given its positive results
in terms of its demand, technicalities, profits and overall societal contribution. Thus, the
high potential of the project allows for a great business opportunity to the proponents —
in pursuit of making a difference.
TABLE OF CONTENTS
CHAPTER
Title Page
Approval
Acknowledgements 2
Executive Summary
List of Tables ⅺ
List of Figures 14
CHAPTER 1: INTRODUCTION 1
1.1 Rationale 1
2.7 Evaluation 39
3.4.1 Schedule 68
REFERENCES 200
APPENDICES 205
Appendix B: Complete List of Licensed Hospitals in Cebu (as of March 2022) 205
1.1 Rationale
Advancements in technology have been evident in the medical field ever since the
discovery of the Smallpox vaccine. Numerous diseases and conditions that were once
deemed incurable can now be treated through various medications and procedures.
Moreover, several aspects of the healthcare system have seen improvements and
innovations over the years; especially with the digitalization of patient data in hospitals and
medical institutions through the utilization of Electronic Medical Records (EMRs).
However, in the Philippines, digital access to such medical information are often
only limited to specific hospital groups, and are not made easily-available between all
hospitals in a certain region. In instances where quick access to patient information are
necessary, such as in accidents and other emergency-related situations, the current
system in the many regions of the country falls short. In fact, 4.4 million lives are lost each
year globally due to injuries and accidents (World Health Organization, 2021). Thus, the
proponents conceived the idea of Cebu Centralized Medical Database (CCMD) to tackle
the said issue.
1
1.2 Industry Assessment
As technological advancements continue to push for the digitalization of many markets
and businesses not just in the Philippines, but across the globe, the healthcare industry is
one that has clearly undergone significant changes in the past several years.
With this, CCMD seeks to differentiate itself in the industry by being the first to
provide a centralized medical database in all hospitals within Cebu – both private and
public. As market trends seem to keep pushing towards digital advancements in most
industries, the healthcare industry is one that would benefit greatly from such service
improvements and enhancements through innovation.
2
Figure 1. SWOT Analysis
Strengths
Not all medical institutions in the country utilize a digital medical record
system, and CCMD is able to provide that feature. Along with that, database
security is also a strength of the service as access limitation to data will be held to
a highest degree. Moreover, physical storage of files and sheets is one of the main
concerns on paper-based medical record systems, and CCMD is able to alleviate
that problem through its digital methods. Efficiency and convenience of acquiring
relevant patient information is also made easier through CCMD’s centralization of
all these records. Lastly, future-proofing the service is one of CCMD’s biggest
advantages as trends continue to move towards the digitalization of things.
Weaknesses
Along with the strengths, always come the weaknesses. The proponents
identify development and implementation costs as one of the main concerns.
Creating the software in itself is going to be very costly, and is going to require a
heavy amount of investment. In addition, CCMD is also going to require the need
for Internet connection and the relevant equipment, entailing further costs for some
medical institutions and connectivity concerns in some rural areas. Being able to
integrate CCMD in all hospitals within Cebu may also take some time to be
3
fullyimplemented considering its large scope. And lastly, data transfer bottlenecks
may be a concern especially for those transitioning from a paper-based system
and the heavy traffic that occurs in our database.
Opportunities
The proponents are aware of the many opportunities that are open for
CCMD in the industry. First, standardizing a high-tech environment in all hospitals
is one way to improve the quality and standard of medical services in the country.
Moreover, CCMD’s software features can also be improved over time through
popular demand requests from buyers and through collaborative innovation. Lastly,
CCMD can be an avenue for these hospitals to standardize several of their
processes. Through the flexibility and adaptability of digital databases, there are
potentially hundreds of opportunities for CCMD to capitalize on.
Threats
Aside from having opportunities, there are also threats that CCMD have to
keep an eye on. The first threat that the proponents have identified is direct
competition. Some of CCMD’s direct competitors that provide similar services
include Bizbox, CHITS, Comlogik, as well as others that were aforementioned.
Also, security breaches and encryption concerns may also arise; therefore, the
proponents have to ensure that the software is developed and maintained carefully
to prevent data loss and breach. There may also be hidden costs entailed in the
service that may be unforeseen by the proponents that could pose a threat. And
lastly, consumer preference and insistence of using paper-based medical records
could be a threat to the implementation of CCMD. With all these mentioned, it is
important for the company to ‘think five steps ahead’.
4
2.1 Service Description
CCMD is a web-based application that allows hospitals to store and retrieve
medical data in less than a minute. Through this application, hospitals are able to access
the data of patients regardless of which hospital these data were recorded, given that the
patient’s consent was given. To ensure data privacy and security, a unique licensed ID
number and password is given to each medical facility worker to allow them to input data.
In a similar way, the patients are also given a unique ID number and password, the
password can then be changed according to the patient’s preference, to enable them and
the hospitals to access their past medical information. CCMD also allows patients to view
a summary of their medical history and condition (except for psychiatric notes and other
incriminatory information) in the presence of the attending physician, as stated by the
Department of Health’s ‘Patients Rights’.
5
● Patient referral tracking - the directory of specialists within the
hospital is included in the software for primary doctors to efficiently
refer their patients to the needed specialist;
● Billing integration - expenses are tracked digitally for a documented
receipt after all transactions have been completed and to assist in
reimbursement;
● User-friendly interface - to help users quickly navigate through the
contents and other activities in the application; and
● Multiple platforms - can be downloaded using mobile devices (for
patients) or through laptops & desktops (for hospitals and/or
patients).
6
emergence of medical clinics have reduced patient traffic in hospitals by offering
specialized services. Not only can these improvements be noticed in urban sectors but
also in rural areas. Thus, data storing and retrieval methods should innovate along with
medical processes.
Currently, several hospitals are utilizing electronic medical records as their data storage
system. While some of the other medical institutions in the country only make use of the
labor-intensive paper-based record system. Moreover, medical clinics and hospitals that
digitally store and record their data aren’t maximizing the use of these systems to its full
potential. Costs of maintaining these medical record systems may amount to millions
monthly depending on its size and reach.
Regardless of its location, hospitals must have access to electricity for it to perform its
procedures such as laboratory tests and surgeries. For them to be able to cater the needs
of the masses, they are situated in different locations, especially those with high population
density. Although some of them may be using paper to store records, the shift to electronic
medical records is not out of reach due to the rapid development of the internet and its
expansion to rural areas.
7
2.2.2 Market Targeting
CCMD aims to provide a more organized, efficient, and digitized recording
system for hospitals in Cebu. The service is a type of service that is paid on a
subscription or license basis depending on the number of licenses that the
hospitals seek to purchase. These institutions are those (1) that are located in Cebu
- both urban and rural, (2) looking to shift to a centralized electronic system, (3)
heavy users, and (4) those with a complex buying behavior. The company aims to
meet the demand of the target market to promote efficiency in data storage and
retrieval.
8
region only. Based on the official data from the Department of Health’s National
Health Facility Registry 2.0, there are currently 40 licensed hospitals (both private
and government hospitals combined) in Cebu.
Slovin’s Formula:
𝑛𝑜. 𝑜𝑓 𝑠𝑎𝑚𝑝𝑙𝑒𝑠 = 𝑁/(1 + 𝑁𝑒!) ; where N = total population
e = margin of error
𝑛𝑜. 𝑜𝑓 𝑠𝑎𝑚𝑝𝑙𝑒𝑠 = 40/(1 + 40 ∗ 0.125!)
𝑛𝑜. 𝑜𝑓 𝑠𝑎𝑚𝑝𝑙𝑒𝑠 = 25 𝑟𝑒𝑠𝑝𝑜𝑛𝑑𝑒𝑛𝑡𝑠
With that, 25 hospitals in Cebu will be needed to take part in the survey.
9
LapuLapu City, and such. Only hospitals that were recognized by the Department
of Health were chosen as respondents. Respondents who utilized a mix of
electronic and paper-based record systems were 92% of the total population while
the rest used a paper-based system only. Of the 25 respondents, 96% agreed that
a centralized medical database can improve emergency response but only 88% of
the population is willing to avail of the service. The most preferred purchasing
frequency is the annual subscription, representing 84% of the total population, 8%
chose a semi-annual subscription, 4% chose a quarterly subscription, while the
remaining 4% chose a monthly subscription. For the facility that chose a monthly
subscription, their preferred price range per license is Php 1,000. Meanwhile, the
facility that chose a quarterly subscription would be willing to pay Php 2,750 per
license. The facilities that chose a semi-annual subscription chose a price range of
Php 5,000 per license. Lastly, for medical facilities that chose the annual
subscription, 75% would be willing to pay Php 9,500 per license, 10% would be
willing to pay for Php 19,500, while 15% would be willing to pay Php 28,500 per
license.
Upon surveying the preferred modes of acquiring the service, 80% of the
respondents would like to acquire/download the service through the official
website, 12% wanted to download it through a flash drive, 8% preferred it to be in
a CD/DVD, while the remaining 4% preferred any method as long as it was reliable.
After the deployment of the service, 72% of the respondents wanted to know its
availability through Facebook, while 56% of the respondents wanted to be
informed through TV commercials. In addition, 24% also wanted to be informed
through flyers. Other promotion channels included YouTube, newspapers, and
radios. The rest of the survey results will be expounded in the following section.
10
2. Medical clinics, RHUs, laboratories, and other health facility types
were omitted from the list of respondents.
2. Projected Population
The projected population pertains to the forecasted number
of licensed hospitals for the next 5 years, obtained using the Linear
Regression Method.
11
a. Efficient Access to Specific Patient Information
The demand for efficient access to specific patient
information includes history of past illnesses, family history
of past illnesses, history of present illnesses, clinical history,
allergies, medication history, laboratory results, and
treatment outcome.
c. Billing Integration
The demand for billing integration is for the population that
needs the total hospital bills to be integrated to the system
for a digitized and electronic viewing of their expenses.
f. Inventory Management
12
The demand for inventory management includes a list or
tracker of all inventories kept per hospital with regards to
their resources (ex: medicine, equipment, PPE).
13
features that the proponents would incorporate into the service
standard.
2023 42
2024 43
2025 44
2026 46
2027 47
2. Demand Factors
Table 2. Demand Factor for Every Feature
Demand
Feature Frequency
Factor
14
3. Projected Demand per Feature
Table 3.
Projected Demand for Each Feature in the Next 5 Years
2023 2024 2025 2026 2027
Billing Integration 41 42 43 45 46
Appointment/Consultation
Schedule and Reminder
42 43 44 46 47
41 42 43 45 46
Inventory Management 41 42 43 45 46
15
Figure 3. Survey Results of the Ranking of Features (Based on Importance)
Table 4.
Factor Rating per Feature
Rank (Weight)
Total
Feature
1 (6) 2 (5) 3 (4) 4 (3) 5 (2) 6 (1) Score
Billing Integration 1 9 6 4 2 3 94
2 4 3 8 4 4 80
Appointment/Consultation
Reminder….
0 1 8 5 8 3 71
Medication Tracking
and...
Inventory Management 3 1 1 4 4 12 59
16
Scoring: 1 - most important, and 6 - least important
Where:
Xia = projected population in year i of hospital type a Pa
= demand factor from survey results of hospital type a
a = 1 if government hospital
a = 2 if private hospital
Table 5.
Annual Demand of CCMD
(See Appendix I for breakdown of calculation)
CCMD Demand (# of Hospitals)
Government Private Government Private Government Private Government Private Government Private
14 23 14 24 14 25 15 26 15 26
17
the actual database. The three features include: (1) efficient access to
specific patient information, (2) billing integration, and (3) patient referral
tracking. Thus, all medical institutions will receive the same standard
license containing these three features.
3. Basis about the features of each of the competing EMRs was based
on information available online. (ex: Bizbox was found to not have
a feature on patient referral tracking)
4. Hospitals that utilize the same EMR provider receive the same
exact features. (ex: Hospital A and B, who both utilize CHITS,
receive the same exact sets of features)
Table 6.
Units supplied by Competitors
18
Competitor Type Competitor Units
Direct Bizbox 6
Direct Comlogik 4
Direct iHOMIS 9
Direct eHATID LGU 2
Direct CHITS 2
Total 23
19
𝑆𝑢𝑝𝑝𝑙𝑦 𝐹𝑎𝑐𝑡𝑜𝑟 𝑋 =
𝑇𝑜𝑡𝑎𝑙𝐹𝑟𝑒𝑞𝑢𝑒𝑛𝑐𝑦 𝑁𝑢𝑚𝑏𝑒𝑟 𝑜𝑓𝑜𝑓
𝐻𝑜𝑠𝑝𝑖𝑡𝑎𝑙𝑠𝑆𝑢𝑝𝑝𝑙𝑦 𝑓𝑜𝑟 𝑆𝑢𝑝𝑝𝑙𝑖𝑒𝑑 𝐹𝑒𝑎𝑡𝑢𝑟𝑒 𝑏𝑦
𝑋 𝑜𝑓𝐶𝑜𝑚𝑝𝑒𝑡𝑖𝑡𝑜𝑟𝑠 𝐸𝑀𝑅 𝑌 ∗𝑛
Feature 1
Table 7.
Feature 1 Supply Factors
EMR SUPPLY FACTOR
Bizbox 0.2609
Comlogik 0.1739
iHOMIS 0.3913
CHITS 0.0870
Feature 2
Table 8.
Feature 2 Supply Factors
Bizbox 0
Comlogik 0
iHOMIS 0.3913
20
eHATID LGU 0
CHITS 0.0870
Feature 3
Table 9.
Feature 3 Supply Factors
Bizbox 0.2609
Comlogik 0.1739
iHOMIS 0.3913
eHATID LGU 0
CHITS 0
Feature 4
Table 10.
Feature 4 Supply Factors
Bizbox 0
Comlogik 0
iHOMIS 0
eHATID LGU 0
CHITS 0.0870
21
Feature 5
Table 11.
Feature 5 Supply Factors
Bizbox 0
Comlogik 0
iHOMIS 0.3913
CHITS 0
Feature 6
Table 12.
Feature 6 Supply Factors
Bizbox 0.2609
Comlogik 0.1739
iHOMIS 0.3913
eHATID LGU 0
CHITS 0
22
𝑃𝑟𝑜𝑗𝑒𝑐𝑡𝑒𝑑 𝑆𝑢𝑝𝑝𝑙𝑦 𝑜𝑓 𝐹𝑒𝑎𝑡𝑢𝑟𝑒 𝑋 = 𝑆𝑢𝑝𝑝𝑙𝑦
𝐹𝑎𝑐𝑡𝑜𝑟 𝑜𝑓 𝐹𝑒𝑎𝑡𝑢𝑟𝑒 𝑋 ∗ 𝑃𝑟𝑜𝑗𝑒𝑐𝑡𝑒𝑑
𝑃𝑜𝑝𝑢𝑙𝑎𝑡𝑖𝑜𝑛
Bixbox 11 11 11 12 12 13
Comlogik 7 8 8 8 8 9
iHOMIS 16 17 17 18 18 19
eHATID 4 4 4 4 4 5
LGU
CHITS 4 4 4 4 4 5
Feature 2
Table 14.
Feature 2 Projected Supply
Bixbox 0 0 0 0 0 0
Comlogik 0 0 0 0 0 0
iHOMIS 16 17 17 18 18 19
eHATID 0 0 0 0 0 0
LGU
CHITS 0 0 0 0 0 0
23
Feature 3
Table 15.
Feature 3 Projected Supply
Bixbox 11 11 11 12 12 13
Comlogik 7 7 8 8 8 9
iHOMIS 16 17 17 18 18 19
eHATID 0 0 0 0 0 0
LGU
CHITS 4 4 4 4 4 5
Feature 4
Table 16.
Feature 4 Projected Supply
Bixbox 0 0 0 0 0 0
Comlogik 0 0 0 0 0 0
iHOMIS 0 0 0 0 0 0
eHATID 0 0 0 0 0 0
LGU
CHITS 0 0 0 0 0 0
Feature 5
Table 17.
Feature 5 Projected Supply
24
2022 2023 2024 2025 2026 2027
Bixbox 0 0 0 0 0 0
Comlogik 0 0 0 0 0 0
iHOMIS 16 17 17 18 18 19
eHATID 4 4 4 4 4 5
LGU
CHITS 0 0 0 0 0 0
Feature 6
Table 18.
Feature 6 Projected Supply
Bixbox 11 11 12 12 12 13
Comlogik 7 8 8 8 8 9
iHOMIS 16 17 17 18 18 19
eHATID 0 0 0 0 0 0
LGU
CHITS 4 4 4 4 4 5
25
feature, with only one supplier, followed by appointment/consultation
schedule and reminder, with no supplier integrating it in their EMRs.
26
Figure 7. Feature 3 Gap Analysis Graph
27
Figure 10. Feature 6 Gap Analysis Graph
Based on the demand and supply gap analysis graphs, the demand for 5 out of
the six features is greater than that of the supply that is available – the only
exception is that of Feature 1 (Efficient Access to Specific Patient Information).
Although the first feature had more supply than that of demand, it is still important
to note that their access to patient information is only limited within their respective
hospital. Thus, sharing of accessible medical information between other hospitals
is still a feature that is absent from the current EMRs utilized by hospitals in Cebu.
The second, fourth, and fifth feature clearly does not have enough supply with
respect to its demand. Moreover, the third and sixth features show a small gap
between its supply and demand – with more of the latter than the former. With this,
the overall results show that the current substitutes have not completely satisfied
the demands of the target market yet, and such a gap may serve as a great
opportunity for CCMD to make its mark in the market and attract the right
customers.
28
Table 19.
Direct Competitors of CCMD
Features: EMR
dashboard,
Integrated with
HIMS,
Disease
Surveillance &
Control,
Simple &
Intuitive User
Interface, 24/7
Live Support,
Tailor-fitted
Implemented,
Money back
guarantee, 5
years software
warranty,
Compatible
with your
existing OS
29
web-based facilities marketing
30
Medical Info,
Vital Sign Graph,
ePrescription,
Receive &
Share Info,
Specialized
Note
Template,Vide
o Conference,
Data Trends,
full
integration, flexible
payment terms,
data integrity,
system
adaptability
Features:
Compliant with
DOH
Standards,
Package of
system
solutions such
as Admitting
System,
Outpatient
Department
31
System,
Emergency
Room
System,
Billing
System,
Medical
Records
Systems, and
Radiology,
among others,
Philhealth
eClaims
Systems
municipalitie newspaper
Features: s and cities feature;
Online & offline nationwide Partnered
mode, with DOST,
Surveillance ADMU, IPC,
tool for AJWCC,
notifiable and
32
diseases, PhilHealth
Communicatio
n tool for LGU
and its
healthcare
workers,
Predictive
analytics tool
using online
data
Features:
Integrated with
DOH &
PhilHealth,
User-friendly,
Portability &
Mobility,
Customizable,
Secure
2.4.2 Competitors Market Share
Table 20.
Direct Competitor’s Market Share
33
Competitor Competitor Units Market Share Type
Direct CHITS 2 9%
Total 23 100%
Table 20 shows the market share of each direct competitor of CCMD. The
market share for direct competitors is obtained by calculating the ratio and
proportion between the number of hospitals that are utilizing each competitor’s
service and the total number of hospitals utilizing the competitors’ services.
34
once online. This is a handy feature, most especially for healthcare service
institutions with intermittent or slow internet connections.
35
2.5.2 Promotional Aspect
2.5.2.1 Company Name
The company logo boasts a minimalist yet modern design that integrates
the use of basic geometric shapes. The logo plays with the shapes to try
and form the letters in the acronym “KUALA”. In addition, as
aforementioned, the word ‘kuala’ means the connection between two
bodies of water in the Malay language. Thus, the logo tries to depict such
an image through the use of intersecting lines. The colors used in the logo
are different shades of red to signify life, passion, and health. Blue was also
incorporated to signify trust, honesty, and dedication – values which the
company strives to prove to its consumers.
36
The name of the service offering is called Cebu Centralized Medical
Database (CCMD). As straightforward as it is, the service aims to provide
Cebu with a centralized medical record system; wherein relevant patient
information can be made accessible in any hospital within Cebu.
37
awareness will be the focus in this stage in order to successfully introduce the
service to the market. Considering that there are already existing EMRs in the
market, it will be trivial for CCMD to have a market share at this point. Since the
goal of CCMD is to provide a centralized medical database for the entire country,
sales and profit is expected to be minimal. For CCMD to position itself in the
market, the company must emphasize its service differentiation when pitched to
the target market.
In the growth stage, CCMD will already have established a market position
and its sales and profit are expected to increase. Areas for improvement will be
identified based on the data obtained from the introductory stage and solutions will
be provided by the company, which may include additional features. The goal of
CCMD at this stage is to achieve 30-50% of the supply.
As more hospitals are supplied with the CCMD software, a steady growth
of the market share can be observed. Even with this, promotional and marketing
efforts shall remain continuous especially in remote areas where information is not
readily accessible. Training and more information dissemination will also be done
at this stage.
38
2.6.3 Maturity Stage (4Ps and Captured Demand)
In the maturity stage, sales of CCMD are expected to peak and eventually
slow down. Competition will be intense at this stage and upgrades will be
necessary to maintain the company’s market share and retain its position in the
market. Additional CCMD features and innovations shall be introduced in this
phase to combat competition but still taking into consideration the feedback of the
current users of CCMD. A decrease in costs and prices will also be expected in the
maturity stage since the competitors entering the market are increasing in number.
2.7 Evaluation
Healthcare is a necessity in every area or location to improve the quality of life and helps
prevent diseases. The healthcare industry is something that must undergo constant
improvement to keep up with diseases and viruses that mutate as time progresses.
However, it is not only the medical procedures and operations that must innovate, its
record systems must continually improve as well. With better and more efficient record
39
systems, emergency response in the country would drastically be enhanced which would
in turn decrease the country’s mortality rate.
Seeing that there are multiple EMRs that are being utilized in the province, it is clear to
see that the paper-based systems which were traditionally used in hospitals for recording
medical data is taking a shift to an electronic-based record system. Seeing that the
majority of the features indicated are not being supplied adequately by competitors, there
is a huge chance that the software would be well-accepted by hospitals all over Cebu.
Aside from that, none of these EMRs provide access to patient information between
hospitals regardless of where these information were gathered. Upon the deployment of
the service, the company seeks to grab almost a 100% of the market share within Cebu
so that data storage and retrieval is centralized in all hospitals located in Cebu. The
company should devote the majority of its efforts in marketing the software to hospitals all
over Cebu seeing that it is a niche market. In the growth stage, talks with hospital heads
and directors must commence to introduce the service offered while highlighting the
differentiation that the service provides.
With that being said, the company is confident that CCMD can penetrate the market and
grab the majority of the market share should it be deployed.
40
3.1 Service Description
● Digital Medical Records of Patients - Medical facilities are able to input and store
medical records of patients including personal information (name, age, gender,
birthdate, nationality, blood type, occupation, address, contact numbers, email
address, and emergency contact person), and medical information (diagnosis,
chief complaints, referrals, diagnostic test results, allergies, immunization, family’s
medical history, medications & treatment, prescriptions, referrals, and billings). It is
important to note that these personal and medical information shall be processed
and used in accordance with the Data Privacy Act of 2012. Medical personnel
have limited and varied data accessibility as patients have the right to grant or deny
consent when asked by a medical personnel or authority;
● Secure and Encrypted Software - Tight data security measures are implemented
in the software to protect all patient information. Each user is given a unique
username and password and developers have integrated Veracrypt, a free open
41
source disk encryption software to prevent data breach and protect all stored
information;
● Data Accessibility - As priorly stated, medical personnel have limited and varied
data accessibility as patients have the right to grant or deny consent when asked
by a medical personnel or authorities in compliance with the Data Privacy Act of
2012. In case of emergency and no guardian is around, each facility is given an
emergency key password that grants access to patients' personal and medical
information (wherein both the emergency contact person and KUALA Analytics
Group will be notified of such scenario). Patients may also view their own medical
records using their own patient identification number and password;
● Billing Integration - Patients may view their electronic billing statements and other
transaction records. This feature enables hospitals to reduce the use of ink and
paper and consequently, and contribute in sustaining the environment;
● User-friendly Interface - The interface is designed in such a way that users may
easily and quickly navigate through the contents and activities that the application
offers;
42
● Help Desk - An ICT customer support representative is available 24/7 to address
technical problems encountered by the medical institutions. A mobile number and
email address is provided for in the bottom of each page of the application. There
is also a text box where users may input their feedback and experience while using
the app. This will serve as one of the basis for technical upgrades and
improvements; and
● Quick User Guide - A detailed user manual is included in the purchase of the
software application to guide users on how to use and navigate the software’s user
interface.
43
Figure 14. Flowchart on Availing CCMD
In availing the CCMD software access, the company will initially reach out
to medical institutions all over Cebu and set appointments. The meeting shall
include an agreement on the subscription plan, payment frequency and method,
terms and conditions, and contract signing. Interested customers who are inclined
to avail of CCMD before operations begin will be invited to the beta testing of the
software. Here, customers will have a general idea of how the software works, its
uses, and its potential on improving the overall healthcare system in Cebu. Should
the institution decide to avail of the company’s service and once the contract has
been settled, the CCMD team will begin setting up the institutional license to that
hospital. (See Appendices K and L for general contract details with the hospital and
their workers)
44
Figure 15. Flowchart on Log-in/Sign Up Process for Medical Personnel
45
purposes. It is important to note that the institution admin will have to verify its
workers who will be given worker accounts to the CCMD service. Aside from these
requirements, a government-issued or any valid identification card is also required
together with a self-portrait showing all facial features. For the verification of
accounts, the institution administrators are the sole officers that are authorized to
approve or decline newly created accounts. Approving of accounts shall be done
individually and very meticulously. Accounts that have failed to upload a clear photo
will be put on hold as well as a slight mismatch in the spelling. This is implemented
to ensure that accounts created are legitimate and that these account holders are
eligible in handling sensitive and confidential data. Once an account has been
verified, CCMD auto-generates a unique personal identification number. Then, the
user will log-in with his/her account details, which includes the identification number
provided by CCMD and the password they created. After login has been
successful, the user will be welcomed to the CCMD Homepage, which contains the
dashboard and main menu.
46
Figure 16. Flowchart on Log-in/Sign Up Process for Patients
As for the patients with no existing CCMD account, the medical facility
personnel catering them will be in-charge of creating a new account for them.
Personal information such as complete name, age, gender, contact number, and
address will be asked as part of creating an account. After the personal information
47
page has been filled out, CCMD will generate a unique patient identification
number and password. It is highly recommended that the password be changed by
the patient as soon as he/she logs-in. The patient’s identification number can be
searched and accessed by medical institutions utilizing CCMD. However, it is not
all the time that patient information and medical records can be accessed by
medical personnel. The users that are granted full and complete access to the
database are called “Super Users”. It is highly recommended that the Super Users
in an institution are the medical administrators and medical department heads only.
Other medical workers such as general physicians, nurses, medical technologists,
and sonographers only have limited control and access to data, and these users
are called “General Users.” This is done to prevent data breach and other forms of
costly errors.
To further ensure the safety and security of stored data, Super Users are
granted a control that enables them to monitor the activities of their medical
personnel within CCMD. This monitoring privilege must still be in coordination with
CCMD.
48
Table 21. Menu
Descriptions
Menu/Activities Description
Patient Registry This tab contains the list of all patient information.
This is where medical records can be inputted and
retrieved by inputting the patient ID number.
49
Search Bar The search bar is used to input keywords or
identification numbers a user would like to search
within CCMD.
be viewed here.
In creating a new record, medical personnel will have to access the patient
registry to add a new patient record. Consent from the patient to have his/her
information stored in CCMD shall be given prior to the collection of sensitive
information. Once the needed information is complete, the record will then be
saved and CCMD will generate a patient identification number for that certain
record. The same patient identification number will be used by the patient when
logging in to his/her account. For personnel that wish to retrieve a patient’s medical
record, he/she will secure consent from the patient then input the patient’s
identification number and his/her personnel password. Figure 17 below shows the
flow of creating and retrieving a patient’s medical record.
50
Figure 17. Flowchart on Creating/Retrieving a Patient’s Record
51
Overriding for Emergency Access
In case of a medical emergency and the patient is unconscious with no
companion or family member, the medical facility attending to the patient is granted
special access to the patient’s records with the use of an emergency key password.
Once a personnel has successfully accessed the patient’s record, an SMS will be
immediately sent to the patient’s emergency contact person informing of the
emergency details and the conducted emergency access.
52
Figure 19 below depicts the process flow when medical personnel inputs
the information obtained from the consultation on the Consultation tab or menu.
Prior to every information input process, a medical personnel should secure the
patient’s consent and input the name or Patient ID Number. After that, the medical
personnel can input the consultation information such as date, time, and chief
complaints. The physician’s name and clinic address will be automatically
displayed after the information has been saved. The process ends when the
personnel saves the newly encoded information, which requires entering his/her
personnel password.
53
Figure 20 below depicts the process flow when a personnel wishes to input
treatment details. This process usually happens when an admitted patient is given
medications or undergoing therapy. It starts with securing the patient’s consent and
inputting the patient’s ID number or name in the Treatment tab. The personnel will
then choose whether to add a new record or update an existing one. After choosing,
treatment details such as date, time, type of treatment given, location, remarks,
and other applicable details, they will be encoded. Once done, the personnel will
save the data by entering his/her personnel password.
54
consultation. The process begins by securing the patient’s consent and inputting
the patient’s ID number or name in the Prescriptions tab. After entering the patient’s
ID number, the personnel will click on the “New Prescription” button and encode
the prescribed medicine or drug in the first column. In the next column, the
personnel will encode other details such as quantity, dosage, and other
instructions. After encoding all the prescriptions made by the physician, the
personnel will then save the data by entering his/her password.
55
Laboratory tab. Then, the personnel will upload a scanned laboratory results and/or
manually encode laboratory results and remarks. The process ends when the
personnel saves the newly encoded results by entering his/her password.
Inputting Referrals
Figure 23 below depicts the flow when a personnel wishes to input the
referrals made. The process begins by securing the patient’s consent and inputting
the patient’s ID number or name in the Referrals tab. Then, the personnel will
encode the referral details which include the referred physician (if applicable) and
what kind of treatment or examination to be given. After that, the personnel will then
56
encode the name of the referring physician or the medical worker who made the
referral. The process ends when the newly encoded information has been saved
by entering the personnel’s password.
57
Desk tab and at the bottom of every page for convenience. Lastly, for writing
feedback, a text box is also available for users to type down their experience in
using the app or any sort of feedback. A 5-star option will also be displayed for
users to choose and rate the application.
58
3.3 Quality Management Process
For the company to be able to develop the software and perform all required
preliminaries prior to the launch of the application, an office space within the city is
required. The location has to be a sanitized environment with proper access to
electricity, internet connection, and clean water. The following QC requirements
are subcategorized according to the 4Ms (Man, Material, Machine, and Method).
● MAN:
Employee/Staff Requirements
Prior to hiring, potential employees must embody the skills and abilities
required for each position. These personnel must also fit the job description as
specified in the next few chapters. Job specifications must also be met by potential
employees before taking up the position. In the long run, employees must
accomplish certain objectives that are specified through strategic, tactical, and
operational goals. They must also observe proper work decorum in accordance
with the Labor Code. The full stack developer is responsible for the database
management/system.
Customer Requirements
Hospitals that seek to avail of the service must have access to electricity
and a stable internet connection. Aside from that, computer devices must be
present within the facility. Customer inputs are gathered quarterly to acquire
suggestions for improvement to allow a more user-friendly experience when using
the software. Proper data privacy and usage must be observed by all customers
as specified in the Data Privacy Act of 2012. Medical practitioners that are
supposed to use the software must be equipped with the necessary skills to
operate the program such as proficiency in using the software.
Patient Requirements
59
The software is available for use to all types of patients. Patients must
exercise proper and appropriate use of the system as specified in the user manual.
● MACHINE:
Machine Requirements (Company)
When purchasing the machines to be utilized in the company, the transaction
would be conducted in stores since the quantity required for each machine is not
too great. Thus, it eliminates the need for a supplier agreement for the procurement
of the machines. When certain errors or problems occur, the company must contact
the service center of the product manufacturer for proper troubleshooting or any
warranty issue. Maintenance sessions for the machines to be used differ
depending on the type of machine and would be conducted by the respective
service centers. These maintenance are administered in the office regularly
according to the maintenance schedule which would be specified in the later
chapters.
Software Requirements
● Functional Stability
Functional stability represents the degree to which the service provides
functions that meet the implied needs when used under specified
conditions. The sub-characteristics of this characteristic are functional
completeness, functional correctness, and functional appropriateness. The
set of functions in the service must cover all the specified tasks and user
objectives. The system must provide the correct results with the needed
degree of precision. Lastly, the system must be able to carry out the
60
requirements that are needed for the different usage objectives that have
been specified.
Therefore, results from filters and searches must be accurate and loading
time must be kept at a minimum. Furthermore, bugs and crashes must not
occur while navigating the system. If so, an immediate remedy must be
presented following the occurrence of the problem.
● Portability
The system must be able to run properly in a different platform to the one
it was designed for with little or no modification. The software must be
developed in a way that it is compatible with both Windows and Mac OS.
Consequently, the application must be developed to be available in Google
Play Stores and Apple App Stores for it to be compatible with its
corresponding operating systems.
61
Menus and other icons must be situated in areas where they are easy to
locate and differentiate. It must embody a sense of familiarity and
consistency for users to develop usage patterns. The design must also be
pleasing to the eye to attract users which allows them to look forward to
using the software.
● Security
Software security is important to ensure that the software is protected
against malicious attacks and other hacker risks so it can function properly
under such potential risks. The importance of security must not be
overlooked since it keeps information protected and prevents viruses and
malware.
Since the service offered is a medical database, there is an increased risk
of hacking and unauthorized access. Multi-Factor Authentications will be
implemented for users of the application to improve security and reduce
fraud. For the hospital staff to access medical information gathered from
different facilities, a unique username and password must be inputted from
the patients. In a similar way, patients can only view their own or other’s
medical information if they know the username and its corresponding
password. In the office, only the developers or analytics team are granted
access to the information being inputted to the database. The only
permissible kinds of medical data that may be inputted and accessed in the
medical database are history of past illnesses, family history of past
illnesses, history of present illnesses, clinical history, allergies, medication
history, laboratory results, and treatment outcome.
● Update Frequency
Update frequency denotes the frequency at which updates will be provided
by the licensor to the licensee. These might include repairing security holes
that have been discovered and fixing or removing computer bugs. These
updates may also lead to new features to be integrated into the software
and removing outdated ones.
62
CCMD must have updates at least every other month to keep the software
fresh and adaptive to market trends while not overwhelming users. These
updates must be focused on the optimization of the software by removing
bugs that are discovered by the developers or the users themselves,
reducing waiting time, strengthening security measures, and so much
more. Total Quality Management must be integrated into the software to
keep up with the evolving needs of users. This way, the service provided is
able to consistently deliver what is expected, or even more, to the end
users.
● Communication Channel
During the initial stage of using the software, problems are bound to occur
due to unfamiliarity of the system. Technical concerns may transpire from
time to time and when left unaddressed, it may cause a halt in hospital
operations. Thus, a clear and responsive communication channel must be
administered to tend to each user’s complaint as quickly as possible.
63
your services while gaining maximum satisfaction. Thus, CCMD has specific and
concise procedures to ensure the quality of the service provided.
● METHODS:
Employee/Staff Procedures
Following the release or announcement of job openings, applicants are able
to submit their resume through email. Each applicant is interviewed and evaluated
to guarantee their skills and capabilities on the responsibilities and tasks they
would assume. These would be confirmed using tests such as a job knowledge
test, integrity test, cognitive ability test, emotional intelligence test, and skills
assessment test. After the said tests, a second interview is conducted to gauge the
capability of potential employees. Following that, new applicants are contacted
through email to notify them of their acceptance in the position they applied in after
careful deliberation of the human resources department. Constant workshops and
seminars are organized to ensure that the skills and abilities of company
employees are up to par. Proper benefits, compensation, and teambuilding
activities would also be organized to improve employee satisfaction, thus
increasing employee retention. A 360-degree feedback system is utilized to
evaluate employee performance every other month. When certain employees fail
to meet the objectives, they are scheduled to meet with supervisors to discuss what
to do to improve performance. If employees still fail to perform despite having
discussions with management or for a ‘just’ cause, their employment will be
terminated in compliance with the Labor Code. A code of conduct (see Appendix
O) will also be implemented for all employees to adhere to wherein violations of
such may result in termination. Notice of termination forms are handed out to
employees that will be terminated (see Appendix P).
64
representatives. Hospitals and patients that violate data privacy rules are
reprimanded for their behavior through a warning (depending on the gravity of the
offense). If the same actions are repeated, their membership/license are
terminated and may be punished by law. Breach of contract notices are sent to
customers that violate the terms and conditions (see Appendix M).
Material Tests
Materials such as furniture and fixtures are canvassed from multiple
suppliers to attain the highest quality possible. Quality reports would be made
available for each material purchased to ensure that it is top-quality merchandise
(see Appendix Q). These reports would be filed by company personnel prior to
purchasing. All quality reports of the same materials would then be compared with
each other to choose the best option. Quality inspections would be implemented
upon receiving the ordered item to make sure that there are no defects present.
Software Tests
● Functional Testing
Through functional testing, pieces of software are able to be tested if they
are acting in accordance with predetermined requirements. In this test,
inputs are fed to the system and the outputs are examined. This way, the
company is able to verify if the software’s features as introduced
beforehand work according to the requirements. Tests such as smoke
testing, sanity testing, and component testing comprise the sets of tests
belonging to the functional stability of the software. Through these tests,
initial checks on whether the new software is functionally stable, new
functionality or bug fixes are validated, and individual parts of an application
are checked. (see Appendices N and S for templates)
● Performance Testing
Software performance testing is conducted to determine how a system
performs in terms of responsiveness, stability, scalability, and resource
usage. Through this test, all performance bottlenecks could be identified
and eliminated. The focus of this test is to determine whether the
application responds quickly, if the application is stable, and the maximum
65
load the software can handle. Determining which component fails first, the
ability to handle sudden volume increases, the application’s performance
under high numbers of users, and the performance of the system under
load over time is the main focus of these tests through the conduction of
stress testing, spike testing, load testing, and endurance testing.
● Cross-platform Testing
The software or program is tested across various platforms to ensure that
it functions properly on all of them. Problems that may occur in numerous
platforms such as consistency and performance problems would be
addressed through this test. Environment conditions are also taken into
consideration since these may impact the web and mobile applications.
● Security Testing
Security tests reveal all potential vulnerabilities and threats in a software
application and prevent malicious attacks. Data privacy and security must
be of utmost priority in softwares, more so in a database type of application.
Vulnerability scanning, penetration testing, security auditing, and posture
assessment would be implemented to identify the weakness of the network
and system while providing an overall security posture of the software.
66
Accessing Patient Information (Emergency)
Data Breach
67
All social media platforms that would be utilized to contact the company
must be verified prior to software deployment. This is to ensure that
consumers may contact the company at all times should they have any
issues or concerns that must be addressed. All phone lines should also be
tested to guarantee that there are no problems on the telephone lines that
may hinder the communication channels. When customers have
complaints or concerns to be addressed, they may issue a ticket through
the website or app that would be attended to immediately by the customer
service representative. Ticket templates are attached in the appendices.
3.4.1 Schedule
68
important to consider the design of the space especially with regards to the
location’s capacity. Generally, the space will be utilized to cater customer
service needs and to run its general operations. Thus, for the capacity and
size design, it is most essential to look into the following specifications:
IT Department
The IT Department houses the employees involved in the
information technology aspect of the service. According to
Matheney (n.d.), 7 sq. meters of space is the minimum requirement
for an employee – especially in a co-working environment. With this,
the computers and chairs needed for the department will also be
taken into consideration for the space allotment. The IT Department
will be strategically located beside the Server & Electrical Room for
security and efficiency purposes.
69
Office Floor Space
The size of the commercial office space will be the leading factor in
whether or not the location is a viable option or not. Taking into
consideration the space requirements mentioned above in the Capacity
and Size Design, the proponents calculated that a minimum floor space of
200 sq. meters requirement will be put into place when looking for potential
spaces. Thus, any available commercial space that does not meet the said
requirement will not be considered.
Number of Employees
Subsequently, the company also has to take into consideration how
many employees stay in the office. More specifically, how many employees
would be present at each shift, and whether or not the office space would
be sufficient enough to accommodate all of them. Although, having more
employees may not necessarily mean a need to increase the floor space
since shifts will be put into place. Furthermore, most of the employees who
will be present during the night shifts would only be the customer service
representatives and program developers/technicians.
With that being said, the system capacity plan is used to determine the
quantity of supplies, human resource, and space needed for the system to function
properly and continue to provide good quality service directly to the customers. The
factors stated above will allow the company to properly plan the layout of the
headquarters so that all necessary machines and equipment may be situated
accordingly. Since the application or software is meant to operate uninterruptedly,
the right number of employees must also be selected so that in cases of
70
emergencies or technical issues, someone would be able to address it immediately.
Thus, hospital operations may resume without unnecessary hindrances.
Prior to the several factors that may potentially affect the service capacity
of the software, the captured demand must be obtained. This can be done by
assessing the yearly demand of CCMD in the first five years of operation. To recall,
such demand was calculated in the marketing chapter of this study. This yearly
demand is in terms of the number of hospitals in Cebu that would avail and acquire
our software license to their own respective institutions. The following values are
obtained based on two data: (1) projected population of hospitals in Cebu, and (2)
survey results acquired in the Marketing chapter that corresponds to the
willingness of hospitals to avail of our service.
Table 22.
Annual Demand of CCMD
CCMD Demand (# of Hospitals)
Government Private Government Private Government Private Government Private Government Private
14 23 14 24 14 25 15 26 15 26
Upon recognizing the number of hospitals that seek to avail of the service,
the assumed average number of worker accounts that each hospital is licensed for
is multiplied with the total number of hospitals to get the monthly captured demand.
This value is then used to acquire the monthly captured demand. The following
assumptions are:
● The average number of worker accounts per hospital license is 40
in the year 2023, with a 5% increase biennially.
● Every worker account calls CCMD’s customer service once a
month.
With the monthly captured demand, the daily demand can be calculated on
the basis that CCMD’s customer service operates every day 24/7. Thus, the
captured demand for the first five years on a daily basis is as follows:
71
Table 23.
Captured Demand of CCMD
Captured Demand
Service Life
Year
Cycle
Monthly Daily
Introduction 1,480 49
2023
Stage
2024 1,520 51
Growth Stage
1,638 55
2025
1,722 57
2026
1,808 60
2027
72
● There are three shifts in a day
𝑁𝑜. 𝑜𝑓 𝐸𝑚𝑝𝑙𝑜𝑦𝑒𝑒𝑠
𝑆𝑡𝑎𝑛𝑑𝑎𝑟𝑑 𝑇𝑖𝑚𝑒 𝑥 𝐷𝑎𝑖𝑙𝑦 𝐶𝑎𝑝𝑡𝑢𝑟𝑒 𝐷𝑒𝑚𝑎𝑛𝑑
= ()(𝑁𝑜. 𝑜𝑓 𝑆ℎ𝑖𝑓𝑡𝑠 𝑖𝑛 𝑎 𝐷𝑎𝑦)
𝑊𝑜𝑟𝑘𝑖𝑛𝑔 𝑇𝑖𝑚𝑒 𝑥 𝑀𝑎𝑛𝑝𝑜𝑤𝑒𝑟 𝐸𝑓𝑓𝑖𝑐𝑖𝑒𝑛𝑐𝑦
𝑆𝑡𝑎𝑛𝑑𝑎𝑟𝑑 𝑇𝑖𝑚𝑒 𝑥 𝐷𝑎𝑖𝑙𝑦 𝐶𝑎𝑝𝑡𝑢𝑟𝑒 𝐷𝑒𝑚𝑎𝑛𝑑
𝑁𝑜. 𝑜𝑓 𝐸𝑚𝑝𝑙𝑜𝑦𝑒𝑒𝑠 = ()(3 𝑠ℎ𝑖𝑓𝑡𝑠)
480 𝑚𝑖𝑛𝑢𝑡𝑒𝑠 𝑥 85%
2023 49 6 1:9
2024 51 6 1:9
2025 55 7 1:8
2026 57 7 1:9
2027 60 7 1:9
The data above on the ratio can be interpreted as the following example: In the
year 2023, 1 customer service representative handles 9 customer calls in a day
(Ratio of 1:9). It is important to note that since the company and its service runs
73
24/7 without interruptions, 3 shifts are to be deployed. Thus, a total of 6 customer
service representatives are to be hired in order for operations to run smoothly.
For the company to be able to perform its operations and deliver superior
service, the employees must know how things will be done within the organization
- including who does what and who answers to whom. The organizational chart
below displays the three major functional departments for CCMD.
74
Chief Executive Officer (CEO)
The Chief Executive Officer of the company is in charge of managing the
company’s overall operations. These operations include making important
decisions, setting the culture of the company, maintaining capital for the business,
and managing risk among others.
Chief Financial Officer (CFO)
The Chief Financial Officer is in charge of the Finance and Accounting Team in the
company. The team is in charge of ensuring the adequate and timely provision of
the funds for the operations of the business. Furthermore, the team is responsible
for providing accounting services and managing the finances of the company.
3.5.2 Headcount
Upon successfully completing the organizational chart, it is important to
identify the number of employees working in each department. Through this metric,
the company is able to assess workforce growth and ensure that there are enough
resources for each employee. The table below shows each position in the company
and the corresponding number of employees necessary to assume each role or
responsibility. Note, that this headcount is based on the manpower requirement for
the year 2023.
75
Table 25.
Headcount Table
Positions Headcount
Financial Accountant 1
Management Accountant 1
Internal Auditor 1
Marketing Manager 1
Marketing Analyst 1
Creative Director 1
Graphic Designer 1
Staffing Personnel 1
Development Representative 1
Backend Developers 6
Frontend Developer 1
For the first year of operation, 31 employees are required to run the
business. In every shift, a backend developer and customer service representative
must be present. Since data comes to the system every minute, a backend
76
developer must be available at all times to handle data storage. Customer service
representatives must also be present to address the concerns of customers
whatever it may be. More backend developers and customer service
representatives are assigned on Mondays, Thursdays, and Fridays since these are
the days in the week when hospitals are the busiest or when the most number of
patients come to avail of medical services. Thus, there is an increase in data traffic
which requires more manpower than the other days. Now that the number of
employees required for each position in each department is determined, the next
step would be identifying the shifts of each employee. Among the departments in
the company, the Marketing, Human Resources, and Accounting/Finance Team
would be working for 8 hrs in a normal work shift from Monday to Friday. The
software development team (customer service representative and backend
developers), however, would be working 24 hrs with varying shifts depending on
the employee. For every shift, two paid 15-minute breaks must be observed.
Furthermore, considering that there needs to be at least 1 attending backend
developer in every shift, it was found that 6 backend developers would be needed
in total. The table below illustrates the shift of each employee throughout the day.
A subsequent table would then follow illustrating the scheduling of the employees.
(See Appendix T for the detailed table on the employee shifts).
Table 26.
Scheduling of Employees
77
Table 27.
Job Description Table
The Chief Financial Officer is the overall head of the financial department and
reports directly to the Chief Executive Officer.
78
Monthly Work Activities:
● Responsible for preparing, interpreting, and analyzing financial reports for
monthly, quarterly, and annual accounting periods
Internal Auditor
The Internal Auditor is responsible for conducting regular analyses of all financial
transactions to ensure accountability in the business.
79
Monthly Work Activities:
● Approaches hospital representatives to introduce the market
● Analyze the company’s marketing strategy and suggest improvements
● Create and present the monthly marketing plan and strategy
Marketing Manager
Marketing Analyst
80
Daily Work Activities:
● Perform valid and reliable market research SWOT analysis
● Gather and analyze statistical data using modern and traditional methods
Creative Director
Graphic Designer
81
The Graphic Designer creates visual concepts to communicate ideas that inspire,
inform, and captivate customers.
82
The Human Resources Manager leads and directs the routine functions of the
Human Resources department including hiring and interviewing staff,
administering pay, etc.
The Human Resources Staff is responsible for managing every aspect of the
employment process including orientation and training new staff members.
83
Monthly Work Activities:
● Develop training and development programs
● Review employment and working conditions to ensure legal compliance
Developer
84
Daily Work Activities:
● Full stack developer is in charge of the developers
● Directing system testing and validation procedures
The Quality Assurance Engineer is responsible for ensuring that products and
services meet the established standards set by the company.
85
Customer Service Representative
The Customer Service Representative helps customers with complaints and
questions, give information about products and services, take orders, and
process returns.
86
3.6 Machine Requirement & Specification
3.6.1 Primary Machines & Equipment
Table 28.
Primary Machines & Equipment
1. Desktop Computer
Specifications: Intel core i3-10100, H510M-A
Motherboard, 8GB 2666MHz Ram, 512GB SSD, 19” LED
Monitor, USB Keyboard + Mouse Combo
Supplier: PC Express
Supplier Details
● Address: Central Bloc, V. Padriga St, Cebu City
● Contact Number: 0919 075 0619
Quantity: 12
2. HP All-in-one printer
Specifications: HP Deskjet Ink Advantage 3776 Printer
(#680 BLK/CLR) Print, copy, scan, wireless
Supplier: Octagon
Supplier Details
● Address: 2nd Level, SM City Cebu
● Contact Number: (032) 256 7152
87
Alternative Supplier Details
● Address: Ayala Malls Central Bloc, V. Padriga St.,
Cebu IT Park
● Contact Number: (032) 326 9433
Quantity: 5
3. Monitor
Specifications: HP 18.5 inch Computer Monitor, HD 1366 x
768 @ 60 Hz
Supplier Details
● Address: Osmeña Blvd, Cebu City
● Contact Number: (032) 253 8175
Quantity: 1
Supplier: Asianic
88
Supplier Details
● Address: Stall 207 2/F Cyberzone, SM Mall Of
Asia, Central Business Park Pasay City ●
Contact Number: (02) 8234-1733
Quantity: 2
Supplier Details
● Address: SM City Cebu, Juan Luna Ave.,Cebu
City
● Contact Number: (032) 416 8388
Quantity: 4
Table 29.
Auxiliary Equipment
89
1. CCTV Specifications: 2MP HDCVI Bullet Camera Starlight,
120dB true WDR, 3DNR, Max 30fps@1080P, HD and SD
dual-output
Supplier: CebuCCTV
Supplier Details
● Address: Ouano Ave, Tipolo, Mandaue City ●
Contact Number: 0975 325 1385
Quantity: 14
Supplier Details
● Address: Unit 3, ZR&DC Bldg. Acacia corner, C.
Rosal St, Cebu City
● Contact Number: (032) 254 2492
90
Price: Php 12,900
Quantity: 1
3.
Specifications: TOTEN Professional 42U Server Rack –
42U, 19″ (W800 x D1000 x H2055mm) G3.8042.9801.
with Split Door
Supplier Details
● Address: Manila Rd., National Highway, Batac
City, 2906 Ilocos Norte
● Contact Number: (077) 600-5838
Server Cabinet
Alternative Supplier: IT World
Quantity: 2
Supplier Details
● Address: Unit 113, TPI Bldg., Rizal Ave. Ext, Cor
9th Ave, Grace Park West, Caloocan, 1400 Metro
Manila
● Contact Number: (02) 8361 1902
91
Alternative Supplier Details
● Address: Unit 217A 2nd Flr. AD Center Square
Bldg. E. Amang Rodriguez Ave., Santolan, Pasig
City, Pasig
● Contact Number: 0932 793 7317
Quantity: 1
Supplier Details
● Address: Unit 113, TPI Bldg., Rizal Ave. Ext, Cor
9th Ave, Grace Park West, Caloocan, 1400 Metro
Manila
Power Distribution Unit ● Contact Number: (02) 8361 1902
Quantity: 1
92
Supplier Details
● Address: Osmeña Blvd, Cebu City
● Contact Number: (032) 416 8388
Quantity: 1
Supplier: Benson
Supplier Details
● Address: Ground Floor, Philplans
● Corporate Center Bldg., Corner Kalayaan Ave. &
11th Ave., Fort Bonifacio Global City, Taguig City
● Contact Number: 0926 7104007
Quantity: 1
93
8. MTP Adapter Panel Specifications: FHD Fiber Adapter Panel (Color-coded),
OS2/OM3/OM4, 12 x MTP®-24 Key Up to Key Down
(Red) Adapter
Supplier: FS
Supplier Details
● Address: 30A Kallang Pl, #11-10/11/12 Singapore
● Contact Number: +(65) 6443 7951
Quantity: 1
9. MTP Fiber Patch Panel Specifications: FHU 1U 19'' Fiber Adapter Panel, 48
Fibers OS2 Single Mode, 24 x SC UPC Duplex (Blue)
Adapter, Ceramic Sleeve
Supplier: FS
Supplier Details
● Address: 30A Kallang Pl, #11-10/11/12 Singapore
● Contact Number: +(65) 6443 7951
94
Quantity: 1
Supplier: RS PRO
Supplier Details
Quantity: 1
Supplier Details
● Address: Wired Systems Corporation, Unit 14 St.,
Patrick's Square, R Aboitiz St. Cebu City ● Contact
Number: (032) 255 5282
95
Alternative Supplier Details
● Address: Unit 217A 2nd Flr. AD Center Square
Bldg. E. Amang Rodriguez Ave., Santolan, Pasig
City, Pasig
● Contact Number: 0932 793 7317
Quantity: 1
Table 30.
Office Supplies
1. Ballpen Specifications: Faber Castell Ballpoint Stick 0.5MM
Black
Supplier Details
● Address: 2nd Floor, Ayala Center Cebu, Cebu
City
● Contact Number: (032) 231 4005
Quantity: 60
96
Supplier: National Bookstore
Supplier Details
● Address: 2nd Floor, Ayala Center Cebu, Cebu
City
● Contact Number: (032) 231 4005
Quantity: 120
Supplier Details
● Address: 2nd Floor, Ayala Center Cebu, Cebu
City
Quantity: 5
97
4. Scissors Specifications: Scotch Multi-Purpose Scissors 7 Inches
Pointed Precision with Tape 500
Supplier Details
● Address: 2nd Floor, Ayala Center Cebu, Cebu
City
● Contact Number: (032) 231 4005
Quantity: 5
Supplier Details
● Address: U/GF SM City Cebu, Cebu City
● Contact Number: 0917 892 2348
98
Quantity: 2
6. Short Bond Paper Specifications: Hard Copy Short Bond Papers 70 gsm,
500 sheets
Supplier Details
● Address: 2nd Floor, Ayala Center Cebu, Cebu
City
● Contact Number: (032) 231 4005
Quantity: 6 reams
7. Long Bond Paper Specifications: Hard Copy Long Bond Papers 70 gsm,
500 sheets
Supplier Details
● Address: 2nd Floor, Ayala Center Cebu, Cebu
City
● Contact Number: (032) 231 4005
99
Alternative Supplier: Visayan Educational Supply
Corporation
Quantity: 6 reams
Supplier Details
● Address: 2nd Floor, Ayala Center Cebu, Cebu
City
● Contact Number: (032) 231 4005
Quantity: 15
100
Supplier: National Bookstore
Supplier Details
● Address: 2nd Floor, Ayala Center Cebu, Cebu
City
● Contact Number: (032) 231 4005
Quantity: 15
Supplier Details
● Address: 2nd Floor, Ayala Center Cebu, Cebu
City
● Contact Number: (032) 231 4005
Quantity: 2
101
11. Glue Specifications: Elmer’s Multipurpose Glue 473ml
Supplier Details
● Address: 2nd Floor, Ayala Center Cebu, Cebu
City
● Contact Number: (032) 231 4005
Quantity: 10
Supplier Details
● Address: 2nd Floor, Ayala Center Cebu, Cebu
City
● Contact Number: (032) 231 4005
Quantity: 15
102
13. Printer Ink
Specifications: HP 680 Black and Tricolor Original Ink
Advantage Cartridge Package
Supplier: Octagon
Supplier Details
● Address: 2nd Level, SM City Cebu
● Contact Number: (032) 256 7152
Quantity: 15
Supplier Details
● Address: 2nd Floor, Ayala Center Cebu, Cebu
City
● Contact Number: (032) 231 4005
103
Quantity: 10
Supplier Details
● Address: Ylaya, Talamban, Cebu City
● Contact Number: 0943 707 6201
Quantity: 10
Table 31.
Furniture & Fixtures
1. Water Dispenser Specifications: Hanabishi Table Type Water Dispenser
– Hot & Cold
Supplier Details
● Address: 2/F, Robinsons Galleria Cebu, General
Maxilom Avenue corner Sergio Osmena
Boulevard, Barangay Tejero, Cebu City
104
Alternative Supplier: Cebu Appliance Center
Quantity: 1
Supplier Details
● Address: Osmeña Blvd, Cebu City
● Contact Number: (032) 416 8388
Quantity: 9
Supplier Details
● Address: Osmeña Blvd, Cebu City
● Contact Number: (032) 416 8388
105
Alternative Supplier: SM Appliance Center
Quantity: 3
Supplier Details
● Address: Osmeña Blvd, Cebu City
● Contact Number: (032) 416 8388
Quantity: 1
Supplier Details
● Address: SM City Cebu, Cebu City
● Contact Number: (032)231 3451
106
Alternative Supplier: Cebu Appliance Center
Quantity: 1
Supplier Details
● Address: SM City Cebu, Cebu City
● Contact Number: (032)231 3451
Quantity: 1
Supplier Details
● Address: Hernan Cortes Street, Mandaue City
● Contact Number: (032) 343 8802
107
Alternative Supplier: Office Furniture Cebu
Quantity: 20
Supplier Details
● Address: Hernan Cortes Street, Mandaue City
● Contact Number: (032) 343 8802
Quantity: 24
9. Office Chair
Specifications: Ergonomic, Butterfly Mechanism = 360
Degree Swivel , Seat Height Adjustable, Tilt & Lock
108
Supplier Details
● Address: Gov. M. Cuenco Ave, Cebu City
● Contact Number: (032) 232 2984
Quantity: 30
Supplier Details
Conference Table ● Address: Hernan Cortes Street, Mandaue City
● Contact Number: (032) 343 8802
Quantity: 1
109
11. Supplier: Mandaue Foam
Supplier Details
● Address: Hernan Cortes Street, Mandaue City
● Contact Number: (032) 343 8802
Quantity: 1
Supplier Details
● Address: 001 B Carlos Street Corner Dizon Brgy
San Bartolome Novaliches Quezon City Metro
Manila
● Contact Number: (+63) 0919 0674453
Quantity: 1
110
13. Pantry Set Specifications: Geoffrey 4 Seater Dining Set
Supplier Details
● Address: Hernan Cortes Street, Mandaue City
● Contact Number: (032) 343 8802
Quantity: 1
Supplier Details
● Address: Hernan Cortes Street, Mandaue City
● Contact Number: (032) 343 8802
Quantity: 1
111
15. CEO Office Chair Specifications: Mc Coy High Back Office Chair 360
Degree Swivel Adjustable Height
Supplier Details
● Address: Hernan Cortes Street, Mandaue City
● Contact Number: (032) 343 8802
Quantity: 1
Supplier Details
● Address: A. S. Fortuna St, Mandaue City
● Contact Number: (032) 230 3777
Quantity: 29
112
17. Circular Fluorescent Lamp Specifications: FireFly Circular Fluorescent Lamp
Daylight T9, 12” (32W)
Supplier Details
● Address: U/GF SM City Cebu, Cebu City
● Contact Number: 0917 892 2348
Quantity: 7
Supplier Details
● Address: 4780 Ortigas Avenue Extension,
● Pasig City, Metro Manila
● Contact Number: 0912 559 9274
113
Quantity: 6
19. T5 LED (Wall Mounted) Specifications: Firefly Basic LED T5 Tube 1.2M 16W
DE Warm White, 15000 Life Hours
Supplier Details
● Address: U/GF SM City Cebu, Cebu City
● Contact Number: 0917 892 2348
Quantity: 3
20. Low-Wattage LED Light Bulbs Specifications: Philips LED Light Bulb 4W (25W) Warm
white 220-240V, Very low energy Consumption
Supplier Details
● Address: U/GF SM City Cebu, Cebu City
● Contact Number: 0917 892 2348
114
Quantity: 4
Table 32.
Sanitary and Safety Tools
1. Tissue Specifications: Sanicare Bathroom Tissue 3ply 200pulls
12s
Supplier: SM Supermarket
Supplier Details
● Address: Juan Luna Avenue, North Reclamation
Area, Cebu City, Cebu
● Contact Number: (02) 8232 6144
Quantity: 10
Supplier: SM Supermarket
115
Supplier Details
● Address: Juan Luna Avenue, North Reclamation
Area, Cebu City, Cebu
● Contact Number: (02) 8232 6144
Quantity: 3
3. Liquid hand soap Specifications: Safeguard Liquid Hand Soap Pure White
450ml
Supplier: SM Supermarket
Supplier Details
● Address: Juan Luna Avenue, North Reclamation
Area, Cebu City, Cebu
● Contact Number: (02) 8232 6144
Quantity: 4
116
4. Alcohol Specifications: GreenCross Isopropyl Alcohol 70%
Solution with Moisturizer 1 Liter
Supplier: SM Supermarket
Supplier Details
● Address: Juan Luna Avenue, North Reclamation
Area, Cebu City, Cebu
● Contact Number: (02) 8232 6144
Quantity: 2
Supplier: SM Supermarket
Supplier Details
● Address: Juan Luna Avenue, North Reclamation
Area, Cebu City, Cebu
● Contact Number: (02) 8232 6144
City
● Contact Number: (032) 243 4004
117
Price: Php 265.00
Quantity: 1
Supplier: SM Supermarket
Supplier Details
● Address: Juan Luna Avenue, North Reclamation
Area, Cebu City, Cebu
● Contact Number: (02) 8232 6144
Quantity: 1
Supplier: SM Supermarket
Supplier Details
● Address: Juan Luna Avenue, North Reclamation
Area, Cebu City, Cebu
● Contact Number: (02) 8232 6144
118
Alternative Supplier Details
● Address: G/F Metro Ayala Center Cebu, Cebu
Business Park, Archbishop Reyes Ave, Cebu
City
● Contact Number: (032) 243 4004
Quantity: 4
Supplier Details
● Address: Gov. M. Cuenco Ave, Cebu City
● Contact Number: (032) 232 2984
Quantity: 8
Supplier: SM Supermarket
Supplier Details
● Address: Juan Luna Avenue, North Reclamation
Area, Cebu City, Cebu
● Contact Number: (02) 8232 6144
119
Alternative Supplier: Metro Supermarket
Quantity: 24
Supplier: SM Supermarket
Supplier Details
● Address: Juan Luna Avenue, North Reclamation
Area, Cebu City, Cebu
● Contact Number: (02) 8232 6144
Quantity: 3
Supplier: SM Supermarket
120
Supplier Details
● Address: Juan Luna Avenue, North Reclamation
Area, Cebu City, Cebu
● Contact Number: (02) 8232 6144
Quantity: 2
Supplier: SM Supermarket
Supplier Details
● Address: Juan Luna Avenue, North Reclamation
Area, Cebu City, Cebu
● Contact Number: (02) 8232 6144
Quantity: 3
121
13. Fire Extinguisher Specifications: Fire Extinguisher, 9kg
Supplier Details
● Address: 795 Dionisio Jakosalem St., Cebu City
● Contact Number: (032) 255 7839
Quantity: 2
122
Computer and Printer Maintenance
The computers are serviced every 6 months in order to keep them operating
at optimal speed. On the other hand, printers are serviced annually. Regular
computer and printer maintenance can help detect issues early before they
become a serious problem. Additionally, it can assist in ensuring that the antivirus
program is up-to-date and operating properly, and that the computer's files are
optimized. Computers and printers tend to slow down when they reach a certain
point, so regular maintenance can help them perform more efficiently. When a
computer is not maintained, dust and debris can accumulate and lead to
performance issues. With that, the company will be outsourcing iSolve Computer
Repair for such services.
Like most equipment, air conditioning units will gradually start to experience
minor issues that, if not detected early enough, can turn into more serious, costly
repairs. Its effectiveness may significantly decline as a result of such issues.
Regular maintenance of twice a year will keep the air conditioning units in the office
operating at maximum efficiency and optimal performance while keeping costs to
a minimum. Another advantage of having effective air conditioning maintenance is
that it extends the life of the equipment, preventing the company from having to
pay a high price for electricity and a replacement unit in the future. With that being
said, the company will be outsourcing EJS Multivector Solutions Inc. and GAB
Airconditioning for such services.
Table 33.
Maintenance Scheduling
123
3.7 Headquarters Location
And after careful deliberation, the proponents of Cebu Centralized Medical Database
(CCMD) have collectively agreed to rent an office space for its headquarters instead of
constructing a building from the ground-up. The proponents took into consideration the
expensive costs it would entail to construct a building from scratch. Through renting an
office space, the company does not have to be tied to the location and maximum flexibility
can be achieved. Furthermore, the company is still young and is still subject to anticipated
growth; thus renting would be a much more logical option in the short-run as to make
location changes in the future much more convenient should the company see a need to
expand.
124
employees and all the necessary resources. The three potential office spaces are
shown in the table below:
Table 34.
Alternative sites for KUALA Analytics
Group’s headquarters
Alternative Address Floor Area (sq. Monthly Rental
m)
Alternative A:
125
Monthly Rental: P172,000
Turn-over Condition: Warm shell
Minimum Lease Term: 3 years
Lease Inclusions:
● 24/7 Security and CCTV
● 100% Emergency power supply system
● Fire detection and alarm system
● Five passenger elevators
● One service elevator
● Ample parking spaces
● Common M/F restroom at every room
Note: Electricity and water consumption is not included in monthly rent
Alternative B:
126
Minimum Lease Term: 2 years
Lease Inclusions:
● 24/7 Security and CCTV
● Reception area
Note: Electricity and water consumption is not included in monthly rent
Alternative C:
127
Minimum Lease Term: 1 year Lease
Inclusions:
● 24/7 Security
● Alarm system
● Elevators
● Function room
● Comfort room
● 1 Parking space
Note: Electricity and water consumption is not included in monthly rent
Cost of Rent
This takes into consideration the budget that the company is willing
to spend on office space rent. The proponents are aware that aside from
the monthly rent, there may also be potential hidden charges that may
factor into the total monthly cost of the property itself. The cheaper the rent,
the better.
Lot Area
This takes into consideration the size of the floor space and area given the
amount of people, materials, and resources that will be needed to set up
the office to achieve maximum productivity and workflow. The larger the
area, the better.
Turn-over Condition
This takes into consideration the turn-over condition of the location.
Depending on the condition, certain costs will definitely be entailed
especially in being able to transform the area into a suitable working space.
128
Thus, the proponents have to account for the costs related to this. The less
transformation required, the better.
Lease Inclusions
This takes into consideration the inclusions provided by the alternatives.
The proponents are aware of the importance of several lease inclusions
and perks, such as 24/7 security and back-up generators, since these are
conditions the company may need to rely on to sustain and maintain the
servers for the database.
Business Environment
This takes into consideration the surrounding areas of the alternatives. The
proponents are aware of the importance of a sturdy business district that is
close to the metropolitan area, especially in being able to cater to the many
needs of the employees and clients; may it be in terms of available
transportation, restaurants, stores, and other amenities.
Location Accessibility
This takes into consideration how easy it is for employees and clients to
reach the headquarters. Similar to the business environment, the
proponents are aware that a location that is much more easily accessible
and convenient may also be crucial for the business to thrive.
Table 35.
Factor Rating for Location Planning
129
Turn-over Condition 0.15 6 6 9 0.90 0.90 1.35
Legend
The table above shows the factor rating for location planning of KUALA
Analytics Group. The weight of the factors were collectively agreed on by the
proponents, as well as the scoring for each of the alternatives per factor. The
scoring for each factor is based on a one-to-ten (1-10) scale with 1 as the lowest
and 10 as the highest. The group also decided on a passing/acceptance score of
7 and above.
Based on the results of the factor rating analysis and after thorough
discussions with the proponents, the company has collectively agreed to locate
their headquarters in Alternative C (in Subangdaku, Mandaue City), with a floor
area of 200 square meters – with a passing score of 7.95.
130
Figure 29. Chosen Headquarters Location Map
As seen in the figure above, the chosen location is along M.J. Cuenco Avenue in
the Subangdaku vicinity, wherein KUALA Analytics Group will be situated.
CEO Office
A CEO Office does not only exist for the sole purpose of
providing a separate private workspace for the CEO, but it also
functions as a place or area to discuss important matters with
business partners and associates. According to Monty (n.d.), a
small CEO office requires 20 sq. meters of space. In here, a desk,
chair, and other furniture including couches and a table top may be
included.
IT Department
The IT Department houses the employees involved in the
information technology aspect of the service. According to
Matheney (n.d.), 7 sq. meters of space is the minimum requirement
for an employee – especially in a co-working environment. With this,
the computers and chairs needed for the department will also be
taken into consideration for the space allotment. The IT Department
131
will be strategically located beside the Server & Electrical Room for
security and efficiency purposes.
Operations Department
Similarly, the Operations Department will house the other
employees under the jurisdiction of the COO. Here, 7 sq. meters of
space will also be allotted for each employee. And, necessary
materials and equipment needed will also be taken into
consideration for the space allotment of the department. The
Operations Department will be strategically located right beside the
Server & Electrical Room for security and efficiency purposes.
Marketing Department
The Marketing Department will house the CMO and its direct
employees. Here, 7 sq. meters of space will also be allotted for each
employee. The necessary materials, equipment, and furniture will
be taken into consideration as well. The Marketing Department will
be strategically located relatively near to the Guest Lounge in order
to easily accommodate guest inquiries.
Conference Room
132
The Conference Room is the designated area for employees
to interact and preside formal meetings. A mediumsized conference
room, which is able to accommodate at least 8 seats, entails a
minimum requirement of 23 sq. meters of space. The room will be
located right beside the Employee Lounge as a formal extension of
the area.
Employee Lounge
The Employee Lounge serves as an area where the
employees may be able to relax and unwind briefly to alleviate the
stressful nature of their job. According to Gebesa (2021), having a
designated employee lounge area in an office may bring about more
productivity and creativity than those offices without one. Thus, the
company wants to be able to breed the same level of productivity
among its employees as well. The company will allocate the open
space between the CEO Office and Conference Room,
approximately 15 sq. meters, for the Employee Lounge.
Collaboration Area
Unlike the Employee Lounge, the sole purpose of the
Collaboration Area is to bring the different departments together into
a shared environment. As much as possible, collaboration and
unison between the departments of the company is to be
encouraged. Thus, the company wants to be able to strategically
locate such Collaboration Area in the open space between the key
departments to make the collaboration as organic and free-flowing
as possible. Approximately 18 sq. meters will be allocated for the
space, which is good enough to seat 6 people.
133
faucets, sinks, toilets will all be provided. The company will ensure
a strict “no eating in desks and near computers” policy, thus
employees may only eat in the Dining Area. Although, employees
may also opt to eat outside headquarters premises during their
breaks should they wish to. Furthermore, the toilet area specifically
will comply with the National Building Code of the Philippines’
minimum requirement of 1.20 sq. meters for toilet and bath floor
space. With that being said, the company will allocate
approximately 19 sq. meters for the whole area.
Guest Lounge
The company also wants to have a designated Guest
Lounge for the guests who may have inquiries and appointments
set within the headquarters. The area will be strategically located
right beside the Reception Area so as to have close proximity to the
attending receptionist. The company will allocate approximately 15
sq. meters for the Guest Lounge.
Reception Area
Lastly, a reception area is designated at the entrance of the office
to serve as the place where visitors and clients will be welcomed
before their inquiry and purpose of visit will be attended to. As this
ultimately sets the first impression of visitors, the company wants to
ensure that the Reception Area is vibrant and chic. Thus, the
company will allot approximately 16 sq. meters for the Reception
Area, which includes a reception station, chairs, and other
decorations.
134
Figure 30. CCMD Ground Floor Plan
135
3.8.1.2 Interior Perspective
136
3.8.3 Plumbing & Electrical Layout
The following symbols are the legends for the plumbing layout. It
contains a total of seven legends such as (1) hose bibb, (2) water supply
line, (3) check valve, (4) water meter, (5) gate valve, (6) floor drain, and (7)
clean out.
137
Figure 34. Ground Floor Sanitary Layout
138
Figure 35. Ground Water Supply Layout
139
Figure 36. Electrical Layout Legends
The following symbols are the legends for the electrical layout. It
contains a total of sixteen legends such as (1) convenience outlet, (2)
weatherproof co, (3) ground fault circuit interrupter, (4) refrigerator outlet,
(5) exhaust fan, (6) convenience outlet (counter top), (7) panel board, (8)
pinlight, (9) circular fluorescent lamp, (10) chandelier, (11) fluorescent lamp,
(12) LED strip light, (13) T5 LED (wall mounted), (14) circuit homerun, (15)
wall lamp, and (16) switch.
140
Figure 37. Ground Floor Lighting Layout
141
Figure 38. Ground Floor Power Layout
Table 36.
142
Summary of Bill of Materials
CCMD Bill of Materials
Carpenter Australia
Doors Solid Door 40mm x 11 5,600.00 61,600.00
60cm x 210cm
143
Galvanized Nails 1-1/4in. 3 kg 415.00 1,245.00
Paints
Plumbing
Labor Costs
Carpenters, Painters,
Labor Cost 8 17,000.00 136,000.00
Electricians, Plumbers
TOTAL
328,203.00
3.10 Utilities
144
Moreover, the energy requirements for most appliances were based on the
Visayan Electric Company (VECO) website. Additionally, the electrical
consumption for the next 5 years (2023, 2024, 2025, 2026, and 2027) are
shown in the appendices portion.
Table 37.
Electrical Consumption for Year 2022
Energy Daily
Appliance Requirements Usage Quantity Daily Monthly Annually
(kW) (hrs)
Desktop
Computers
(CEO Office,
Operations
0.225 8 8 14.40 432.00 3,456.00
Dept.,
Marketing
Dept.,
Reception)
Desktop
Computers (IT 0.225 24 4 21.60 648.00 5,184.00
Department)
Computer
Monitor (for 0.030 24 1 0.72 21.60 172.80
server room)
All-in-one HP
0.175 8 5 7.00 210.00 1,680.00
Printer
145
Pinlight 0.010 8 29 2.32 69.60 556.80
Circular
Fluorescent 0.030 8 7 1.68 50.40 403.20
Lamp
T5 LED (Wall
0.010 8 3 0.24 7.20 57.60
Mounted)
Low-Wattage
0.003 24 4 0.29 8.64 69.12
LED Light Bulbs
Water Dispenser
0.090 24 1 2.16 64.80 518.40
146
147
Year 2022 Electrical Consumption (kWh)
Energy Daily
Appliance Requirements Usage Quantity Daily Monthly Annually
(kW) (hrs)
3.10.2
Multi-Split Air
condition unit 1.913 12 6 137.74 4,132.08 33,056.64 Water
(2.0 HP)
Multi-Split Air
condition unit 1.913 24 3 137.74 4,132.08 33,056.64
(2.0 HP)
Table 38.
2022 Water Consumption
148
Using Bathroom
31 0.030 0.94 28.16 6,984.52
Sink
Using Kitchen
31 0.030 0.94 28.16 6,984.52
Sink
The following table shows the monthly and yearly rates for the
internet plans that PLDT offers. This is to better give the company an idea
of what internet plan would be cost-effective to invest in. The
greenhighlighted row is the internet plan that the company would be
availing of.
Table 39.
2022 Telephone/Internet Consumption Plans and Rates
Internet Plan (with Monthly Rate
Landline) Speed (PHP) Annual Rate (PHP)
149
Unli Plan 3000 50 MBPS 3,000.00 36,000.00
Table 40.
Equipment Management
Primary Equipment
Auxiliary Equipment
150
Server Cabinet 1 unit 8 years Every 8 years
151
Office Chair 30 units 8 years Every 8 years
Sanitary Equipment
Consumables are items that are meant to be used up before being replaced or
restocked. Since these items are used often and may go out of stock fast, it is important
to set a reorder point so that the company would know when to restock the consumables
for additional resources. This emphasizes the significance of supply management in
avoiding consumables scarcity.
152
Table 41.
Supplies Management
Item Unit Quantity Consumption
Reorder Point
Period
Office Supplies
153
Band Aid Box 3 1 Year Yearly
154
Table 43.
Auxiliary Equipment Forecast
1 for server 1 1 1 1 1 1
RackMounted
Fan Unit
(1U)
Table 44.
Fixtures and Furnitures Forecast
155
Fixtures and Furnitures 2022 2023 2024 2025 2026 2027
1 for kitchen 1 1 1 1 1 1
Coffee Maker
4 per department; 20 20 20 20 20 20
Filing Cabinet
4 for CEO Office
156
Pinlight 29 for whole office 29 29 29 29 29 29
157
Securing business permits and registration
In order to be able to pursue this business project, the proponents need to first secure
legal business permits and registration from all relevant offices – may it be from the local
government, Securities and Exchange Commission (SEC), Department of the Bureau of
Internal Revenue (BIR), and the Department of Labor and Employment (DOLE). Included
here is also the starting of the EMR validation process with the Department of Health
(DOH) which includes the online registration and assessment of submitted documents
(Department of Health, 2022). Doing so will be a time-consuming process especially with
all the paperwork and legal documents required, thus an estimated 12 weeks or 3 months
will be allotted for this activity alone.
158
This activity will include the recruitment and selection of qualified individuals, employee
orientation to company mission and core values, basic introduction to job description and
deliverables, task-oriented and flexible on-the-job training, etc. Here, it is also important
for the company to be able to secure registration of employees under the Social Security
System (SSS). The proponents will allot 4 weeks or 1 month for the completion of this
activity.
159
promotion of Cebu Centralized Medical Database (CCMD). The Human Resource team
will also be involved in this activity to cater to the needs and inquiries of interested and
potential customers. 7 weeks will be allotted for the company to attract and draw
customers.
160
3.13 Evaluation
In this chapter, the proponents were able to tackle in depth the technical features and
aspects of Cebu Centralized Medical Database in order to fully grasp the degree of
complexity that needs to be taken care of in the development, maintenance, and creation
of the software.
Specifically, the details on the specific processes involved for the company were
established to ensure that a collective agreement was understood. Furthermore, aspects
on quality management and plant size were determined in order to assure orderliness and
systemization of processes. An appropriate headquarters location was also determined by
the proponents after scavenging several options in order to accommodate such capacity
and service requirements of the company. In addition, a complete plant layout was
established and designed for the location to illustrate and visualize the arrangement of
things and resources involved in the service. Lastly, the manpower and machine
requirements needed by the company were determined to support the operational needs
of the company in aims of establishing a smooth and efficient service workflow. Thus, in
its first year of operation (2023), a total of 31 employees are needed to run the business
smoothly.
In this technical phase of the project feasibility study, the proponents of CCMD have
concluded that the service is feasible on the grounds that the technicalities are achievable,
well-planned, and reasonable. As the proponents have laid down the necessary details
involved in the technical aspect of the project, the study on the financial feasibility of the
service will now commence to assess whether or not a sufficient amount of profit can be
made by establishing such service in Cebu.
161
162
CHAPTER 4: FINANCIAL FEASIBILITY STUDY
To recall, Cebu Centralized Medical Database (CCMD) is an online database service that
seeks to provide an interconnected network of certain patient information and medical
data, and store them on a cloud so that patients can enter any hospital within Cebu and
have the necessary information made readily-available and hassle-free. From a marketing
standpoint, the service was deemed feasible. In addition to that, it was also deemed
feasible from a technical standpoint. At this point, the proponents want to be able to assess
whether or not the financial aspect of the service is attainable and profitable for KUALA
Analytics Group. To be more specific, the main objective of this chapter is to be able to
validate the viability of the service considering the expenses to be incurred and the
revenues to be generated. The following information in this chapter includes general
accounting terminologies and principles to determine said objective.
Table 45.
Local Projected Inflation Rates per Year
Projected Inflation Rates
Sales Revenue
1. It is assumed that the sales of the service will start on the first day of
163
January 2023;
2. It is assumed that 84% of hospitals renew their CCMD licenses annually,
8% semi-annually, 4% quarterly, and the other 4% monthly;
3. Licensing prices vary depending on the hospital’s renewal frequency, with
an 8% price increase starting 2025;
4. It is assumed that the actual demand forecasted by the company will be
captured;
5. It is assumed that an average of 40 worker accounts are purchased by each
hospital in the year 2023, with a 5% increase biennially; and
6. A one-time membership fee is also incorporated into the generated sales.
164
6. It is assumed that employee salaries are directly affected by inflation rate.
Advertising Expense
1. It is assumed that the expenses incurred related to advertising are solely
based on the following advertising channels: (1) Facebook advertising and
(2) flyers;
2. The advertising expenses are directly affected by inflation rate; and
3. The amount of advertising exposure the company utilizes will decrease
exponentially over the years.
Depreciation Expense
1. It is assumed that the yearly depreciation rate of all equipment and machines
is 5% of the original cost.
4.1.2 Sales
Cebu Centralized Medical Database’s sales are mainly generated from the
number of licenses it secures per year. Although there is only one standard license
type, hospitals have the choice to purchase their licenses on several renewal
frequency options: (1) annually, (2) semi-annually, (3) quarterly, and (4) monthly. It
is important to note that the licensing rates were influenced by the results of the
165
respondents in the marketing survey. Furthermore, an average of 40 workers
accounts from each hospital was assumed in order to calculate the annual
revenues, with a 5% increase biennially. The following table below shows the
different licensing rates:
Table 46.
2023 CCMD Licensing Rates
Service Renewal Frequency Licensing Rates
Annually ₱13,300.00
Semi-annually 7,315.00
Quarterly 5,364.00
Monthly 1,475.00
Table 47.
CCMD Sales from Licensing
Cebu Centralized Medical Database Annual Sales from Licensing
# of # of
Payment # of # of Hospital Revenue Hospital
# of Hospitals Revenue Revenue Revenue Revenue
Frequency Hospitals Hospitals s s
19,724,166 20,710,374.3
.00 0
Annually 32 ₱17,024,000.00 32 17,024,000.00 33 19,724,166.00 33 33
Semi- 2,629,888. 2,761,383.2
annually 80 4
3 1,755,600.00 4 2,340,800.00 4 2,629,888.80 4 4
1,446,348. 1,518,666.4
96 1
Quarterly 1 643,680.00 1 643,680.00 1 723,174.48 2 2
1,590,876. 1,670,419.8
00 0
Monthly 1 708,000.00 1 708,000.00 1 795,438.00 2 2
25,391,279 26,660,843.7
Total 37 .76 5
₱20,131,280.00 38 20,716,480.00 39 23,872,667.28 41 41
166
4.1.3 Other Revenues
Table 48.
CCMD Sales from One-Time Membership
Cebu Centralized Medical Database Annual Sales from One-Time Membership
With that being said, CCMD’s total yearly revenues can be calculated by adding
the values of Table 47 and Table 48. The results are tabulated in Table 49 below:
Table 49.
CCMD Total Yearly Revenues
167
Cebu Centralized Medical Database Total Yearly Revenues
Table 50.
Annual Direct Labor Cost
Direct Labor Cost
Year Total
2022 ₱4,580,923.72
2023 ₱6,792,332.47
2024 ₱6,888,390.82
168
2025 ₱7,226,003.22
2026 ₱7,414,495.71
2027 ₱7,515,155.34
Table 51.
Annual Primary Machine Maintenance Expense
Primary Machine Maintenance Expense
Year Total
2022 ₱0.00
2023 3,830.88
2024 3,872.37
2025 3,939.22
2026 5,101.83
2027 6,241.44
169
application development include application publishing to Google’s Play
Store & Apple’s App Store, as well as the building of the website. It is
important to note that Google’s Play Store only has a one-time publishing
fee, while Apple’s App Store demands such a fee annually. Note, the
website builder costs ₱0.00 since WordPress provides free access to
website builder functionalities. Table 52 below illustrates the expenses
involved here.
Table 52.
Annual Software & Application Development Expense
Software and Application Development Expense
Application Publishing
Google Play
Store
₱0.00 1,343.58 0.00 0.00 0.00 0.00
Apple App
Store
0.00 5,321.74 5,321.74 5,321.74 5,321.74 5,321.74
Website
Domain
Registration
805.79 805.79 805.79 805.79 805.79 805.79
Web Hosting 4,349.32 5,799.09 5,799.09 5,799.09 5,799.09 5,799.09
Website
Builder
0.00 0.00 0.00 0.00 0.00 0.00
Total ₱ 5,155.11 13,270.20 11,926.62 11,926.62 11,926.62 11,926.62
170
Table 53. Annual Direct Training Cost
Training Expense
4.1.5 Expenses
The company is also bound to incur some other expenses as well, especially in
order for the company to run its operations and generate its revenues. With that
being said, the expenses that KUALA Analytics Group incur for its service, Cebu
Centralized Medical Database (CCMD), includes the ff: (1) salaries,
(2) rent, (3) auxiliary maintenance, (4) training, (5) advertising, (6) supplies, (7)
depreciation, (8) utilities, (9) interest and (10) miscellaneous expense.
171
Salaries Expense
Aside from the direct labor costs incurred in the Cost of Sales, it is also essential
for the company to pay all the other workers who play a specific role – whether it
be in administrative or other departments not directly involved in the delivery of the
service to the customers. Note, that the 13th month pay and fringe benefits are
also included in the calculation here. With that being said, the summary of the
salaries expense pertaining to these employees are illustrated in Table 54 below.
(See Appendix AC for the breakdown of the salaries expense)
Year Total
2022 ₱3,676,016.05
2023 5,656,635.67
2024 5,737,781.45
2025 5,838,079.61
2026 5,989,557.21
2027 6,067,629.17
Rent Expense
As stated in Section 3.7.1 of the Technical Feasibility, the monthly rental cost of
the chosen office space in Subangdaku, Mandaue City is ₱90,900. Considering
inflation rate changes over the years, the proponents also take this into
consideration in calculating the monthly rental cost of the office space in the
upcoming years as well. The table below illustrates the monthly rental cost of each
year.
Table 55.
Monthly Rental Cost
172
2022 - ₱90,900.00
Table 56 below then illustrates the annual rent cost of the office space with regards
to the information shown above. The calculation for the annual rent expense is
calculated using the formula:
Number of
Year Monthly Rent Months Annual Rent Expense
173
Table 57. Annual Auxiliary Maintenance Expense
2024 14,512.82
2025 14,763.39
2026 15,169.77
2027 15,380.30
Year Total
2022 ₱0.00
2023 14,357.34
Interest Expense
Due to the high capital needed in starting the business, the cash received from
capital may be insufficient which makes it inevitable to loan from a bank. KUALA
Analytics Group will acquire a compounded monthly interest (1.89%) loan from the
bank to compensate for the total amount lacking to start the business.
Table 58 below shows the interest expense for every year.
Table 58.
Annual Interest Expense
Interest Expense
Year Interest
2022 -
2023 ₱1,889,446.90
2024 1,660,086.74
2025 1,372,944.74
2026 1,013,464.13
2027 563,420.91
174
Training Expense
Training of employees is also a significant aspect to the success of the
company. With that being said, the company will be incurring costs related to the
training of employees. For the training of company employees, KUALA Analytics
Group will be outsourcing services from Staff Outsourcing Solutions – a
Cebubased service provider. Table 59 below illustrates the costs involved here.
Table 59.
Annual Training Expense
Direct Training Cost
# of Training Hours 45
Frequency 2 2 1 1 1
Advertising Expense
Based on the results in the Marketing Feasibility, the proponents have strategically
decided on utilizing two out of the three most preferred marketing channels: (1)
Facebook ads and (2) flyers. As the target market for the service is a very specific
group of people – hospital administrators, the means of advertising the service is
crucial for the company to thrive. Thus, the proponents believe that Facebook ads
and flyers are the most appropriate channels to promote the service considering
the niche target market. With that being said, the table below depicts the total
expenses associated with the company’s advertising efforts for the next couple of
years. (See Appendix AC for the breakdown of the advertising expense)
Table 60.
Annual Advertising Expense
Advertising Expense
175
Facebook ads ₱975,000.00 663,961.08 335,575.66 341,369.46 245,536.22 248,943.88
Supplies Expense
Part of operating a business includes using up and consuming supplies & other
stationeries that are needed in running the service. With this, the annual expense
related to the use of such supplies need to be accounted for as some of these
materials need to be replenished and restocked at some point in time. Thus, Table
61 below shows the summary of annual supplies expenses which include
consumable & non-consumable office supplies, bathroom & sanitary supplies, and
safety supplies. (See Appendix AC for the breakdown of the supplies expense)
Table 61.
Summary of Annual Supplies Expense
Supplies Expense
Depreciation Expense
An asset’s initial value decreases over time until the end of its useful life. The cost
of an asset that has been depreciated for a particular period is known as a
depreciation expense. The depreciation value was calculated using the Straightline
method. With that being said, the summary of the annual depreciation expense
and the accumulated depreciation are illustrated in Table 62 below. (See Appendix
AC for the breakdown of the depreciation expense)
Table 62.
Summary of Annual Depreciation Expense
Depreciation Summary
176
Annual
Depreciation
Expense
₱122,423.88 183,635.82 184,000.60 201,008.36 202,806.77 218,117.29
Accumulated
Depreciation
₱122,423.88 306,059.71 490,060.31 691,068.67 893,875.43 1,111,992.73
Utilities Expense
KUALA Analytics Group is also bound to incur costs related to electricity, water,
and telephone/internet expenditures. These expenses are also known as utilities
expenses. With that being said, Table 63 below illustrates a summary of the annual
utilities expense that the company incurs: (See Appendix AC for the breakdown of
the utilities expense)
Table 63.
Summary of Annual Utilities Expense
Summary of Utilities Expense
Electricity Telephone/Internet
Year Expense Water Expense Expense Total
177
Table 64.
Annual Electricity Expense
Electricity Expense
Year Total
2022 ₱1,297,809.56
2023 2,016,145.43
2024 2,037,978.93
2025 2,237,429.01
2026 2,299,016.67
2027 2,330,923.42
Table 65.
Annual Water Expense
Water Expense
Year Total
2022 ₱268,122.17
2023 397,569.27
2024 415,270.50
2025 422,440.25
2026 462,072.78
2027 482,682.16
178
In terms of internet and telephone consumption, it is important to note that
the company will be acquiring said supply from PLDT. To be more specific, KUALA
Analytics Group will be availing the highest business plan offered by the company,
their GFiber Unli Plan 12500, which is their premium Internet+Landline Plan with
internet speeds up to 1 GBPS. The following tables below show the monthly PLDT
telephone/internet consumption rates, as well as the said annual expense to be
incurred by KUALA Analytics Group.
Table 66.
Annual Telephone/Internet Expense
Telephone/Internet Expense
Year Total
2022 ₱100,000.00
2023 153,221.79
2024 154,881.08
2025 157,555.14
2026 161,892.01
2027 164,138.82
Miscellaneous Expense
Miscellaneous expenses include the costs of relatively insignificant expenditures
that are too difficult for the company to categorize into a specific account. Note, the
company is assuming a ₱5,000.00 miscellaneous expense incurrence annually.
Table 67 below illustrates such annual miscellaneous expenses to be incurred by
KUALA Analytics Group for the next couple of years.
Table 67.
Annual Miscellaneous Expense
Miscellaneous Expense
Year Total
2022 ₱5,000.00
179
2023 5,000.00
2024 5,000.00
2025 10,000.00
2026 10,000.00
2027 10,000.00
Current Assets
1. A one-month advance rent payment is made before the start of
preoperations.
2. Prices of machine and equipment will be affected by the inflation
rate of the year they were acquired; and
3. Replenishment of goods will be made during their respective
reorder points.
Non-Current Assets
1. Equipment value is affected by its yearly depreciation;
2. Equipment price is affected by each year’s corresponding inflation
rate;
3. Equipment are sold at their salvage value price during reorder
points; and
4. Office renovation works are conducted during the preoperational
period only.
180
Liabilities
1. Certain liabilities, such as accounts payable, wages payable, and
rent payable will be paid before their respective deadlines and
would therefore not be reflected in the balance sheet.
4.2.2.1 Cash
Cash is a current asset and is the most liquid type of asset. This includes
the bank accounts and undeposited bank checks of CCMD. Cash can be
immediately or near-immediately be used in exchange for goods, services,
and other assets. Table 68 shows the cash of CCMD at the end of the
period as its current asset.
Table 68.
Cash of CCMD
Cash
2022 - ₱519,738.92
181
4.2.2.2 Supplies
Supplies are the daily consumables of CCMD within a period or the
next 12 months and are recorded as current assets until they are consumed
or used up. These supplies include the office supplies and other
consumables listed in Section 3.6.2 of the Technical Feasibility. In
alignment with the projected yearly inflation rate, prices will increase over
the years. Table 69 shows the supplies remaining at the end of each year
that are left unconsumed.
Table 69.
Cost of Supplies
Supplies
Prepaid
Supplies
₱17,427.25 16,662.96 16,201.72 17,134.31 18,808.90 15,950.54
Prepaid
Supplies
(Accumulated)
₱17,427.25 34,090.21 50,291.93 67,426.24 86,235.14 102,185.68
For the year 2023, the first operating year, the prepaid supplies for CCMD
amount to PHP 102,185.68.
Table 70.
CCMD Prepaid Expenses
Prepaid Expenses
182
Prepaid
₱ 980,523.97 1,421,699.98 1,481,002.06 1,542,223.70 1,565,004.60 1,579,785.76
Expenses
Prepaid
Expenses ₱ 980,523.97 2,402,223.95 3,883,226.01 5,425,449.71 6,990,454.31 8,570,240.06
(Accumulated)
4.2.2.1 Equipment
Table 71.
Equipment Expense
Equipments
Cost of
Equipment
₱1,308,550.02 - 3,071.78 114,482.55 8,310.46 409,435.79
Sold Equipment 0.00 0.00 0.00 0.00 0.00 19,934.06
183
4.2.2.2 Furniture & Fixtures
Table 72.
Office Renovation Expense
Office Renovation Expense
184
Carpenter Australia
Solid Door 40mm x
60cm x 210cm
Doors 11 ₱5,600.00 ₱61,600.00
Tempered 12mm thk Clear
Glass Door Tempered Glass Door
1 6,499.00 6,499.00
HardiFlex
Wall
Partitions
12mm x 4ft. x 8ft. 45 1,564.00 70,380.00
Frameless
Tempered
Glass
12mm thk Clear
Partition
Tempered Glass Wall 2 6,700.00 13,400.00
Portland
Cement
40kg per bag 9 265.00 2,385.00
HardiFlex 1-1/4in. 1 125.00 125.00
Nails
Galvanized
Nails
1-1/4in. 3 415.00 1,245.00
Paints
Plumbing
Plumbing
Pipes
PVC Pipes 2000 mm 8 ₱1,971.00 ₱15,768.00
Stainless Steel Floor
Drain
Floor Drain 1 49.50 49.50
Total ₱325,032.00
185
4.2.2.3 Intangible Assets
Table 73.
Annual Licensing & Registration Expense
Licensing and Registration Expense
Intangible
Assets ₱ 11,550.00 14,050.00 14,050.00 14,050.00 14,050.00 14,050.00
Intangible
Assets ₱ 11,550.00 25,600.00 39,650.00 53,700.00 67,750.00 81,800.00
(Accumulated)
The sum of all depreciation that has been recorded since an asset was
first used by a company up until a particular date is known as accumulated
depreciation. It essentially refers to the entire amount of depreciation that
has occurred over the useful life of an item. The table below shows the
accumulated depreciation expense from the year 2022 to 2027.
186
Table 74.
Accumulated Depreciation
Accumulated Depreciation
Year
Total
2022 -₱122,423.88
2023 -306,059.71
2024 -490,060.31
2025 -691,068.67
2026 -893,875.43
2027 -1,111,992.73
4.2.3 Liabilities
4.2.3.1 Value Added Tax (VAT) Payable
For every successful service sale from consumers, CCMD pays the
government a uniform VAT rate of 12%. The gross sales are obtained from
the total sales (licensing and membership fees from consumers with 12%
VAT) of the company, while the net sales are the total sales without the VAT.
The VAT payable, which the company needs to pay to the Bureau of Internal
Revenue (BIR), is calculated by dividing net VAT by 4.
Table 75.
VAT Payable Calculation
Value Added Tax (12%)
187
4.2.3.2 Loans Payable
Loans payable are the company’s loan debt that has not been paid
yet. Since CCMD would be inquiring about a bank loan that is payable in 5
years with 1.89% compound interest monthly, the company will have to pay
a certain amount before the deadline. Moreover, the bank loan that CCMD
would be borrowing is a total of ₱7,500,000.00.
Table 76.
Loans Payable Amortization Schedule
Amortization Schedule
4.2.4 Equity
The equity of the company comprises capital and retained earnings. Capital, which
is used to start the business, has a yearly value of ₱7,500,000.00, while the value
for retained earnings is obtained from the income statement. The total equity of the
company can also be calculated by subtracting the total assets from the total
liabilities.
Table 77.
Total Equity of CCMD
Equity
Retained
Earnings -₱11,959,601.73 -11,152,854.77 -9,729,853.66 -6,386,781.90 -1,964,877.75 3,472,271.89
188
Total
Equity -₱4,459,601.73 -3,652,854.77 -2,229,853.66 1,113,218.10 5,535,122.25 10,972,271.89
189
Table 78.
Total Project Cost for the Year 2022
EXPENSES 2022
Output VAT -
190
Cash Received from Sold Equipments -
Given that CCMD is a startup enterprise that specializes in the provision of health
information system services to healthcare facilities in Cebu, it will require sourcing
adequate funds from reliable sources. During the preoperative stage and the first five
years of operations, the project will be financially supported by the following sources:
Partnership Contributions
Profits earned at the end of each year will be reinvested into the business.
The reinvested profits will be used to further improve the business operations,
expand the business, or pay off any existing debts.
Bank Loans
Loans from banks will be filed to support the total amount of funds needed
to run the business pre-operations. A total of ₱7,500,000.00 will be loaned from the
bank which will be payable in 5 years with a 1.89% compound interest monthly.
The equipment purchased will be used as collateral for the bank to approve the
loan.
191
4.5 Financial Statements
4.5.1 Cash Flow Statement
The cash flow statement indicates how changes in the balance sheet and income
statement affects cash and cash equivalents. Furthermore, it breaks the analysis
down into operating, investing, and financing activities. This statement
demonstrates CCMD’s ability to operate in the short and long term depending on
how cash goes into and out of the business. Through this, investors can evaluate
the company’s profitability and long-term future outlook.
Table 79.
Cash Flow Statement
192
4.5.2 Income Statement
The income statement indicates the company’s financial performance by
summarizing all income and expenses incurred by the company. It determines
profitability by showing the net income and loss by accounting all relevant
information such as the operating expenses and such. From this financial
statement, decisions such as increasing production capacity, shutting down certain
departments, and the like can be made.
Table 80.
Income Statement
193
Table 81.
Balance Sheet
194
visible in the year 2027, the consistent increase in the said margin over the 5-year
operating period shows strong promise that the company is in a good position to
maintain high margins in the years to come.
Table 82.
Net Profit Margin
Net Profit Margin
NET PROFIT
MARGIN
- 0.04 0.07 0.14 0.17 0.20
Table 83.
Return on Assets
Return on Assets (ROA)
195
4.6.3 Return on Equity (ROE)
Similar to a company’s return on assets, the return on equity indicates the
company’s profitability with relation to its equity. In other words, it represents the
company’s ability to generate profit with respect to the investments pooled in by
shareholders. When analyzing the ROE, a 15-20% margin would be considered
good. The company obtained the highest ROE in its third year of operations with a
300% margin, while a good ROE is also maintained in the years 2026 and 2027
.
Table 84.
Return on Equity
Return on Equity (ROE)
Table 85.
Current Ratio
Current Ratio
196
Current
Liabilities
₱7,500,000.00 ₱7,199,062.61 ₱6,071,432.67 ₱4,739,190.34 ₱2,998,490.15 ₱799,825.31
CURRENT
RATIO
- 0.31 0.44 1.01 2.55 13.39
Table 86.
Leverage Ratio
Leverage Ratio
DEBT TO
EQUITY
RATIO
- -1.98 -2.76 4.10 0.54 0.07
Table 87.
Payback Period
Payback Period
197
2022 -₱11,959,601.73 -₱11,959,601.73
Table 88.
Return on Investment
Return on Investment
For the first year of operations, the company is shown to be unprofitable due to
the startup costs which resulted in a negative operating income. The ROI is
198
projected to increase from -159.46% in 2022 to 72.50% in 2027, indicating a
longterm upward trend in the company’s profitability and operating cost in the
succeeding years. Based on the projected ROI, the company will be able to return
about 140.82% of its initial investment in 2028.
4.8 Evaluation
The financial aspect of the study was examined in this chapter by assessing the
startup costs, operating expenses, projected cash flow, and determining the return on
investment for the proposed business, Cebu Centralized Medical Database. The income
statement, balance sheet, and statement of cash flows were prepared and projected
based on five-year estimates of costs and revenues to outline any financial risks and
evaluate if the company would be sustainable throughout the projection of five years.
The financial ratios were thoroughly analyzed in order to gain insight into the company’s
liquidity, operational efficiency and profitability to better understand the trajectory of
operations and see how the company is doing competitively in relation to its competitors.
Based on the results of the financial ratios, the company has the capacity of paying off its
debts which can be interpreted in the increasing trend in the liquidity ratio and the
decreasing trend in the leverage ratios. Even though the company will incur losses in its
initial year of operations, the succeeding years indicate a long-term upward trend in the
company's profitability, which may more than make up for those losses. The company is
in a good position to maintain high profit margins in the years to come since it has the
ability to effectively minimize operational cost while increasing its profitability, which is
shown by the constant increase in the net profit margin. Additionally, this shows potential
investors that the company is qualified enough to receive new credit for its future plan and
that it offers minimal risks over time.
Based on the analysis of the study’s financial aspect which were based on the presented
ideas from the marketing and technical phase, the proponents were able to establish that
Cebu Centralized Medical Database is a financially feasible business. As what was
projected in the financial phase, the company will be able to financially sustain and grow
throughout the following years.
199
REFERENCES
Bizbox Inc. (n.d.). Home. Bizbox Inc. Retrieved May 21, 2022, from
http://www.bizbox.ph/copy-of-telemedicine
Cebu Grand Realty. (2019). 215 SqM Office Space for Rent in Banilad. Cebu Grand
Realty. https://cebugrandrealty.com/property/215-sqm-office-space-forrent-in-
banilad/
Cebu Grand Realty. (2019). 200 SqM Office Space for Rent in Cebu Business Park.
for-rent-in-cebu-business-park/
hierarchyorganization-15386.html
Company.
https://www.visayanelectric.com/page.html?main=efficiency&sub1=efficient%20e
nergy%20usage&sub2=Compute%20Energy%20Consumption%20of%20your%2
0Appliances
Renting vs. Buying Office Space: Pros, Cons and Tips. American Psychological
Association.
200
https://www.apaservices.org/practice/business/management/tips/rent-buy
Health.
http://home.doh.gov.ph/uploads/downloads/DOHISSP20152017FINAL8282015.p
df
Development. https://ro7.doh.gov.ph/systems-implementaion/ihomis
EXCHANGE".
https://blr.dole.gov.ph/2014/12/11/termination-of-employment/
https://shop.globe.com.ph/broadbandplans?gclid=Cj0KCQjw06OTBhC_ARIsAAU
1yOWr7rFJWYmkcOHxb1XExHG4f4
cocon1d6jJOcNWPoDPzhYFLefW1MAaAhgJEALw_wcB&gclsrc=aw.ds#highspe
ed-and-unlimited-access
Lafradez, R. (2022, July 26). 200 Square Meters Office Space in Mandaue City,
201
Cebu. 200 Square Meters Office Space in Mandaue
mandaue-citycebu.html
Mammen, S. S. (2021, January 15). Bare shell: What is bare shell property
shell/
Medina, M. (2017, November 20). DID YOU KNOW: PH has 476 public, 960
https://newsinfo.inquirer.net/946244/did-you-know-ph-has-476-public-960private-
hospitals-as-of-october-2017
http://ehealth.doh.gov.ph/nehehrsv/index.php/validation-process
National Health Facility Registry v2.0. (n.d.). National Health Facility Registry v2.0.
https://nhfr.doh.gov.ph/Philippine_health_facility_statuslist.php
Orange Health Consultants. (2021, April). Health Care in The Philippines. Health
https://www.rvo.nl/sites/default/files/2021/06/Healthcarein-The-Philippines.pdf
https://www.philhealth.gov.ph/advisories/2016/adv2016-0040.pdf
Province of Davao del Norte. (2017). RESOLUTION NO. 798, s-2017 [“A
DPA, Ph.D, TO ENTER INTO AND SIGN FOR AND IN BEHALF OF THE CITY
202
THE DEPARTMENT OF HEALTH REGIONAL OFFICE XI FOR THE
2017/
Export.gov.
https://2016.export.gov/industry/health/healthcareresourceguide/eg_main_10861
1.asp
Ryan, K., Levit, K., & Davis, H. (2010, March). it, K. (Thomson Reuters), and Davis,
Sabalo, W. B. (2022, June 16). DOLE-7 reminds employers to follow new minimum
https://cebudailynews.inquirer.net/447814/dole-7-reminds-employers-to-
follownew-minimum-wage-rates-in-the-region
Saint Anthony Mother and Child Hospital. (n.d.). PATIENTS RIGHTS. Department
of Health. https://samch.doh.gov.ph/index.php/patients-and-visitors-
corner/patients-rights
Software Development Team for Your Project [Perfect match]. (2022, June 17).
https://www.haysmed.com/wpcontent/uploads/2019/02/IndividualEMRSystemUse
rAgreement_121007-1.pdf
06/ACCESS%20TO%20ELECTRONIC%20HEALTH%20RECORDS%20AGREE
203
MENT.pdf
What Is an HR Department? (2020). Indeed.
https://www.indeed.com/recruitment/c/info/departments-in-hr
resources/softwarequality
World Health Organization. (2021, March 19). Injuries and violence. WHO | World
https://www.who.int/newsroom/fact-sheets/detail/injuries-and-violence
Engineering. https://knowindustrialengineering.com/manpower-requirement-
calculation/
204
APPENDICES
205
MACTAN DOCTORS HOSPITAL, INC. Private Level 2
206
WOMEN'S AND CHILDREN'S COMMUNITY HOSPITAL Private Level 1
207
○ No
5. If there was a web-based electronic medical record system that could collect, store,
and access general patient information (patient profile and medical abstracts) from
all public and private hospitals in Cebu, such as Cebu Centralized Medical
Database (CCMD), would you be willing to avail of such a service?
○ Yes
○ No
6. In the table listed below, check ‘YES’ or ‘NO’ for each row if you would want the
following added *features integrated into our service. (Check all that applies)
YES NO
*Billing integration ● ●
*Inventory management ● ●
7. Rank the following features according to its benefit or convenience. (1 being the
most important and 6 being the least important)
Feature Rate
*Billing integration
*Inventory management
8. What other added features (aside from the ones mentioned above) would you want
in our service? ____________________________
208
9. If you were to avail our service, how often would you prefer to renew it?
○ Monthly
○ Quarterly
○ Semi-annually
○ Annually
10. Based on your preferred renewal frequency, kindly encircle how much would you
be willing to pay per license? (Only answer the column of your preferred frequency
of payment)
11. After purchasing, how would you prefer to acquire or download our service?
○ CD/DVD
○ Flash drive (USB)
○ Official website
○ Others: ____________
12. In what social media platform would you like to know about our service launch?
○ Facebook
○ Instagram
○ Twitter
○ YouTube
○ TikTok
○ Others: ____________
○ N/A
13. In what traditional media platform would you like to know about our service launch?
○ TV Commercials
○ Radio
○ Newspaper
○ Magazine
○ Billboard
○ Flyer
○ Others: _____________
○ N/A
209
Appendix D: Survey Results
Respondents’ Current Medical Record System
210
Respondents’ Preferred CCMD Features
Insurance Information 1
211
Network with Government Health Programs 2
Financial Reports 1
E-diagnostics 1
Auditable 1
Autogenerate Reports 1
Printable Forms 1
212
Respondents’ Preferred Social Media Platform for CCMD Promotion
213
Year Number of Licensed Hospitals
in Cebu
2013 28
2017 33
2022 40
1. Projected Population
Step 1: Make use of Linear Regression method since it was deemed to be of least
error.
Step 2: Identify the total number of licensed hospitals in at least three different
periods.
Step 3: Find for the slope and y-intercept of the matrix using Microsoft Excel. 𝑆𝑙𝑜𝑝𝑒
= 1.336
𝑌 − 𝑖𝑛𝑡𝑒𝑟𝑐𝑒𝑝𝑡 = −2661.623
Step 4: Use this formula:
𝑃𝑟𝑜𝑗𝑒𝑐𝑡𝑒𝑑 𝑃𝑜𝑝𝑢𝑙𝑎𝑡𝑖𝑜𝑛&’#( * = 1.336(𝑌𝑒𝑎𝑟 𝑥) −
2661.623
214
𝑃𝑃 = 1.336(2026) − 2661.623 46
2026
2. Demand Factors
Step 1: Identify the frequency of demand for each Feature X from the survey
results.
Step 2: Identify the total number of survey respondents.
Step 3: Use this formula:
𝐷𝑒𝑚𝑎𝑛𝑑 𝐹𝑎𝑐𝑡𝑜𝑟 𝑌 =
+(’,-’./& >’[email protected]’.2?
Appointment/Consultation 25 1.00
Schedule and Reminder 𝐷𝐹 =
215
3. Projected Demand per Feature
Step 1: Utilize the results of ‘Projected Population’ and ‘Demand Factors’.
Step 2: Use the formula:
𝑃𝑟𝑜𝑗𝑒𝑐𝑡𝑒𝑑 𝐷𝑒𝑚𝑎𝑛𝑑 𝑓𝑜𝑟 𝐹𝑒𝑎𝑡𝑢𝑟𝑒
𝑋 = 𝐷𝑒𝑚𝑎𝑛𝑑 𝐹𝑎𝑐𝑡𝑜𝑟 𝑌 ∗
𝑃𝑟𝑜𝑗𝑒𝑐𝑡𝑒𝑑 𝑃𝑜𝑝𝑢𝑙𝑎𝑡𝑖𝑜𝑛
Billing Integration 41 42 43 45 46
Appointment/Consultation
Schedule and Reminder
42 43 44 46 47
Inventory Management 41 42 43 45 46
4. Factor Rating
Step 1: Identify the results of the factor rating question in the survey.
Step 2: Tally the frequency of the scoring per feature.
216
Step 3: Use the formula:
A
i Weighted Value
1st 6
2nd 5
3rd 4
4th 3
5th 2
6th 1
Step 4: Calculate.
Billing Integration 1 9 6 4 2 3 94
217
2 4 3 8 4 4 80
Appointment/Consultation
Reminder….
0 1 8 5 8 3 71
Medication Tracking and...
Inventory Management 3 1 1 4 4 12 59
Feature 4 0 0 0 0 0 0 0 0 0 0
218
Feature 6 6 0.2609 4 0.1739 9 0.3913 0 0 0 0
Step 3: Calculate Total Projected Supply of Feature X for each EMR using Equation X.
Use the Projected Population data from the Demand Computations
Feature 1
2022 2023 2024 2025 2026 2027
Comlogik 7 8 8 8 8 9
iHOMIS 16 17 17 18 18 19
eHATID 4 4 4 4 4 5
LGU
CHITS 4 4 4 4 4 5
219
Appendix H: Supply-Demand Gap Calculation
Step 1: Tabulate the demand for each feature based on survey results.
Feature 1 Feature 2 Feature 3 Feature 4 Feature 5 Feature 6
2022 37 39 39 40 39 39
2023 39 41 41 42 41 41
2024 40 42 42 43 42 42
2025 41 43 43 44 43 43
2026 43 45 45 46 45 45
2027 44 46 46 47 46 46
Step 2: Tabulate the supply for each feature based on the supply equation
Feature 1 Feature 2 Feature 3 Feature 4 Feature 5 Feature 6
2022 42 16 38 0 20 38
2023 44 17 39 0 21 40
2024 44 17 40 0 21 41
2025 46 18 42 0 22 42
2026 46 18 42 0 22 42
2027 51 19 46 0 24 46
Step 3: Plot the data points for supply and demand on the graph
220
Appendix I: Annual Demand of CCMD Calculations
Step 1: Find the ratio of government to private hospitals of the current year
2022 Population
13 27 40
Percentage of
Total
0.325 0.675
Step 2: Identify the number of government and private hospitals surveyed in the study
(sample population)
Surveyed Hospitals
8 17 25
Step 3: Identify the number of government and private hospitals who voted “Yes” in their
willingness to avail of CCMD Service, and calculate their respective percentages to the sample
population
Survey Results (Yes)
Government Private
8 14
Step 4: Identify the projected population of Cebu hospitals for the next 5 years
Projected Population
2023 42
2024 43
2025 44
2026 46
2027 47
221
Step 5: Multiply the values of ‘Step 1’ to the corresponding values in ‘Step 4’ for every year.
2023 Population
14 28 42
2024 Population
14 29 43
2025 Population
14 30 44
2026 Population
15 31 46
2027 Population
15 32 47
Step 6: With the values obtained in ‘Step 5’, multiply them with the values in ‘Step 3’
2023 Total Demand
14 23 37
14 24 38
222
2025 Total Demand
14 25 39
15 26 41
15 26 41
223
224
Appendix K: CCMD Contract with Medical Institution Template
RECITALS
A. Medical Institution provides health care to patients in the Province of Cebu through
its locations and seeks to utilize information technology for maintenance of electronic
medical records for services rendered at those locations, specifically Cebu Centralized
Medical Database; and
B. Medical Institution provides health care services to patients in the Province of Cebu
who also receive services through other Cebu hospitals utilizing Cebu Centralized Medical
Database; and
C. Medical Institution is a Covered Entity as defined by the Data Privacy Act of 2012
(“RA 10173”); and
D. Medical Institution intends to protect the privacy and provide for the security of
protected health information pursuant to RA 10173, the Privacy Guidelines For The
Implementation of The Philippine Health Information Exchange, and the regulations
promulgated thereunder, and as may be amended from time to time (collectively, the
“Privacy and Security Regulations”); and
225
1. DEFINITIONS
1.1 Disclose and Disclosure mean, with respect to PHI, the release, transfer,
provision of, access to, or divulging in any other manner of PHI outside of the internal
operations of the applicable KUALA Analytics Grp.
1.2 Electronic Medical Record (“EMR” or “CCMD”) means the Cebu Centralized
Medical Database electronic medical record system maintained by KUALA Analytics Grp.
that contains protected health information that is subject to protection under RA 10173 and
the Privacy Guidelines For The Implementation of The Philippine Health Information
Exchange.
1.4 Use or Uses means, with respect to PHI, the sharing, employment, application,
utilization, examination or analysis of such PHI within KUALA Analytics Grp. internal
operations.
1.5 Other terms used, but not otherwise defined in this Agreement, shall have the
same meanings as those terms in RA 10173.
2. HOSPITAL OBLIGATIONS
2.1 Access. Subject to the terms and conditions of this Agreement, KUALA
Analytics Grp. grants Medical Institution non-transferable and non-exclusive access to
CCMD to permit the individuals listed right below:
●
●
●
●
●
● to electronically access and use CCMD solely for accessing patient
medical records in the EMR for purposes of coordinating care and treatment of patients of
Medical Institution. Medical Institution understands and warrants that such access and use
shall be limited to the access provided to Authorized Users through designated Worker
IDs and corresponding passwords and a second authentication factor, such as but not
limited to SMS, push notice, or physical token. Authorized Users shall be prohibited from
using any other Authorized User’s Worker IDs/password to access and/or use CCMD.
226
Authorized Users may not disclose, share, or transfer Worker IDs/passwords to
unauthorized parties, and shall not store Worker IDs/passwords in written form. Medical
Institution further acknowledges and understands and
acknowledges that KUALA Analytics Grp. may terminate individual Authorized Users’
access at any time for any reason without penalty, regardless of any effect such
termination may have on Medical Institution’s operations. Medical Institution shall ensure
that its Authorized Users shall personally enter all Worker IDs/passwords and two-factor
forms of identification when accessing the EMR and shall not attempt or take action to
circumvent such authentication measures through manual, automated or other means.
2.2 Equipment. Medical Institution acknowledges and agrees that any hardware,
software, network access, or other components necessary for Medical Institution to access
and use CCMD must be obtained separately by Medical Institution. KUALA Analytics Grp.
shall not be responsible for the procurement, installation, or maintenance of any such
components, and KUALA Analytics Grp. makes no representations or warranties regarding
the components whatsoever.
3.1 Permitted Use. KUALA Analytics Grp. shall make access to CCMD available
to Medical Institution and its Authorized Users to enable both parties to coordinate care
and treatment for patients and enhance the quality and efficiency of the services Medical
Institution provides (the “Permitted Purpose”). Medical Institutions shall ensure that its
Authorized Users shall use CCMD to access PHI that is necessary and used solely for the
Permitted Purpose. Medical Institutions shall ensure that Authorized Users do not use
CCMD for any other purpose.
3.2 Application for Use. Before accessing CCMD, Medical Institution shall require
each
Authorized User to acknowledge and sign the confidentiality statement (the
“Confidentiality
Statement”)which is incorporated herein by reference, as that form may be amended from
time to time. Medical Institution agrees to ensure that each Authorized User approved for
access under this Agreement adheres to the requirements of this Agreement and the
Confidentiality Statement. Each Authorized User shall also complete, in a form and in a
manner to be determined by KUALA Analytics Grp., training regarding the requirements
of provincial law as such requirements pertain to CCMD access.
227
Use or Disclose PHI accessed via the
CCMD in any manner that would constitute a violation of Applicable Laws, or that would
otherwise constitute a breach of this Agreement.
3.6 Audits. KUALA Analytics Grp. has the right, at Medical Institution’s sole cost
and expense, at any time, to monitor, audit, and review activities and methods in
implementing this Agreement in order to assure compliance therewith, within the limits of
Medical Institution’s technical capabilities.
3.8 Training. Medical Institution is responsible for training and educating the
Authorized Users regarding their obligations under the Data Privacy Act. Medical
Institution will provide evidence of the training and education of the Authorized Users on
KUALA Analytics Grp.’s request.
228
agents or by a third party to which Medical Institution Disclosed PHI within
one (1) business day of becoming aware of such unauthorized Use or
Disclosure. Such notice shall be made to the following:
3.10.2 If at any time Medical Institution has reason to believe that PHI
accessed by an Authorized User pursuant to this Agreement may have
been accessed or Disclosed without proper authorization and contrary to
the terms of this Agreement, Medical Institution will immediately give
KUALA Analytics Grp. notice and take actions to eliminate the cause of the
impermissible use or disclosure.
3.11 Third Party Access. Medical Institution and its Authorized Users are
expressly prohibited from allowing any third-party entity, agent or subcontractor to access
the EMR via CCMD or otherwise.
3.12 Mitigation. Medical Institution shall mitigate, to the extent practicable, any
harmful effect that is known to Medical Institution of a Use or Disclosure of PHI by Medical
Institution or its Authorized Users in violation of the requirements of this Agreement.
Medical Institution shall work cooperatively with KUALA Analytics Grp. in mitigating and
preventing any further unauthorized Use or Disclosure of PHI.
3.13 Data Ownership. Medical Institution acknowledges and agrees that KUALA
Analytics Grp. own all rights, interests, and title in and to the PHI and other data contained
in the EMR and that such rights, interests, and title shall remain vested in KUALA Analytics
Grp. at all times. Medical Institution shall not compile, de-identify, aggregate, and/or
distribute analyses to third parties utilizing any data received from or created or received
on behalf of without express written permission from KUALA Analytics Grp..
229
4. TERM AND TERMINATION
4.1 Term. The initial term of this Agreement shall be one (1) year. Unless otherwise
terminated, this Agreement shall automatically renew for successive one (1) year terms
thereafter on the same terms and conditions.
4.2 Termination.
4.2.1 Either party may terminate this Agreement by providing thirty (30)
days’ prior written notice to the other party of its intent to terminate.
5. MISCELLANEOUS
5.1 Covered Entity Status. KUALA Analytics Grp. and Medical Institution shall
comply in all material respects with the standards for privacy of individually identifiable
health information of the Data Privacy Act of 2012. Both parties recognize their status as
“covered entities” under RA10173 and agree to carry out their responsibilities under this
Agreement in accordance with such status.
5.2 No Referral Obligation. The parties acknowledge and agree that nothing
contained in this Agreement is conditioned on any requirement that either party make
referrals to, be in a
position to make or influence referrals to, or otherwise generate business for the other
party or any of the other party’s affiliates, and nothing contained in this Agreement shall
be interpreted to require or obligate either party to make referrals to, be in a position to
make or influence referrals to, or otherwise generate business for the other party or any
of the other party’s affiliates
5.3 Availability of Books and Records. Medical Institution agrees to make its
internal practices, books, and records relating to the Use and Disclosure of PHI received
from KUALA Analytics Grp., or created or received on behalf of KUALA Analytics Grp.,
available to the Secretary of the Philippine Department of Health (the “Secretary”) for
purposes of determining the both parties’ compliance with the RA 10173 standards.
Medical Institution promptly shall provide to KUALA Analytics Grp. a copy of any
documentation that Medical Institution provides to the Secretary.
5.4 Insurance. Each party shall maintain for its respective business, at its sole
expense,
230
policies of general liability and professional liability insurance, or self-insurance, in an
amount considered adequate for such businesses and deemed satisfactory to the other
party. In addition, each party shall maintain for its respective business, at its sole expense,
policies of insurance or self-insurance for workers compensation and property loss in an
amount considered adequate for such business and in accordance with any applicable
state statutory requirements and deemed satisfactory to the other party. Such policies shall
insure against any claim or claims for damages arising directly or indirectly in connection
with the acts or omissions of the respective party, its agents or employees pursuant to
performance under this Agreement. Each party shall provide, upon request of the other
party, applicable and valid certificates of insurance for any of the aforementioned policies
of insurance or self-insurance. Such policies shall include “cyber liability” insurance
coverage.
5.5 Entire Agreement. This Agreement and all Exhibits attached hereto, which are
hereby incorporated by reference, constitutes the entire understanding and agreement
between of the parties regarding access to CCMD and supersedes and replaces all prior
oral or written agreements, commitments, or understandings concerning the subject
matter provided for herein.
5.9 Waiver. Neither the waiver by any of the parties hereto of a breach of or a
default under any of the provisions of this Agreement, nor the failure of either of the parties,
on one (1) or more occasions, to enforce any of the provisions of this Agreement or to
exercise any right or privilege hereunder, will thereafter be construed as a waiver of any
subsequent breach or default of a similar nature, or as a waiver of any of such provisions,
rights or privileges hereunder.
5.11 Notice. Any notices given under this Agreement shall be in writing and
delivered by overnight PH mail, postage prepaid, return receipt requested or by certified
231
PH. mail, return receipt requested, postage prepaid, or by LBC or another nationally
recognized courier service (billed to sender), addressed as follows:
If to Medical Institution:
[INSERT ADDRESS]
Notices shall be effective three (3) days after mailing if mailed. Addresses for notice may
be changed from time to time without requiring an amendment to this Agreement.
IN WITNESS WHEREOF, the parties hereto have caused this Agreement to be executed
as of the day and year first above written.
_________________________________ __________________________________
Lance Ranier Tabel Printed Name and Signature
CEO
_______________________
______
Title of Signee
______________________________ _____________________________
Date Signed Date Signed
_____________________________
Name of Hospital
232
Appendix L: CCMD Contract with Medical Institution Employee Template
W I T N E S S E T H: That;
WHEREAS, User represents he/she has a need to have access to CCMD for
purposes of performing his/her job responsibilities; and
WHEREAS, KUALA Analytics Grp. and all hospitals licensed under CCMD have
certain obligations under provincial laws and private contract to protect the privacy and
security of confidential information relating to and maintained on CCMD; and
NOW, THEREFORE, for good and valuable consideration, the receipt and
adequacy of which hereby is acknowledged, the parties agree as follows:
233
a. Protected Health Information: Information relating to the past, present, or
future physical or mental health or condition of an individual; the provision of health
care to an individual; or the past, present, or future payment for the provision of
health care to an individual. Protected Health Information includes demographic
information, e.g., address, telephone number, employer, date of birth, next of kin,
identification numbers, as well as other information regulated under RA 10173 -
also known as the Data Privacy Act of 2012.
!,654C!6/!’&)!6*24/!’B*24&*+,’*+6&!*6!’,,4--!<<=:1! 9?!#-4/!2’-!’&)!/4’-6&!*6!E4(+4>4!*24!-
4,B/+*)!6?!#-4/@-!,6A0B*4/!0’--;6/5C!’,,4--!,654C! 6/!’&)!’B*26/+F’*+6&!#-4/!2’-!*2’*!’((6;-
234
!#-4/!*6!’,,4--!<<=:!2’-!E44&!,6A0/6A+-45C! #-4/!-2’((!/406/*!-B,2!,6&,4/&-
!*6!’00/60/+’*4!G’)-=45!04/-6&&4(!’-!-66&!’-!06--+E(41!
4. Exclusive Use: User shall use CCMD solely and exclusively for the purposes of
(1) providing health care services to those patients for whom User is directly involved in
providing care and treatment (hereinafter referred to as “User’s Patients”), (2) obtaining
payment for such care and treatment provided to User’s Patients, or (3) conducting health
care operations on behalf of KUALA Analytics Grp. User shall not, under any
circumstances, access the EMR system in order to obtain Confidential Information on User
or User’s family members. In accessing the EMR system, User shall attempt to gain
access only to that Confidential Information minimally necessary to provide care and
treatment to, or encode essential information about User’s Patients. User understands
that any other use of the EMR system is specifically prohibited, and any such prohibited
use may result in the termination of User’s access to the EMR system.
6. Tracking of Use: User understands that KUALA Analytics Grp. may monitor each
and every time the EMR system is accessed by any person. User understands that any
action User takes in the EMR system may be tagged with User’s Worker ID as established
in User’s profile, and such actions may be traced back to User.
9. Term and Termination: The term of this Agreement shall continue for so long as
User continues to have access to CCMD. User understands KUALA Analytics Grp. may
terminate such access at any time for any known or suspected violation of this Agreement
by User. User’s obligation to maintain the confidentiality of any and all Confidential
Information to which User gains access through the EMR System shall survive termination
of this Agreement.
235
10. Governing Law: The validity, interpretation, and performance of this Agreement
shall be governed by and construed in accordance with the laws of the Province of Cebu.
11. Severability: The provisions of this Agreement shall be deemed severable and if
any portion shall be held invalid, illegal or unenforceable for any reason, the remainder of
this Agreement shall be effective and binding upon the parties.
13. Amendments: This Agreement may be amended, but only in writing, signed by
the parties hereto.
IN WITNESS WHEREOF, the parties hereto have caused this Agreement to be executed
as of the day and year first above written.
___________________________ ____________________________
Signature Lance Ranier Tabel
CEO
__________________________
Title
___________________________ ____________________________
Date Signed Date Signed
________________________________
Name of Hospital under Employment
236
Appendix N: 360 Degree Feedback Template
237
238
Appendix O: Code of Conduct Template
239
Appendix P: Notice of Termination Template
240
Appendix Q: Quality Report Template
241
Appendix R: Support Ticket Template
242
Appendix T: Shifting of Employees
243
Chief Financial Officer
The Chief Financial Officer is the overall head of the financial department and
reports directly to the Chief Executive Officer.
244
________________________________________________________________
Chief Marketing Officer
The Chief Marketing Officer is responsible for planning, developing, implementing,
and monitoring the overall marketing strategy.
245
________________________________________________________________
Creative Director
The Creative Director is in charge of planning company advertisements, monitoring
brand campaigns, revising presentations, and shaping brand standards.
246
________________________________________________________________
● Excellent interpersonal and public-speaking skills
● Master’s Degree in Business Administration or relevant field
247
________________________________________________________________
● Solid critical-thinking and decision-making skills
● Expertise in programming and debugging
● Excellent verbal and written communication skills
● Bachelor’s/Master’s Degree in Computer Science,
Information Technology, or related field with experience
________________________________________________________________
248
Developer
The Developer is in charge of researching, designing, implementing, and managing software
programs.
250
Energ
Daily
y
Usag Quantit Annually Quantit Annually Quantit Annually
Appliance Requir
e y (kWh) y (kWh) y (kWh)
ement
(hrs)
s (kW)
Desktop
Computers
(CEO
Office,
Operations 0.225 8 8 5,256.00 8 5,256.00 9 5,913.00
Dept.,
Marketing
Dept.,
Reception)
Desktop
Computers
(IT 0.225 24 4 7,884.00 4 7,884.00 4 7,884.00
Department
)
Computer
Monitor (for
0.030 24 1 262.80 1 262.80 2 525.60
server
room)
All-in-one
0.175 8 5 2,555.00 5 2,555.00 5 2,555.00
HP Printer
Circular
Fluorescent 0.030 8 7 613.20 7 613.20 7 613.20
Lamp
LED Strip
0.010 8 6 175.20 6 175.20 6 175.20
Lights
251
T5 LED
(Wall 0.010 8 3 87.60 3 87.60 3 87.60
Mounted)
LowWattage
LED Light 0.003 24 4 105.12 4 105.12 4 105.12
Bulbs
Water
0.090 24 1 788.40 1 788.40 1 788.40
Dispenser
Multi-Split
Air condition
1.913 12 6 50,273.64 6 50,273.64 6 50,273.64
unit (2.0
HP)
Multi-Split
Air condition
1.913 24 3 50,273.64 3 50,273.64 3 50,273.64
unit (2.0
HP)
252
TOTAL 144,280.12 TOTAL 144,280.12 TOTAL 155,711.92
Energy Daily
Annually Annually
Appliance Requirements Usage Quantity Quantity
(kWh) (kWh)
(kW) (hrs)
Desktop
Computers
(CEO
Office,
Operations 0.225 8 9 5,913.00 9 5,913.00
Dept.,
Marketing
Dept.,
Reception)
Desktop
Computers 0.225 24 4 7,884.00 4 7,884.00
(IT
Department
)
Computer
Monitor (for
0.030 24 2 525.60 2 525.60
server
room)
All-in-one
0.175 8 5 2,555.00 5 2,555.00
HP Printer
253
Circular
Fluorescent 0.030 8 7 613.20 7 613.20
Lamp
LED Strip
0.010 8 6 175.20 6 175.20
Lights
T5 LED
(Wall 0.010 8 3 87.60 3 87.60
Mounted)
LowWattage
LED Light 0.003 24 4 105.12 4 105.12
Bubs
Water
0.090 24 1 788.40 1 788.40
Dispenser
Multi-Split
Air
condition 1.913 12 6 50,273.64 6 50,273.64
unit (2.0
HP)
Multi-Split
Air
condition 1.913 24 3 50,273.64 3 50,273.64
unit (2.0
HP)
Wi-Fi
Router 0.010 24 4 350.40 4 350.40
254
Server 1.200 24 3 31,536.00 3 31,536.00
255
Appendix W: Annual Water Consumption Breakdown
Flushing
0.012 31 4,151.52 32 4,285.44 33 4,419.36
Toilet
Using
Bathroom 0.030 31 10,476.78 32 10,814.74 33 11,152.70
Sink
Using
0.030 31 10,476.78 32 10,814.74 33 11,152.70
Kitchen Sink
Flushing
0.012 33 4,419.36 33 4,419.36
Toilet
Using
Bathroom 0.030 33 11,152.70 33 11,152.70
Sink
Using
0.030 33 11,152.70 33 11,152.70
Kitchen Sink
256
TOTAL 26,724.75 TOTAL 26,724.75
2022 2023
NEEDED PURCHASED USED SELL REMAIN NEEDED PURCHASED USED SELL REMAIN
Desktop 12 12 12 0 12 12 0 12 0 12
Computer
All-in-one 5 5 5 0 5 5 0 5 0 5
Printer
Monitor 1 1 1 0 1 1 0 1 0 1
Rack 2 2 2 0 2 2 0 2 0 2
Server
Wifi 4 4 4 0 4 4 0 4 0 4
Router
2024 2025
257
Desktop 12 0 12 0 12 13 1 13 0 13
Computer
All-in-one 5 0 5 0 5 5 0 5 0 5
Printer
Monitor 1 0 1 0 1 2 0 2 0 2
Rack 2 0 2 0 5 3 1 3 0 3
Server
Wifi 4 0 4 0 4 4 0 4 0 4
Router
2026 2027
NEEDED PURCHASED USED SELL REMAIN NEEDED PURCHASED USED SELL REMAIN
Desktop 13 0 13 0 13 13 13 13 12 1
Computer
All-in-one 5 0 5 0 5 5 5 5 5 0
Printer
Monitor 2 0 2 0 2 2 0 2 0 2
Rack 3 0 3 0 3 3 0 3 0 3
Server
Wifi 4 0 4 0 4 4 4 4 4 0
Router
2022 2023
258
CCTV 14 14 14 0 14 14 0 14 0 14
Biometrics 1 1 1 0 1 1 0 1 0 1
Lock
Server 1 1 1 0 1 1 0 1 0 1
Cabinet
1 1 1 0 1 1 0 1 0 1
RackMounted
Fan Unit
Power 1 1 1 0 1 1 0 1 0 1
Distributio n
Unit
Ethernet 1 1 1 0 1 1 0 1 0 1
Switch
1 1 1 0 1 1 0 1 0 1
Patch Panel
MTP 1 1 1 0 1 1 0 1 0 1
Adapter
Panel
1 1 1 0 1 1 0 1 0 1
MTP Fiber
Patch Panel
1 1 1 0 1 1 0 1 0 1
SC Fiber
Patch Panel
Horizontal 1 1 1 0 1 1 0 1 0 1
Cable
Manager
2024 2025
259
CCTV 14 0 14 0 14 14 0 14 0 14
Biometrics 1 0 1 0 1 1 0 1 0 1
Lock
Server 1 0 1 0 1 1 0 1 0 1
Cabinet
1 0 1 0 1 1 0 1 0 1
RackMounted
Fan Unit
Power 1 0 1 0 1 1 0 1 0 1
Distributio n
Unit
Ethernet 1 0 1 0 1 1 0 1 0 1
Switch
1 0 1 0 1 1 0 1 0 1
Patch Panel
MTP 1 0 1 0 1 1 0 1 0 1
Adapter
Panel
1 0 1 0 1 1 0 1 0 1
MTP Fiber
Patch Panel
SC Fiber 1 0 1 0 1 1 0 1 0 1
Patch
Panel
Horizontal 1 0 1 0 1 1 0 1 0 1
Cable
Manager
2026 2027
260
CCTV 14 0 14 0 14 14 0 14 0 14
Biometrics 1 0 1 0 1 1 1 1 1 0
Lock
Server 1 0 1 0 1 1 0 1 0 1
Cabinet
1 0 1 0 1 1 0 1 0 1
RackMounted
Fan Unit
Power 1 0 1 0 1 1 0 1 0 1
Distributio n
Unit
Ethernet 1 0 1 0 1 1 0 1 0 1
Switch
1 0 1 0 1 1 0 1 0 1
Patch Panel
MTP 1 0 1 0 1 1 0 1 0 1
Adapter
Panel
1 0 1 0 1 1 0 1 0 1
MTP Fiber
Patch Panel
1 0 1 0 1 1 0 1 0 1
SC Fiber
Patch Panel
Horizontal 1 0 1 0 1 1 0 1 0 1
Cable
Manager
2022 2023
NEEDED PURCHASED USED SELL REMAIN NEEDED PURCHASED USED SELL REMAIN
261
Water 1 1 1 0 1 1 0 1 0 1
Dispenser
Air 9 9 9 0 9 9 0 9 0 9
conditioner
Television 3 3 3 0 3 3 0 3 0 3
Refrigerator 1 1 1 0 1 1 0 1 0 1
Coffee 1 1 1 0 1 1 0 1 0 1
Maker
Microwave 1 1 1 0 1 1 0 1 0 1
Filing 20 20 20 0 20 20 0 20 0 20
Cabinet
Office Desk 24 24 24 0 24 24 0 24 0 24
Office Chair 30 30 30 0 30 30 0 30 0 30
Conference 1 1 1 0 1 1 0 1 0 1
Table
Office sofa 1 1 1 0 1 1 0 1 0 1
set
Reception 1 1 1 0 1 1 0 1 0 1
Counter
Pantry Set 1 1 1 0 1 1 0 1 0 1
CEO Office 1 1 1 0 1 1 0 1 0 1
Table
CEO Office 1 1 1 0 1 1 0 1 0 1
Chair
Pinlight 29 29 29 0 29 29 0 29 0 29
Circular 7 7 7 0 7 7 0 7 0 7
Fluorescent
Lamp
262
LED Light 6 6 6 0 6 6 0 6 0 6
Strips
T5 LED 3 3 3 0 3 3 0 3 0 3
(Wall
Mounted)
Low- 4 4 4 0 4 4 0 4 0 4
Wattage
LED Light
Bulb
2024 2025
NEEDED PURCHASED USED SELL REMAIN NEEDED PURCHASED USED SELL REMAIN
Water 1 0 1 0 1 1 0 1 0 1
Dispenser
Air 9 0 9 0 9 9 0 9 0 9
Conditioner
Television 3 0 3 0 3 3 0 3 0 3
Refrigerator 1 0 1 0 1 1 0 1 0 1
Coffee 1 0 1 0 1 1 0 1 0 1
Maker
Microwave 1 0 1 0 1 1 0 1 0 1
Filing 20 0 20 0 20 20 0 20 0 20
Cabinet
Office Desk 24 0 24 0 24 24 0 24 0 24
Office Chair 31 1 31 0 31 31 0 31 0 31
Conference 1 0 1 0 1 1 0 1 0 1
Table
263
Office sofa 1 0 1 0 1 1 0 1 0 1
set
Reception 1 0 1 0 1 1 0 1 0 1
Counter
Pantry Set 1 0 1 0 1 1 0 1 0 1
CEO Office 1 0 1 0 1 1 0 1 0 1
Table
CEO Office 1 0 1 0 1 1 0 1 0 1
Chair
Pinlight 29 0 29 0 29 29 0 29 0 29
Circular 7 0 7 0 7 7 7 7 0 7
Fluorescent
Lamp
LED Light 6 0 6 0 6 6 0 6 0 6
Strips
T5 LED 3 0 3 0 3 3 0 3 0 3
(Wall
Mounted)
Low- 4 0 4 0 4 4 0 4 0 4
Wattage
LED Light
Bulb
2026 2027
NEEDED PURCHASED USED SELL REMAIN NEEDED PURCHASED USED SELL REMAIN
Water 1 0 1 0 1 1 0 1 0 1
Dispenser
Air 9 0 9 0 9 9 0 9 0 9
Conditioner
Television 3 0 3 0 3 3 0 3 0 3
264
Refrigerator 1 0 1 0 1 1 0 1 1 0
Coffee 1 0 1 0 1 1 0 1 1 0
Maker
Microwave 1 0 1 0 1 1 0 1 1 0
Filing 20 0 20 0 20 20 0 20 0 20
Cabinet
Office Desk 25 1 25 0 25 26 1 26 0 26
Office Chair 33 2 33 0 33 34 1 34 0 34
Conference 1 0 1 0 1 1 0 1 0 1
Table
Office sofa 1 0 1 0 1 1 0 1 0 1
set
Reception 1 0 1 0 1 1 0 1 0 1
Counter
Pantry Set 1 0 1 0 1 1 0 1 0 1
CEO Office 1 0 1 0 1 1 0 1 0 1
Table
CEO Office 1 0 1 0 1 1 0 1 0 1
Chair
Pinlight 29 0 29 0 29 29 0 29 0 29
Circular 7 0 7 0 7 7 0 7 0 7
Fluorescent
Lamp
LED Light 6 6 6 0 6 6 0 6 0 6
Strips
T5 LED 3 3 3 0 3 3 0 3 0 3
(Wall
Mounted)
265
Low- 4 4 4 0 4 4 0 4 0 4
Wattage
LED Light
Bulb
266
Screwdriver 2 for whole office 2 2 2 2 2 2
Sanitary and Safety Materials 2022 2023 2024 2025 2026 2027
Mop 1 for CR 1 1 1 1 1 1
267
Inflation Percent Increase/
Term Year Rate Cycle Percentage Change Decrease
Transition
2010 4.11 21.93% Year 1.27 Increase
15th
2013 2.58 13.77% 0.85 Decrease
Transition
2016 1.25 6.90% Year 1.87 Increase
Transition
2022 4.26 31.89% Year 1.08 Increase
17th
268
2025 1.73 12.93% 1.59 Increase
Annual ₱13,300.00
Semi-annually ₱7,315.00
Quarterly ₱5,364.00
Monthly ₱1,475.00
Annual ₱14,231.00
Semi-annually ₱7,827.05
Quarterly ₱5,739.48
269
Monthly ₱1,578.25
Development
Representative
₱21,350.00 8 ₱14,233.33 1 ₱28,432.00 ₱213,465.33
Software
Development
Manager
₱89,430.00 8 ₱59,620.00 1 ₱50,217.60 ₱825,277.60
Full Stack
Developer
₱28,297.42 8 ₱18,864.95 1 ₱30,655.17 ₱275,899.48
Backend
Developers
₱22,321.43 8 ₱14,880.95 6 ₱172,457.15 ₱1,333,171.51
Frontend
Developer
₱24,302.67 8 ₱16,201.78 1 ₱29,376.85 ₱239,999.99
Quality Assurance
Engineer
₱18,165.17 8 ₱12,110.11 1 ₱25,332.85 ₱182,764.33
Customer Service
Representatives
₱13,501.67 8 ₱9,001.11 6 ₱114,963.21 ₱817,050.05
Information
Security Staff
₱16,827.98 8 ₱11,218.65 1 ₱23,864.95 ₱169,707.45
Total ₱4,580,923.72
270
Total Annual Total Annual Total Annual Total Annual Total Annual
Creative
Director
₱503,247.88 ₱510,446.73 ₱519,289.97 ₱532,659.11 ₱539,585.27
Graphic
Designer
₱302,887.71 ₱307,019.32 ₱312,350.33 ₱320,023.23 ₱323,998.34
Development
Representative
₱328,288.01 ₱332,808.46 ₱338,584.73 ₱346,979.77 ₱351,328.99
Software
Development
Manager
₱1,269,890.23 ₱1,288,825.33 ₱1,311,107.47 ₱1,346,272.25 ₱1,364,490.08
Full Stack
Developer
₱424,376.52 ₱430,367.96 ₱437,828.62 ₱448,955.45 ₱454,719.93
Backend
Developers
₱2,050,342.08 ₱2,078,698.90 ₱2,114,769.64 ₱2,167,431.71 ₱2,194,714.37
Frontend
Developer
₱369,125.85 ₱374,271.48 ₱380,763.62 ₱390,319.67 ₱395,270.38
Quality
Assurance
Engineer
₱281,899.20 ₱286,525.32 ₱291,529.44 ₱299,452.16 ₱303,932.60
Customer
Service
Representative
s
₱1,262,275.00 ₱1,279,427.33 ₱1,519,779.41 ₱1,562,402.36 ₱1,587,115.38
Information
Security Staff
₱261,064.76 ₱491,290.19 ₱499,870.02 ₱513,591.96 ₱521,076.79
271
Appendix AB: Annual Primary Machine Maintenance Expense Breakdown
272
Appendix AC: Operating Expense Breakdown
Rent Expense
Where; X = year
Monthly RentX = cost of rent for year X
YX = number of months renting in year X
Salaries Expense
Financial Accountant
₱25,025.25 8 ₱16,683.50 1 29,608.08 ₱246,493.58
273
Management
Accountant
₱27,775.00 8 ₱18,516.67 1 30,488.00 ₱271,204.67
Internal Auditor ₱19,457.67 8 ₱12,971.78 1 27,306.45 ₱195,939.59
Human Resource
Manager
₱21,400.75 8 ₱14,267.17 1 28,448.24 ₱213,921.41
Staffing Personnel ₱15,083.00 8 ₱10,055.33 1 21,226.56 ₱151,945.89
Total ₱3,676,016.05
Financial
Accountant
₱379,119.73 ₱384,418.35 ₱391,085.67 ₱400,925.85 ₱406,023.76
Management
Accountant
₱417,151.02 ₱423,031.85 ₱430,365.85 ₱441,287.26 ₱446,945.32
Internal Auditor ₱302,115.53 ₱306,235.32 ₱311,552.80 ₱319,203.75 ₱323,167.48
Marketing
Manager
₱392,601.32 ₱398,106.32 ₱405,009.98 ₱415,233.44 ₱420,529.91
Marketing
Analyst
₱341,994.35 ₱346,724.63 ₱352,741.16 ₱361,525.87 ₱366,076.97
COO ₱944,160.17 ₱958,108.79 ₱974,681.03 ₱1,000,585.30 ₱1,014,005.54
274
Human
Resource
Manager
₱328,989.92 ₱333,521.12 ₱339,309.69 ₱347,724.68 ₱352,084.24
Staffing
Personnel
₱234,590.26 ₱237,783.79 ₱242,820.64 ₱249,531.43 ₱252,603.99
₱2,400.0 ₱19,200.
0 00
CEO ₱60,000.00 8 ₱2,600.00 ₱20,800.00 ₱100.00 ₱800.00 ₱40,800.00
₱2,783.5 ₱22,268.
6 45
CFO ₱69,588.92 8 ₱2,600.00 ₱20,800.00 ₱100.00 ₱800.00 ₱43,868.45
₱6,226.4
5
Internal Auditor ₱19,457.67 8 ₱2,535.00 ₱20,280.00 ₱100.00 ₱800.00 ₱778.31 ₱27,306.45
₱1,227.9 ₱9,823.6
6 8
CMO ₱30,699.00 8 ₱2,600.00 ₱20,800.00 ₱100.00 ₱800.00 ₱31,423.68
Marketing ₱7,149.1
Analyst 2
₱22,341.00 8 ₱2,600.00 ₱20,800.00 ₱100.00 ₱800.00 ₱893.64 ₱28,749.12
275
Graphic ₱6,244.3
Designer 2
₱19,513.50 8 ₱2,535.00 ₱20,280.00 ₱100.00 ₱800.00 ₱780.54 ₱27,324.32
₱2,635.1 ₱21,081.
6 27
COO ₱65,878.97 8 ₱2,600.00 ₱20,800.00 ₱100.00 ₱800.00 ₱42,681.27
Human
Resource
₱6,848.2
Manager
₱21,400.75 8 ₱2,600.00 ₱20,800.00 ₱100.00 ₱800.00 ₱856.03 4 ₱28,448.24
Staffing ₱4,826.5
Personnel 6
₱15,083.00 8 ₱1,950.00 ₱15,600.00 ₱100.00 ₱800.00 ₱603.32 ₱21,226.56
Development ₱6,832.0
Representative 0
₱21,350.00 8 ₱2,600.00 ₱20,800.00 ₱100.00 ₱800.00 ₱854.00 ₱28,432.00
Software
Development
₱3,577.2 ₱28,617.
Manager
₱89,430.00 8 ₱2,600.00 ₱20,800.00 ₱100.00 ₱800.00 0 60 ₱50,217.60
Frontend ₱7,776.8
Developer 5
₱24,302.67 8 ₱2,600.00 ₱20,800.00 ₱100.00 ₱800.00 ₱972.11 ₱29,376.85
Quality
Assurance
₱5,812.8
Engineer
₱18,165.17 8 ₱2,340.00 ₱18,720.00 ₱100.00 ₱800.00 ₱726.61 5 ₱25,332.85
Customer
Service
Representative
₱4,800. ₱25,923.
s
₱13,501.67 8 ₱1,755.00 ₱84,240.00 ₱100.00 00 ₱540.07 21 ₱114,963.21
Information ₱5,384.9
Security Staff 5
₱16,827.98 8 ₱2,210.00 ₱17,680.00 ₱100.00 ₱800.00 ₱673.12 ₱23,864.95
₱22,400. ₱259,062.
00 36
Total ₱670,959.40 ₱592,800.00 ₱889,623.97
276
CFO ₱71,385.14 ₱76,112.03 ₱77,456.37 ₱78,663.56 ₱79,288.97
Financial
Accountant
₱46,803.89 ₱48,503.75 ₱49,371.43 ₱49,805.55 ₱50,030.46
Management
Accountant
₱48,320.65 ₱50,207.29 ₱51,104.38 ₱51,586.20 ₱51,835.82
Internal Auditor ₱43,732.82 ₱45,054.50 ₱45,862.62 ₱46,200.17 ₱46,375.04
Marketing
Manager
₱47,341.56 ₱49,107.63 ₱49,985.73 ₱50,436.77 ₱50,670.44
Marketing
Analyst
₱45,323.26 ₱46,840.79 ₱47,679.76 ₱48,067.32 ₱48,268.10
Creative Director
₱51,754.35 ₱54,063.83 ₱55,027.50 ₱55,617.31 ₱55,922.88
Graphic
Designer
₱43,763.62 ₱45,089.09 ₱45,897.81 ₱46,236.32 ₱46,411.69
COO ₱69,338.74 ₱73,813.62 ₱75,118.28 ₱76,261.12 ₱76,853.19
Human
Resource
Manager
₱44,804.62 ₱46,258.28 ₱47,087.19 ₱47,458.44 ₱47,650.78
Staffing
Personnel
₱34,299.76 ₱35,324.29 ₱36,865.62 ₱37,907.27 ₱38,042.82
Development
Representative
₱44,776.63 ₱46,226.84 ₱47,055.21 ₱47,425.58 ₱47,617.46
Software
Development
₱82,329.45 ₱88,404.06 ₱89,960.62 ₱91,512.01 ₱92,315.74
Manager
Full Stack
Developer
₱48,608.81 ₱50,530.94 ₱51,433.62 ₱51,924.51 ₱52,178.82
Backend
Developers
₱271,874.79 ₱280,972.01 ₱286,004.54 ₱288,327.87 ₱289,531.52
Frontend
Developer
₱46,405.31 ₱48,056.09 ₱48,916.04 ₱49,337.63 ₱49,556.05
277
Quality
Assurance
Engineer
₱40,679.88 ₱42,693.76 ₱43,488.06 ₱44,583.18 ₱45,526.44
Customer
Service
Representatives
₱186,525.00 ₱192,027.68 ₱229,243.21 ₱236,342.75 ₱242,652.15
Information
Security Staff
₱37,602.29 ₱39,525.34 ₱40,305.34 ₱41,377.26 ₱42,308.50
Total ₱1,421,699.98 ₱1,481,002.06 ₱1,542,223.70 ₱1,565,004.60 ₱1,579,785.76
Electrical
Technician
1 ₱142.89 6 ₱857.34
2024 Frequency Hourly Rate Service Time (Hrs) Total
278
Electrical
Technician
1 ₱144.44 6 ₱866.62
2025 Frequency Hourly Rate Service Time (Hrs) Total
Electrical
Technician
1 ₱146.93 6 ₱881.59
2026 Frequency Hourly Rate Service Time (Hrs) Total
Electrical
Technician
1 ₱150.98 6 ₱905.85
2027 Frequency Hourly Rate Service Time (Hrs) Total
Electrical
Technician
1 ₱153.07 6 ₱918.43
Advertising Expense
Advertising Expense
2022 2023 2024
Rate (per
impression)
Quantity Total Quantity Total Quantity Total
Facebook
Ads
₱0.65 1,500,000 ₱975,000.00 1,000,000 ₱663,961.08 500,000 ₱335,575.66
Rate (per
sheet)
Quantity Total Quantity Total Quantity Total
Flyers
Annual
Grand
₱1,115,000.0
Total
0 ₱814,118.43 ₱346,417.34
279
2025 2026 2027
Rate (per
impression)
Quantity Total Quantity Total Quantity Total
Facebook Ads
₱0.68 500,000 ₱341,369.46 350,000 ₱245,536.22 350,000 ₱248,943.88
Rate (per
sheet)
Quantity Total Quantity Total Quantity Total
Flyers
Annual Grand
Total
₱352,398.32 ₱253,091.18 ₱256,603.69
Supplies Expense
Supplies Expense
Type 2022 2023 2024 2025 2026 2027
Long Bond
Paper
₱ 1,750.00 ₱ 1,787.63 ₱ 1,806.93 ₱ 1,838.19 ₱ 1,888.74 ₱ 1,915.00
Short Bond
Paper
₱ 1,750.00 ₱ 1,787.63 ₱ 1,806.93 ₱ 1,838.19 ₱ 1,888.74 ₱ 1,915.00
Long Folder ₱ 675.00 ₱ 689.51 ₱ 696.96 ₱ 709.02 ₱ 728.51 ₱ 738.64
280
Brown
Envelope
₱ 398.00 ₱ 406.56 ₱ 410.95 ₱ 418.06 ₱ 429.55 ₱ 435.52
Stapler ₱ 1,245.00 ₱- ₱- ₱- ₱- ₱-
Scissors ₱ 565.00 ₱- ₱- ₱- ₱- ₱-
Screwdriver ₱ 1,328.00 ₱- ₱- ₱- ₱- ₱-
Bathroom
Tissue
₱ 11,040.00 ₱ 11,277.36 ₱ 11,399.16 ₱ 11,596.36 ₱ 11,915.26 ₱ 12,080.88
Fire
Extinguisher
₱ 5,600.00 ₱- ₱- ₱- ₱- ₱-
Trash Can ₱ 1,736.00 ₱- ₱ 1,792.48 ₱- ₱- ₱ 1,899.68
Liquid Hand
Soap
₱ 1,881.00 ₱ 1,921.44 ₱ 1,942.19 ₱ 1,975.79 ₱ 2,030.13 ₱ 2,058.35
Broom and
Dustpan
₱ 265.00 ₱ 270.70 ₱- ₱ 278.35 ₱- ₱ 289.98
Multi-Purpose
Cleaner
₱ 480.00 ₱ 490.32 ₱ 495.62 ₱ 504.19 ₱ 518.05 ₱ 525.26
281
TOTAL ₱ 61,951.25 ₱ 52,584.01 ₱ 54,164.83 ₱ 54,449.59 ₱ 55,520.64 ₱ 59,806.12
Supplies Expense
Stapler ₱ 1,245.00 ₱- ₱- ₱- ₱- ₱-
Scissors ₱ 565.00 ₱- ₱- ₱- ₱- ₱-
282
Liquid Hand Soap ₱ 1,881.00 ₱ 1,921.44 ₱ 1,942.19 ₱ 1,975.79 ₱ 2,030.13 ₱ 2,058.35
Multi-Purpose
Cleaner
₱ 480.00 ₱ 490.32 ₱ 495.62 ₱ 504.19 ₱ 518.05 ₱ 525.26
TOTAL ₱ 60,623.25 ₱ 52,584.01 ₱ 54,164.83 ₱ 54,449.59 ₱ 55,520.64 ₱ 59,806.12
Depreciation Expense
2022
Yearly
Useful Monthly Depreciation
Cost Per Salvage Life Depreciation
Fixed Assets Unit Value Qty Total Cost Cost
(Years) Cost
Computer
Office Equipment
HP All-in-one Printer
₱8,600.00 ₱430.00 5 ₱43,000.00 5 ₱680.83 ₱8,170.00
Telephone ₱700.00 ₱35.00 5 ₱3,500.00 8 ₱34.64 ₱415.63
283
Server ₱41,500.00 ₱2,075.00 1 ₱41,500.00 7 ₱469.35 ₱5,632.14
Furnitures and
Fixtures
284
Wifi Router ₱1,975.24 ₱1,975.24 ₱1,975.24 ₱1,975.24 ₱1,975.24 ₱2,161.47
Auxiliary Equipment
Rack-Mounted Fan
Unit (1U)
₱434.47 ₱434.47 ₱434.47 ₱434.47 ₱434.47 ₱434.47
Power Distribution
Unit (PDU)
₱174.17 ₱174.17 ₱174.17 ₱174.17 ₱174.17 ₱174.17
Ethernet Switch ₱790.88 ₱790.88 ₱790.88 ₱790.88 ₱790.88 ₱790.88
Horizontal Cable
Manager (1U) ₱100.94 ₱100.94 ₱100.94 ₱100.94 ₱100.94 ₱100.94
TOTAL ₱12,746.67 ₱12,746.67 ₱12,746.67 ₱12,746.67 ₱12,746.67 ₱12,746.67
285
Refrigerator ₱3,419.05 ₱3,419.05 ₱3,419.05 ₱3,419.05 ₱3,419.05 ₱3,741.41
Circular Fluorescent
Lamp ₱321.42 ₱321.42 ₱321.42 ₱659.03 ₱659.03 ₱659.03
Utilities Expense
A. Electrical Consumption
286
ConsumptionX = total electricity consumption for year X
Electricity Rate
2022 ₱13.68 -
Electrical Consumption
2022
Energy Daily
Requireme Usage
Annually
nts (kW) (hrs)
Appliance Quantity Daily Monthly (kWh)
0.03 8 7
Circular Fluorescent Lamp 1.68 50.40 403.20
287
LED Strip Lights 0.01 8 6 0.48 14.40 115.20
0.003 24 4
Low-Wattage LED Light Bubs 0.29 8.64 69.12
Refrigerator 0.17 24 1 4.08 122.40 979.20
288
Computer
Monitor (for
server room)
1 262.80 1 262.80 2 525.60
All-in-one HP
Printer
5 2,555.00 5 2,555.00 5 2,555.00
Telephone 4 105.12 4 105.12 4 105.12
Circular
Fluorescent
7 613.20 7 613.20 7 613.20
Lamp
LED Strip
Lights
6 175.20 6 175.20 6 175.20
T5 LED (Wall
Mounted)
3 87.60 3 87.60 3 87.60
Low-Wattage
LED Light
Bulbs
4 105.12 4 105.12 4 105.12
Refrigerator 1 1,489.20 1 1,489.20 1 1,489.20
Water
Dispenser
1 788.40 1 788.40 1 788.40
Multi-Split Air
condition unit
(2.0 HP)
6 50,273.64 6 50,273.64 6 50,273.64
Multi-Split Air
condition unit
(2.0 HP)
3 50,273.64 3 50,273.64 3 50,273.64
Wi-Fi Router 4 350.40 4 350.40 4 350.40
289
TOTAL 144,280.12 TOTAL 144,280.12 TOTAL 155,711.92
2026 2027
290
Multi-Split Air condition unit
(2.0 HP)
3 50,273.64 3 50,273.64
Year Total
2022 ₱1,297,809.56
2023 ₱2,016,145.43
2024 ₱2,037,978.93
2025 ₱2,237,429.01
2026 ₱2,299,016.67
2027 ₱2,330,923.42
B. Water Consumption
Where; X = year
RateX = price per m3 for year X
ConsumptionX = total water consumption for year X
MCWD m3 Rate
2022 ₱16.02 -
291
2023 16.36 2.15
Water Rates
2022 ₱16.02 -
Water Consumption
2022 2023
Using
Bathroom Sink
0.0302832 31 0.94 28.16 6,984.52 30 10,138.82
Using Kitchen
Sink
0.0302832 31 0.94 28.16 6,984.52 30 10,138.82
TOTAL 2.18 54.42 16,736.71 TOTAL 24,295.23
2024 2025
292
(m3)
Using Bathroom
Sink
0.0302832 31 10,476.78 31 10,476.78
Using Kitchen
Sink
0.0302832 31 10,476.78 31 10,476.78
TOTAL 25,105.07 TOTAL 25,105.07
2026 2027
Consumption
(m3)
Description Users Annually (m3) Users Annually (m3)
Flushing Toilet 0.012 33 4,419.36 34 4,553.28
Using Bathroom
Sink
0.0302832 33 11,152.70 34 11,490.66
Using Kitchen
Sink
0.0302832 33 11,152.70 34 11,490.66
TOTAL 26,724.75 TOTAL 27,534.59
Water Consumption
(Summary)
Year Total
2022 ₱268,122.17
2023 ₱410,821.57
2024 ₱428,666.32
2025 ₱449,694.46
2026 ₱462,072.78
2027 ₱482,682.16
C. Telephone/Internet Consumption
293
𝐴𝑛𝑛𝑢𝑎𝑙 𝑇𝑒𝑙𝑐𝑜𝑚_𝐸𝑥𝑝𝑒𝑛𝑠𝑒* =
𝑀𝑜𝑛𝑡ℎ𝑙𝑦 𝑅𝑎𝑡𝑒* ∗ 𝑌*
Where; X = year
Monthly RateX = monthly price of PLDT plan for year
X
YX = number of months availing plan in
year X
Inflation
Rate
Year Monthly Rate Months
2022 ₱12,500.00 - 8
Year Total
2022 ₱100,000.00
2023 ₱153,221.79
2024 ₱154,881.08
2025 ₱157,555.14
2026 ₱161,892.01
2027 ₱164,138.82
294
Appendix AD: Complete Return on Investment Forecast
𝑆𝑙𝑜𝑝𝑒 = 2849743.312
𝑌 − 𝑖𝑛𝑡𝑒𝑟𝑐𝑒𝑝𝑡 = −5768717661
Return on Investment
295
Php 13,750.00 - Php 14,249.99 Php 1,820.00
CURRICULUM VITAE
296