Hotel Budget Template

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 16

2023

ANNUAL REVENUE TOTAL AVAILABLE BUDGET

$0.00
ANNUAL EXPENSE
$0.00
$0.00
REVENUE $ - $ - $ -

Revenue Category JAN FEB MAR

EXPENSE $ - $ - $ -

Expense Category JAN FEB MAR


HOTEL BUDGET
LABLE BUDGET
REVENUE VS. EXPENS
$1.00

.00
$0.80
$0.60
$0.40
$0.20
$- $- $- $- $- $- $- $- $- $- $- $- $- $- $-
$-
JAN FEB MAR APR MAY JUN JUL A

$ - $ - $ - $ - $ -

APR MAY JUN JUL AUG

$ - $ - $ - $ - $ -

APR MAY JUN JUL AUG


GET
NUE VS. EXPENSE

$- $- $- $- $- $- $- $- $- $- $- $- $- $-
JUN JUL AUG SEP OCT NOV DEC

$ - $ - $ - $ -

SEP OCT NOV DEC

$ - $ - $ - $ -

SEP OCT NOV DEC


2
REVENUE $ 70,000.00 $ 61,000.00 $ 84,000.00

Revenue Category January February March

Room Revenue $ 50,000.00 $ 45,000.00 $ 60,000.00

Food and Beverage Revenue $ 15,000.00 $ 12,000.00 $ 18,000.00

Other Revenue Streams $ 5,000.00 $ 4,000.00 $ 6,000.00

EXPENSE $ 67,000.00 $ 58,500.00 $ 74,000.00

Expense Category January February March

Staff Salaries $ 25,000.00 $ 25,000.00 $ 26,000.00

Utilities $ 8,000.00 $ 7,500.00 $ 8,500.00

Maintenance $ 5,000.00 $ 4,500.00 $ 5,500.00

Marketing and Advertising $ 10,000.00 $ 8,000.00 $ 12,000.00

Administrative Expenses $ 4,000.00 $ 3,500.00 $ 4,000.00

Capital Expenditures $ 15,000.00 $ 10,000.00 $ 18,000.00


2023 BUDGET
$ 93,000.00 $ 104,000.00 $ 111,000.00 $ 125,000.00 $ 130,000.00

April May June July August

$ 65,000.00 $ 75,000.00 $ 80,000.00 $ 90,000.00 $ 95,000.00

$ 20,000.00 $ 22,000.00 $ 25,000.00 $ 28,000.00 $ 30,000.00

$ 8,000.00 $ 7,000.00 $ 6,000.00 $ 7,000.00 $ 5,000.00

$ 82,500.00 $ 72,000.00 $ 71,000.00 $ 82,500.00 $ 86,000.00

April May June July August

$ 28,000.00 $ 28,000.00 $ 27,000.00 $ 29,000.00 $ 30,000.00

$ 9,000.00 $ 8,500.00 $ 8,000.00 $ 9,500.00 $ 9,000.00

$ 6,000.00 $ 5,500.00 $ 5,000.00 $ 6,500.00 $ 6,000.00

$ 15,000.00 $ 14,000.00 $ 12,000.00 $ 13,000.00 $ 15,000.00

$ 4,500.00 $ 4,000.00 $ 4,000.00 $ 4,500.00 $ 4,000.00

$ 20,000.00 $ 12,000.00 $ 15,000.00 $ 20,000.00 $ 22,000.00


$ 109,000.00 $ 95,000.00 $ 79,000.00 $ 82,000.00

September October November December

$ 80,000.00 $ 70,000.00 $ 55,000.00 $ 60,000.00

$ 25,000.00 $ 20,000.00 $ 18,000.00 $ 15,000.00

$ 4,000.00 $ 5,000.00 $ 6,000.00 $ 7,000.00

$ 76,000.00 $ 68,000.00 $ 61,500.00 $ 62,000.00

September October November December

$ 28,000.00 $ 26,000.00 $ 25,000.00 $ 27,000.00

$ 8,500.00 $ 8,000.00 $ 7,500.00 $ 8,000.00

$ 5,500.00 $ 5,000.00 $ 4,500.00 $ 5,000.00

$ 12,000.00 $ 10,000.00 $ 9,000.00 $ 8,000.00

$ 4,000.00 $ 4,000.00 $ 3,500.00 $ 4,000.00

$ 18,000.00 $ 15,000.00 $ 12,000.00 $ 10,000.00


2
REVENUE $ 22.00 $ - $ -

Revenue Category January February March

Food and Beverage Revenue $ 22.00

EXPENSE $ - $ - $ -

Expense Category January February March


2024 BUDGET
$ - $ - $ - $ - $ -

April May June July August

$ - $ - $ - $ - $ -

April May June July August


$ - $ - $ - $ -

September October November December

$ - $ - $ - $ -

September October November December


(Y
REVENUE $ - $ - $ -

Revenue Category January February March

EXPENSE $ - $ - $ -

Expense Category January February March


(YEAR) BUDGET
$ - $ - $ - $ - $ -

April May June July August

$ - $ - $ - $ - $ -

April May June July August


$ - $ - $ - $ -

September October November December

$ - $ - $ - $ -

September October November December


SET UP
Revenue Category Expense Category

Room Revenue Staff Salaries

Food and Beverage Revenue Utilities

Other Revenue Streams Maintenance

Marketing and Advertising

Administrative Expenses

Capital Expenditures

You might also like