Otaku Haven

# Run: run-2026-04-25-15-13-00
# Purpose: Financial Model and Competitive Analysis Matrix — Otaku Haven LLC

---

## TASK-001 — Create Output Directory

**Description:** Verify or create the output directory before any deliverables are written.

**Inputs:** None.

**Output:** Directory `Business Plan/02-Strategic/` exists in the repository root.

**Acceptance Criteria:**
- The path `Business Plan/02-Strategic/` exists before Task 002 begins.

---

## TASK-002 — Build Financial-Model.xlsx

**Description:** Produce a multi-tab Excel workbook with 3–5 year financial projections for Otaku Haven LLC. This workbook is the canonical financial source for all other documents in this intent package.

**Inputs:**
- `trail/meta/files/Otaku_Haven_Reference_Data.md`

**Output:** `Business Plan/02-Strategic/Financial-Model.xlsx`

---

### Required Tabs (in this order)

**Tab 1 — Key Assumptions**

All input parameters with labels and values. Every numeric input used anywhere in the model must appear here as a named, labeled row. No hardcoded numbers in formula cells in other tabs — all values must reference this tab.

Required rows (at minimum):
- Store open date: June 1, 2026
- Monthly rent: $3,500 (NNN, constant)
- Startup budget: $250,000
- Monthly owner contribution: $2,000 (×12 months = $24,000)
- Total Year 1 available capital: $274,000
- Gross margin assumption (select one value within the 45–55% target range; document rationale)
- Revenue growth rate assumptions (Year 2, 3, 4, 5)
- Hourly employee weekly hours assumptions (for Assistant Manager, Key Holders, Sales Associates)
- Employer tax and benefit burden rate (% applied to base payroll — reasonable assumption)
- Utility cost assumption (monthly)
- Insurance cost assumption (monthly)
- Marketing expense assumption (monthly — this becomes the canonical marketing budget figure referenced by the Marketing Plan)
- Technology/software subscription costs (monthly — references: Square for Retail, Square Online, Xero, Gusto, Microsoft 365)
- Miscellaneous/contingency expense (monthly)

---

**Tab 2 — Revenue Year 1 Monthly**

Monthly revenue by product category for the operational period: June 2026 through December 2026 (7 months).

Apply seasonal adjustments to monthly revenue — express as a seasonal index (1.0 = baseline):
- June 2026: opening month boost (index > 1.0 — new store awareness)
- July 2026: convention/summer season (index > 1.0)
- August 2026: moderate (index ≈ 1.0)
- September 2026: moderate (index ≈ 1.0)
- October 2026: moderate (index ≈ 1.0)
- November 2026: holiday ramp-up (index > 1.0)
- December 2026: holiday peak (highest month — index > 1.0)

Document the seasonal index values in the Key Assumptions tab.

Rows (product categories):
- Figures & Statues
- Manga & Light Novels
- Apparel
- Accessories
- Home & Lifestyle
- Trading Cards
- Media
- Consignment / Local Creator Section
- **Total Revenue** (sum row)
- **COGS** (Total Revenue × (1 − gross margin %) — pull gross margin from Key Assumptions tab)
- **Gross Profit** (Total Revenue − COGS)
- **Gross Margin %** (Gross Profit ÷ Total Revenue)

Also show: January–May 2026 columns with $0 revenue (pre-opening period — no sales). These columns are needed for the Cash Flow Statement.

---

**Tab 3 — Revenue Years 2–5 Annual**

Annual revenue by product category for Years 2–5 (calendar years 2027, 2028, 2029, 2030).

Use a growth rate from Key Assumptions tab (e.g., Year 2 vs. Year 1 full-year run rate). Apply the same seasonal logic as a note — no need for monthly detail in Years 2–5.

Same product category rows as Tab 2. Include total revenue, COGS, gross profit, gross margin %.

---

**Tab 4 — Payroll Detail**

Line-by-line payroll for all 8 employees using exact values from the reference data compensation table.

| Role | Count | Type | Rate | Assumed Hours/Week | Monthly Cost (per person) | Monthly Cost (total for role) |
|---|---|---|---|---|---|---|
| Store Manager | 1 | Salaried | $65,000/year | N/A | $65,000÷12 | — |
| Assistant Manager | 1 | Hourly | $20/hour | Assumed (document in Key Assumptions) | Rate×Hours×52÷12 | — |
| Key Holder | 2 | Hourly | $18/hour | Assumed (document in Key Assumptions) | Rate×Hours×52÷12 | ×2 |
| Sales Associate | 4 | Hourly | $15/hour | Assumed (document in Key Assumptions) | Rate×Hours×52÷12 | ×4 |
| **Total Base Payroll** | 8 | | | | | Sum |
| **Employer Tax/Benefit Burden** | | | | | | Base × burden rate (from Key Assumptions) |
| **Total Payroll Cost** | | | | | | Base + Burden |

