Set room rates for a small Goa guesthouse across slow, shoulder and peak weeks

A Goa guesthouse charging one flat rate all year undercharges in the busy season and stays empty in the monsoon. You are comparing a flat rate with seasonal rates across slow, shoulder and peak weeks, using made-up round figures, and recommending one.

• Which weeks of the year count as slow, shoulder and peak for a small Goa guesthouse?
• What kind of guest arrives in each season, and what do they care about?
• What occupancy will you assume in each season for each option, and why?
• What happens to your answer if peak occupancy is lower than you hoped?

A clear sheet for six rooms with made-up rates and occupancy guesses per season, both options totalled for the year, a test with weaker peak occupancy, and a recommendation that says how it depends on the guesses, with every number labelled as made up.

Assuming higher seasonal prices bring in the same number of guests. Each option needs its own occupancy guess, and the test with weaker demand matters more than the headline total.

• Public tourism information about Goa's seasons, such as festival periods and the monsoon, saved as notes with sources
• If possible, a short call to a real guesthouse about which months are busy and what guests ask for
• Your made-up round rates and occupancy guesses, typed by you and labelled

AI must not give real room rates, occupancy figures or tourist numbers for Goa. Season patterns come from public tourism information or a real guesthouse, and every number in the sheet is your labelled made-up figure.

1. 3.1 Describe guests by seasonCLAUDE CHAT

   Why this tool: Claude can suggest guest types to check, which you confirm against public information and the call.

   Ask for typical guest types per season, then keep only those your sources support.

   Prompt to copy · fill in the [brackets]Copy

   I am planning rates for a six-room guesthouse in [area of Goa]. Suggest what kinds of guests might arrive in slow, shoulder and peak weeks and what each cares about. Label every suggestion as something for me to check. Then give me three questions to ask a real guesthouse owner on the phone.

2. 3.2 Build the rate workbookCLAUDE WORKING ON YOUR FILES (FORMERLY COWORK)

   Why this tool: Given your notes with rates and occupancy guesses, Claude can lay out a clean model on a copy of a workbook.

   Put your notes and an empty workbook in a folder. Ask Claude to build an inputs sheet and a revenue sheet for both options, then check one season by hand.

   Prompt to copy · fill in the [brackets]Copy

   In this folder are my notes [file] with seasons, number of weeks in each, made-up rates and occupancy guesses for two pricing options: one flat rate and seasonal rates. On a copy of the empty workbook, build an Inputs sheet with each figure in a labelled cell marked 'made up', and a Revenue sheet computing rooms times nights times occupancy times rate for each season and each option, with yearly totals. No typed numbers in formulas.

   Before you let it act: Read Claude's plan before it builds and confirm it works on a copy. Then recompute one season of one option on paper and compare.

3. 3.3 Test a weak peak seasonCLAUDE FOR EXCEL

   Why this tool: Inside the workbook, Claude can help you add a scenario cell and explain the change.

   Add a cell for peak occupancy, lower it step by step, and note when seasonal pricing stops beating the flat rate, if it does.

4. 3.4 Challenge the recommendationCLAUDE CHAT

   Why this tool: A challenge reveals which guess your recommendation leans on.

   Write your recommendation with its numbers, then ask Claude to find the weakest assumption.

   Prompt to copy · fill in the [brackets]Copy

   I recommend [option] for a six-room Goa guesthouse because my made-up figures show [result]. My assumptions: [list]. Which assumption is weakest, and what could the owner check in a month to test it? Use only my figures.

• Recompute one season's revenue for each option by hand
• The weeks across seasons add up to a full year
• Every rate and occupancy figure is labelled made up
• Your recommendation mentions what happens if peak occupancy is lower
• No number typed inside a formula: every input is a labelled cell
• Recompute the headline result by hand

AI often fills in real-sounding Goa rates or tourist numbers and assumes the same occupancy for both options. Keep figures your own and give each option its own occupancy.

• Season calendar with guest types and sources
• Six-room model for flat and seasonal options
• Yearly totals compared
• Weak-peak test
• A short recommendation

A season calendar strip at the top, the comparison table in the middle, and the recommendation with its key condition at the bottom.

Explain why seasonal pricing did or did not win in your model, and which guess the owner should check first.