Dawn is concerned that SGM is not maximizing its purchasing power. She wants a table

showing the name of all the vendors that sell to five or fewer stores. For each vendor in

the table, she also wants to know how many stores they sell to and how much SGM

purchased from them in dollars.

Per the Purchases file, SMG$\text{'}$s total liquor purchases were $$219,598,495,$ while the total

wine purchases were $$105,205,984.$ Using pivot tables, answer the following questions.

$($Hint: remember liquor purchases are identified as classification $1$ and wine purchases

as classification $2.)$

$3$a The stores in which state accounted for the smallest percentage of the $$219,598,495$

SMG spent on liquor? What percentage of the total liquor purchases came from stores in

that state?

$3b$ In total, liquor accounted for $67\mathrm{.}61\%$ of SMG$\text{'}$s total purchases, while wine accounted

for the remaining $32\mathrm{.}39\%.$ Based on the purchases within each state, in which state were

the wine purchases the largest percentage of the state's total purchases? What percentage

of the state's total purchases were wine? $($Hint: Based on the state, you will need to create

a pivot table that identifies what percentage each state's purchases are wine and what

percentage are liquor. Based on that, you will need to identify which state purchased the

most wine as a percentage of the state's total purchases.$)$

$3$c A state's percentage of total liquor purchases and the percentage of liquor versus wine

purchased within a specific state are both benchmarks, but they convey different

information. How might each benchmark be useful?