BulbPredict

Predict and prevent LED burnout in your dorm with smart logging.

Score: 7.7/10UKEasy BuildReady to Spawn
Brand Colors

The Opportunity

Problem

Dorm students suffer flickering and rapid burnout of energy-efficient LED bulbs due to irregular campus power grids.

Solution

Users log bulb installs, replacements, and occasional power notes; BulbPredict uses campus-shared data to forecast lifespan and send proactive alerts. It generates personalized replacement schedules and power-saving tips for irregular grids.

Target Audience

College students living in on-campus dorms

Differentiator

AI-driven predictions from crowdsourced dorm power data, no hardware required unlike IoT competitors.

Brand Voice

supportive

Features

Bulb Logging

must-have12h

Track install dates, types, and burnout events.

Lifespan Forecasting

must-have30h

Predict days until burnout using historical data.

Campus Data Aggregation

must-have20h

Anonymized insights from other dorms.

Alert Scheduler

must-have10h

Custom reminders via email/app.

Recommendation Engine

must-have15h

Suggest flicker-resistant bulbs.

Power Log Journal

nice-to-have8h

Quick notes on outages/fluctuations.

Trend Reports

nice-to-have10h

Weekly summaries of dorm trends.

Shareable Schedules

future5h

Export for roommates.

Total Build Time: 110 hours

Database Schema

users

ColumnTypeNullable
iduuidNo
emailtextNo
campustextNo
created_attimestampNo

Relationships:

  • one-to-many with bulbs

bulbs

ColumnTypeNullable
iduuidYes
user_iduuidNo
install_datetimestampNo
burnout_datetimestampYes
bulb_typetextNo

Relationships:

  • foreign key to users.id

power_logs

ColumnTypeNullable
iduuidNo
user_iduuidNo
event_typetextNo
timestamptimestampNo

Relationships:

  • foreign key to users.id

campus_stats

ColumnTypeNullable
iduuidNo
campustextNo
avg_lifespanintNo
updated_attimestampNo

API Endpoints

POST
/api/bulbs

Log new bulb or burnout

🔒 Auth Required
GET
/api/predictions

Get forecasts for user's bulbs

🔒 Auth Required
POST
/api/logs

Add power event log

🔒 Auth Required
GET
/api/campus-stats

Fetch campus averages

PUT
/api/alerts

Update alert prefs

🔒 Auth Required

Tech Stack

Frontend
Next.js 14 + Tailwind + Framer Motion
Backend
Next.js API + Supabase Functions
Database
Supabase Postgres
Auth
Supabase Auth
Payments
Stripe
Hosting
Vercel
Additional Tools
Supabase AI Vectors for recsCron for stats updates

Build Timeline

Week 1: Auth and logging

20h
  • User signup
  • Bulb CRUD

Week 2: Predictions core

30h
  • Forecast logic
  • Campus stats

Week 3: Dashboard and alerts

25h
  • User dashboard
  • Email setup

Week 4: Recs and polish

20h
  • Bulb recs
  • Mobile UI

Week 5: Payments

15h
  • Stripe tiers

Week 6: Beta testing

10h
  • Onboarding flow

Week 7: Launch

10h
  • SEO, analytics
Total Timeline: 7 weeks • 140 hours

Pricing Tiers

Free

$0/mo

No campus insights

  • 3 bulbs tracked
  • Basic predictions

Pro

$17/mo
  • Unlimited bulbs
  • Campus data
  • Custom alerts
  • Recommendations

Roommate Pro

$29/mo
  • All Pro + Shared logs
  • Multi-user

Revenue Projections

MonthUsersConversionMRRARR
Month 1803%$41$492
Month 61,2005%$1,020$12,240

Unit Economics

$6
CAC
$170
LTV
6%
Churn
94%
Margin
LTV:CAC Ratio: 28.3xExcellent!

Landing Page Copy

Know Exactly When Your Dorm Bulbs Will Die

Log once, predict forever – beat campus power chaos with smart forecasts.

Feature Highlights

Easy bulb logging
Accurate lifespan AI
Campus-wide insights
Proactive alerts
Tailored bulb picks

Social Proof (Placeholders)

"'Predicted my burnout perfectly!' – Jordan, Stanford"
"'No more dark study nights.' – Mia, Berkeley"

First Three Customers

Run Twitter poll in college threads; share MVP landing in dorm Discord servers; cold email student union leaders with free access.

Launch Channels

Product Huntr/Frugalr/collegeHacker NewsTikTok dorm hacks

SEO Keywords

dorm bulb lifespan calculatorled burnout predictor collegecampus power fluctuation bulb trackerprevent dorm light flickeringdorm led replacement scheduler

Competitive Analysis

Bulb Calculator Apps

bulb.com/tools
Free
Strength

Generic estimates

Weakness

Ignores dorm grids

Our Advantage

Data-driven from real dorm logs

🏰 Moat Strategy

Network effects from user-submitted data improving predictions for all.

⏰ Why Now?

LEDs ubiquitous in dorms, but power grids strained by EV charging surges.

Risks & Mitigation

markethigh severity

Users forget to log

Mitigation

Gamify with streaks

technicalmedium severity

Prediction accuracy low initially

Mitigation

Seed with public data

Validation Roadmap

pre-build5 days

Google Form to 100 students

Success: 40% pain confirmation

mvp21 days

Waitlist to 50 logs

Success: 20 active weekly

Pivot Options

  • General home bulb tracker
  • Dorm maintenance reporter
  • Affiliate bulb shop

Quick Stats

Build Time
140h
Target MRR (6 mo)
$1,000
Market Size
$35.0M
Features
8
Database Tables
4
API Endpoints
5