Automated computer modeling of pallet costs in a storage facility and presentation thereof in graphical user interfaces

A system for modeling costs per pallet in a facility, the system comprising:

• a cold room comprising a fan and a sensor;
• a refrigeration control system (RCS) configured to:
• receive from the sensor a sensor measurement associated with the cold room, and
• automatically control the fan associated with the cold room;
• and
• a computer system in network communication with the RCS, wherein the computer system comprises one or more processors and memory storing instructions that, when executed, cause the one or more processors to perform operations comprising:
• receiving, from at least one of a warehouse management system (WMS) or the RCS, time series data for a period of time for pallets in the facility;
• retrieving, from a data store, pallet movement data, changes in temperature data, labor usage data, and energy consumption data for each pallet amongst the pallets;
• determining a plurality of costs per pallet over the period of time based on correlating the time series data with the retrieved data for each pallet amongst the pallets, wherein the plurality of costs per pallet comprises at least one of energy costs per pallet or labor costs per pallet;
• determining a plurality of projected costs per pallet based on modeling the plurality of costs per pallet over the period of time, wherein the plurality of projected costs per pallet are determined for one or more future periods of time;
• generating, based on the plurality of projected costs per pallet, instructions for execution by the RCS to automatically control the fan associated with the cold room at a particular time that corresponds to a lowest energy cost amongst a plurality of energy costs associated with the plurality of projected costs per pallet;
• and
• returning, to the RCS, the instructions for execution,
• wherein the RCS is configured to execute the instructions to automatically control the fan associated with the cold room at the particular time that corresponds to the lowest energy cost, wherein automatically controlling the fan associated with the cold room comprises automatically activating the fan until the sensor measurement is within a predetermined threshold range.