Tableau Dashboard Activity $12-1$: State and Local Tax $($Algo$)$

Skip to question

State and Local Tax

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.

GK$,$ Incorporated recently received a notice from Indiana assessing substantial penalties and interest for failure to register for and collect Indiana sales tax. GK$,$ Incorporated was not aware Indiana generally imposes sales tax on candy as Michigan does not impose a sales tax on candy and GK$,$ Incorporated has never had to collect sales tax from its customers. GK$,$ Incorporated has engaged you to complete a nexus analysis based on general economic nexus thresholds from the U$.$S$.$ Supreme Court decision in South Dakota v$.$ Wayfair, Incorporated $(138$ S$.$ Ct $2080).$

State and Local Tax $($Algo$)$

Required:

In what jurisdiction$($s$)$ does GK$,$ Incorporated have at least $$100,000$ in sales?

In what jurisdiction$($s$)$ does GK$,$ Incorporated have at least $200$ transactions?

Based on general economic nexus thresholds, in which jurisdiction$($s$)$ should GK$,$ Incorporated register to collect and remit sales tax?

The state sales tax rate in Wisconsin is $5\mathrm{.}00\%.$ How much tax should have been collected from sales made to Wisconsin customers?