Data Visualization

Given the sales data provided on the 23 stores in Table 1, the senior auditor decided it would be beneficial to create visualizations to find additional information underlying the data. Thus, the senior auditor put together the five charts below.

Figure 1: Quicky Stores, Current and Prior Year Sales in Store ID Order as Presented

Store Sales, Current and Prior Years

\f55 50 O O 45 O O O oo 40 O Inventory O Turnover 35 O Oinventory Turnover, Includes Gas 30 O inventory Turnover, No Gas 25 O 20 O O 15 22 10 1 13 4 12 2 11 3 23 20 17 8 9 19 21 7 5 16 14 15 6 18 Store ID in Order of Total Current Sales650 O 600 OO 550 500 Sales per 450 Square Foot o OSales per Square Foot, Sells Gas 350 Sales per Square Foot, No Gas 300 250 O 200 22 10 1 13 4 12 2 11 3 23 20 17 8 9 19 21 7 5 16 14 15 6 18 Store ID in Order of Total Current Sales2500000 O 2000000 1500000 Current-Year Sales ($), Sells Gas Sales . Prior-Year Sales (Audited) ($), Sells Gas 1000000 Current-Year Sales ($), No Gas . Prior-Year Sales (Audited) ($), No Gas 500000 22 10 1 13 4 12 2 11 3 23 20 17 8 9 19 21 7 5 16 14 15 6 18 Store ID in Order of Total Current Sales2/500,000 RJ = 0.6092 O 2,000,000 O O O O O O R' = 0.6688 1,500,000 Sales 1,000,000 500,000 O Current-Year Sales ($), Sells Gas Current-Year Sales ($), No Gas 10 11 12 13 14 Average Number of Full-Time Employees