I AM STARTING A RESTAURANT WITH NAME AND BRAND OF ZAEQA WITH WEBSITE WWW.ZAEQA.COM PLEASE PREPARE A SUCCESSFUL BLUE PRINT HOW TO GET STARTED AND RUN IT SUCCESSFULLY IN HYDERABAD AT BANDLAGUDA INNER RING ROAD NEAR ARAMGHAR X ROAD, AND CHANDRAINGUTTA MAIN ROAD,

Market Strategy and Concept Localization

• Target Audience: The Bandlaguda Inner Ring Road (near Aramghar X Road) and Chandrayangutta Main Road corridor acts as a major high-traffic, multicultural artery connecting Old City to the PVNR Expressway and tech/residential outer suburbs. Your demographic includes local families, corporate commuters, students, and strong late-night food crowds.
• Cuisine Positioning: Given the name ZAEQA (implying flavor/taste) and the local culinary preference, your core menu should feature authentic Hyderabadi Dum Biryani, Mughlai/North Indian gravies, authentic Arabian Mandi, and popular Chinese-fusion fast foods. Offer dedicated family dining sections alongside a robust packaging unit for takeaway.

Operational Roadmap & Timeline

Phase	Milestone	Action Items
Phase 1 (Weeks 1-3)	Legal Compliance & Licensing	• Secure GHMC Trade License, FSSAI central license, Fire NOC, GST registration, and Eating House license. • Finalize commercial lease agreements along the target transit corridors.
Phase 2 (Weeks 4-6)	Infrastructure & Branding	• Build out kitchen workflows (hot kitchen, tandoor, dishwashing area) prioritizing high ventilation. • Sync interior decor with www.zaeqa.com branding (warm, contemporary lighting with ethnic touches).
Phase 3 (Weeks 7-8)	Supply Chain & Tech Integration	• Partner with local vendors for daily fresh meat (halal) and produce. • Integrate POS software with delivery aggregators (Swiggy/Zomato) and embed direct-order widgets onto www.zaeqa.com.
Phase 4 (Week 9-10)	Launch & Local Marketing	• Execute soft launches targeting local food vloggers and neighborhood communities. • Launch grand opening promotions tied to digital QR menus hosted via your web domain.

Location-Specific Growth Tactics

• Visibility & Accessibility: Ensure ample parking space or seamless valet/security management, as traffic congestion near Aramghar X Road and Chandrayangutta main junctions can deter drive-in diners. Highlight prominent, illuminated signage visible from the main road.
• Late-Night Hub Advantage: The Chandrayangutta-Aramghar stretch has a vibrant late-night economy. Keeping ZAEQA operational past midnight on weekends will capture high-margin post-theater and transit crowds.
• Digital & Domain Synergy: Use www.zaeqa.com as your central hub for loyalty programs, direct-to-consumer ordering with lower delivery fees than aggregators, and corporate/party catering bookings for the surrounding residential layouts.

What specific style of dining are you leaning toward for ZAEQA—fine dining, a casual family restaurant, or a high-volume quick-service takeaway format?

PLEASE GUIDE ME HOW TO MAKE INVENTORY LIST, PURCHASING LIST, STOCK AND SALES AND FINANCIAL PLANNING AND BOOK KEEPING RECORDS MAINTAINING

Inventory and Purchasing Architecture

• Master Inventory List: Categorize every item into four distinct groups: Perishable Raw Materials (fresh meats, dairy, vegetables), Non-Perishable Goods (rice, cooking oils, dry spices, flours), Packaging Supplies (takeaway containers, biryani handis, carry bags, branded tissue paper), and Cleaning/Utility Items (sanitizers, detergents, gas cylinders). Track each item with its designated unit of measurement (kg, liters, pieces) and safety stock threshold.
• Purchasing List & Par Levels: Set a strict minimum stock level (par level) for every ingredient. Use a daily purchase order template where kitchen managers record closing stock, subtract it from par levels, and generate exact procurement quantities to prevent over-buying, spoilage, or stockouts during peak dining hours.

Stock, Sales, and Daily Reconciliation

• Daily Stock Ledger: Maintain a physical or digital log tracking opening stock plus daily purchases minus closing stock to calculate consumption. Compare actual consumption against theoretical consumption (calculated via recipe portion sizes multiplied by daily sales volume) to immediately flag and control kitchen wastage or shrinkage.
• Sales Integration: Link your point-of-sale (POS) terminal directly to your inventory ledger. Every time a plate of biryani or a beverage is billed, the POS should automatically deduct the exact raw material quantities from your live stock database.

Financial Planning and Capital Allocation

