LifeRemix.aiMake a little more possible.Join the good stuff ↗
Daily LifehackMy Agentic LifeThe Weekly Remix
remix with ai:Making & Managing Money

The Summer Side-Hustle Reality Check: Build a Private Profit Calculator

Earning extra cash for the holidays sounds great until you realise you are working for three dollars an hour. Here is how to use an AI assistant to architect a completely private profitability spreadsheet, without handing your financial data over to a chatbot.

The Summer Side-Hustle Reality Check: Build a Private Profit Calculator
AI-generated illustrative photograph.

The November Cash Crunch

It is late November, and the internet has become an aggressive battleground of digital sales. Your inbox is overflowing with "sitewide" discounts, while a pulsing countdown timer attempts to panic you into buying an air fryer you do not need. Regulators are officially exhausted by the theatre; the Australian Competition and Consumer Commission (ACCC) has launched another sweep this month targeting retailers who use misleading scarcity messaging and false reference prices to pressure shoppers.

Between the retail barrage and the impending summer holidays, the desire to generate some extra household income is entirely rational. Perhaps you are thinking of selling handmade festive wreaths, baking shortbread for the local summer market, or flipping vintage clothes. But there is a dangerous trap in seasonal side hustles: it is incredibly easy to accidentally work for three dollars an hour once you account for your materials and time.

The financial education team at Sorted notes that nearly four in 10 New Zealanders worry about money from pay to pay. They point out that if you have a varied income, it is critically important to budget so you can figure out your minimum expenses and put any surplus to work building a buffer. To get our "maths mathing," as Sorted puts it, we need a ruthless viability calculator.

However, we are not going to dump our financial hopes into a public chat window. The New Zealand Office of the Privacy Commissioner issues a strict warning: do not input personal or confidential information into a generative AI tool. The data can be retained and used for training. Instead, we are going to use the AI purely as a structural architect. It will write the spreadsheet formulas for us, and we will run the actual numbers in complete privacy on our own computers.

The Finish Line

A locally hosted, functional spreadsheet that calculates the true hourly wage and net profit of your seasonal side hustle, providing a brutal but necessary reality check before you buy $200 worth of craft supplies. Note: This is an administrative planning tool to test business viability; it is not personalised financial or tax advice.

  • Time Estimate: 20 minutes (5 minutes prompting, 10 minutes assembling, 5 minutes testing).
  • Cost Estimate: Free.
  • Prerequisites: A standard AI chat tool (like ChatGPT, Claude, or Google Gemini) and a local spreadsheet application (like Microsoft Excel, Apple Numbers, or Google Sheets).

Step 1: Commission the Architect

We need the AI to design a spreadsheet layout complete with the exact mathematical formulas required to calculate break-even points, labour costs, and profit margins. We will ask it to output the design as a simple table so we can recreate it instantly.

Open your AI assistant and copy and paste this exact prompt:

I am building a Side-Hustle Viability Calculator in a standard spreadsheet to see if a seasonal project is profitable. Please provide a layout for my columns and rows, and the exact formulas I need to use. I need to calculate:
1. Total Material Costs
2. Total Labour Cost (Hours spent multiplied by my Target Hourly Wage)
3. Total Production Cost (Materials + Labour)
4. Cost Per Unit (Total Production Cost divided by Units Produced)
5. Total Revenue (Sale Price Per Unit multiplied by Units Produced)
6. Net Profit/Surplus (Total Revenue minus Total Production Cost)

Do not fill it with personal data. Just give me a clear table showing exactly what text to type in Column A, and the exact formulas to type in Column B. Assume my data starts in Row 2.

Step 2: Assemble Your Local Vault

The AI will reply with a set of instructions. Now, leave the AI and open a brand-new, blank spreadsheet on your computer. This file lives on your machine, meaning your financial data stays out of the cloud's training models.

Following the AI's blueprint, set up your rows. You will generally type your labels in Column A and your numbers or formulas in Column B.

Here is what an illustrative output of the structural setup looks like:

  • Cell A2: Material Costs ($)
  • Cell A3: Hours Spent (hrs)
  • Cell A4: Target Hourly Wage ($)
  • Cell A5: Units Produced
  • Cell A6: Sale Price Per Unit ($)
  • Cell A7: Total Labour Cost (Formula: =B3*B4)
  • Cell A8: Total Production Cost (Formula: =B2+B7)
  • Cell A9: Break-Even Cost Per Unit (Formula: =B8/B5)
  • Cell A10: Total Revenue (Formula: =B6*B5)
  • Cell A11: Net Profit / Surplus (Formula: =B10-B8)

Type the labels into the left column, and carefully paste the formulas (including the equals sign =) into the right column.

Step 3: Run the Reality Check

Now for the fun part: testing your assumptions. Let us imagine a hypothetical scenario where you are making luxury pinecone and ribbon wreaths for the local weekend market.

Type your estimated numbers into the empty data cells (B2 to B6). As you hit enter, your formula cells will instantly calculate the bottom line.

Worked Example Input:

  • Materials (B2): 120
  • Hours Spent (B3): 8
  • Target Wage (B4): 25
  • Units Produced (B5): 10
  • Sale Price (B6): 45

The Reality Check Output:
Your Total Labour Cost calculates to $200 (8 hours at $25/hr). Added to your $120 materials, your Total Production Cost is $320. To simply break even and pay yourself a fair wage, the Cost Per Unit is $32.

If you sell all 10 wreaths at $45, your Total Revenue is $450. Your Net Profit (the true surplus above your wages and costs) is $130.

Congratulations, the maths is mathing. You are making a genuine profit.

Checks, Failures and Recovery

If you see an error like #NAME? or #DIV/0!, do not panic. This usually happens for one of two reasons:

The Divide-by-Zero Error: If your "Units Produced" cell is empty, the spreadsheet cannot calculate the cost per unit. Make sure you enter a number greater than zero in your production cell.
The Text Error: If you accidentally type "$120" instead of just "120", the spreadsheet might read it as text rather than a number, breaking the formula. Type raw numbers only, and use the spreadsheet's formatting menu to add currency symbols.

To check the system is working, double your "Hours Spent". You should see the "Net Profit" plummet immediately. If the profit does not move, you have missed an equals sign in your formula. Click the broken cell and ensure it starts with =.

Step 4: Flowing the Surplus

Once you have a working calculator, save the file to a secure, backed-up folder on your computer. You can copy and paste this block of cells for every new idea you have, from dog-walking to freelance graphic design, tweaking the labels as needed.

Crucially, this spreadsheet tells you what you actually earn. Once the market is over and the cash is in your hand, you can take Sorted's advice for managing varied income: dedicate your newly proven surplus to a specific job. Whether that is building an emergency buffer for unexpected expenses, or simply funding a stress-free summer holiday without dipping into the credit card, you are doing it with actual profit, not just busywork.


AI disclosure: AI systems assisted with research and writing. Gemini independently peer-reviewed and approved this article before publication. Images, where present, are illustrative AI-generated photographs.