willkommen! bienvenue! welcome! - magicworkbookswillkommen! bienvenue! welcome! to the world of...

WILLKOMMEN! BIENVENUE! WELCOME!

to the world of

MagicWorkbooks®

HotelBudgetXXL

The complete tool for budgeting and evaluating any hotel business

This is a MagicWorkbook: a controlling tool in the form of a Microsoft Excel file. No macros, no write protection. All formulas used are visible.

All formats used are standard Excel which transform into your country's Excel formats. You can import your DATA from any source that supports MS Excel.

You can also add your own worksheets as you see fit.

© 2014 K! Business Solutions GmbH

www.MagicWorkbooks.com

Page 1 of 34

http://www.magicworkbooks.com/

0150-01 HotelBudgetPlusXXL

http://www.MagicWorkbooks.com/ Page 2 of 34 Fragen? [email protected]

System requirements Platform: Windows 98 or later operating system Microsoft Excel Version: 2007 or later (You need a xls format (excel 2003) – send us a

short information after you placed the order – [email protected] - we’ll send you the ordered xls MagicWorkbook by email)

Product Survey

Same old problem every year: hammering out a hotel budget from heaps of lists and scraps of paper?

Your owners expect a detailed analysis according to international standards (Uniform System of Accounts) every month?

You don't want to dish out loads of money for a controlling software solution ?

Then HotelBudgetXXL is just the tool for you!

It budgets and analyses your hotel business with up to 8 separate F&B outlets, banquet and wellness or spa facilities. It incorporates automatic calculation of commissions, management and franchise fees, revenue-based or GOP-based rents or other fees, up to profit share calculation.

http://www.magicworkbooks.com/mailto:Fragen?%[email protected]


http://www.MagicWorkbooks.com/ Page 3 of 34 question? [email protected]

It generates automatically:

a complete budget for your business (survey and detailed),

Year-end projections for the hotel and all operating departments,

Budget-to-actual comparisons for revenues, expenses and every department,

Surveys and projections for revenue segments, occupancy, rates and payroll.

Charts and graphs for presentation purposes are also included.

And if you are a real control freak, there is also a daily revenue-to-budget check.

And the best thing is: Next year's budget will be a lot less work! The bulk of your data is in and you just have to input the changes to this year's budget!

http://www.magicworkbooks.com/mailto:question?%[email protected]



Back Home! C O N T E N T S HotelBudget XXL

Sheet name type containsc lick on book to

get to page!

WELCOME readme Introduct ion / Ins truct ions on Use &

DATA Spreadsheet DATA INPUT &

CalendarRooms Spreadsheet DATA INPUT Calendar Rooms &

ActualData Spreadsheet DATA INPUT Actual f igures &

ActualDataRates Spreadsheet Data Input Actual Rooms Segments and Rates &

ProjectionDATA Spreadsheet DATA INPUT PROJECTION &

FBRevData Spreadsheet Data Input F&B out lets &

DailyData Spreadsheet DATA INPUT for Daily Revenue Check &

BUDGET Spreadsheet BUDGET SURVEY &

BUDGETDetail Spreadsheet BUDGET Detailed &

DailyBudgetRev Spreadsheet Budget Daily Revenue &

BudgetRates Spreadsheet Budget Rooms Segments and Rates &

BudgetFBRev Spreadsheet BUDGET F&B Revenue &

BudgetOutlet Spreadsheet BUDGET OUTLET CHECK F&B &

BudgetDepRooms Spreadsheet Budget Rooms Dep &

BudgetDepFB Spreadsheet Budget F&B Dep &

BudgetDepSpa Spreadsheet Budget Dep Spa &

BudgetDepTel Spreadsheet Budget Dep Telecommunicat ion &

BudgetDepO Spreadsheet Budget Dep Other Revenue &

Budget Staff Graph BUDGET Payroll &

…





Sheet name type containsc lick on book to

get to page!

WELCOME readme Introduct ion / Ins truct ions on Use &

Actual Spreadsheet ACTUAL SURVEY &

Projection Spreadsheet PROJECTION SURVEY &

ProjDetail Spreadsheet PROJECTION Detailed &

BreakevenRate Graph Project ion Breakeven Rate &

BreakevenSegments Graph Comparing Breakeven Rate to Rate s t ructure &

ProjFBrev Spreadsheet Project ion F&B Revenue &

ProjDepRooms Spreadsheet Project ion Rooms Dep &

ProjDepFB Spreadsheet Project ion F&B Dep &

ProjDepSpa Spreadsheet Project ion Spa Dep &

ProjDepTel Spreadsheet Project ion Telecommunicat ion Dep &

ProjDepO Spreadsheet Project ion Other Revenue &

ProjRates Spreadsheet Project ion Rooms Sold and Rooms Revenue by Segment &

ProjOutlet Spreadsheet OUTLET CHECK Project ion &

ProjOutletSelect Spreadsheet Project ion F&B OUTLET CHECK Restaurant Red &

ProjStaff Spreadsheet PROJECTION Payroll &

VAR interact ive Actual to Budget Comparison Survey &

VarDetail interact ive Actual to Budget Comparison Detailed &

Var Rev interact ive Actual to Budget Comparison Revenue &

Var Staff interact ive Actual to Budget Comparison Payroll &

Var rates interact ive Actual to Budget Rooms Segments &

Var Daily Spreadsheet Revenue Variance Daily &

…





Sheet name type containscl ick on book to

get to page!

WELCOME readme Introduct ion / Instruct ions on Use & REV Graph Project ion Revenue Segments Cumulat ive &

REVm Graph Project ion Revenue Segments Month &

GOP Graph Project ion GOP Cumulat ive &

GOPm Graph Project ion GOP Month &

NOP Graph Project ion NOP Cumulat ive &

NOPm Graph Project ion NOP Month &

OCC Graph Project ion Occupancy Cumulat ive &

OCCm Graph Project ion Occupancy Month &

RATE Graph Project ion Room Rate Cumulat ive &

RATEm Graph Project ion Room Rate Month &

REVPAR Graph Project ion RevPar Cumulat ive &

REVPARm Graph Project ion RevPar Month &




…




INPUT-

EXTRACT!!!!




…




In what way do MagicWorkbooks® differ from normal Excel workbooks? MagicWorkbooks are easier to use:

Easy-to-handle data input with demo data for orientation

All data to be entered only once

No programming knowledge required

No detailed knowledge of Microsoft Excel required

No work on spreadsheets or charts required

No scrolling for sheets thanks to a Hyperlink-table of contents

MagicWorkbooks are faster:

A monthly report with 20 spreadsheets and 20 charts in 20 minutes?

Calculate year-end liquid reserves with changes in revenue prediction for every month in half an hour?

Compute balance sheets for the next five years in one hour?

Decision on a $ 50 million operation: Prepare all relevant data in one

hour?

Determine capital re-investment requirements (fixed assets) for the next year in 10 minutes?

Prepare a comprehensive company presentation for your bank in one

hour? With MagicWorkbooks all that is „business as usual“! This was just a brief survey ...

if you have further questions regarding this workbook, email us! You are interested in other products:

www.MagicWorkbooks.com

Magic Workbooks „are alive“ and always up-to-date:
http://www.magicworkbooks.com/mailto:Fragen?%[email protected]://www.magicworkbooks.com/

willkommen! bienvenue! welcome! - magicworkbookswillkommen! bienvenue! welcome! to the world of...

Documents