• Cost Control Targets: Manage your primary restaurant ratios tightly. Target a Food Cost of 30% to 32% of menu pricing, Labor Cost of 15% to 20%, and Overhead/Rent expenses under 15% to maintain a healthy net profit margin.
• Working Capital Buffer: Maintain a liquid cash reserve covering at least 3 months of operational fixed costs (rent, salaries, utility bills, raw material advance payments) to absorb seasonal fluctuations in footfall.

Bookkeeping and Record-Keeping Framework

• Core Financial Registers: Maintain three primary digital ledgers (via cloud accounting software or structured spreadsheets):
  • Sales Register: Daily cash, credit card, and digital/UPI collections cross-verified with POS settlement reports.
  • Purchase Register: Invoices categorized by vendor, tracking GST input tax credits and payment due dates.
  • Expense Register: Petty cash expenditures, utility bills, daily wages, and marketing expenses.
• Audit Cadence: Conduct a physical stock audit twice a week for high-value items (meats, exotic spices, oils) and a complete wall-to-wall stock count at the end of every calendar month to reconcile book inventory with actual physical inventory.

Would you like a ready-to-use digital template structure or spreadsheet layout for tracking daily purchases and recipe-based inventory consumption?

YES PLEASE SURE

Here is a complete, ready-to-use template structure and framework designed specifically for ZAEQA. You can copy this exact structure into Google Sheets or Microsoft Excel to manage your daily inventory, purchasing, sales reconciliation, and bookkeeping.

Sheet 1: Recipe-Based Inventory & Daily Consumption Tracker

Use this sheet to monitor your daily stock movement. When sales are logged, this structure helps calculate what should have been consumed versus what is physically left.

Item ID	Item Name	Category	Unit	Opening Stock	Purchases Today	Total Available	Closing Stock (Physical)	Total Consumed	Unit Cost (₹)	Total Cost (₹)
ING-001	Basmati Rice (Aged)	Dry Goods	KG	100	50	150	120	30	95	=J2*I2
ING-002	Mutton (Fresh Halal)	Perishables	KG	15	25	40	8	32	750	=J3*I3
ING-003	Cooking Oil	Groceries	Liters	45	15	60	38	22	140	=J4*I4
PKG-001	750ml Takeaway Containers	Packaging	Pcs	500	0	500	350	150	6	=J5*I5

• Formula Tip for “Total Available”: =E2+F2 (Opening Stock + Purchases Today)
• Formula Tip for “Total Consumed”: =G2-H2 (Total Available − Closing Stock)
• Formula Tip for “Total Cost”: =I2*J2 (Total Consumed × Unit Cost)

Sheet 2: Daily Purchasing & Par-Level Order Sheet

Hand this to your kitchen manager or purchasing supervisor every morning. It prevents stockouts by calculating exactly what needs to be ordered based on predefined minimum safety levels (Par Levels).

Item Name	Unit	Par Level (Min Stock)	Current Stock	Reorder Quantity (Needed)	Preferred Supplier	Contact Number	Status / Notes
Basmati Rice	KG	50	30	=C2-D2	Deccan Agro Traders	98490XXXXX	Urgent delivery by 4 PM
Chicken (Raw)	KG	40	10	=C3-D3	Al-Madina Meats	98850XXXXX	Morning batch only
Curd / Yogurt	KG	20	5	=C4-D4	Vijaya Dairy Distributor	97000XXXXX	Daily fresh supply

• Formula Tip for “Reorder Quantity”: =C2-D2 (If current stock drops below the Par Level, this tells you precisely how much to buy).

Sheet 3: Daily Sales & POS Reconciliation Register

At the end of every business shift, reconcile your cash drawer and digital payment gateways against total items sold.

Date	Bill / Order ID	Dine-In / Takeaway / Delivery	Cash (₹)	UPI / QR (₹)	Credit Card (₹)	Swiggy / Zomato (₹)	Total Bill Value (₹)
2026-09-12	ZQ-1001	Dine-In	1,200	850	0	0	=SUM(D2:G2)
2026-09-12	ZQ-1002	Takeaway	0	450	600	0	=SUM(D3:G3)
2026-09-12	ZQ-1003	Delivery (Aggregator)	0	0	0	1,450	=SUM(D4:G4)
TOTAL			=SUM(D2:D4)	=SUM(E2:E4)	=SUM(F2:F4)	=SUM(G2:G4)	=SUM(H2:H4)

Sheet 4: Master Bookkeeping & P&L Tracker (Monthly Summary)

Keep track of your cash flows, ensuring overheads and variable costs stay within healthy margins.

