/
Inventory Turn Report

Inventory Turn Report

Owned by Philip Prieto Laurente
Last updated: Jan 24, 2024
3 min read

Report Definition

This report would help us look into how quickly we turn over purchased inventory.

 

  1. Stakeholders

    1. Mark Shaver

  2. Author

    1. Nicholas Pusateri

  3. Subject matter expert(s)

    1. Nicholas Pusateri

    2. Jhon Cabalejo

  4. Data source(s)

    1. dbo.

    2. dbo.

    3. dbo.

  5. Presentation Medium

    1. SSRS

  6. Fields (data)

A. Top Level view

  • Category

  • Quantity

  • Quantity % of Total

  • Total Cost

  • % of Total

  • Total Sale

  • % of Total

  • Profit

  • % of Total

  • Margins

  • Average Turns Per Year

  • Annualized RoR

B. Mid Level view

  • Event

  • Total Sales

  • Total Costs

  • Profit

  • Quantity

  • Average Purchase Date

  • Average Days To Turn Over

  • Average Sale Date

  • Median Sale Date

  • Sales Per Day

  • Average Turns Per Year

  • Annualized RoR

C. Expanded view

  • Venue

  • Event Date/Time

  • Total Sale

  • Total Cost

  • Total Profit

  • Quantity

  • Average Purchase Date

  • Turnover Date

  • Days to Turnover

  • Average Sale Date

  • Median Sale Date

  • Sales per Day

  • Days to Event

  • Projected Turns Remaining

  • Turns Per Year

  • Annualized RoR

Calculations

Column Name
Data Type
Calculation
Description
Column Name
Data Type
Calculation
Description
Quantity % of Total
Numeric
= Quantity of filtered in event on line / Quantity of all filtered in events.
Sample calculation:
(Quantity / Sum of Quantity from all Category) x 100
Quantity of filtered in event on line / Quantity of all filtered in events.
Average Turns Per Year = the average of all the events Turns per year underneath OR 365/Average Days to Turn Over
Numeric
= 365/Average Days to Turn Over
The average of all the events Turns per year underneath
Annualized RoR
Numeric
= ((Total Costs + Profit) / Total Costs) ^ (1 / Average Days to Turn Over / 365)) - 1
The average RoR of all the events underneath
Average Days to Turn Over
Numeric

 

Average days to turnover looks at the time between the purchase day and the sell date.
If 8 tickets are purchased on 1/1, and we have 8 tickets sold on 1/20, it would be 19 days.
This is a running total. So, we might buy 8 on 1/1, and another 8 on 2/1. If we sold another 8 on 3/18, the average would 29.5.
So, the formula would look at the quantity of tickets on each PO, in order of date/time PO'd. When that quantity of tickets is sold, count up the days it took to sell that number of tickets and move onto the next PO. Where it again counts the days. Take the average of all counted days.
Average Sale Date
Numeric

 

Take days from PO date to day of sale to get number of days until sold. Add up all days Until sold, divide by total number of sales.
So if we had 3 invoices:
10 days until sold
20 Days until sold
45 days until sold
(10+20+45)=75
75/3=25 Average days until sale
Median Sale Date
Numeric

 

Median Sale date looks at the most common sale date and displays that date
Sales Per Day
Numeric

 

Quantity/Average Days to Turn Over
Average Purchase Date
Numeric

 

So average purchase date is just going to be the average date of purchase. If 2 tickets are bought on 3/10 and 2 on 3/20, then the average day is 3/15
Days to Turn Over
Numeric

 

Turnover Date - Average Purchase Date
Sales Per Day
Numeric

 

Quantity / Days to Turn Over
Days to Event
Numeric

 

Event Date/Time-TODAY()
Projected Turns Remaining
Numeric

=(Days to Event x Sales Per Day) / Quantity

(Days to Event*Sales Per Day)/Quantity
Turns Per Year
Numeric
=365/Days to Turn Over

 

Profit

 

= Sales - Cost

 

Margins

 

= Profit / (Total cost x 100)

 

Parameters

 

  1. Filters

    1. @Event VARCHAR

      1. Leaving blank returns all values.

      2. Must match eibo event.

    2. @venue VARCHAR

      1. Leaving blank returns all values

      2. Must Match eibo event

    3. @Event Date From

      1. No Default is set

    4. @Event Date To

      1. No Default is set

  2. Intentions for printing vs. online viewing

    1. The report is delivered via SSRS

    2. This report can be accessed here: SSRS→ Asset→ Inventory Turn Report.

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

    1. Run on Demand

  4. Future maintenance tasks or manually maintained items

    1. None

Results

 

  1. Data Accuracy

    1. QA

      1. v=

  2. Limitations

    1.  

Change Log

https://ticketboat.atlassian.net/browse/TIC-1105

 

Related content