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.$)$ A$\backslash$table$[[$Mecherat $-1$Got, Seles$],[,$Michigan,fwerprefwere,Evrcerelape,Whieflied Fercentape$],[$Paynol$,$F$,$r$,$r$,$F$],[$Dor moperty,F$,$r$,,],[$for Bugrevity,F$,$r$,,],[$Average froperty,$\backslash$bar $($F$),$r$,,],[$Gert Expence $-$ Annosalued,F$,$F$,,],[$Dolal Property,$\backslash$bar $($F$),$r$,$F$,$F$],[$Sales$,$F$,$F$,$F$,$F$],[,,$Aportaonment Factor:,F$],[$Neve York $-100$ps sales$],[,$Abew Elark,Iveripathese,Gvereibape,Whechiled Rescentage$],[$Frypoll$,$F$,$r$,\backslash$Psi $,$F$],[$EOT Ivoperty,F$,$r$,,],[$IOT Meperty,$,$r$,,],[$Average froperty,F$,$r$,,],[$Rent Ixpreme $-$ Amnualked,F$,$r$,,],[$Iotal inoperty,F$,$F$,$F$,$F$],[$sales$,$r$,$r$,$r$,$r$],[,,$Approrticurertent Fiactor:,$]]$