Expense Category	Sub-Item / Description	Vendor Name / Details	Amount (₹)	Payment Mode	Invoice / Receipt Ref
Fixed Costs	Property Rent (Bandlaguda/Aramghar)	Landlord Name	75,000	Bank Transfer	INV-RENT-09
Fixed Costs	Salaries & Staff Wages	Kitchen & Service Crew	1,20,000	Cash / Bank	PAY-ROLL-09
Variable Costs	Raw Material Purchases (Accumulated)	Various Vendors	2,10,000	UPI / Bank	PUR-AGGR-09
Utilities	Commercial LPG Gas Cylinders	HP / Indane Commercial	14,500	UPI	GAS-INV-12
Utilities	Electricity Bill (TSSPDCL)	Monthly Power Consumption	18,000	Online	ELEC-09
Marketing	Local Pamphlet Distribution & Meta Ads	Digital & Print Agencies	8,000	UPI	MKT-09
TOTAL EXPENSES			=SUM(D2:D7)

Pro-Tips for Managing This Digitally:

1. Cloud Access: Create these four tables as separate tabs in a single Google Sheets document. This allows your manager at the restaurant floor to update the purchasing list or daily sales, while you can view live inventory and expenses remotely from anywhere.
2. Weekly Wastage Audits: Add a small column in your inventory sheet called “Wastage / Spoilage” so cooks have to account for dropped food, burnt rice, or trimmed meat fat. This stops hidden kitchen leakage cold.

Would you like me to draft a quick script or formula set to track automated low-stock warning alerts whenever your ingredients hit safety levels?

YES

To set up automated low-stock warnings in your Google Sheet for ZAEQA, you can use two simple methods: Conditional Formatting (which highlights items in red when stock is low) and an Apps Script (which can send you an email alert when items hit safety levels).

Method 1: Visual Low-Stock Alerts (Conditional Formatting)

This method automatically turns a row or cell bright red when your current stock drops to or below your par level.

1. Open your Daily Purchasing & Par-Level Order Sheet in Google Sheets.
2. Highlight your entire data range for current stock (for example, select cells D2:D50).
3. In the top menu, click on Format > Conditional formatting.
4. Under the Format rules drop-down menu, select Custom formula is.
5. Paste this formula into the box: =D2<=C2 (Assuming D is your Current Stock column and C is your Par Level / Minimum Stock column).
6. Under Formatting style, choose a bright red fill color with white text so it stands out immediately.
7. Click Done. Now, whenever stock falls below the threshold, the row will flag itself visually.

Method 2: Automated Email Alerts via Google Apps Script

If you want Google Sheets to automatically check your inventory every morning and email you a warning list of items that need reordering, follow these steps:

1. In your Google Sheet, click on Extensions > Apps Script in the top menu.
2. Delete any code in the editor and paste the following clean script:

JavaScript

function checkLowStock() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2"); // Change "Sheet2" to your exact sheet name if different
  var range = sheet.getDataRange().getValues();
  
  var lowStockItems = [];
  
  // Loop through rows (assuming row 1 is headers)
  for (var i = 1; i < range.length; i++) {
    var itemName = range[i][0];   // Column A: Item Name
    var unit = range[i][1];       // Column B: Unit
    var parLevel = range[i][2];   // Column C: Par Level (Min Stock)
    var currentStock = range[i][3]; // Column D: Current Stock
    
    // Check if current stock is less than or equal to par level
    if (currentStock <= parLevel) {
      lowStockItems.push(itemName + " (Current: " + currentStock + " " + unit + ", Required Min: " + parLevel + ")");
    }
  }
  
  // If there are low stock items, send an email alert
  if (lowStockItems.length > 0) {
    var email = Session.getActiveUser().getEmail(); // Sends to your logged-in Google email
    var subject = "⚠️ ZAEQA Inventory Alert: Low Stock Warning!";
    var message = "The following items have dropped below their safety par levels at ZAEQA:\n\n" + lowStockItems.join("\n") + "\n\nPlease place a purchase order immediately.";
    
    MailApp.sendEmail(email, subject, message);
  }
}

// Optional: Set up an automated daily trigger to run this every morning at 8:00 AM
function createDailyTrigger() {
  // Clear old triggers first to prevent duplicates
  var triggers = ScriptApp.getProjectTriggers();
  for (var i = 0; i < triggers.length; i++) {
    ScriptApp.deleteTrigger(triggers[i]);
  }
  
  // Create a new time-driven trigger for 8 AM
  ScriptApp.newTrigger('checkLowStock')
      .timeBased()
      .everyDays(1)
      .atHour(8)
      .create();
}

3. Click the Save icon (floppy disk) at the top of the Apps Script editor.
4. Click the Run button once to test it. Google will ask you to review permissions—click “Review Permissions,” select your Google account, click “Advanced,” and click “Go to Untitled project (unsafe)” to grant access to send emails and read your sheet.
5. Once authorized, run the createDailyTrigger function once from the dropdown function menu to lock in the automated daily morning check.

