Tell me Share 4 Comments Home Insert Draw Page Layout Formulas Data Review View Insert v X Calibri (Body) 12 AA ab Wrap Text v General x Delete v Conditional Format Cell Sort & Find & Analyze Sensitivity Paste BI MVA Merge & Center v $ ~ % 19 Formatting as Table Styles Format v Filter Select Data H10 X V fx E F G H K M N O A B C D Average Number of Prior year Sales Current year Current Year Full Time Store# (Audited $) Sales ($) Inventory ($) Square Feet Employees Sells Gas (1) 781793 48725 2500 11 O 1165221 1146438 44171 2500 11.31 1147430 1195004 45714 2500 12.46 951784 37218 1000 11.86 2037463 1981409 45826 4000 10.06 O L O V OR UI AWN 2257920 2300671 53852 4000 11.1 1850354 1956481 49883 1000 10.71 10 00 1916884 1799713 47016 4000 7.5 1833209 1820641 59726 4000 14 10 774954' 35882 2500 11.2 11 980484 1159004 37664 2500 11.6 oo 12 1069653 1139475 34663 2500 12.7 13 948522 44782 4000 11.86 14 1795123 1984777 38774 4000 12.2 15 2119015 2293847 55423 4000 11.1 17 16 1947303 1984722 52884 4000 10.4 18 17 1705789 1798336 46834 1000 8.84 19 18 2396971 2484503 53772 4000 12.1 1' 20 19 1901631 1837400 43982 4000 9.7 21 20 1514798 1609385 44893 4000 7,2 22 21 1886587 1874229 37665 4000 10.5 23 22 698333 33826 2500 10.5 24 23 1092908 1198229 44857 2500 10.9 11 25 Total 30618743 34944696 1038032 80000 243.6 26 27 28 29 Sheet1 + 130% ReadyYour Convenience Store on Tableau Your Convenience Store is a chain of 23 convenience stores located in the southwest United States. The following data are provided in the excel le: - Store Number - Prior year audited sales dollars - Current year sales dollars Current year inventory Store square feet Average number of full-time employees Whether the store sells gas (listed an a "1") If there is a blank cell in the "prior year audited sales dollars" column, the store was opened during the current year. Typically, a store's operations do not change much unless a new product line is introduced, such as selling gas, offering check cashing services, and so forth. The mix of products and services can vary, and the most important factor is whether the store sells gas. Benchmark data for convenience stores shows that sales average $490 per square foot. You have just been assigned to this audit. The audit manager is also newly assigned to this client, and you have been asked to provide as much insight into this client, based upon the provided data, as you can. You should verify the data and at a minimum provide the following visualizations to meet the manager's needs: Inventory turnover Store sales: current and prfor year Store sales: current and prfor year in ascending order of sales Sales per square foot compared with benchmark ($490) Correlation between sales and number of employees After providing these visualizations, derive insightsr'conclusions based on them, as well as any potential questions that you would like to ask your client andfor the audit manager. Excluding the visualizations, which should also be submitted in the same Word document, your write-up should be 1.5-2 single-spaced pages, size 12 Times New Roman font with 1-inch margins all around