Hospital Operational Cost Optimization: A Practical Guide to SIMRS Efficiency

In today's dynamic healthcare landscape, managing hospital operational costs effectively is no longer merely an administrative task, but a strategic necessity. Many hospitals still struggle with insufficiently transparent cost structures, often leading to inefficiencies, budget overruns, and ultimately, the potential decline in patient service quality. Without clear visibility into every cost component, from medicine procurement to staff salaries and medical equipment maintenance, optimization efforts often become guesswork. This problem is exacerbated by the complexity of data scattered across various systems, making accurate and rapid data-driven decision-making difficult. This article will guide you, hospital operational and IT managers, to deeply understand how to calculate operational costs, identify areas of waste, and implement proven optimization strategies through a comprehensively integrated Hospital Management Information System (SIMRS). We will discuss basic concepts, technical implementation, code examples, and best practices to achieve maximum efficiency and improve healthcare service quality.

Analysis of Hospital Operational Cost Components

Understanding cost structure is the first fundamental step in any optimization effort. Hospital operational costs can generally be categorized into several main components: direct costs and indirect costs. Direct costs include all expenses that are directly and can be attributed to patient care, such as salaries of doctors and nurses directly involved, costs of medicines consumed by patients, consumable medical devices, and costs for laboratory tests or radiology procedures. As a concrete example, the cost of one unit of a particular antibiotic injection includes not only the cost of the drug itself, but also the cost of the syringe, alcohol swabs, nurse time for administration, and the cost of handling the resulting medical waste. Identifying and tracking these costs accurately requires a detailed recording system, often integrated into the pharmacy and inventory modules of SIMRS.

Indirect costs, on the other hand, are expenses that cannot be directly traced to one specific patient service but are essential to support the hospital's overall operations. This category includes administrative staff salaries, utility costs such as electricity, water, and gas, maintenance of buildings and general equipment, marketing costs, insurance premiums, asset depreciation, and of course, IT costs such as SIMRS software licenses and network infrastructure. A real example: the electricity cost for cooling the SIMRS servers or the maintenance cost of the electric generator is an indirect cost that sustains the entire hospital operation. Allocating these indirect costs fairly to service units or patients often requires special methodologies such as Activity-Based Costing (ABC), which identifies cost-driving activities and distributes them proportionally.

Furthermore, it is also important to distinguish between fixed costs and variable costs. Fixed costs are expenses that do not change regardless of the volume of patients or services provided, such as building rent, senior management salaries, or depreciation of large equipment. Conversely, variable costs fluctuate with changes in service volume, such as patient food costs, laboratory reagents, or the amount of linen washed. Break-even analysis becomes crucial here, where the hospital needs to understand what minimum patient volume must be served or what revenue must be generated to cover all costs. For example, if monthly fixed costs are Rp 750 million and the average contribution margin per patient is Rp 1.5 million, the hospital needs to serve 500 patients per month just to reach operational break-even.

Implementing a robust cost accounting system within SIMRS enables each department to have visibility into its budget and expenditures in real-time. With an integrated accounting module, every transaction, from purchasing consumables to patient billing, can be categorized and tracked with precision. This provides a strong data foundation for in-depth analysis, enabling managers to see spending trends, identify anomalies or waste, and make more appropriate strategic decisions, both for negotiations with vendors and adjustments to service rates. Without accurate and integrated data from information systems, optimization efforts will only be high-risk assumptions.

Technical Implementation of Cost Optimization through SIMRS

Optimizing operational costs in modern hospitals heavily depends on the use of information technology, especially comprehensively integrated SIMRS. Nugroho Setiawan, with his extensive experience in SIMRS development and integration with external systems such as BPJS, SatuSehat, and FHIR, understands that SIMRS is not only about medical records, but also the backbone of financial and operational management. Effective implementation begins with choosing a scalable, modular, and interoperable SIMRS architecture. For example, using a modern backend framework such as Laravel 11.x for business logic and API, combined with a Vue.js 3.x-based frontend for a responsive user experience, as well as a robust relational database such as PostgreSQL 16, provides a solid foundation for managing large volumes of financial and operational data. PostgreSQL, with its advanced features such as JSONB, is highly suitable for storing transaction log data or flexible configurations.