Would you like help mapping out a vendor contact directory sheet to link directly with these reorder quantities?

YES

Here is your Vendor Contact & Supply Chain Directory template structure. You can add this as Sheet 5 in your Google Sheets workbook.

This directory acts as your procurement command center, connecting your low-stock alerts and daily purchasing lists directly to the right suppliers with clear terms, lead times, and payment cycles.

Sheet 5: Vendor Contact & Supply Chain Directory

Vendor ID	Category / Supplies Provided	Company / Supplier Name	Contact Person	Phone Number / WhatsApp	Alternative Number	Delivery Lead Time	Payment Terms	Preferred Order Time	Notes & Quality Rating (1-5)
VND-001	Dry Goods (Rice, Pulses, Spices)	Deccan Agro Traders	Rajesh Gupta	98490XXXXX	98490YYYYY	Same Day / 4 Hours	15 Days Credit	Before 10:00 AM	Rating: 4.5 – Reliable bulk pricing
VND-002	Perishables (Meats & Halal Chicken)	Al-Madina Meats	Mohammed Ali	98850XXXXX	—	Morning Batch (2 Hrs)	Cash on Delivery (COD)	Night Before (9 PM)	Rating: 4.8 – Fresh cuts, morning delivery
VND-003	Dairy Products (Curd, Milk, Paneer)	Vijaya Dairy Distributor	Suresh Kumar	97000XXXXX	97000YYYYY	Daily Morning	Weekly Credit	Before 8:00 PM	Rating: 4.2 – Consistent chilling
VND-004	Packaging (Containers, Handis, Bags)	Hyderabad Packaging Solutions	Santosh Agarwal	93910XXXXX	—	24 Hours	50% Advance, 50% COD	Anytime	Rating: 4.0 – Good bulk discounts
VND-005	Utilities (Commercial LPG Cylinders)	HP Commercial Gas Agency	Ramesh Babu	98660XXXXX	—	3 to 6 Hours	Immediate UPI / Cash	Before 11:00 AM	Rating: 4.7 – Emergency backup available

How to Link This Directory to Your Purchasing Sheet:

To make your workflow seamless, you can use a formula in your Daily Purchasing & Par-Level Order Sheet (Sheet 2) to pull supplier contact details automatically whenever you select a vendor name.

If your Vendor Directory is on Sheet 5 (columns A through J) and your Purchasing Sheet lists the preferred supplier name in Column F, you can pull their phone number directly using this VLOOKUP formula: =VLOOKUP(F2, 'Sheet 5'!C:E, 3, FALSE) (This formula looks up the supplier name in Sheet 5 and automatically populates their phone number into your purchasing list).

Would you like to expand this into a staff shift roster or kitchen task checklist next?

YES

Here are the next two essential templates to add to your Google Sheets workbook for ZAEQA. These will ensure your staff knows exactly when to work and what their daily responsibilities are, which is critical for maintaining hygiene and food quality.

Sheet 6: Staff Shift & Attendance Roster

Since ZAEQA is positioned on a busy transit corridor and will cater to late-night crowds, managing shifts effectively is crucial to prevent staff burnout. Use this sheet to track schedules and weekly days off.

Emp ID	Staff Name	Role / Designation	Shift Type	Shift Timings	Weekly Off	Contact Number	Notes / Special Instructions
EMP-001	Abdul Rehman	Head Chef (Biryani Ustad)	Split Shift	08:00 AM – 12:00 PM & 06:00 PM – 11:00 PM	Tuesday	98490XXXX1	Manage morning marination & evening dum
EMP-002	Shaik Imran	Tandoor / Kebab Chef	Evening Shift	04:00 PM – 01:00 AM	Monday	98850XXXX2	Late night prep
EMP-003	Suresh Kumar	Kitchen Prep / Helper	Morning Shift	07:00 AM – 04:00 PM	Wednesday	97000XXXX3	Veg chopping, onion frying, cleaning
EMP-004	Syed Aamer	Front Desk / Cashier	Full Shift	11:00 AM – 11:00 PM	Thursday	93910XXXX4	POS management, aggregator dispatch
EMP-005	Rahul	Waitstaff / Server	Evening Shift	05:00 PM – 01:00 AM	Tuesday	98660XXXX5	Focus on family dining section

• Pro-Tip for Scheduling: For a Biryani and Mandi restaurant, your busiest days are Friday, Saturday, and Sunday. Ensure no critical staff (like your Head Chef or Tandoor Chef) take their weekly off on the weekends. Assign off-days strictly between Monday and Thursday.

