The first implemented workflow in a broader program to streamline sponsorship sales & Operations.
Preparing a Life FM sponsorship campaign meant bringing package pricing, sponsor spot rules, dates, budgets, exclusions and production costs together before the customer could receive a clear schedule.
ExIQ turned that rules-heavy work into a guided Excel workflow. The Life FM Spot Calculator is the first delivered implementation in an ongoing sponsorship sales and operations streamlining program, with the relationship continuing through ExIQ's role as a station sponsor.
A sponsor schedule is a commercial promise, not a simple count of spots.
Each campaign had to coordinate placement windows, spot lengths, package pricing, monthly targets, campaign dates, allowed weekdays, production costs and GST. Public holidays, Christmas Day, fundraising periods and other blackout dates added another layer of checking.
A change to the budget, dates or placement mix could send the team back through manual calculations and schedule checks. The process needed to become faster and more consistent without removing the human judgement required to shape a useful sponsorship campaign.
Enter the campaign once. Generate a schedule the team can still shape.
ExIQ designed and built the macro-enabled Life FM Spot Calculator around the team's existing Excel workflow. Staff enter the core campaign details through a guided Quick Fill sheet, then refresh the workbook to rebuild the editable schedule.
Commercial logic lives in one configurable rate-card and package area rather than being repeated across the workbook. The output keeps formulas protected while leaving the schedule open for the human adjustments that real sponsorship campaigns require.
- 1 / Capture Campaign details
Customer, package, dates, budget, spot lengths, placements and allowed days.
- 2 / Apply Commercial and schedule rules
Rates, multipliers, holidays, blackout dates, bonus spots, costs and GST.
- 3 / Review Customer-ready schedule
Editable year view, campaign totals, placement summary and print-ready output.
- Configurable rate cards and sponsorship package templates.
- One-click schedule generation and refresh.
- Recurring sponsor spot patterns and weekday rules.
- South Australian public holiday highlighting.
- Christmas Day protection and placement-specific blackouts.
- Bonus, filler, GST and production-cost calculations.
- Contract, campaign and placement summaries.
- Editable schedules with protected formulas.
Life FM offers sponsorship packages and sponsor spots. This case study uses that language throughout rather than describing the spots as radio ads.
Up to four hours returned for every customer onboarded.
The calculator creates a repeatable path from campaign requirements to a reviewed, customer-ready schedule. Pricing and scheduling rules stay together, manual recalculation falls away, and the team gains a clearer view of sponsor spot allocation and campaign value.
The weekly estimate varies with customer onboarding volume and campaign complexity; it is presented as Life FM's estimate, not an independently measured result.
One bottleneck solved. The next sales workflows can now connect around it.
ExIQ's work with Life FM is continuing. The calculator gives the broader sponsorship sales and operations streamlining program a practical first foundation, with the next workflow opportunities spanning the records and handoffs around sponsorship campaigns.
Practical transformation begins with one repeatable workflow.
ExIQ can identify the highest-friction step in your sales process and turn it into a focused first implementation your team can use.