Kuhn Block Analysis

Want to present to them 4 options, SP Program with a 4% override and 2 Proxima level 6 products, PXX & PXV - for both their 2023 block and with their block rounded up to 6MM.

Use their block from 2023 and round up to 6MM to account for 3 new firms they have bought since then.

SELECT *
FROM CUSTOMER_DIMENSION CD
WHERE CD.DEF_LVL_10_DESCR LIKE '%KUHN%'
--FH00008766
--FH00004845 -- FIX TO 8766 GROUP

-- SP PROGRAM - 4% OVERRIDE
-- OR INDEPENDENT - PXX, PXV - 2 LOWEST GROWTH FOR PROXIMA LEVEL 6

--4,725,648
-- TOTAL NEEDS TO BE 6MM
-- 1MM