Integration between SIMRS modules is the main key to efficiency. The Pharmacy Module must be closely connected with the Finance and Inventory Modules to track drug movement from purchasing, storage, to dispensing to patients, including calculation of cost of goods sold (COGS) and profit margin. Likewise, the Laboratory and Radiology Modules must automatically send service billing details to the Patient Billing Module. This integration can be implemented using a well-designed RESTful API, with standards such as FHIR R4 for clinical data exchange and ADT (Admission, Discharge, Transfer) messages using HL7 v2.5.1 for administrative data. For example, when a patient is registered, the registration data automatically enters the registration module, then is forwarded to the billing module for opening the patient account, and so on, without the need for repeated manual entry.

The use of an integrated ERP (Enterprise Resource Planning) system, such as those often developed by Nugroho Setiawan's team, is very helpful in hospital supply chain management. The purchasing module can be automated to compare prices from various vendors, track discounts, and manage contracts efficiently. For example, the system can intelligently identify that the price of a certain reagent from Vendor A is 15% cheaper than Vendor B for the same purchase volume, or recommend bulk purchasing to get a better discount price. This can significantly reduce procurement costs. Furthermore, the system can also predict inventory needs based on historical usage trends, avoiding stock buildup that incurs storage costs or, conversely, stock shortages that can disrupt vital services.

For in-depth reporting and analysis, data from various SIMRS modules must be consolidated into a data warehouse. Powerful Business Intelligence (BI) tools such as Metabase, Power BI, or Tableau can be used to create interactive dashboards that display financial and operational Key Performance Indicators (KPIs) in real-time. Relevant KPIs include cost per patient per day (CPPD), drug cost to revenue ratio, or efficiency of medical equipment resource use. This analysis allows managers to visualize data, identify trends, find anomalies, and discover areas that need immediate attention. For example, the dashboard can show that the CPPD cost in ward A is 20% higher than in ward B, triggering further investigation into the causes, such as differences in drug use protocols or disproportionate staff allocation.

Example Code and Integration for Cost Analysis

To provide a concrete illustration of how cost data can be accessed and analyzed using code, we will assume that we have a PostgreSQL database that stores inventory and billing transactions from SIMRS. The following code example will focus on retrieving and calculating drug cost data, which is one of the largest cost components in a hospital.

First, we want to calculate the total drug costs incurred for inpatients in a specific month, as well as identify the drugs with the highest expenses. This data can be retrieved from the inventory_transactions table (for drug purchases/expenses) and patient_billings (for patient bills).

<?phpnamespace App\'Services;
use Illuminate\Support\Facades\DB;
use Carbon\Carbon;
class CostAnalysisService
{
    public function calculateMonthlyDrugCost(string $monthYear)
    {
        $startDate = Carbon::createFromFormat('Y-m', $monthYear)->startOfMonth();
        $endDate = Carbon::createFromFormat('Y-m', $monthYear)->endOfMonth();
        // Query untuk menghitung total biaya obat yang dikeluarkan untuk pasien
        // Asumsi: inventory_transactions memiliki 'item_type' = 'drug' dan 'transaction_type' = 'out'
        // dan terhubung ke patient_billings melalui transaction_reference_id (misalnya, ID billing)
        $totalDrugCost = DB::table('inventory_transactions as it')
            ->join('patient_billings as pb', 'it.transaction_reference_id', '=', 'pb.id')
            ->where('it.item_type', 'drug')
            ->where('it.transaction_type', 'out') // Obat keluar untuk pasien
            ->whereBetween('it.transaction_date', [$startDate, $endDate])
            ->sum(DB::raw('it.quantity * it.unit_cost')); // Menghitung total biaya berdasarkan kuantitas dan harga unit
        return $totalDrugCost;
    }
    public function getTopNExpensiveDrugs(int $limit = 10, string $monthYear)
    {
        $startDate = Carbon::createFromFormat('Y-m', $monthYear)->startOfMonth();
        $endDate = Carbon::createFromFormat('Y-m', $monthYear)->endOfMonth();
        $topDrugs = DB::table('inventory_transactions as it')
            ->select('it.item_name', DB::raw('SUM(it.quantity * it.unit_cost) as total_cost'))
            ->where('it.item_type', 'drug')
            ->where('it.transaction_type', 'out')
            ->whereBetween('it.transaction_date', [$startDate, $endDate])
            ->groupBy('it.item_name')
            ->orderByDesc('total_cost')
            ->limit($limit)
            ->get();
        return $topDrugs;
    }
}