Sheet 7: Daily Kitchen & Operations Checklist

This is your Standard Operating Procedure (SOP). Print this out daily, laminate it, and have your shift supervisors use a dry-erase marker to tick off tasks. It ensures nothing is forgotten.

Phase	Time	Task Category	Specific Task Description	Assigned Role	Status (Tick)	Supervisor Sign-off
Opening	07:00 AM	Deliveries	Receive daily meat & dairy; check weight and temperature	Prep Cook	[ ]
Opening	08:00 AM	Food Prep	Marinate mutton/chicken for Biryani; prepare ginger-garlic paste	Head Chef	[ ]
Opening	10:30 AM	Setup	Switch on POS system, count opening cash drawer (float)	Cashier	[ ]
Mid-Shift	03:30 PM	Cleaning	Sweep and mop kitchen floor; wipe down dining tables	Helper/Server	[ ]
Mid-Shift	04:30 PM	Restock	Refill takeaway containers, tissues, and sauces at the packing station	Front Desk	[ ]
Closing	12:00 AM	Equipment	Turn off Tandoor, lock commercial LPG valves securely	Tandoor Chef	[ ]
Closing	12:30 AM	Inventory	Log daily wastage; count closing stock of meat and premium items	Head Chef	[ ]
Closing	01:00 AM	Cash & Close	Tally POS sales with cash drawer; lock premises	Cashier / Mgr	[ ]

Adding Checkboxes in Google Sheets

To make Sheet 7 interactive in Google Sheets:

1. Highlight the cells in the “Status (Tick)” column.
2. Go to the top menu and click Insert > Checkbox.
3. Now your manager can simply click the box to check off tasks as they are completed!

You now have a complete, 7-sheet operational blueprint covering Inventory, Purchasing, Sales, Bookkeeping, Vendors, Rosters, and Checklists.

Would you like me to compile all of these strategies, templates, and market research into a formal Business Plan Document (Google Doc) directly into your Google Drive, or would you like to focus on Menu Pricing and Profit Margins next?

YES PLEASE

I have successfully created and compiled your complete restaurant business plan and operational strategy document for ZAEQA.

ZAEQA Restaurant Business Plan – Hyderabad Operations

ZAEQA Restaurant Business Plan – Hyderabad Operations

Google Docs

This comprehensive document integrates your brand positioning, market strategy for the Bandlaguda / Aramghar / Chandrayangutta corridors, inventory frameworks, staffing schedules, and financial cost-control targets into a professional layout.

