Docstoc

Financial Template for Station PSD Implementaiton

Document Sample
Financial Template for Station PSD Implementaiton Powered By Docstoc
					                                        1/31/07 DRAFT Financial Template for Station PSD Implementaiton
                                                       Initial Year Expenses and Revenue
                                              Showing Baseline, Intermedate, and Advanced Options

NOTE: Assumptions stated below. Figures indicated are for illustrative puposes only.
This worksheet is designed as a template for stations to use to plug in their own revenue and expense estimates.


                                                        Minimum/                     Average
Start-up Expense                                        Maximum Staff                $/HR      Baseline
(Staff initial investment - one-time)                   Hours    Involved            Rate      (MPS only)

 Initial implementation of SIS and static PSD w/ EAS
 - changing no more than a few times per day              40-80    1 Engineer            60    $      2,400
                                                                   1 jr. Engineer
 ...plus static pgm sched in TSU                          10-20    or 1 Ops staff       50     $        500
                                                                   1 promo wrtr
                                                                   1 Promo Dir.
                                                                   1 PD
 ...plus basic/static interstitials                       20-40    1 Ops staff          95     $      1,900
                                                                   1 Web dev
 …plus dynamic pgm sched from PI Composer                 12-24    1 Ops staff          60
                                                                   1 Web dev
 …plus integration of live XML from nationals                      1 Ops staff
 producers via internet (i.e. PRX, PI C24, etc...)        10-30    1 Engineer           60
                                                                   1 Engineer
 …plus PSD from PRSS feeds                                10-15    1 Ops staff          55
 …plus song/segment-level PSD for CDs loaded                       1 jr. Ops staff
 into automation and scrubbed                               80     1 Music Librn.       65
                                                                   1 Promo Wrtr
                                                                   1 Promo Dir.
 …plus dynamically-generated interstitials (i.e.                   1 PD/1 DD
 fundraising, promos, PSAs, etc…), including station               1 Ops staff
 policy on PSD content, style, inventory                    80     1 Engineer           95
                                                                   1 PD
 …plus real-time dynamic services (i.e. weather,                   1 Ops staff
 stocks)                                                    40     1 Engineer           90
                                                                   1 PD
                                                                   1 Ops staff
  …plus additional PSD for custom apps TBD                  40     1 Engineer           90
Initial Investment Totals (estimate) *                                                         $      4,800

* Stations may choose to capitalize costs of initial investment required to implement PSD



                                                        Weekly    Staff              Hourly    Baseline
Weekly Expenses (ongoing costs)                         Hours     Involved           Rate      (MPS only)
                                                                     1 promo wrtr
 Data stream up-keep, staff workflow time                  3-5       1 Ops staff      50       $        150
                                                                     1 engineer
 Contingency/data integrity, engineering/IT time            2        1 IT staff       60       $        120
 Licensing fees for data feeds (stocks, weather)         0.1      legal            50        $          5
 Underwriting/Promotions staff                           .25      DD/PD            80        $         20
 Insurance                                                1       Admin            15        $         15
Subtotal                                                                                     $        310

Annualized Ongoing Costs (weekly x 52)                                                       $     16,120




Weekly Earned Revenue                                                                        Baseline
(conservative estimates)                                                                     (MPS only)
  UW upsell (9 months of first year)                                                          $       200
Subtotal                                                                                      $       200

Annualized Ongoing Revenue (potential)                                                       $     10,400


Assumptions (costs NOT included above)
 1. Station is already transmitting in HD Radio.
 2. Station has functioning in-house broadcast automation system with PSD-compliant TSU component.
 3. Station has functioning PSD Importer/Exporter.
 4. More advanced layers of PSD (i.e. dynamic PSD) will require increased inter-departmental coordination/cooperation/expen
 5. The nacent state of current PSD and TSU tools will necessitate higher implementation costs for early-adopters.
 6. Once established, daily production of most PSD layers will be automated.
 7. For PSD on HD2 and HD3, mulitply above cost estimates by 1.5 and 1.25 respectively to account for additional engineering
mentaiton

ions


ense estimates.



            Intermediate   Advanced
            (MPS only)     (MPS and SAC)


             $     3,600   $        4,800

             $       750   $        1,000



             $     2,850   $        3,800

             $       720   $        1,440


             $       600   $        1,800

             $       550   $          825

                           $        5,200




                           $        7,600


                           $        3,600


                           $        3,600
             $     9,070   $       33,665




            Intermediate   Advanced
            (MPS only)     (MPS and SAC)

             $       200   $          250

             $       120   $          120
              $          5    $              5
              $         20    $             20
              $         15    $             15
              $        360    $            410

              $     18,720    $        21,320




             Intermediate Advanced
             (MPS only)    (MPS and SAC)
              $        300 $          400
              $        300 $          400

              $     15,600    $        20,800




