A Happy "Forecast Model" Family
GAINSU
Guess Who (Employee)
Guess Who (Customer)
Database Tables
100

When compared to the other model families, this family is in a particular "regression" of fame.

Family 4: Linear Regression

100

These are the two key outputs to Inventory Optimization

ORQ and Service Stock

100

Touting his drumsticks in hand, this person also plays on the drumline for the Chicago Bears.

Isaac Frank

100

This customer is headquartered in Pennsylvania, and provides the world with needed steep and piping supplies. 

TW Metals

100
This number represents an Item and Location

SKUL Number

200

This family would walk a "straight line" and "move with the average" folk around town. 

Family 1: Straight Line / Moving Average

200

Which action code numbers indicate an overstock situation

4, 5, 6

200

Recently winning a Women in Supply Chain award, this person is a Senior Engineering Manager at GAINS.

Laurel Christ

200

"Chopping" the air and its competition, this customer creates helicopters for government entities. 

Bell Helicopter

200

Key for CSLO, this table houses population target and minimum service levels.

abcparam
300

A family of models with a "sporadic" history of troublemaking, this family is one of three who were developed by GAINS to forecast the parts often causing a majority of planning issues.

Family 8: Sporadic or High-Volume/Infrequent (Poisson, Negative Binomial, Event-Based)

300

This demand in GAINS comes from parent/child relationships

Dependent Demand

300
Paving the way to optimize global supply chains, this person was a professor of engineering at Purdue University and started a consulting practice in the 1960's.

William Benton

300

"Crunching" their way to snackers' hearts, this customer is located outside of Chicago and provides health-in-mind snack foods offering a line of rice crackers found at Costco.

TH Foods

300

This table is to analyze key AGGREGATE points  data points of today and in the past

Dataverstats

or perf_archive_daily

400

This family of models, unfortunately, has had a "low-volume" of magazine "hits" in the last 36 months. 

Family 9: Low-Volume (Poisson, Negative Binomial)

OR

Family 7: Low-Volume (Heuristics)

400

In terms of inventory optimization, this parameter has an inverse relationship to service stock.

DAILY DOUBLE!!!!

Optimal Replenishment Quantity

400

A frequently flyer at local country clubs, this person went to Northwestern and Chicago Booth.

Jeff Gosz

400

As a leading distributor of electrical supplies, this company boasts a high ROI utilizing one of GIANS' recent product launches.

Border States

400

Table to see process duration and used to identify what process to kill.

pg_stat_activity

500

Still in their "20's", this family of models likes to keep up with "simple trends". When it comes to fashion, their branded with latest "seasonal" gear. 

Family 2: Zero or Simple Trend / Seasonal

500

Name three factors are used to calculate a SKUL's service stock

LT and Forecast Variance; Service Level; GAINS ORQ

500

Cat-owner, with exceptional analytical skills.

Brook Zhang

500

Formerly known as "Bic", this customer keeps our drinks cold and is one of the largest suppliers in the promotional product industry. 

Koozie

500
This table can be used to setup the UI en masse

componentuserconfig