Below is a walk through on how the calculations of the projections work and where the numbers come from.

Where do the numbers come from:

1. Booked Figures - these figures come from the traffic file data set.
   1. Booked - the dollar value of the Outlet, Office, Salesperson, Agency, and Account combination from the traffic file for the specified time period.
   2. Budget - a calculated dollar value of the Outlet, Office, Salesperson, Agency and Account for the specified time period. This value is NOT on the traffic file, it is instead calculated.
   3. Share - a value of the share of the market for the Outlet, Office, Salesperson, Agency, and Account for the specified time period. This number is on the traffic file.
2. Pending Figures - these figures from from a pending integration. There is a file that is imported to show these numbers.
   1. Pending - the dollar value of the Outlet, Office, Salesperson, Agency, and Account combination from the pending file for the specified time period.
   2. Budget - a dollar value of the Outlet, Office, Salesperson, Agency and Account for the specified time period, from the pending file
   3. Share - a value of the share of the market for the Outlet, Office, Salesperson, Agency, and Account for the specified time period. This number is on the pending file.
3. Forecast - the total of the booked column and the pending column for the time frame. This is calculated by Matrix and is not on file.
4. Projection - Numbers that are manually entered by an end user for their projections.
   1. Projection - the dollar value for the quarter that an Account Executive feels that they are going to get
   2. Budget - the advertiser's projected budget for the quarter for the entire market
   3. Share - the percentage of the overall projected budget that is due to the customer

Calculations

Line Level Calculations

• Booked Figures
  1. Booked - summation of the dollar value from the traffic file for the time period for that specific Outlet, Office, Salesperson, Agency, and Account combination. This would be no different than the totals on a multi-year sales history report.
  2. Budget - calculated as follows (Total Booked Amount) / (Share / 100)
  3. Share - the share value from the traffic file for the specific time frame and for the Outlet, Office, Salesperson, Agency, and Account. the value is on the file.
• Pending Figures
  • These are all on the pending file.
• Forecast
  • Booked plus Pending dollars
• Projections
  • A user has to enter in 2 of the 3 items to have the data get calculated.
    • Enter in Projections and Budget, Monarch will calculate the Share:  (Projections/Budget) * 100 = Share
    • Enter in Share and Budget, Monarch will calculate the Projection: (Share / 100) * Budget = Projection
    • Enter in Projections and Share, Monarch will calculate the budget: Projection / (Share / 100) = Budget

Total Calculations

• Booked Figures

1. Booked - summation of the data in the booked column
2. Budget - summation of the data in the budget column
3. Share - calculation of (Total Booked/Total Budget)

• Pending Figures 

1. Pending - summation of the data in the pending column
2. Budget - summation of the data in the budget column
3. Share - calculation of (Total Pending/Total Budget)

• Forecast - summation of the forecast column
• Projection

1. Projection - summation of the projection column.
2. Budget - summation of the unique combination budget values per Market, Office, Salesperson, Agency, Outlet.

• If there are two stations in one market (called a duopoly), they will both have the same market budget. We only count one row in the totals to not inflate the budget

                3. Share - calculation of (Total Projections/Total Budget)

Note: If the value from traffic is negative, the value shown in the booked is zero and the share is zero.