please find the formulas for the yellow sections marked incorrect (RED X) ?and the apportionment factor cell E32 ?G's

WO 00 =] h LN e N P e e e e | e W~ otk wWN S A B C D G's Kitchen, Incorporated (\"GK, Incorporated\") has been crafting fine chocolates for over sixty years. GK, Incorporated is a well-established local brand, but business really took off when GK, Incorporated hired a social media firm to develop a greater online presence. Sales have expanded from a retail storefront in a small Michigan resort town to being sold online and shipped throughout the contiguous United States. Recently, GK, Incorporated signed a retail agreement with a prominent national retail chain. In order to meet the demands of the national retail chain while maintaining a high gquality product, GK, Incorporated began leasing refrigerated warehouse space from Penguin Network Storage, LLC to store Just-In-Time inventory of its top products. Gk, Incorporated has hired you to determine the income tax apportionment percentage in states where it has a [ physical presence using the data provided in Column G through Column L. The apportionment weightings have been provided below. Required: 1. Complete the client-provided data with SUM formulas for the Everywhere amounts. 2. Complete the apportionment calculations using VLOOKUP formulas to the client provided data in G1:L51 (HINT: Use the FALSE logical value for exact match VLOOKUP formulas. Use absolute referencing for the table array.) \f\f\f\f