Week One: Hands-on Analysis - Need pivot tables created in Excel. Please use data provided.

Use the data provided to perform the below analyses using PivotTables (required for all four analyses): Analyze ALL THREE of the below items: 1. Best Performing Regions by Total Revenue 2. Best Performing Stores by Total Revenue 3. Best Selling Products by Total Revenue Select ONLY ONE of the below items to analyze: A. Total Revenue for each Product by Selling Period B. Total Revenue for each Region by Selling Period C. Total Revenue for each Store by Selling Period Provide your insights and recommendations in a formal business case – in the form of ONE descriptive paragraph and ONE data table -- for each analysis. Each paragraph must refer to the information presented in the table using the labeled Table #. Use APA format to label your tables. SUBMIT – your final report with one WORD document and one EXCEL file.

Get Help With a similar task to - Week One: Hands-on Analysis - Need pivot tables created in Excel. Please use data provided.

Login to view and/or buy answers.. or post an answer
Additional Instructions:

Data Analysis and Improvement Recommendation The Best Performing Regions with regards to the Total Revenue of the company Notes: Table 1 shows the revenue of every region with regards to the total revenue got of each region. As portrayed by Table 1, the East region, which has a total revenue of $529,129.80 can be accounted for 53% of the total number of sales across the region. The South region comes as the second with total revenue of $234,595.05, which accounts for 24% of total sales. Conclusively, the Region that is accounted for the smallest share of the total number of sales at $233,832.75, or 23% of the total number of sales. Table 1 The Best Performing Regions with regards to the company Total Revenue Sales Region Total Units Sold NORTH $233,832.75 SOUTH $234,595.05 EAST $529,124.80 Best Performing Stores by the Total amount of Revenue acquired Notes: Table 2 portrays the total revenue of each of the stores organized in numerical order. Store 6, which happens to be the subset of the East region sales, ends up accounting for the lion share ending up reporting total earnings of $267,648.90. The second following store happens to be store number 7, which is a subset of the East region at $170,040.85. Store number 5 follows as the third, which a subset of the North region and accounts for $158,334.00 Table 2 Best Performing Stores by Total Revenue Sales Region Store No Total Units Sold South 1 $90,281.10 South 2 $54,262.70 South 3 $90,051.25 North 4 $75,498.75 North 5 $158,334.00 East 6 $267,648.90 East 7 $170,040.85 East 8 $91,435.05 The Best Selling Products by Total Revenue Notes: Table 3 depicts the bestselling product across all three regions. In the table, the best-selling product belongs to item Number 8500, which is a row label Desktop CPU that accounts for $833,800.95 of the total sales, which is assisted by the total sales and the high per-unit price. Item number 2005 happens to be the second in row label 17” Monitor accounting for $139,461.00 of the total sales. Table 3 The Best Selling Products by Total Revenue Item No Total Units Sold 2005 $139,461.00 3006 $18,294.15 6050 $5,996.50 8500 $833,800.95 Select ONLY ONE of the below items: A. Strongest Selling Period for each Product by Total Revenue B. Strongest Selling Period for each Region by Total Revenue Table 4 Strongest Selling Period for each Region by Total Revenue East South North October 27 2010 $160,940.90 $77,577.90 $79,203.95 November 24 2010 $181,965.35 $81,578.90 $78,416.80 December 29 2010 $186,218.55 $74,675.95 $76,974.30 Notes: Table 4 depicts the best sales period for each region. The East region’s best sales fall within the December 2010 period accounting for $186,218.55 in total sales. The South region’s best sales fall within the November 2010 period accounting for $81,578.90 in total sales. The North region’s best sales fall within the October 2010 period accounting for $79,203.95 in total sales. The recommendations are before a web guest leaves your site, demand that they complete a short overview identified with your business. Individuals are glad to put themselves out there and regularly appreciate educating you concerning their on the web and disconnected encounters. You can utilize an overview to direct industry research, client experience, or measure consumer loyalty. A client who contacts client care about their first request is similarly pretty much as significant as a client who contacts client support about their 10th request. Approach every client with deference and make a fitting move. A cheerful client is probably going to educate in any event three companions regarding a positive encounter and extraordinary client support prompts expanded deals. The best part is that you can monitor past client correspondence through devices like CRM programming. The new and instructive substance is one of the fundamental components that draw in new guests and possible clients. Keep your substance new by distributing a blog that reports the most recent business news, key takeaways from whitepapers, and hotly debated issues inside your industry. The new substance will likewise assist your site with being found in web crawlers. Facebook clients have a normal of 229 companions. At the point when you make a new substance, dispatch another item or run another mission, be certain you share this across the online media diverts you are dynamic in. There could be no simpler method to develop your client base than offering some benefit and afterward having your clients advance your image for you. Advertising is the specialty of drawing in and keeping clients. If building a strong client base for your item or administration is the thing that you are hoping to accomplish in 2021, carrying out the five stages above will extraordinarily expand your client information base in a brief timeframe. The recommendations are before a web guest leaves your site, demand that they complete a short overview identified with your business. Individuals are glad to put themselves out there and regularly appreciate educating you concerning their on the web and disconnected encounters. You can utilize an overview to direct industry research, client experience, or measure consumer loyalty. A client who contacts client care about their first request is similarly pretty much as significant as a client who contacts client support about their 10th request. Approach every client with deference and make a fitting move. A cheerful client is probably going to educate in any event three companions regarding a positive encounter and extraordinary client support prompts expanded deals. The best part is that you can monitor past client correspondence through devices like CRM programming. The new and instructive substance is one of the fundamental components that draw in new guests and possible clients. Keep your substance new by distributing a blog that reports the most recent business news, key takeaways from whitepapers, and hotly debated issues inside your industry. The new substance will likewise assist your site with being found in web crawlers. Facebook clients have a normal of 229 companions. At the point when you make a new substance, dispatch another item or run another mission, be certain you share this across the online media diverts you are dynamic in. There could be no simpler method to develop your client base than offering some benefit and afterward having your clients advance your image for you. Advertising is the specialty of drawing in and keeping clients. If building a strong client base for your item or administration is the thing that you are hoping to accomplish in 2021, carrying out the five stages above will extraordinarily expand your client information base in a brief timeframe. 2

