G$\text{'}$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:

Complete the client$-$provided data with SUM formulas for the Everywhere amounts.

Complete the apportionment calculations using VLOOKUP formulas to the client provided data in G$1$:L$51$

$($HINT: Use the FALSE logical value for exact match VLOOKUP formulas. Use absolute referencing for the table array.$)$

Navigation:

Use the Open Excel in New Tab button to launch this question.

When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.