Include annual totals and monthly averages.

---

**Tab 5 — Operating Expenses**

Monthly columns for June–December 2026. Annual columns for Years 2–5.

Line items:
- Rent: $3,500/month (constant — pull from Key Assumptions)
- Payroll (total base payroll from Tab 4 — cell reference)
- Employer Taxes/Benefits (from Tab 4 — cell reference)
- Utilities (from Key Assumptions)
- Insurance (from Key Assumptions)
- Marketing (from Key Assumptions — this is the canonical marketing budget figure)
- Technology / Software Subscriptions (from Key Assumptions)
- Miscellaneous / Contingency (from Key Assumptions)
- **Total Operating Expenses** (sum row)

Also show January–May 2026 (pre-opening): rent and any startup-period costs applicable (e.g., technology setup, insurance beginning from lease date). No payroll in pre-opening unless explicitly included as an assumption.

---

**Tab 6 — Startup Costs and Use of Funds**

Complete allocation of the $250,000 startup budget. Line items must sum exactly to $250,000.

Required categories:
- Leasehold Improvements / Buildout
- Initial Inventory
- Equipment and Fixtures (including POS hardware, shelving, display cases)
- Technology Setup (software licenses, website development, domain)
- Signage and Branding
- Marketing and Pre-Opening Promotion
- Legal and Professional Fees
- Working Capital Reserve

All amounts are assumptions — document rationale in the tab and/or Key Assumptions tab. Total must equal $250,000 exactly.

---

**Tab 7 — Income Statement (P&L)**

Columns: January–December 2026 (monthly), then Years 2–5 (annual).

Structure:
- Revenue (from Tab 2 / Tab 3)
- COGS (from Tab 2 / Tab 3)
- **Gross Profit**
- **Gross Margin %**
- Operating Expenses (line items from Tab 5 or summarized)
- **Total Operating Expenses**
- **Operating Income / (Loss)** = Gross Profit − Total Operating Expenses
- **Net Income / (Loss)** (same as Operating Income for this model — no debt financing assumed unless added as an assumption)

Pre-opening months (January–May 2026): show $0 revenue and startup-period operating costs only. The startup budget ($250,000) appears as an investing/financing item in the Cash Flow Statement, not as an operating expense in the P&L.

---

**Tab 8 — Cash Flow Statement**

Columns: January–December 2026 (monthly), then Years 2–5 (annual).

Sections:
- **Operating Activities**: Net Income/(Loss) + non-cash adjustments + working capital changes
- **Investing Activities**: Startup spending (buildout, equipment, initial inventory) drawn from Tab 6
- **Financing Activities**: Owner capital contributions ($2,000/month × 12 months + initial $250,000 startup capital infusion)
- **Net Change in Cash**
- **Beginning Cash Balance**
- **Ending Cash Balance**

The ending cash balance must never go negative — if it does, document the issue in `results.md` and adjust assumptions to resolve it (e.g., adjust working capital reserve or draw timing). The $274,000 total available capital ($250,000 startup + $24,000 owner contributions) is the Year 1 funding source.

---

**Tab 9 — Break-Even Analysis**

Show on a monthly basis (June 2026 through at least July 2027 — 14 months of operations):

| Month | Month # | Monthly Revenue | Monthly Fixed Costs | Monthly Gross Profit | Monthly Operating Income/(Loss) | Cumulative Operating Income/(Loss) |
|---|---|---|---|---|---|---|

Identify the specific month when Monthly Operating Income first turns positive (break-even month). This must fall between Month 10 (March 2027) and Month 14 (July 2027) of operations.

If the break-even does not fall in this range, adjust revenue growth assumptions (not cost assumptions — costs are fixed by reference data) and document the adjustment in `results.md`.

Include a note showing: Break-Even Revenue = Total Monthly Fixed Costs ÷ Gross Margin %.

---

### Key Parameters (non-negotiable — do not deviate)