MGT 608 – Information and Supply Chain Systems Week One: Hands-on Analysis Store & Region Sales Database This exercise helps students understand how a raw file of sales transactions can be analyzed to produce valuable information for managers. Your challenge is to see what the data is telling you and then present your case for improvement! You are the Senior Vice President of Sales for the Natun Computer Company. This is your regular report to the CEO, summarizing the recent performance of the company. Although all stores are approximately the same in terms of retails space and workforce, there have been falling sales in some stores. Leadership is interested in using data-driven decision making to make management changes at the region and store level. Product Development is looking for direction to focus investments. Marketing is also interested in how the “best sellers” can be leveraged in advertising and promotions to increase overall sales. For each analysis below, provide your insights on historical performance and your recommendations for future actions. Use the data provided to perform the below analyses using PivotTables (required for all four analyses): Analyze ALL THREE of the below items: 1. Best Performing Regions by Total Revenue 2. Best Performing Stores by Total Revenue 3. Best Selling Products by Total Revenue Select ONLY ONE of the below items to analyze: A. Total Revenue for each Product by Selling Period B. Total Revenue for each Region by Selling Period C. Total Revenue for each Store by Selling Period Provide your insights and recommendations in a formal business case – in the form of ONE descriptive paragraph and ONE data table -- for each analysis. Each paragraph must refer to the information presented in the table using the labeled Table #. Use APA format to label your tables. SUBMIT – your final report with one WORD document and one EXCEL file.

