i need formulas that go in the yellow boxes
G' Kitchen, Incorporated ("GK, Incorporated") has been crafting fine chocolates for over sixty vears. 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 retall storefront in a small Michigan resort town to being sold online and shipped throughout the contiguous United states. Recentl. GK. Incorporated signed a retai agreement with a prominent national retail chain in order to meet the demands of the national retall chain whie maintaining a high quality product, GK, Incorporated began leasing refrigerated warehovse space from Penguin Network Storage, LLe to store Just-nn-1ime irventory 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 columm . The apportionment weightings have been provided below Required: 1 Complete the client-proyded data with $um formulas for the Everywhere amounts. 2 Complete the apportonment calculations using VLOOkUp formulas to the cient provided data in G1:151 (HINT: Use the FAISE logical value for easct match VLOOKUP formulas. Use absolute referencing for the table array.) 146 Texas - 100\% Sales 747. Payroll Texas Everywhere Weighted Percentage 149 150 BOY Property 151 EOY Property 152 Average Property 153 Rent Expense - Annualized 154 Total Property 155 156 Sales 157 159 159 Apportionment Factor: G' Kitchen, Incorporated ("GK, Incorporated") has been crafting fine chocolates for over sixty vears. 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 retall storefront in a small Michigan resort town to being sold online and shipped throughout the contiguous United states. Recentl. GK. Incorporated signed a retai agreement with a prominent national retail chain in order to meet the demands of the national retall chain whie maintaining a high quality product, GK, Incorporated began leasing refrigerated warehovse space from Penguin Network Storage, LLe to store Just-nn-1ime irventory 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 columm . The apportionment weightings have been provided below Required: 1 Complete the client-proyded data with $um formulas for the Everywhere amounts. 2 Complete the apportonment calculations using VLOOkUp formulas to the cient provided data in G1:151 (HINT: Use the FAISE logical value for easct match VLOOKUP formulas. Use absolute referencing for the table array.) 146 Texas - 100\% Sales 747. Payroll Texas Everywhere Weighted Percentage 149 150 BOY Property 151 EOY Property 152 Average Property 153 Rent Expense - Annualized 154 Total Property 155 156 Sales 157 159 159 Apportionment Factor