The PHP code above, which is part of the service layer in a Laravel 11.x application, demonstrates two important functions. The calculateMonthlyDrugCost function calculates the total cost of drugs incurred in one month, providing an aggregate picture of one of the largest cost components. The getTopNExpensiveDrugs function identifies drugs with the highest expenditure, helping pharmacy management in price negotiations with vendors or seeking more cost-effective alternatives. The use of DB::raw enables calculations directly in the database, optimizing query performance. It is important to ensure that the inventory_transactions and patient_billings tables have a clear relationship or at least a transaction_reference_id column that can be used for joins. For optimal query performance, ensure there are indexes on columns such as transaction_date, item_type, and transaction_type.

Next, for a broader analysis of operational costs, we can integrate data from various sources into a reporting system. For example, utility data from an IoT (Internet of Things) system that monitors electricity, water, and gas consumption can be ingested into the system. This data is then combined with data from SIMRS to obtain a comprehensive picture of operational costs.

import pandas as pdfrom sqlalchemy import create_engineimport jsonimport requestsdef fetch_utility_data(api_url, start_date, end_date):    """Fetch utility data from an external API."""    params = {'start_date': start_date, 'end_date': end_date}    response = requests.get(api_url, params=params)    response.raise_for_status() # Raise an exception for HTTP errors    return response.json()def analyze_operational_costs(db_connection_string, utility_api_url, month_year):    """Analyze overall operational costs including utilities and SIMRS data."""    engine = create_engine(db_connection_string)    start_date = pd.to_datetime(month_year).to_period('M').start_time    end_date = pd.to_datetime(month_year).to_period('M').end_time    # Fetch SIMRS financial data (example: total non-drug operational costs)    simrs_query = f"""    SELECT        SUM(CASE WHEN transaction_type = 'expense' AND category NOT IN ('drug', 'medical_supply') THEN amount ELSE 0 END) as total_non_medical_expense,        SUM(CASE WHEN transaction_type = 'salary' THEN amount ELSE 0 END) as total_salary_expense    FROM financial_transactions    WHERE transaction_date BETWEEN '{start_date}' AND '{end_date}';    """    simrs_df = pd.read_sql(simrs_query, engine)    # Fetch utility data    utility_data = fetch_utility_data(utility_api_url, start_date.isoformat(), end_date.isoformat())    utility_df = pd.DataFrame(utility_data)    total_utility_cost = utility_df['cost'].sum() if not utility_df.empty else 0    total_operational_cost = simrs_df['total_non_medical_expense'].iloc[0] + \                             simrs_df['total_salary_expense'].iloc[0] + \                             total_utility_cost    print(f"Operational Cost Analysis for {month_year}:")    print(f"  Total Non-Medical Expense (SIMRS): {simrs_df['total_non_medical_expense'].iloc[0]:,.2f}")    print(f"  Total Salary Expense (SIMRS): {simrs_df['total_salary_expense'].iloc[0]:,.2f}")    print(f"  Total Utility Cost: {total_utility_cost:,.2f}")    print(f"  Grand Total Operational Cost: {total_operational_cost:,.2f}")    return {        "total_non_medical_expense": simrs_df['total_non_medical_expense'].iloc[0],        "total_salary_expense": simrs_df['total_salary_expense'].iloc[0],        "total_utility_cost": total_utility_cost,        "grand_total_operational_cost": total_operational_cost    }# Example Usage:# db_conn_str = "postgresql://user:password@host:port/dbname"# utility_api_endpoint = "https://api.hospital.com/utilities/monthly"# result = analyze_operational_costs(db_conn_str, utility_api_endpoint, "2023-10")# print(json.dumps(result, indent=2))

