Unit Economics – Figuring out total costs associated with per unit costs. If it’s a cup of lemonade stand, then your unit economics would be for a cup of lemonade. Unit economics lets you figure out what you need to charge on a per unit basis.
Unit Economics of a cup of Lemonade
Waste – You need to factor in waste costs associated with your unit cost. Lemons rot. Water get dirty.
Separate labor costs from unit economics. Labor fluctuates and can include many elements in itself.
Calculating labor costs (estimate):
Estimate the time it takes to make lemonade (prep time)
Calculate the time it takes to sell.
Choosing the best location:
Store selectionFinancial Model with Unit Economics and store location selection Adding a premium upgrade to your Lemonade (strawberry lemonade)
Name your variables so that you can easily reference it later on when you haven’t used your model in a while.
Expansion to Multiple locations (*Sheet 1)Individual spreadsheet for each location based on Location data from Sheet 1Aggregated Store Data with grouped line itemsTotal line items from all stores with collapsed accordian.
Section 3: Before You Build Your Model
Section 4: Modeling Best Practices
Section 5: Case Study: YouWorks Co-Working Space (Part 1)
Section 6: Modeling Growth
Section 7: Modeling Revenue
Section 8: Modeling Startup Costs & Expenses
Section 9: Case Study 1: Standard Assembly Programming Bootcamp
Section 10: Case Study 2: YouWorks Co-Working Space (Part 2)
Section 11: Case Study 3: Fancy Bread, Moble App for Renting Offices
Section 12: Case Study 4: ScholarPRO & It’s Inevitable Doom
Section 13: Case Study 5: Tee Lounge, A Brick and Mortar Business
Section 14: Case Study 6: SaasForce Saas Startup
Section 15: Case Study 7: “Smoked Chili” Fast Casual Mexican Restaurant
