Crowdfunding Campaign Planning: Reward Tiers, Funding Goals, Fulfilment & Shipping Costs

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Add up what the first production run of a fictional product really costs, gross it up for platform and payment fees and set a funding goal that pays for it.
• Spread the expected backers over seven reward tiers, calculate the money each tier brings in, the weighted average pledge and whether the plan reaches the goal.
• Calculate what it costs to deliver each reward: product cost, packaging from a lookup table and the shipping rate for the box size and destination zone with a two-way INDEX/MATCH.
• Calculate the fees, the margin and the margin % of every reward tier and flag the tiers that lose money with conditional formatting.
• Build the cumulative funding curve of a 30-day campaign, measure how much came in the first 48 hours, find the day the goal was reached and chart the daily pledges.
• Decide which stretch goals the campaign unlocked, cost each one with one-off, per-backer and per-unit parts and check how much of the money above the goal is left.
• Turn page visits per channel into backers, calculate the overall conversion rate and judge the paid channels by their cost per backer (CAC) and return on ad spend (ROAS).
• Build a six-month cash-flow plan after the campaign: one payout, a growing pre-order pipeline, tooling, production and fulfilment payments, and find the month when cash is tightest.