| Parameter | Value | Source |
|---|---|---|
| Store open date | June 1, 2026 | Reference data |
| Monthly rent | $3,500 NNN | Reference data |
| Startup budget | $250,000 | Reference data |
| Owner contributions | $2,000/month × 12 months | Reference data |
| Total Year 1 available capital | $274,000 | Reference data |
| Target gross margin | 45–55% (select one value) | Reference data |
| Break-even target | Month 10–14 of operations | Reference data |
| Headcount | Exactly 8 (per compensation table) | Reference data |
| Payroll rates | Per compensation table | Reference data |
| Fiscal year start | January 1 | Reference data |

---

### Acceptance Criteria for Task 002

- [ ] All 9 tabs are present in the workbook in the specified order.
- [ ] Break-even is achieved in Month 10–14 of operations (March 2027 – July 2027).
- [ ] All 8 employees appear in the Payroll Detail tab at exact compensation table rates.
- [ ] Rent is $3,500/month in every operational period (Year 1 through Year 5).
- [ ] Startup Costs tab sums exactly to $250,000.
- [ ] Year 1 gross margin % is within 45–55%.
- [ ] All formula cells in Tabs 2–9 reference the Key Assumptions tab rather than hardcoded values.
- [ ] Ending cash balance does not go negative in any month.

---

## TASK-003 — Self-Verify Financial-Model.xlsx

**Description:** Before proceeding to Task 004, verify that `Financial-Model.xlsx` meets all acceptance criteria from Task 002. Fix any issues found. Document the verification outcome in `results.md`.

**Inputs:** Completed `Financial-Model.xlsx`.

**Output:** Verification documented in `results.md`. Issues fixed or documented as blockers.

**Acceptance Criteria:**
- Every acceptance criterion from Task 002 is confirmed and documented in `results.md`.
- If any criterion fails: fix it and re-verify, OR document it as a blocker with an explanation.
- Do not proceed to Task 004 until this task is complete.

---

## TASK-004 — Build Competitive-Analysis.xlsx

**Description:** Produce a tabular competitor comparison matrix for Otaku Haven versus 4 competitors.

**Inputs:**
- `trail/meta/files/Otaku_Haven_Reference_Data.md`

**Output:** `Business Plan/02-Strategic/Competitive-Analysis.xlsx`

---

### Required Matrix Structure

**Columns (one per entity):**
1. Otaku Haven
2. Crunchyroll Store (online anime retailer)
3. Hot Topic (big-box, anime/pop-culture chain)
4. Barnes & Noble (big-box, manga section)
5. Local Anime Shop — Austin area (fictional — label clearly as "Fictional Local Competitor")

**Rows (comparison dimensions):**
1. Product Selection — breadth and depth of anime product categories
2. Pricing Positioning — budget / mid-range / premium; price-match capability
3. Location / Accessibility — online only, physical only, or both; geographic reach
4. Community Engagement — events, loyalty programs, social media, Discord/forums
5. Online Presence — website quality, social media scale, e-commerce capability
6. In-Store / Customer Experience — atmosphere, staff expertise, discovery experience
7. Unique Differentiators — what sets each competitor apart

Place the comparison matrix on a sheet labeled **"Comparison Matrix"**.

---

### Required Summary Section

On a second sheet labeled **"Competitive Positioning Summary"**, include:

1. **Otaku Haven's Top 3 Competitive Advantages** — specific, grounded in the matrix
2. **Primary Competitive Threat(s)** — which competitor(s) pose the greatest risk and why
3. **Underserved Customer Need** — the gap in the market that Otaku Haven addresses that competitors do not

Otaku Haven details for the matrix (from reference data):
- Product categories: all 8 (Figures & Statues, Manga & Light Novels, Apparel, Accessories, Home & Lifestyle, Trading Cards, Media, Consignment/Local Creator)
- Location: 2847 S Lamar Blvd, Suite 105, Austin, TX 78704 (physical + online)
- Digital: @OtakuHavenATX (Instagram, TikTok, X), OtakuHaven.store, discord.gg/otakuhavenatx
- Community: local creator consignment section, in-store events planned
- Experience: curated specialist retail, knowledgeable staff, community-first positioning

---

### Acceptance Criteria for Task 004

- [ ] "Comparison Matrix" sheet: 5 columns (Otaku Haven + 4 competitors), 7 dimension rows.
- [ ] "Competitive Positioning Summary" sheet: all 3 required sections present.
- [ ] Otaku Haven details are consistent with the reference data (product categories, location, digital handles).
- [ ] Fictional local competitor is labeled clearly as fictional.
- [ ] File is formatted with clear headers and consistent structure.