This Python script, using the pandas and sqlalchemy libraries, shows how financial data from SIMRS (for example, the financial_transactions table) can be combined with external data such as utility costs retrieved from an API. The create_engine function from sqlalchemy enables connections to various types of databases, including PostgreSQL. The fetch_utility_data function simulates retrieving data from an external API, which may be used by building management systems or utility vendors. By combining this data, managers can obtain a holistic view of operational costs and identify areas where utility expenses may be too high, for example due to inefficient equipment or wasteful energy usage practices. This analysis is very important for making investment decisions in energy-saving technology or more efficient operational procedures, as well as for complying with environmental regulations.

Payload Data and Error Handling in Financial Integration

In the context of SIMRS integration, the exchange of financial data between modules or with external systems (for example, insurance claim systems, ERP, or BPJS) is common and crucial. Data payloads must be well-structured and follow established standards to ensure consistency, integrity, and interoperability. Let us take an example of a realistic JSON payload for recording patient payment transactions, which is an integral part of the SIMRS billing module.

{  "transactionId": "TXN-20231115-0012345",  "patientId": "PSN-009876",  "encounterId": "ENC-20231110-0054321",  "transactionDate": "2023-11-15T10:30:00Z",  "transactionType": "payment",  "amount": 1500000.00,  "currency": "IDR",  "paymentMethod": "Bank Transfer",  "referenceNumber": "BNI-TRF-789012345",  "itemsPaid": [    {      "itemId": "BILL-001-20231110",      "itemDescription": "Biaya Rawat Inap 3 Hari",      "amount": 1200000.00    },    {      "itemId": "BILL-002-20231110",      "itemDescription": "Obat-obatan",      "amount": 300000.00    }  ],  "processorInfo": {    "system": "SIMRS-FINANCE",    "user": "admin.keuangan",    "timestamp": "2023-11-15T10:30:15Z"  }}

The JSON payload above represents a patient payment transaction, complete with the details required for accounting and auditing. Each field has an important role: transactionId as the unique identifier of the transaction, patientId and encounterId for linking to the medical record and patient encounter, amount and currency for financial details, and itemsPaid which details what was paid with references to specific billing items. This structure ensures that each payment can be accurately attributed to a specific service or item, which is very important for accurate cost accounting and reconciliation. In the context of integration with external systems such as BPJS or the SatuSehat platform, this payload will be adapted to FHIR Resource standards such as PaymentNotice or PaymentReconciliation, ensuring broad data interoperability.

However, in every system integration, error handling is a crucial aspect that must not be overlooked. Imagine a scenario where the system tries to process a payment with an invalid amount value (for example, a negative number or an incorrect format). A robust system must be able to detect and respond to such errors informatively.

HTTP/1.1 400 Bad RequestContent-Type: application/json{  "status": "error",  "code": "INVALID_AMOUNT_FORMAT",  "message": "The 'amount' field must be a positive numeric value.",  "details": {    "field": "amount",    "received_value": "-1500000.00",    "expected_format": "positive_numeric"  }}

The error message above is an example of a good and informative response. The HTTP status code 400 Bad Request clearly indicates that there is a problem with the client request. The specific code field (INVALID_AMOUNT_FORMAT) allows the client system to identify the type of error programmatically and perform appropriate handling. The message field provides a human-readable explanation, and details provides additional context that is very useful such as the problematic field, the received value, and the expected format. To handle this kind of error, the system sending the payload (for example, the registration or cashier module) must have strong validation, both on the client side (frontend) and on the server side (backend). Client-side validation, using JavaScript or a framework such as Vue.js, can prevent the submission of clearly incorrect data. Server-side validation, using a framework such as Laravel, will ensure data integrity before it is saved to the database. If an error occurs, the system must log the error with sufficient detail, notify the user or administrator, and ideally, attempt a retry mechanism or provide an option for manual correction. In a Laravel application, this can be implemented with a try-catch block and using Form Request Validation to ensure the payload data complies with the established rules, such as amount must be numeric and min:0.

