/
Sales and Profitability

Sales and Profitability

Owned by Kaitlyn Niemann (Unlicensed), created
Last updated: Apr 26, 2024 by Albert Saludaga
1 min read

Requirements and Purpose

Report displays pricer performance by event, venue, and section information

Report Definition

  1. Stakeholders

    1. @Kaitlyn Niemann (Unlicensed)

    2. @Mark Shaver

  2. Author

    1. @Kaitlyn Niemann (Unlicensed)

  3. Subject matter expert(s)

    1. Alex Goldberg

  4. Presentation Medium

    1. SSRS

  5. Fields (data)

    1. Pricer

    2. eName

    3. VenueName

    4. edate

    5. SeatSection

    6. TotalSale

    7. GrossMargin

    8. gmp

    9. gsold

    10. spi

    11. cpi

    12. gmpi

Data source(s)

The data gathered in this report is from the Eibo-215 Database and the STG Database. Using the stored procedure sr_GetSalesAndProfitability.

  1. eiboxoffice.dbo

    1. TicketGroup

    2. Event

    3. Venue

    4. Region

  2. STG.users

    1. PricerEvents

    2. Users

Calculations

Column Name

Data Type

Calculation

Description

Column Name

Data Type

Calculation

Description

gmp

decimal

=CASE WHEN SUM(ISNULL(cte.gsale,0)) = 0 THEN -1 ELSE ROUND(((SUM(ISNULL(cte.gsale,0))+0.0001-SUM(ISNULL(cte.gcost,0))+0.0001))/(SUM(ISNULL(cte.gsale,0))+0.0001),2) END gmp,

Calculates gross margin percentage

spi

decimal

=CASE WHEN SUM(ISNULL(cte.gsale,0)) = 0 THEN -1 ELSE ROUND((SUM(ISNULL(cte.gsale,0))+0.0001)/(SUM(ISNULL(cte.invct,0))+0.0001),2) END spi,

Calculates average sale per invoice

cpi

decimal

=ROUND((SUM(ISNULL(cte.gcost,0))+0.0001)/(SUM(ISNULL(cte.invct,0))+0.0001),2) cpi,

calculates average cost per invoice

gmpi

decimal

=CASE WHEN SUM(ISNULL(cte.gsale,0)) = 0 THEN -1 ELSE ROUND((((SUM(ISNULL(cte.gsale,0))+0.0001)/(SUM(ISNULL(cte.invct,0))+0.0001))-(SUM(ISNULL(cte.gcost,0))/(SUM(ISNULL(cte.invct,0))+0.0001)))/((SUM(ISNULL(cte.gsale,0))/SUM(ISNULL(cte.invct,0)))+0.0001),2) END gmpi

calculates average margin per invoice

Parameters

  1. Filters

    1. @pricer

      1. text

      2. multiple values

      3. populated from other query

      4. defaults to all values

    2. @event

      1. text

      2. can be blank

    3. @venue

      1. text

      2. can be blank

  2. Grouping

    1. Pricer 

    2. EventName

    3. VenueName

    4. EventDate

  3. Intentions for printing vs. online viewing

    1. The report is delivered via SSRS

    2. This report can be accessed here: SSRS → Asset → Sales and Profitability

  4. Intended delivery mechanism (run on demand vs. delivered by subscription)

    1. On Demand

  5. Future maintenance tasks or manually maintained items

    1. None

Results

  1. Data Accuracy

    1. QA

      1. Validate using the Income by Event report

  2. Limitations

    1. Report shortfalls

Change Log

  1. https://ticketboat.atlassian.net/browse/SP-257

Images



Related content