Data Store & Region Sales Database ID Store No Sales Region Item No Item Description Unit Price Units Sold Week Ending Weekly Revenue 1 1 South 2005 17" Monitor $229.00 38 10/27/20 2 1 South 2005 17" Monitor $229.00 40 11/24/20 Instructions: See detailed instructions in the assignment. 3 1 South 2005 17" Monitor $229.00 19 12/29/20 4 1 South 3006 101 Keyboard $19.95 40 10/27/20 5 1 South 3006 101 Keyboard $19.95 45 11/24/20 6 1 South 3006 101 Keyboard $19.95 49 12/29/20 7 1 South 6050 PC Mouse $8.95 38 10/27/20 8 1 South 6050 PC Mouse $8.95 13 11/24/20 9 1 South 6050 PC Mouse $8.95 48 12/29/20 10 1 South 8500 Desktop CPU $849.95 35 10/27/20 11 1 South 8500 Desktop CPU $849.95 37 11/24/20 12 1 South 8500 Desktop CPU $849.95 43 12/29/20 13 2 South 2005 17" Monitor $229.00 18 10/27/20 14 2 South 2005 17" Monitor $229.00 18 11/24/20 15 2 South 2005 17" Monitor $229.00 20 12/29/20 16 2 South 3006 101 Keyboard $19.95 18 10/27/20 17 2 South 3006 101 Keyboard $19.95 18 11/24/20 18 2 South 3006 101 Keyboard $19.95 18 12/29/20 19 2 South 6050 PC Mouse $8.95 19 10/27/20 20 2 South 6050 PC Mouse $8.95 19 11/24/20 21 2 South 6050 PC Mouse $8.95 18 12/29/20 22 2 South 8500 Desktop CPU $849.95 28 10/27/20 23 2 South 8500 Desktop CPU $849.95 28 11/24/20 24 2 South 8500 Desktop CPU $849.95 30 12/29/20 25 3 South 2005 17" Monitor $229.00 48 10/27/20 26 3 South 2005 17" Monitor $229.00 40 11/24/20 27 3 South 2005 17" Monitor $229.00 13 12/29/20 28 3 South 3006 101 Keyboard $19.95 40 10/27/20 29 3 South 3006 101 Keyboard $19.95 42 11/24/20 30 3 South 3006 101 Keyboard $19.95 43 12/29/20 31 3 South 6050 PC Mouse $8.95 35 10/27/20 32 3 South 6050 PC Mouse $8.95 15 11/24/20 33 3 South 6050 PC Mouse $8.95 36 12/29/20 34 3 South 8500 Desktop CPU $849.95 38 10/27/20 35 3 South 8500 Desktop CPU $849.95 37 11/24/20 36 3 South 8500 Desktop CPU $849.95 39 12/29/20 37 4 North 2005 17" Monitor $229.00 28 10/27/20 38 4 North 2005 17" Monitor $229.00 30 11/24/20 39 4 North 2005 17" Monitor $229.00 14 12/29/20 40 4 North 3006 101 Keyboard $19.95 22 10/27/20 41 4 North 3006 101 Keyboard $19.95 34 11/24/20 42 4 North 3006 101 Keyboard $19.95 46 12/29/20 43 4 North 6050 PC Mouse $8.95 39 10/27/20 44 4 North 6050 PC Mouse $8.95 21 11/24/20 45 4 North 6050 PC Mouse $8.95 48 12/29/20 46 4 North 8500 Desktop CPU $849.95 31 10/27/20 47 4 North 8500 Desktop CPU $849.95 34 11/24/20 48 4 North 8500 Desktop CPU $849.95 40 12/29/20 49 5 North 2005 17" Monitor $229.00 37 10/27/20 50 5 North 2005 17" Monitor $229.00 35 11/24/20 51 5 North 2005 17" Monitor $229.00 33 12/29/20 52 5 North 3006 101 Keyboard $19.95 90 10/27/20 53 5 North 3006 101 Keyboard $19.95 92 11/24/20 54 5 North 3006 101 Keyboard $19.95 85 12/29/20 55 5 North 6050 PC Mouse $8.95 75 10/27/20 56 5 North 6050 PC Mouse $8.95 34 11/24/20 57 5 North 6050 PC Mouse $8.95 65 12/29/20 58 5 North 8500 Desktop CPU $849.95 65 10/27/20 59 5 North 8500 Desktop CPU $849.95 67 11/24/20 60 5 North 8500 Desktop CPU $849.95 57 12/29/20 61 6 East 2005 17" Monitor $229.00 34 10/27/20 62 6 East 2005 17" Monitor $229.00 95 11/24/20 63 6 East 2005 17" Monitor $229.00 66 12/29/20 64 6 East 3006 101 Keyboard $19.95 62 10/27/20 65 6 East 3006 101 Keyboard $19.95 68 11/24/20 66 6 East 3006 101 Keyboard $19.95 79 12/29/20 67 6 East 6050 PC Mouse $8.95 45 10/27/20 68 6 East 6050 PC Mouse $8.95 49 11/24/20 69 6 East 6050 PC Mouse $8.95 54 12/29/20 70 6 East 8500 Desktop CPU $849.95 88 10/27/20 71 6 East 8500 Desktop CPU $849.95 98 11/24/20 72 6 East 8500 Desktop CPU $849.95 109 12/29/20 73 7 East 2005 17" Monitor $229.00 44 10/27/20 74 7 East 2005 17" Monitor $229.00 46 11/24/20 75 7 East 2005 17" Monitor $229.00 45 12/29/20 76 7 East 3006 101 Keyboard $19.95 59 10/27/20 77 7 East 3006 101 Keyboard $19.95 57 11/24/20 78 7 East 3006 101 Keyboard $19.95 58 12/29/20 79 7 East 6050 PC Mouse $8.95 55 10/27/20 80 7 East 6050 PC Mouse $8.95 52 11/24/20 81 7 East 6050 PC Mouse $8.95 55 12/29/20 82 7 East 8500 Desktop CPU $849.95 65 10/27/20 83 7 East 8500 Desktop CPU $849.95 67 11/24/20 84 7 East 8500 Desktop CPU $849.95 65 12/29/20 85 8 East 2005 17" Monitor $229.00 28 10/27/20 86 8 East 2005 17" Monitor $229.00 27 11/24/20 87 8 East 2005 17" Monitor $229.00 33 12/29/20 88 8 East 3006 101 Keyboard $19.95 32 10/27/20 89 8 East 3006 101 Keyboard $19.95 28 11/24/20 90 8 East 3006 101 Keyboard $19.95 32 12/29/20 91 8 East 6050 PC Mouse $8.95 24 10/27/20 92 8 East 6050 PC Mouse $8.95 26 11/24/20 93 8 East 6050 PC Mouse $8.95 27 12/29/20 94 8 East 8500 Desktop CPU $849.95 42 10/27/20 95 8 East 8500 Desktop CPU $849.95 38 11/24/20 96 8 East 8500 Desktop CPU $849.95 40 12/29/20

