Create a start up excel sheet for restaurant business serving upto 75 persons within a seating area of 200 square meters, kitchen 125 square meters toilets 30 square meters

create a start up excel sheet for restaurant business serving upto 75 persons within a seating area of 200 square meters, kitchen 125 square meters toilets 30 square meters

1 Answer

1

Hi Kamal! Welcome to the forum! :rabbit_face::paw_prints: Setting up a 75-seat restaurant across 355 m² (200 m² dining, 125 m² kitchen, 30 m² restrooms) is an exciting venture.

Here is a practical structure you can set up in Excel with 3 main tabs:

Tab 1: Fit-Out & CapEx (Capital Expenditure)

Break this down by space to keep contractors on budget:

  • Dining Area (200 m² / 75 seats): Tables, chairs, host stand, POS system, lighting, flooring, decor.
  • Commercial Kitchen (125 m²): Extraction hood, ovens, fryers, prep tables, walk-in coolers, dishwashing station, smallwares.
  • Restrooms (30 m²): Plumbing fixtures, tiling, ventilation, dispensers.
  • Formulas:
    • Total CapEx: =SUM(B2:B30)
    • Fit-Out Cost per m²: =Total_CapEx / 355
    • Cost per Seat: =Total_CapEx / 75

Tab 2: Pre-Opening & Soft Costs

  • Legal & Permits: Health department, food licenses, liquor license, architectural drawings.
  • Initial Inventory: Food & beverage opening stock, cleaning chemicals, uniforms.
  • Branding & Tech: Signage, website, menu design, reservation software.

Tab 3: Working Capital (3–6 Months Runway)

  • Fixed Costs: Rent, insurance, POS subscriptions, utilities.
  • Labor: Chef, line cooks, dishwashers, servers, manager.
  • Contingency Fund: Set aside 10%–15% of your total budget for surprise expenses: =Total_Budget * 0.15.

(Note: Startup costs vary heavily by city, so it’s always wise to review your final numbers with a hospitality accountant or financial advisor!)

Would you like me to provide a list of estimated sample costs for these rows so you can copy and paste them straight into Excel? Just press Reply! :paw_prints:

My mistake, Paid up capital US $ 350,000 location Jubail, Lebanon. On our way to Annaya (St. Charbel) there is a newly constructed mall. Parking is available, one of the main obstacle resolved

–