BIAnalytix Tip Summary: Calculating projected program profitability

By projecting Program Rights expense amortization over the future programming schedule, the projected revenue can be compared to the projected costs to provide powerful feedback on future margins on the planned schedule. To achieve this, the future scheduled programs can be assigned their expected amortized expense and then the remaining unamortized balance on the active contracts should be distributed over the remaining duration of those contracts. This distributed programming cost can then be analyzed together with the projected adverting revenue to analyze potential profitability in the future schedule.

This Media BI analysis understandably requires that both the Traffic spot revenue and program rights amortization are loaded into the Media data warehouse. Shared dimensions between the different fact transactions should include the Programs, the Dayparts, the Program Categories, the Channels, and the Date and Time Dimensions. Calculated Measures can be defined to form the profitability analysis across the shared dimensions..

BIAnalytix
is an advanced Data Warehouse and Business intelligence system that provides modules for both advertising revenue qnd program amortization. Calculated measures provide program profitability by comparing the projected program revenue with the projected amortized program costs.

© Copyright 2011, Decentrix Inc. All rights reserved.
Decentrix Inc. 1200 17th Street, Suite 200, Denver, Colorado, 80202 Phone: 303-899-4000  
 
Decentrix Website Solution & Collaborative Intranet Tools   |   DishOnTheWeb.com by Decentrix, Dish Network Retailer Solutions
Afftraq Affiliate Sales Tracking Solution   |  HotDesk, Superior Website & Intranets for Small to Medium Size Business

Home Products Website Solution Collaboration NetAnalytix e-Commerce Technology Overview Architecture Quickcentrix Quickcentrix Integration Kit Consulting Web Analytics Consulting e-Commerce Consulting Business Intelligence Analytics Decentrix Process Online Marketing Site Visitors Search Engines Register With Yahoo Register With Google Search Engine Ranking Becoming Visible Online Collecting Prospect Lists Checklist Target Market Tours Website Solution Tour Collaboration Tour NetAnalytix Tour BIAnalytix Tour Clients News Press Releases e-Newsletters Contact Support Sales Company Vision Management Team Careers