Data Analysis and Improvement Recommendation The Best Performing Regions with regards to the Total Revenue of the company Notes: Table 1 shows the revenue of every region with regards to the total revenue got of each region. As portrayed by Table 1, the East region, which has a total revenue of $529,129.80 can be accounted for 53% of the total number of sales across the region. The South region comes as the second with total revenue of $234,595.05, which accounts for 24% of total sales. Conclusively, the Region that is accounted for the smallest share of the total number of sales at $233,832.75, or 23% of the total number of sales. Table 1 The Best Performing Regions with regards to the company Total Revenue Sales Region Total Units Sold NORTH $233,832.75 SOUTH $234,595.05 EAST $529,124.80 Best Performing Stores by the Total amount of Revenue acquired Notes: Table 2 portrays the total revenue of each of the stores organized in numerical order. Store 6, which happens to be the subset of the East region sales, ends up accounting for the lion share ending up reporting total earnings of $267,648.90. The second following store happens to be store number 7, which is a subset of the East region at $170,040.85. Store number 5 follows as the third, which a subset of the North region and accounts for $158,334.00 Table 2 Best Performing Stores by Total Revenue Sales Region Store No Total Units Sold South 1 $90,281.10 South 2 $54,262.70 South 3 $90,051.25 North 4 $75,498.75 North 5 $158,334.00 East 6 $267,648.90 East 7 $170,040.85 East 8 $91,435.05 The Best Selling Products by Total Revenue Notes: Table 3 depicts the bestselling product across all three regions. In the table, the best-selling product belongs to item Number 8500, which is a row label Desktop CPU that accounts for $833,800.95 of the total sales, which is assisted by the total sales and the high per-unit price. Item number 2005 happens to be the second in row label 17” Monitor accounting for $139,461.00 of the total sales. Table 3 The Best Selling Products by Total Revenue Item No Total Units Sold 2005 $139,461.00 3006 $18,294.15 6050 $5,996.50 8500 $833,800.95 Select ONLY ONE of the below items: A. Strongest Selling Period for each Product by Total Revenue B. Strongest Selling Period for each Region by Total Revenue Table 4 Strongest Selling Period for each Region by Total Revenue East South North October 27 2010 $160,940.90 $77,577.90 $79,203.95 November 24 2010 $181,965.35 $81,578.90 $78,416.80 December 29 2010 $186,218.55 $74,675.95 $76,974.30 Notes: Table 4 depicts the best sales period for each region. The East region’s best sales fall within the December 2010 period accounting for $186,218.55 in total sales. The South region’s best sales fall within the November 2010 period accounting for $81,578.90 in total sales. The North region’s best sales fall within the October 2010 period accounting for $79,203.95 in total sales. The recommendations are before a web guest leaves your site, demand that they complete a short overview identified with your business. Individuals are glad to put themselves out there and regularly appreciate educating you concerning their on the web and disconnected encounters. You can utilize an overview to direct industry research, client experience, or measure consumer loyalty. A client who contacts client care about their first request is similarly pretty much as significant as a client who contacts client support about their 10th request. Approach every client with deference and make a fitting move. A cheerful client is probably going to educate in any event three companions regarding a positive encounter and extraordinary client support prompts expanded deals. The best part is that you can monitor past client correspondence through devices like CRM programming. The new and instructive substance is one of the fundamental components that draw in new guests and possible clients. Keep your substance new by distributing a blog that reports the most recent business news, key takeaways from whitepapers, and hotly debated issues inside your industry. The new substance will likewise assist your site with being found in web crawlers. Facebook clients have a normal of 229 companions. At the point when you make a new substance, dispatch another item or run another mission, be certain you share this across the online media diverts you are dynamic in. There could be no simpler method to develop your client base than offering some benefit and afterward having your clients advance your image for you. Advertising is the specialty of drawing in and keeping clients. If building a strong client base for your item or administration is the thing that you are hoping to accomplish in 2021, carrying out the five stages above will extraordinarily expand your client information base in a brief timeframe. The recommendations are before a web guest leaves your site, demand that they complete a short overview identified with your business. Individuals are glad to put themselves out there and regularly appreciate educating you concerning their on the web and disconnected encounters. You can utilize an overview to direct industry research, client experience, or measure consumer loyalty. A client who contacts client care about their first request is similarly pretty much as significant as a client who contacts client support about their 10th request. Approach every client with deference and make a fitting move. A cheerful client is probably going to educate in any event three companions regarding a positive encounter and extraordinary client support prompts expanded deals. The best part is that you can monitor past client correspondence through devices like CRM programming. The new and instructive substance is one of the fundamental components that draw in new guests and possible clients. Keep your substance new by distributing a blog that reports the most recent business news, key takeaways from whitepapers, and hotly debated issues inside your industry. The new substance will likewise assist your site with being found in web crawlers. Facebook clients have a normal of 229 companions. At the point when you make a new substance, dispatch another item or run another mission, be certain you share this across the online media diverts you are dynamic in. There could be no simpler method to develop your client base than offering some benefit and afterward having your clients advance your image for you. Advertising is the specialty of drawing in and keeping clients. If building a strong client base for your item or administration is the thing that you are hoping to accomplish in 2021, carrying out the five stages above will extraordinarily expand your client information base in a brief timeframe. 2

