BUSN3640 - Business Analysis Tool Assignment

Assignment Task

1. As one of the customers, you will use the Project Randomiser file to access your unique information. To begin, simply input your university email address into cell B2 and click Refresh.

2. Data Set Overview and Insights 

Provide a comprehensive description of the dataset with managerial insights. Employ appropriate graphical representations and analysis methods (e.g., pivot tables) to aid in understanding. Present this information and a summary (up to words) on the sheet titled Task 2.

3. Product and Customer Analyzer Tools

On anew sheet named Analyzer, develop a product analyzer tool. This tool should reveal key characteristics of a selected product (e.g. top customer, region, etc.) when the user inputs/selects a product ID. Similarly, create a customer analyzer tool on the same sheet that displays vital information about a selected customer. Utilize conditional functions and search and retrieve/lookup and reference functions for these tools.

4. Financial Analysis for Product Revenue Investment

Focusing on a specific product (e.g., product 2002), the manufacturer intends to invest all of its revenue (now in January 2024) in a bank for a certain number of years. Three banking options with varying Annual Percentage Rates (APRs) are being considered: Option 1 at 2.4%, Option 2 at 2.6%, Option 3 at 2.8%, Option 4 at 3%, Option 5 at 3.2%. Design a tool on anew sheet titled "Finance" that calculates and displays the expected savings after 2, 4, 6, 8, 10, 12, 14, 16, 18, 20, 22, or 24 years for each banking option. This tool should provide a simultaneous comparison of all outcomes and include a clear analysis. This tool should also work for any product.

This Business Analysis Assignment Help has been solved by our Business Analysis Experts at My Uni Paper.