i need to know the formulas that go in the yellow

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 quality 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: 51. (HINT: Use the FALSE logical value for exact match VLOOKuP formulas. Use absolute referencins for the table array.) 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 quality 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: 51. (HINT: Use the FALSE logical value for exact match VLOOKuP formulas. Use absolute referencins for the table array.)