MGT 608 – Information and Supply Chain Systems Week One: Hands-on Analysis Store & Region Sales Database This exercise helps students understand how a raw file of sales transactions can be analyzed to produce valuable information for managers. Your challenge is to see what the data is telling you and then present your case for improvement! You are the Senior Vice President of Sales for the Natun Computer Company. This is your regular report to the CEO, summarizing the recent performance of the company. Although all stores are approximately the same in terms of retails space and workforce, there have been falling sales in some stores. Leadership is interested in using data-driven decision making to make management changes at the region and store level. Product Development is looking for direction to focus investments. Marketing is also interested in how the “best sellers” can be leveraged in advertising and promotions to increase overall sales. For each analysis below, provide your insights on historical performance and your recommendations for future actions. Use the data provided to perform the below analyses using PivotTables (required for all four analyses): Analyze ALL THREE of the below items: 1. Best Performing Regions by Total Revenue 2. Best Performing Stores by Total Revenue 3. Best Selling Products by Total Revenue Select ONLY ONE of the below items to analyze: A. Total Revenue for each Product by Selling Period B. Total Revenue for each Region by Selling Period C. Total Revenue for each Store by Selling Period Provide your insights and recommendations in a formal business case – in the form of ONE descriptive paragraph and ONE data table -- for each analysis. Each paragraph must refer to the information presented in the table using the labeled Table #. Use APA format to label your tables. SUBMIT – your final report with one WORD document and one EXCEL file.

