G$\text{'}$s Kitchen, Incorporated $("$GK$,$ Incorporated"$)$ has been crafting fine chocolates for over sioty years. GK$,$ Incorporated

is a well$-$established local brand, but buriness really took off when GK$,$ incorporated hired a social media firm to

develop a greater online presence, Sales have expanded from a retal storefront in a small Michigan resort town to

being sold online and shipped throughout the contiguous United Srasek.

Recently, GK$,$ incorporated signed a retail agreement, with a prominent national retal chain. In order to meet the

demands of the national retail chain while maintaining a Righ quality product, oK$,$ lacorporated began leasing

Jrefrigerated warehouse space from Penguin Network Storage, LLC to store Just$-$In$-$Time 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 Column L$.$ The apportionment weightings have been

provided belove.

Required:

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

Complete the apportionment caloulations using VOCKUp formulas to the cllent provided data in G$1$:$151$

$($HINT: Use the FMSt logical value for ecact match voOoup formulas. Use absolute referencing for the table array.$)$