As the chief accountant for Davis Mobile Concepts, a leading car audio dealer serving four states, you have been asked by the vice president to create a worksheet to analyze the yearly sales for each...

four states, you have been asked by the vice president to create a worksheet to analyze the yearly sales for each state (Figure_1– 76). The packages and corresponding sales by state for the year are shown in Table.