Data Store & Region Sales Database ID Store No Sales Region Item No Item Description Unit Price Units Sold Week Ending Weekly Revenue 1 1 South 2005 17" Monitor $229.00 38 10/27/20 2 1 South 2005 17" Monitor $229.00 40 11/24/20 Instructions: See detailed instructions in the assignment. 3 1 South 2005 17" Monitor $229.00 19 12/29/20 4 1 South 3006 101 Keyboard $19.95 40 10/27/20 5 1 South 3006 101 Keyboard $19.95 45 11/24/20 6 1 South 3006 101 Keyboard $19.95 49 12/29/20 7 1 South 6050 PC Mouse $8.95 38 10/27/20 8 1 South 6050 PC Mouse $8.95 13 11/24/20 9 1 South 6050 PC Mouse $8.95 48 12/29/20 10 1 South 8500 Desktop CPU $849.95 35 10/27/20 11 1 South 8500 Desktop CPU $849.95 37 11/24/20 12 1 South 8500 Desktop CPU $849.95 43 12/29/20 13 2 South 2005 17" Monitor $229.00 18 10/27/20 14 2 South 2005 17" Monitor $229.00 18 11/24/20 15 2 South 2005 17" Monitor $229.00 20 12/29/20 16 2 South 3006 101 Keyboard $19.95 18 10/27/20 17 2 South 3006 101 Keyboard $19.95 18 11/24/20 18 2 South 3006 101 Keyboard $19.95 18 12/29/20 19 2 South 6050 PC Mouse $8.95 19 10/27/20 20 2 South 6050 PC Mouse $8.95 19 11/24/20 21 2 South 6050 PC Mouse $8.95 18 12/29/20 22 2 South 8500 Desktop CPU $849.95 28 10/27/20 23 2 South 8500 Desktop CPU $849.95 28 11/24/20 24 2 South 8500 Desktop CPU $849.95 30 12/29/20 25 3 South 2005 17" Monitor $229.00 48 10/27/20 26 3 South 2005 17" Monitor $229.00 40 11/24/20 27 3 South 2005 17" Monitor $229.00 13 12/29/20 28 3 South 3006 101 Keyboard $19.95 40 10/27/20 29 3 South 3006 101 Keyboard $19.95 42 11/24/20 30 3 South 3006 101 Keyboard $19.95 43 12/29/20 31 3 South 6050 PC Mouse $8.95 35 10/27/20 32 3 South 6050 PC Mouse $8.95 15 11/24/20 33 3 South 6050 PC Mouse $8.95 36 12/29/20 34 3 South 8500 Desktop CPU $849.95 38 10/27/20 35 3 South 8500 Desktop CPU $849.95 37 11/24/20 36 3 South 8500 Desktop CPU $849.95 39 12/29/20 37 4 North 2005 17" Monitor $229.00 28 10/27/20 38 4 North 2005 17" Monitor $229.00 30 11/24/20 39 4 North 2005 17" Monitor $229.00 14 12/29/20 40 4 North 3006 101 Keyboard $19.95 22 10/27/20 41 4 North 3006 101 Keyboard $19.95 34 11/24/20 42 4 North 3006 101 Keyboard $19.95 46 12/29/20 43 4 North 6050 PC Mouse $8.95 39 10/27/20 44 4 North 6050 PC Mouse $8.95 21 11/24/20 45 4 North 6050 PC Mouse $8.95 48 12/29/20 46 4 North 8500 Desktop CPU $849.95 31 10/27/20 47 4 North 8500 Desktop CPU $849.95 34 11/24/20 48 4 North 8500 Desktop CPU $849.95 40 12/29/20 49 5 North 2005 17" Monitor $229.00 37 10/27/20 50 5 North 2005 17" Monitor $229.00 35 11/24/20 51 5 North 2005 17" Monitor $229.00 33 12/29/20 52 5 North 3006 101 Keyboard $19.95 90 10/27/20 53 5 North 3006 101 Keyboard $19.95 92 11/24/20 54 5 North 3006 101 Keyboard $19.95 85 12/29/20 55 5 North 6050 PC Mouse $8.95 75 10/27/20 56 5 North 6050 PC Mouse $8.95 34 11/24/20 57 5 North 6050 PC Mouse $8.95 65 12/29/20 58 5 North 8500 Desktop CPU $849.95 65 10/27/20 59 5 North 8500 Desktop CPU $849.95 67 11/24/20 60 5 North 8500 Desktop CPU $849.95 57 12/29/20 61 6 East 2005 17" Monitor $229.00 34 10/27/20 62 6 East 2005 17" Monitor $229.00 95 11/24/20 63 6 East 2005 17" Monitor $229.00 66 12/29/20 64 6 East 3006 101 Keyboard $19.95 62 10/27/20 65 6 East 3006 101 Keyboard $19.95 68 11/24/20 66 6 East 3006 101 Keyboard $19.95 79 12/29/20 67 6 East 6050 PC Mouse $8.95 45 10/27/20 68 6 East 6050 PC Mouse $8.95 49 11/24/20 69 6 East 6050 PC Mouse $8.95 54 12/29/20 70 6 East 8500 Desktop CPU $849.95 88 10/27/20 71 6 East 8500 Desktop CPU $849.95 98 11/24/20 72 6 East 8500 Desktop CPU $849.95 109 12/29/20 73 7 East 2005 17" Monitor $229.00 44 10/27/20 74 7 East 2005 17" Monitor $229.00 46 11/24/20 75 7 East 2005 17" Monitor $229.00 45 12/29/20 76 7 East 3006 101 Keyboard $19.95 59 10/27/20 77 7 East 3006 101 Keyboard $19.95 57 11/24/20 78 7 East 3006 101 Keyboard $19.95 58 12/29/20 79 7 East 6050 PC Mouse $8.95 55 10/27/20 80 7 East 6050 PC Mouse $8.95 52 11/24/20 81 7 East 6050 PC Mouse $8.95 55 12/29/20 82 7 East 8500 Desktop CPU $849.95 65 10/27/20 83 7 East 8500 Desktop CPU $849.95 67 11/24/20 84 7 East 8500 Desktop CPU $849.95 65 12/29/20 85 8 East 2005 17" Monitor $229.00 28 10/27/20 86 8 East 2005 17" Monitor $229.00 27 11/24/20 87 8 East 2005 17" Monitor $229.00 33 12/29/20 88 8 East 3006 101 Keyboard $19.95 32 10/27/20 89 8 East 3006 101 Keyboard $19.95 28 11/24/20 90 8 East 3006 101 Keyboard $19.95 32 12/29/20 91 8 East 6050 PC Mouse $8.95 24 10/27/20 92 8 East 6050 PC Mouse $8.95 26 11/24/20 93 8 East 6050 PC Mouse $8.95 27 12/29/20 94 8 East 8500 Desktop CPU $849.95 42 10/27/20 95 8 East 8500 Desktop CPU $849.95 38 11/24/20 96 8 East 8500 Desktop CPU $849.95 40 12/29/20

Related Questions

Similar orders to Week One: Hands-on Analysis - Need pivot tables created in Excel. Please use data provided.
24
Views
0
Answers
Time and motion study for the production of company to increase
I am currently working on a project of "Time and Motion Study" required for the company that I am working for. I have prepared a dataset observing all the instances performed by the employees of my company and recorded the times. I have attached the datase...
39
Views
0
Answers
Time Series Analysis and Forecasting
TextBook: Essentials-of-Business-Analytics-South-Western-Educational-Publishing-2018. Questions Download the Excel file Closing Stock Prices on Canvas, which provides data for IBM stock over a 1-month period. You need to submit your EXCEL file on Can...
55
Views
0
Answers
Bis155
Excel project with 25 steps on excel mainly using vlookup functions...
80
Views
0
Answers
Business Data Analytics

Minimum Requirements

Create an Excel workbook that is able to, at the very minimum, answer the questions you defined in the memo you created in Part 1. Structure your Workbook as follows: Create at least 8 worksheets and re-name the worksheets a...