Best Practices for Hospital Operational Cost Optimization

1. Fully Integrated SIMRS Implementation: Ensure all SIMRS modules (registration, medical records, pharmacy, laboratory, radiology, billing, accounting, inventory, HR) are interconnected and share data in real time and accurately. This integration significantly reduces duplicate data entry, minimizes human error, and provides full visibility into the cost flow from upstream to downstream. An integrated system enables accurate cost tracking per patient or per service, which is the basis for in-depth analysis.
2. Procurement and Inventory Process Automation: Utilize the SIMRS purchasing and inventory modules to automate ordering, vendor price comparison, and efficient stock management. Implement a Just-In-Time (JIT) or Economic Order Quantity (EOQ) system to reduce storage costs and prevent expiration of expensive drugs/consumables. This automation also helps in negotiating better prices with vendors based on transparent purchase volumes and history, as well as identifying potential savings from long-term contracts.
3. Activity-Based Cost Analysis (Activity-Based Costing - ABC): Apply the ABC method to allocate indirect costs to specific activities or services more accurately. This provides a much more accurate understanding of the actual cost of each medical service or procedure, enabling more competitive pricing and identification of areas with hidden cost inefficiencies. For example, knowing the real cost of an appendectomy, including all associated overhead costs, not just direct costs.
4. Continuous Financial and Operational KPI Monitoring: Use a Business Intelligence (BI) dashboard connected to SIMRS to monitor financial and operational Key Performance Indicators (KPI) in real time. Important KPIs include Cost Per Patient Day (CPPD), drug cost-to-revenue ratio, medical equipment utilization rate, and staff-to-patient ratio. This continuous monitoring enables early problem identification, trend analysis, and proactive decision-making for improvement. The dashboard should be updated in real time or at least daily for relevance.
5. Human Resource Optimization Through Data Analysis: Analyze staff scheduling, productivity, and attendance data through the SIMRS HR module to identify patterns of overstaffing or understaffing at certain hours or departments. Implement an efficient shift management system and continuous training programs to improve staff skills, reduce turnover costs, and maximize productivity. The use of e-roster or integrated digital attendance systems can help track and optimize HR allocation effectively.
6. Utilization of Telemedicine and Digital Services: Consider integrating telemedicine and digital consultation services to reduce the hospital's physical operational burden in certain cases. This can reduce utility costs (electricity, water), building maintenance, and even reduce the need for physical space, while improving patient accessibility and physician time efficiency. Implementation must comply with applicable regulations, such as PMK No. 20 of 2019 concerning the Implementation of Telemedicine Services.
7. Periodic Vendor Contract Audit and Evaluation: Conduct routine audits of all contracts with drug suppliers, medical devices, cleaning services, and other services. Use historical data from SIMRS (purchasing and inventory modules) to renegotiate prices or find more competitive alternative vendors. Ensure every contract has a clear Service Level Agreement (SLA) clause to avoid hidden costs and ensure optimal service quality.
8. Smart Energy and Utility Management: Investment in energy-saving technologies, such as LED lighting, efficient HVAC (Heating, Ventilation, and Air Conditioning) systems, and automated building management systems (Building Management System - BMS) can significantly reduce electricity, water, and gas costs. Monitor utility consumption in real time and identify areas of waste for quick intervention. For example, using motion sensors for lighting in rarely traversed areas.
9. Utilization of Data Analytics for Demand Forecasting: Use machine learning algorithms on historical SIMRS data to predict patient trends (number of visits, disease types), drug or consumable inventory needs, or even patient re-admission risk. Accurate predictions enable more efficient resource allocation, reduce waste from overstocking or understocking, and optimize capacity planning. For example, predicting peak patient visits based on history to adjust staff schedules.

