Available Resources


The HUB of Analytics Education team created a large dataset with supporting information. The company created is called Bibtor, LLC., a retail wine and spirits company with 79 locations within the fictional state of Lincoln. The following information for Bibitor, LLC is available on the HUB of Analytics Education website:

 
DESCRIPTION OTHER DETAILS AVAILABLE NOW
Beginning Inventory Table (July 1, 2015, October 1, 2015, January 1, 2016, and April 1, 2016) Approximately 200,000 Records YES
Ending Inventory Table (June 30, 2016, September 30, 2016, December 31, 2016, and March 31, 2017) Approximately 200,000 Records YES
Purchases Table (12 months ended June 30, 2016, September 30, 2016, December 31, 2016, and March 31, 2017) Approximately 2.3 Million Records YES
Sales Table (12 months ended June 30, 2016, September 30, 2016, December 31, 2016, and March 31, 2017 Approximately 12.6 Million Records YES
Invoice Purchase Table (12 months ended June 30, 2016, September 30, 2016, December 31, 2016, and March 31, 2017) Approximately 5,300 Records YES
Purchase Price Table (Through June 30, 2016, September 30, 2016, December 31, 2016, March 31, 2017) Approximately 10,000 Records YES
Payroll Table (12 months ended June 30, 2016) Approximately 32,000 Records YES
Process Overview Flowcharts Uses two IT Systems, Micros POS and Netsuite.com YES
Purchases Manual Uses Netsuite.com YES
Sales Manual Uses a Micros POS linked to Netsuite.com YES
Payroll Manual Uses ADP linked to Netsuite.com YES
Purchases Flowchart YES
Sales Flowchart YES
Payroll Flowchart YES
Demographic Data for the State of Lincoln County Level Data, including population, age, household income, race, etc. YES
Dunn & Bradstreet Industry Statistics SIC Code 5182 Industry Ratios YES
Bibitor, LLC Data on Netsuite.com Faculty get their own Netsuite.com Account with all the Bibitor, LLC data NO – July 2017

References:

Bame-Aldred, C. W. and Lee, C. 2016. Bibitor, LLC June 2016 Dataset. http://hubae.org September 2016
Bame-Aldred, C. W. 2016. Bibitor, LLC September 2016 Dataset. http://hubae.org. November 2016
Bame-Aldred, C. W. 2017. Bibitor, LLC December 2016 Dataset. http://hubae.org. January 2017
Bame-Aldred, C. W. 2017. Bibitor, LLC March 2017 Dataset. http://hubae.org. May 2017
Bame-Aldred, C. W. 2017. Bibitor, LLC June 2017 Dataset. http://hubae.org. Forthcoming July 2017

* Flat files for the 12-months ended June 30, 2017. should be available 30 days after the end of the quarter.