oordination/cooperation/expense.
for early-adopters.

ount for additional engineering and operations costs.
PSD Type                                                    Comments/issues
     Example

SIS and static PSD - changing no more than a few times
per day
   WBEZ 91.5                                                SIS - Station Information Service
   NPR News and Information from                            PSD line 1 - (title) Program Name
   Chicago Public Radio                                     PSD line 2 - (artist) Program Description


EAS
   WBEZ 91.5
   Amber Alert: Missing Child
                                                            Connectivity to Importer
   OHIO VEHICLE LICENSE: YYY931
                                                            Pre-emption of TSU-based PSD

Static pgm sched hard-coded in TSU
   WBEZ 91.5
   This American Life
                                                            Time/labor costs, initial setup
   Just like Car Talk, only with just one guy and no cars
                                                            Time/labor costs, ongoing

Basic/static interstitials, hard-coded in TSU
                                                            Time/labor costs, initial setup
   WBEZ 91.5
                                                            Time/labor costs, ongoing
   Coming Up Next on Chicago Public Radio...
                                                            Involvement of Dev and promo staff for
   Michael Feldman's Whadd'ya Know? from PRI
                                                            promos, fundraising, UW, branding, etc..

Dynamic pgm sched from PI Composer, changing every
90 minutes, minimum
   WBEZ 91.5
   Hello Beautiful!
                                                            Internet connectivity
   The Sunday Morning Arts Show with Edward Lifson
                                                            Synchronization with TSU-based PSD

Dynamic pgm sched from PI's C24 data feed, piece-level
refresh
   WBEZ 91.5
   JS Bach, Goldberg Variations, BWV. 988
                                                            Internet connectivity
   Glen Gould, pianio
                                                            Synchronization with TSU-based PSD

From live XML delivery for national pgms via internet
(i.e. PRX)
   WBEZ 91.5
   Black Comedy
   The Comedy-o-Rama Lewis Black Special from PRX
                                                            Internet connectivity to automation sys.
From PRSS file-delivered programs
   WBEZ 91.5
   This American Life
                                                            Segment-level vs. piece-level
   Just like Car Talk, only with just one guy and no cars
                                                            PSD embedded in cart-chunk

Song-level from CDs from manual input
   WBEZ 91.5
   John Coltrane
   A Love Supreme
                                                            Time/labor costs

Song-level from CDs from automation system
   WBEZ 91.5
   John Coltrane
                                                            Time/labor to ingest CDs and scrub ID3
   A Love Supreme
                                                            tags


Song-level from CDs via CD serial interface and/or CDDB
   WBEZ 91.5
                                                            Few compliant CD players
   JS Bach, Goldberg Variations, BWV. 988
                                                            Synchronization with TSU-based PSD
   Glen Gould, piano
                                                            Accuracy of tags on CD

Segment-level from local XML file (canned
news/talk/magazine)
                                                            Producer-facing tools to create,
   WBEZ 91.5
                                                            manipulate, transfer, store XML
   Eight-Forty-Eight with Steve Edwards
                                                            LAN connectivity and TSU integration
   Three Arts Club……next up, Regina Taylor and more….
                                                            Synchronization of segment/piece PSD

Segment-level from local XML file (live
news/talk/magazine)
                                                            Producer-facing tools to create,
   WBEZ 91.5
                                                            manipulate, transfer, store XML
   Eight-Forty-Eight with Steve Edwards
                                                            LAN connectivity and TSU integration
   Three Arts Club……next up, Regina Taylor and more….
                                                            Synchronization of segment/piece PSD


Dynamically-generated interstitials (i.e. fundraising,
promos, PSAs, etc…)
                                                            Involvement of Dev and promo staff for
   WBEZ 91.5
                                                            promos, fundraising, UW, branding, etc
   Grant Park Music Festival
                                                            Station tools to automate creation,
   Now thru August 12th…grantparkmusicfestival.com
                                                            manipulation, transfer, storage of XML

Real-time dynamic services (i.e. weather, stocks)
   WBEZ 91.5
                                                   Synchronization with TSU-based PSD
   TRAFFIC JAM
                                                   Cost of data feed services
   I-90/I-94 to/from Skyway to Stevenson
                                                   Control of output style

Additional PSD for custom apps, TBD
   WBEZ 91.5
   Wine Spectator Subscription to benefit
   Chicago Public Radio - press "Buy Now" button
                                                   Hardware-dependent