Warehouse Champions
Inventory Parts
Process Mastery
Intriguing Formulas
Management Metrics
100

Having worked at Solgen Power for nearly 1 year, this warehouse champion has consistently held a near zero variance in her satellite warehouse.

Who is Amber Carr?

100

This part has been a staple in the Solgen inventory for years, and was secured via many large contracts with New East Solar.  This part also required upgrading inverters from 1000s to 1200s when it first arrived.

What is ZnShine 360?

100

This type of action is used to track efforts put into every job the supply chain touches.

What is a work order?

100

This formula is used to total all numbers in a given range.

What is sum?

100
This metric, at a high level allows managers to understand how more days they can install solar modules without any further receipt of inventory.

What is days of solar panels on hand?

200

Typically known as always willing to get work done, this champion operates independently with little direction yet runs a very organized warehouse in a smaller market.

Who is Robert Carrizosa?

200

Commonly referred to as a junction box, this part is used as a point of junction for all wires to enter the customer's roof from the solar array.

What is a Soladeck?

200
This process is used when moving inventory from one place in the warehouse to another.

What is a bin transfer?

200

This formula checks for two conditions and then returns a result based on the outcome of this check.

What is an "if" statement?

200

This metric shows a weekly total of installs that are currently waiting on the supply chain.  

What is Installs on Hold for Inventory?

300

This warehouse champion was originally hired with one other manager before alter being named the sole champion of this warehouse.

Who is Aaron Davis?

300

Typically referred to as a 2 to 1, this part is designed to be attached to 2 solar modules.

What is an HMN, HMNT, or MI 600?

300

Using engineered plans and supply chain guidance, this document is created to help all parties better understand parts for a job.  

What is picklist?

300

Using a data set as a reference and a column number selection, this formula returns a value in the dataset given the column number and the reference check.

What is a Vlookup?

300

A financial ratio showing how many times we have installed and replaced inventory over a given period.  Expressed as COGS divided by Average Inventory.

What is Inventory Turnover Ratio?

400

One of the very first warehouse "managers" ever hired, this warehouse manager was known for working hard but struggled with process or any oversight.

Who is Cassie Green?

400

Used to secure a solar module to the UniRac rail system, this part allows for a wide array of module thicknesses to be attached. 

What is the Universal AF mid or end clamp?

400

Items in the system that are not properly in their place use this process to fix the issue.

What is a bin-putaway?

400

This Excel advanced function is one of the formulas used with multiple variants. This advanced Excel formula helps us join several text strings into one text string.

What is the concatenate formula?

400

Measure of standard pallet positions not filled with product in all warehouses. 

What is Warehouse Capacity Available?

500

By night this champion is an avid artist of the musical persuasion.

Who is Anthony Kingery?

500
Typically designed for aesthetics, this part, if designed well, also allows for the draining of water on a solar array.

What is an end cap or end cover?

500

Used to ensure all parties review work, this document is used at the final point before an install occurs.

What is an inventory/pick list audit form?
500

Returns number rounded up, away from zero, to the nearest multiple of significance. Unlike "Roundup" this allows you choose a multiple of significance, such as round dollar values to the nearest nickel.  

What is the Ceiling Formula?

500

Number of hours by warehouse personnel per KW installed over the given period.  

What is Warehouse Labor Hours per KW installed?

M
e
n
u