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.$)\backslash$table$[[$Rennoyflanda $-1$cofs sales.$],[,$INveloplarerie,Erevpelwere,Inrcendage,Whrehted Pvrountage$],[$Rayroll$,$F$,$r$,$F$,$F$],[$hor Broperty,F$,$r$,,],[$for haperty,$,$r$,,],[$Average hoperty,F$,$r$,,],[,$F$,$F$,,],[$Total Nroperrty,F$,$r$,$r$,$F$],[$Sales$,$F$,$r$,$F$,$F$],[,,$Apporthonement Factor:,$=>],[$Mreas $-10$cht falks$],[,$Irman,Iowprefuse,Mevenentare,Wheghted Resorentage$],[$fryed$,$F$,$r$,$F$,$F$],[$Bow Property,F$,$r$,,],[10$ F Duperity,F$,$r$,,],[$Average Droperty,r$,$r$,,],[$heset I appowe $-$ Amwaslimed,:$\text{'},$r$,,],[$Iotal hoperty,$\backslash$bar $($F$),$F$,$F$,$F$],[$Sales$,$F$,$r$,$r$,$F$],[,,$Apporthomeneint Iactor:,$=$F$],[,,,,],[,,,,]]$