@extends('admin.layouts.app') @section('title', 'Financial KPIs') @section('content')

Financial KPIs

@if($month) {{ Carbon\Carbon::create($year, $month, 1)->format('F Y') }} @else Year {{ $year }} @endif

Total Revenue

₦{{ number_format($totalRevenue, 0) }}

Net Profit

₦{{ number_format($netProfit, 0) }}

Profit Margin

{{ number_format($profitMargin, 1) }}%

Occupancy Rate

{{ number_format($occupancyRate, 1) }}%

Average Daily Rate (ADR)

₦{{ number_format($adr, 0) }}

Average room rate per sold night

RevPAR

₦{{ number_format($revpar, 0) }}

Revenue per available room

Gross Margin

{{ number_format($grossMargin, 1) }}%

Gross profit as % of revenue

Revenue & Expense Summary

Room Revenue ₦{{ number_format($totalRevenue - $posRevenue, 0) }}
POS Revenue ₦{{ number_format($posRevenue, 0) }}
Total Revenue ₦{{ number_format($totalRevenue, 0) }}
Cost of Goods Sold ₦{{ number_format($cogs, 0) }}
Gross Profit ₦{{ number_format($grossProfit, 0) }}
Operating Expenses ₦{{ number_format($totalExpenses, 0) }}
Net Profit ₦{{ number_format($netProfit, 0) }}

Operational Metrics

Total Rooms {{ $totalRooms }}
Occupied Rooms {{ $occupiedRooms }}
Total Bookings {{ $totalBookings }}
Nights Sold {{ $nightsSold }}
Average Daily Rate ₦{{ number_format($adr, 0) }}
RevPAR ₦{{ number_format($revpar, 0) }}

Monthly Performance

@foreach($monthlyRev as $data) @endforeach
Month Revenue Expenses Profit Margin
{{ $data['month'] }} ₦{{ number_format($data['revenue'], 0) }} ₦{{ number_format($data['expenses'], 0) }} ₦{{ number_format($data['revenue'] - $data['expenses'], 0) }} {{ $data['revenue'] > 0 ? number_format((($data['revenue'] - $data['expenses']) / $data['revenue']) * 100, 1) : 0 }}%
@endsection