Business Analytics IIII

profileabparsley
Parsley_Excel_BU01_Assessment2_AutoBody.xlsx

Sheet1

Jim's Auto Shop
2022 Six Month Sales Analysis
January
Oil change 2643 2782 3100 2876 2925 2668
Tire rotation 1827 1374 1935 1457 1984 1264
Air conditioner services 837 927 812 1029 913 1008
Auto detailing 1628 2187 1932 1745 1723 1421
Alignment services 1292 983 927 998 1054 1789
Battery maintenance and replacment 1877 1654 1452 1987 1432 1207
Flat tire repair 876 772 967 723 851 670
Air filter cleaning and replacment 634 992 1325 1624 1220 982
Muffler inspection and replacment 923 927 1112 1329 1013 876
Windshield repair 1211 869 1098 1267 1034 912

Sheet2

Jim's Auto Body
Create Date By Whom Description Workbook Name
5/18/22 Jim Love Sales data analysis PCT Files Completed.xlsx
Mod. Date By Whom Mod. Description Last Version Backup Name
Create Date Sheet Name Creator Purpose
5/18/22 Sheet1 Jim Love Six month sales analysis