FAQ: Common Questions About Hospital Operational Cost Optimization

1. How can SIMRS help in identifying hidden costs? A fully integrated SIMRS can track every transaction and activity across departments with high granularity. With in-depth reporting and analytics features, the system can identify unreasonable expenses, process inefficiencies, or even costs that are not properly allocated, such as drug inventory piling up in the warehouse or suboptimal use of medical equipment. Recorded historical data also enables trend analysis to uncover hidden cost patterns that may not be visible in conventional financial reports, such as readmission costs due to low service quality.
2. What is the biggest challenge in implementing cost optimization in hospitals? The main challenge often lies in resistance to change from staff accustomed to old methods, lack of holistically integrated data, and the complexity of the hospital's own organizational structure. In addition, significant initial investment in an advanced SIMRS and comprehensive staff training programs can also be an initial obstacle. However, with strong leadership, effective communication strategies, and a focus on long-term benefits, these challenges can be overcome, and the potential savings and service quality improvements will far outweigh the initial costs.
3. How quickly can a hospital see results from cost optimization efforts undertaken? The time to see results from cost optimization efforts varies greatly depending on the scale of implementation and the specific area optimized. Quick savings can be seen from better vendor negotiations, tighter inventory management, or reduced energy waste within 3-6 months. However, more comprehensive optimization, such as restructuring core business processes or major technology investments, may take 1-2 years to show a significant and sustainable financial impact overall on the hospital's financial statements.
4. Are there industry standards or benchmarks for hospital operational cost ratios in Indonesia? Yes, there are several benchmarks that can be used as references, although these vary by type of hospital (general, specialty, type A/B/C/D), size, and geographic location. The Indonesian Ministry of Health often publishes data or guidelines that can be used as references, as well as hospital associations such as PERSI (Indonesian Hospital Association). However, the most important thing is to compare your own hospital's performance over time, identify areas needing improvement, and set realistic improvement targets based on internal and external conditions.
5. How can we ensure medical and non-medical staff support cost optimization initiatives? The key is transparent communication, involving them in the decision-making process, and showing how cost optimization will benefit them and patients. Explain why cost optimization is important for the hospital's sustainability, facility improvement, and quality of patient care. Provide adequate training on SIMRS usage and show how these initiatives can make their work easier, not add burden. Rewards and recognition for their contributions in achieving efficiency targets are also very effective in maintaining motivation.
6. Can legacy SIMRS be integrated for cost optimization purposes, or is a new implementation needed? It depends on your legacy SIMRS architecture. If the legacy SIMRS has well-documented APIs, an accessible database, or supports basic interoperability standards, integration may be possible using middleware or ETL (Extract, Transform, Load) tools. However, if the system is too outdated, inflexible, does not support modern interoperability standards such as FHIR, or is difficult to develop, investing in a new, modular, integrated SIMRS based on current technology may be more cost-effective and effective in the long term. Nugroho Setiawan and his team have the expertise to help assess the feasibility of integration or the need for system migration.

Optimizing hospital operational costs is not an easy and instant task, but with a systematic approach, supported by the right technology, it is highly achievable. SIMRS is not merely an administrative tool, but a strategic instrument that can provide visibility, efficiency, and accountability across every financial aspect of your hospital. From identifying hidden costs to process automation, predictive analytics, and intelligent supply chain management, the potential for savings and service quality improvement is enormous. If you are an operations manager, IT manager, or clinic owner looking for innovative technology solutions to optimize costs and improve efficiency, Nugroho Setiawan and his team are ready to help. With deep experience in SIMRS development, BPJS/SatuSehat/FHIR integration, as well as customized ERP solutions for various needs, we can design and implement a system tailored to the unique needs of your healthcare facility. Don't let inefficiency hinder your hospital's potential. Contact us today for a consultation and discover how technology can be a catalyst for your operational efficiency and service excellence.

This article is part of the education by Nugroho Setiawan, IT consultant Jogja. Related solutions: SIMRS BPJS & SatuSehat Bridging Integrator. Need free consultation?