Embedded Files
"Update site to reflect: $10K/3yr TA cap, 300 qualified orgs, opt-in list pending from 4Culture, no direct outreach, sustained support only."
Applied Business Intelligence for a County-Wide BTA Training System
Applied Business Intelligence for a County-Wide BTA Training System
This page is a live strategic case study that shows how Black Fox Studios is building a county-wide Business Technical Assistance Training System almost entirely with Google Workspace and a small assist from ChatGPT. Every chart, funnel, timeline, and document you see here was created in Google Sheets, Docs, Slides, Sites, Apps Script, Gemini, or other Google Cloud services. The aim is to demonstrate that one practitioner with deep knowledge of these readily available tools can perform at the level of a full operations team while keeping costs low and technology barriers minimal for small nonprofits.
Sharing the mechanics makes the value clear. I already can bill at one hundred eighty-five dollars per hour on the 4Culture Network of Support roster. Here you can see exactly how that rate turns public grant dollars into trained staff, automated workflows, and audit-ready documentation. Because the entire stack runs on Google, every grantee already has access. With just ten percent of a ten-thousand-dollar technical assistance budget, a cohort of nonprofits can leave with Google-powered standard operating procedures, AI-ready data, and staff trained in the same entry-level skills taught in the Google Career Certificates program. If you want to watch strategic intent become tactical execution, keep reading. This page is the build log.
The Project Schedule
The Project Schedule
This embedded Google Calendar is the live schedule that guides the buildout of our BTA system. Displayed in Agenda view, it shows every confirmed engagement from planning sessions with 4Culture to monthly Network of Support check-ins. In the coming weeks we will add the operational tasks that power the work itself, including outreach touchpoints with KCLS and SPL, sprint deadlines for curriculum design, and key dates for rolling out Google based automations. Because the calendar is connected directly to our workspace, any change we make in Google Calendar appears here instantly, giving partners and team members a clear and current view of the entire production timeline.
Gantt Chart - Sales Cycle for Library Systems
Gantt Chart - Sales Cycle for Library Systems
This Gantt chart outlines the phased rollout strategy for engaging five major library systems as part of our 2025 Strategic Plan. Each row represents a different library system—King County Library System (KCLS), Seattle Public Library (SPL), Pierce County Library, Tacoma Public Library, and Puyallup Public Library—and is broken into three stages: Marketing & Sales (yellow), Procurement (green), and Delivery (blue). The timeline demonstrates how we stagger engagement to ensure smooth onboarding, performance testing, and scaling across systems.
KCLS serves as our entry point in July 2024, allowing us to test and refine our approach before expanding to SPL in August, and subsequently Pierce, Tacoma, and Puyallup in the following months. This structured sequence not only manages our operational bandwidth but also ensures insights from early partnerships improve success in later phases. Each engagement is spaced approximately 90 days apart to align with the procurement cycles and planning windows of public library systems.
Value Stream Mapping
Value Stream Mapping
The Value Stream Map below outlines BlackFox Studios’ 2025 strategic approach to converting public grant momentum into sustainable revenue through targeted outreach and community-based delivery. Starting with 1,500 4Culture-funded nonprofits, we narrow our focus to 300 qualified leads and invite them to free workshops hosted across public libraries. These workshops, delivered in 5-part monthly series, filter down to 75 participants—63 of whom convert into partial service clients ($1,000 each), and 12 into full-service contracts ($10,000 each). By leveraging libraries as trusted engagement hubs and structuring a clear conversion pipeline, this model turns public funding channels into a $213,000 revenue opportunity—while building long-term value for both community organizations and our business.
4 Culture Grantee Funnel Pipeline
4 Culture Grantee Funnel Pipeline
This funnel diagram illustrates BlackFox Studios’ strategic outreach and conversion pipeline, beginning with 1,500 nonprofit organizations identified through 4Culture. From this group, 300 are directly engaged through targeted outreach efforts. Of those, 75 organizations respond and attend informational workshops held at local libraries. From this warm pool, 25 enter deeper sales conversations, and ultimately, 12 convert into high-engagement clients at $10,000 each. This progressive engagement strategy ensures that only the most aligned organizations move through the pipeline, balancing volume outreach with high-value conversions.
Dual Funnel Pipeline
Dual Funnel Pipeline
This visual breaks down BlackFox Studios’ dual revenue strategy by illustrating how library-based workshops serve as both a direct revenue stream and a lead funnel into deeper 4Culture-funded engagements. By delivering 12 library workshop series at $2,500 each, BFS generates $30,00 in initial revenue while exposing participants to its broader 4Culture services. This exposure converts 63 organizations into partial users at $1,000 each and 12 into full-service clients at $10,000 each—resulting in an additional $183,000 in revenue, and a total revenue of $213,000 The combined outcome is a high-leverage ecosystem where free-to-access library workshops catalyze deeper partnerships and sustained funding.
Revuene Forecast
Revuene Forecast
This bar chart illustrates the 2025 revenue forecast for BlackFox Studios using four strategic scenarios: Minimum, Medium, Maximum, and Ultra. Each bar represents a revenue model combining income from library workshops and 4Culture contracts. The Minimum scenario ($102K) reflects conservative outcomes based on 6-month intervals; the Medium ($117K) assumes consistent monthly library activity but staggered 4Culture engagements. The Maximum model ($204K) anticipates full monthly conversions at standard nonprofit rates, while the Ultra projection ($252K) uses premium hourly consulting rates at full capacity. A dashed line indicates the median forecast ($168,750), showing where real expectations may land within this green-shaded spectrum.
Updated – July 19th (Conversation with Cassie Chinn, 4Culture)
Updated – July 19th (Conversation with Cassie Chinn, 4Culture)
Update – July 19th (Conversation with Cassie Chinn, 4Culture)
Update – July 19th (Conversation with Cassie Chinn, 4Culture)
After speaking with Cassie Chinn on July 19th, it’s clear that 4Culture will handle the vetting process for Sustained Support organizations. Cassie estimates that this process will take approximately 4 months to complete, with a final group of around 150 Sustained Support organizations opting in to the Network of Support.
In contrast, the Launch Grant is a new funding program, and all Launch Grant recipients will automatically qualify for consultant support through the Network of Support. This means that BlackFox Studios (BFS) can directly engage Launch Grant grantees as soon as awards are announced, without waiting for the opt-in process that applies to Sustained Support organizations.
Sustianed Support Awardees
Sustianed Support Awardees
Sales and Marketing Funnel - Qualifiing leads
Sales and Marketing Funnel - Qualifiing leads
Qualified Lead Funnel: 1,500 Awardees to 300 Prospects
Qualified Lead Funnel: 1,500 Awardees to 300 Prospects
When I joined the 4Culture Network of Support I learned that the $185 hourly rate only applies if a grantee’s annual revenue is under $300,000. The public awardee list does not show revenue, so I built an AI-driven qualifier with Google Sheets, Apps Script, Gemini, and a few Google Cloud calls. The script pulls each awardee name, checks IRS filings and other public sources, tags any organization that meets the revenue limit, and records the source for every decision. What started as more than 1,500 unverified entries is now a focused pipeline of qualified leads I can serve at the approved rate. This page walks through that process: the original 4Culture site for the raw list, the live Google Sheet that runs the checks, and the Gemini brief that explains why the final list aligns with Black Fox Studios’ Business Technical Assistance strategy. It is both proof of method for funders and a template any public agency or consultant can replicate using everyday Google tools.
4 Culture Site Awardees
4 Culture Site Awardees
This panel shows the public awardee directory that lists every organization funded by 4 Culture during the past six years. It is the raw data source that feeds the lead-qualification pipeline.
Launch Grant Strategic Plan
Launch Grant Strategic Plan
Launch Grant - Outreach
Launch Grant - Outreach
Andrew Powers and BlackFox Studios (BFS) are targeting up to 12 nonprofits to pursue the 4Culture Launch Grant (up to $180K over 3 years) by offering free, upfront grant application coaching to ensure strong submissions. Once awarded, BFS leverages the $10K Technical Assistance (TA) budget attached to the grant to provide a core package: 10 hours of Google & AI for Nonprofits training (focused on digital systems, automation, and AI-powered admin support) and 17 hours of GrantGPT consulting (aligning the grant narrative with a sustainable 3-year plan). This strategy creates a win-win-win: nonprofits get expert grant prep and capacity-building at no cost, BFS secures committed participants for its workshops (a key requirement for KCLS and SPL partnerships), and 4Culture’s TA funds are applied toward high-impact services that directly strengthen grantees’ operations.
Page updated
Report abuse