Studio Sample · Data, Spreadsheets & Analysis

From booking rows to a useful operating view.

This workbook organises reservation details into a monthly and channel comparison, with each calculation traceable to the underlying rows.

Classification: Studio Sample. All 18 bookings, properties, dates, channel rates and costs are synthetic. No client, guest, property, performance or operating result is represented.

Input → work → finished output

The sample follows the calculation through.

Input
18 fictional reservation rows over six months, with booking channel, check-in/out, rates, cleaning charges and operating-cost assumptions.
Work
Calculate nights, accommodation revenue, illustrative channel fees, cleaning and supply costs, then contribution. Summarise by month and channel.
Finished output
A two-sheet workbook with a summary, formula-backed monthly table, channel comparison, chart and inspectable booking detail.
Reservations
18
Booked nights
56
Accommodation revenue
R 95,270
Contribution*
R 82,072

*Contribution is accommodation revenue plus cleaning fees charged, less the assumed platform fee, cleaning cost and supplies. It excludes rent, utilities, taxes, repairs, labour and other costs; it is not profit.

Finished workbook preview

Summary view

The displayed figures are generated from the workbook formulas. Open the workbook to inspect the editable booking rows and calculations.

Workbook summary showing synthetic accommodation revenue, platform fees, contribution, monthly totals, channel totals and a comparison chart
Summary worksheet preview · synthetic figures · select the image to view it larger

Data · spreadsheets · analysis

Have files that need structure or a clear summary?

Send the source workbook or export, describe the decision it needs to support and identify the required output.

Describe a data project