Would you like to dive deeper into Menu Engineering and Profit Margin Calculations or explore marketing strategies to drive traffic to [www.zaeqa.com](https://www.zaeqa.com) next?

Menu Pricing and Profit Margins next?

Menu Engineering & Profit Margin Framework

• Pricing Strategy (The 30% Rule): Price your menu items so that the total cost of ingredients (Food Cost) makes up exactly 30% to 32% of the selling price. For example, if a plate of Mutton Dum Biryani costs ₹180 in raw ingredients (meat, basmati rice, oil, spices, ghee), divide ₹180 by 0.30 to arrive at a target menu price of ₹600. ZAEQA Restaurant Business Plan – Hyderabad Operations
• The Menu Matrix (Four Quadrants): Classify every item on your ZAEQA menu into one of four categories based on popularity and profitability:
  • Stars (High Profit, High Popularity): Your signature Hyderabadi Dum Biryani and special Mandi variants. Keep quality pristine and never alter recipes.
  • Plowhorses (Low Profit, High Popularity): High-volume items like standard chicken fried rice or regular combos. Slightly optimize portion costs or increase prices by 5% to boost margins.
  • Puzzles (High Profit, Low Popularity): Specialty premium kebabs or seafood dishes. Re-engineer descriptions on www.zaeqa.com, train servers to upsell them, or run promotional bundles. ZAEQA Restaurant Business Plan – Hyderabad Operations
  • Dogs (Low Profit, Low Popularity): Slow-moving items that waste inventory space. Remove them immediately from your active menu rotation.
• Aggregator Commission Buffer: Keep in mind that third-party delivery platforms like Swiggy and Zomato charge 22% to 28% commissions. Create a dual-pricing model where items ordered directly through www.zaeqa.com are priced 10% lower, passing savings to the customer while protecting your margins against aggregator cuts. ZAEQA Restaurant Business Plan – Hyderabad Operations
• Fixed vs. Variable Contribution: Every item sold must contribute toward covering your fixed overheads (rent along the Bandlaguda/Aramghar corridor, utilities, and base staff salaries) after absorbing its specific raw material cost and packaging expense. ZAEQA Restaurant Business Plan – Hyderabad Operations

Would you like to calculate specific target menu prices for your top 5 signature items at ZAEQA?

YES

Applying a target 30% food cost model to ZAEQA’s menu, here is how you can engineer pricing for your flagship items based on current market rates in Hyderabad:

Menu Item	Estimated Raw Material Cost per Portion (₹)	Target Food Cost %	Calculated Ideal Menu Price (₹)	Typical Market Price Range in Hyderabad	Recommended ZAEQA Dine-In Price (₹)
Chicken Dum Biryani (Single)	₹65 – ₹75	30%	₹216 – ₹250	₹220 – ₹280	₹240
Mutton Gosht Dum Biryani	₹150 – ₹165	30%	₹500 – ₹550	₹490 – ₹550	₹520
Arabian Chicken Mandi (Full)	₹180 – ₹200	30%	₹600 – ₹660	₹600 – ₹750	₹650
Butter Chicken (Gravy)	₹90 – ₹100	30%	₹300 – ₹330	₹280 – ₹350	₹320
Chicken 65 (Starter)	₹70 – ₹80	30%	₹233 – ₹266	₹240 – ₹300	₹250

Strategic Pricing Rules for ZAEQA:

• The Psychology of Pricing: Avoid ending prices in random digits. In Hyderabad’s dining market, round your pricing to clean figures ending in 0 or 5 (e.g., ₹240 instead of ₹238) as it speeds up POS billing and cash change transactions.
• Combo Engineering: Bundle high-margin items with low-cost accompaniments. For instance, pairing a Chicken Dum Biryani (₹240) with a small Thums Up or a portion of Mirchi ka Salan allows you to market a “ZAEQA Special Combo” at ₹310 while increasing your average ticket size.
• Aggregator Guardrail: If you list your Mutton Biryani at ₹520 for dine-in, list it at ~₹580 to ₹600 on Swiggy and Zomato to absorb their 25% commission slot, while keeping your direct website orders on www.zaeqa.com at ₹520 or with a minor discount code to build your own customer database. ZAEQA Restaurant Business Plan – Hyderabad Operations

PLEASE MAKE GOOGLE SHEETS FOR THE ABOVE SUGGEST TABLE FROM 1 TO 7

All seven core operational tables for ZAEQA have been fully compiled below into a clean, unified layout designed for easy copying and pasting directly into individual tabs of your Google Sheets workbook.

Sheet 1: Recipe-Based Inventory & Daily Consumption Tracker

Item ID	Item Name	Category	Unit	Opening Stock	Purchases Today	Total Available	Closing Stock	Total Consumed	Unit Cost (₹)	Total Cost (₹)
ING-001	Basmati Rice (Aged)	Dry Goods	KG	100	50	150	120	30	95	=J2*I2
ING-002	Mutton (Fresh Halal)	Perishables	KG	15	25	40	8	32	750	=J3*I3
ING-003	Cooking Oil	Groceries	Liters	45	15	60	38	22	140	=J4*I4
PKG-001	750ml Containers	Packaging	Pcs	500	0	500	350	150	6	=J5*I5

Sheet 2: Daily Purchasing & Par-Level Order Sheet

Item Name	Unit	Par Level	Current Stock	Reorder Quantity	Preferred Supplier	Contact Number	Status / Notes
Basmati Rice	KG	50	30	=C2-D2	Deccan Agro Traders	98490XXXXX	Urgent delivery by 4 PM
Chicken (Raw)	KG	40	10	=C3-D3	Al-Madina Meats	98850XXXXX	Morning batch only
Curd / Yogurt	KG	20	5	=C4-D4	Vijaya Dairy Distributor	97000XXXXX	Daily fresh supply

Sheet 3: Daily Sales & POS Reconciliation Register

Date	Bill ID	Dine-In / Takeaway / Delivery	Cash (₹)	UPI / QR (₹)	Credit Card (₹)	Swiggy / Zomato (₹)	Total Bill Value (₹)
2026-09-12	ZQ-1001	Dine-In	1,200	850	0	0	=SUM(D2:G2)
2026-09-12	ZQ-1002	Takeaway	0	450	600	0	=SUM(D3:G3)
2026-09-12	ZQ-1003	Delivery (Aggregator)	0	0	0	1,450	=SUM(D4:G4)
TOTAL			=SUM(D2:D4)	=SUM(E2:E4)	=SUM(F2:F4)	=SUM(G2:G4)	=SUM(H2:H4)

Sheet 4: Master Bookkeeping & P&L Tracker (Monthly Summary)

Expense Category	Sub-Item / Description	Vendor Name / Details	Amount (₹)	Payment Mode	Invoice / Receipt Ref
Fixed Costs	Property Rent (Bandlaguda/Aramghar)	Landlord Name	75,000	Bank Transfer	INV-RENT-09
Fixed Costs	Salaries & Staff Wages	Kitchen & Service Crew	1,20,000	Cash / Bank	PAY-ROLL-09
Variable Costs	Raw Material Purchases	Various Vendors	2,10,000	UPI / Bank	PUR-AGGR-09
Utilities	Commercial LPG Gas Cylinders	HP / Indane Commercial	14,500	UPI	GAS-INV-12
Utilities	Electricity Bill (TSSPDCL)	Monthly Power Consumption	18,000	Online	ELEC-09
Marketing	Local Pamphlet Distribution & Meta Ads	Digital & Print Agencies	8,000	UPI	MKT-09
TOTAL EXPENSES			=SUM(D2:D7)

Sheet 5: Vendor Contact & Supply Chain Directory

Vendor ID	Category	Company Name	Contact Person	Phone / WhatsApp	Lead Time	Payment Terms	Preferred Order Time	Rating
VND-001	Dry Goods	Deccan Agro Traders	Rajesh Gupta	98490XXXXX	Same Day / 4 Hrs	15 Days Credit	Before 10:00 AM	4.5
VND-002	Perishables	Al-Madina Meats	Mohammed Ali	98850XXXXX	Morning Batch (2 Hrs)	COD	Night Before (9 PM)	4.8
VND-003	Dairy	Vijaya Dairy Distributor	Suresh Kumar	97000XXXXX	Daily Morning	Weekly Credit	Before 8:00 PM	4.2
VND-004	Packaging	Hyderabad Packaging Solutions	Santosh Agarwal	93910XXXXX	24 Hours	50% Adv, 50% COD	Anytime	4.0
VND-005	Utilities	HP Commercial Gas Agency	Ramesh Babu	98660XXXXX	3 to 6 Hours	Immediate UPI/Cash	Before 11:00 AM	4.7

Sheet 6: Staff Shift & Attendance Roster

Emp ID	Staff Name	Role / Designation	Shift Type	Shift Timings	Weekly Off	Contact Number	Notes
EMP-001	Abdul Rehman	Head Chef (Biryani Ustad)	Split Shift	08:00 AM – 12:00 PM & 06:00 PM – 11:00 PM	Tuesday	98490XXXX1	Marination & dum
EMP-002	Shaik Imran	Tandoor / Kebab Chef	Evening Shift	04:00 PM – 01:00 AM	Monday	98850XXXX2	Late night prep
EMP-003	Suresh Kumar	Kitchen Prep / Helper	Morning Shift	07:00 AM – 04:00 PM	Wednesday	97000XXXX3	Veg chopping, cleaning
EMP-004	Syed Aamer	Front Desk / Cashier	Full Shift	11:00 AM – 11:00 PM	Thursday	93910XXXX4	POS management
EMP-005	Rahul	Waitstaff / Server	Evening Shift	05:00 PM – 01:00 AM	Tuesday	98660XXXX5	Family dining section

Sheet 7: Daily Kitchen & Operations Checklist

Phase	Time	Task Category	Specific Task Description	Assigned Role	Status (Tick)	Supervisor Sign-off
Opening	07:00 AM	Deliveries	Receive daily meat & dairy; check weight and temperature	Prep Cook	[ ]
Opening	08:00 AM	Food Prep	Marinate mutton/chicken for Biryani; prepare ginger-garlic paste	Head Chef	[ ]
Opening	10:30 AM	Setup	Switch on POS system, count opening cash drawer (float)	Cashier	[ ]
Mid-Shift	03:30 PM	Cleaning	Sweep and mop kitchen floor; wipe down dining tables	Helper/Server	[ ]
Mid-Shift	04:30 PM	Restock	Refill takeaway containers, tissues, and sauces at packing station	Front Desk	[ ]
Closing	12:00 AM	Equipment	Turn off Tandoor, lock commercial LPG valves securely	Tandoor Chef	[ ]
Closing	12:30 AM	Inventory	Log daily wastage; count closing stock of meat and premium items	Head Chef	[ ]
Closing	01:00 AM	Cash & Close	Tally POS sales with cash drawer; lock premises	Cashier / Mgr	[ ]

PLEASE CONNECT THESE SHEETS TO GOOGLE WORKPLACE

To connect these operational sheets directly to your Google Workspace account and create a live workbook, open a blank Google Sheet at sheets.google.com and follow these quick steps:

1. Set Up the Tabs: Create seven separate tabs at the bottom of your Google Sheet and rename them exactly as listed below:
   • Inventory Tracker
   • Par Level Purchasing
   • Sales Reconciliation
   • Bookkeeping P&L
   • Vendor Directory
   • Staff Roster
   • Operations Checklist
2. Copy and Paste Tables: Copy each of the structured tables provided above and paste them into their respective tabs in your new Google Sheet.
3. Enable Formulas & Checkboxes:
   • In your Inventory Tracker and Par Level Purchasing sheets, ensure the cells containing formulas (like =J2*I2 or =C2-D2) start with the = sign so Google Sheets calculates them automatically.
   • In the Operations Checklist tab, highlight your status column and go to Insert > Checkbox to make them interactive.
4. Automate Alerts (Optional): Click on Extensions > Apps Script inside your Google Sheet, paste the automated email alert script provided earlier, and save it to receive low-stock notifications directly in your Gmail.

Would you like me to guide you through setting up a custom Google Workspace domain email (like info@zaeqa.com) to manage your restaurant vendor communications?

YES

To set up your custom domain email (info@zaeqa.com) for ZAEQA, you will need to host your domain email using a provider like Google Workspace (Workspace Business Starter) or Zoho Mail, since your domain is hosted or pointed via [www.zaeqa.com](https://www.zaeqa.com).

ZAEQA Restaurant Business Plan – Hyderabad Operations

Here is the step-by-step implementation guide to get your professional restaurant email running:

Step 1: Choose a Business Email Provider

• Google Workspace: Highly recommended because it integrates seamlessly with the Google Sheets, Google Docs, and Drive folders you are already using for your restaurant operations. Plans start around ₹130–₹210 per user/month in India.
• Zoho Mail: A fantastic, cost-effective alternative that offers robust secure mailing for small businesses, with free or very low-cost tiers.

Step 2: Register Your Domain

• Ensure your domain registrar (where you originally bought zaeqa.com) gives you access to your DNS settings (Cloudflare, GoDaddy, Hostinger, etc.). You will need this to verify ownership.

Step 3: Configure DNS Records (MX and SPF) Once you sign up for Google Workspace or Zoho Mail, they will provide specific text records that you must paste into your domain registrar’s DNS manager:

• MX Records (Mail Exchange): These tell the internet where to deliver emails sent to @zaeqa.com. Google will give you a primary and secondary MX server address to add.
• SPF & DKIM Records: These security text (TXT) records prevent your restaurant emails from landing in your vendors’ or customers’ spam folders.

Step 4: Create Your Restaurant Team Inboxes Set up role-based email addresses so vendors and customers can reach the right department:

• info@zaeqa.com (General inquiries & website contact forms)
• orders@zaeqa.com (For digital orders from [www.zaeqa.com](https://www.zaeqa.com) and aggregator coordination) ZAEQA Restaurant Business Plan – Hyderabad Operations
• accounts@zaeqa.com (For managing vendor invoices and bookkeeping receipts)

Would you like help drafting a professional vendor onboarding email template to send from your new info@zaeqa.com address to your suppliers?

YES

Subject: Vendor Account Setup and Supply Guidelines – ZAEQA

Dear Partner,

We are pleased to onboard [Supplier Company Name] as an official supply partner for ZAEQA, located along the key transit corridors of Bandlaguda Inner Ring Road (near Aramghar X Road) and Chandrayangutta Main Road in Hyderabad.

To ensure seamless operations, daily inventory tracking, and timely fulfillment for our kitchen, please review our standard purchasing guidelines and terms:

• Purchase Orders & Reordering: Daily purchase orders will be generated based on our automated par-level tracking system and sent via WhatsApp or email from info@zaeqa.com or our procurement team.
• Delivery Timelines & Location: Deliveries must be strictly fulfilled according to agreed lead times (morning batches for perishables before 8:00 AM; dry goods as per scheduled lead times) directly to our back-of-house receiving area.
• Quality & Compliance Standards: All raw materials, meats (Halal certified), dairy, and packaging items must meet high hygiene and quality standards. Any sub-standard or temperature-compromised stock will be subject to immediate rejection at the dock.
• Invoicing & Billing: All physical and digital invoices must clearly reference your Vendor ID, item breakdown, quantities, and GST details, and be sent to accounts@zaeqa.com to facilitate our 15-day credit or Cash-on-Delivery (COD) payment cycles.

Please confirm receipt of this email and reply with your updated contact numbers, bank details for digital settlements, and a copy of your active FSSAI/trade licenses for our compliance records.

We look forward to a long and mutually successful business relationship.

Warm regards,

Procurement Team

ZAEQA

Website: www.zaeqa.com

ZAEQA Restaurant Business Plan – Hyderabad Operations

Location: Bandlaguda Inner Ring Road & Chandrayangutta Main Road, Hyderabad