Spreadsheet: 811927d1672865648-lookup-function-with-multiple-criteria-example2-addl-columns-in-openorderbookdata_2
Sheet: NextMonthFC

Current Open Orders
Overdue Orders
Addtl Local Production | 100000
Row Labels | Sum of Open Order Value | % of Total |  | Row Labels | Sum of Open Order Value | % of Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecast | Actual
Imports | 4211159.280000003 |  |  | LOCHINVAR CORPORATION | 1524888.569999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | Sep | 950000 | 966059.95
Local | 170715.28 |  |  | Patterson-Kelley, LLC | 1008158.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct | 780000 | 795623.87
HEX | 666807.13 |  |  | AO SMITH CORPORATION | 446488.4399999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov | 750000 | 883263.25
Grand Total | 5048681.690000003 |  |  | QNERGY, INC | 359114.48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec | 750000 | 756531.3099999999
 |  |  |  | ECR International, Inc. | 288893.2600000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021 | Jan | 1150000
 |  |  |  | CAMUS HYDRONICS LTD | 230972.27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 1000000
Row Labels | Sum of Open Order Value | % of Total |  | LAARS HEATING SYSTEMS | 224961.61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar
Shelpman | 1971426.459999999 |  |  | RHEEM SALES COMPANY INC. | 180735.62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
Kordi | 2378620.619999999 |  |  | WEIL-MCLAIN | 163237.49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
[NAME] | 698634.61 |  |  | RAYPAK, INC | 129802.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun
Grand Total | 5048681.689999999 |  |  | Cleaver-Brooks, Inc. | 62345.61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  | AERCO INTERNATIONAL, INC. | 54685.49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  | CLEAVER-BROOKS OF CANADA LTD | 49105.92 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
Row Labels | Sum of Open Order Value | % of Total |  | [NAME] | 44771.65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
Segassie | 1862379.909999999 |  |  | NEPTRONIC | 33222 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
[NAME] | 3118541.51 |  |  | DRISTEEM HUMIDIFER CO. | 32228.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
Marr | 67760.27 |  |  | Cleaver Brooks de Mexico SA de CV | 30463.24
Grand Total | 5048681.689999999 |  |  | [NAME] INC. | 28111.79
 |  |  |  | HTP INC. | 26849.02
 |  |  |  | [NAME] | 14220
 |  |  |  | THERMAL SOLUTIONS PRODUCTS LLC | 13516.83
 |  |  |  | AMERICAN WATER HEATER CO. | 13507.6
 |  |  |  | CIMARRON ENERGY INC. | 13219.38
 |  |  |  | PVI WATER HEATERS | 12514.45
 |  |  |  | FULTON HEATING SOLUTIONS | 11792.46
 |  |  |  | SELLERS MANUFACTURING CO. | 10504.3
 |  |  |  | ZODIAC POOL SYSTEMS, INC. | 9036
 |  |  |  | Robertshaw | 8190
 |  |  |  | CLAYTON INDUSTRIES | 7654.06
 |  |  |  | BOCK WATER HEATERS, INC. | 7536.3
 |  |  |  | POWER FLAME INC | 7516.75
 |  |  |  | HAMILTON ENGINEERING, INC. | 437.85
 |  |  |  | Grand Total | 5048681.689999999