Prompt

Using Excel, create a spreadsheet that clearly and functionally displays the numerical data provided in the final project scenario.

scenario:

You have graduated from SNHU and are now employed as a business analyst by Business Consultants (BC), a business consulting firm. As a business analyst, you are responsible for analyzing businesses to determine how your firm can help them meet their sales goals. Your first business to analyze is New Hampshire Business Products (NHBP). NHBP is a small company operating as a sole proprietorship desiring to expand its geographical reach. The products sold by NHBP fall into four categories: office supplies, office equipment, printing services, and technology courses. NHBP has been in business since 2005 and operates one brick-and-mortar location selling various products and services. The company operates a retail store from its one physical location and offers services to customers in its current geographical area via a catalog published semi-annually. Customers using the catalog call their orders in to the retail location by phone, and the company delivers completed orders via delivery truck and third-party carriers such as United Parcel Service (UPS). All technology classes are held at NHBPs retail location. NHBP has concluded that its one retail outlet and its current catalog business have reached their maximum potential and is seeking a means to expand sales as well as geographical reach. NHBP has also concluded that adding internet sales is the best option to expand both sales and geographical reach. BC has been hired to evaluate current operations and suggest paths that will satisfy the sales goals set by NHBP. In your capacity as a business analyst for BC, you have met with the management team at NHBP and made an initial review of the current business operations. Your notes of the review show the following: Total current sales are $638,000 divided into the following categories: o Office supplies: $150,000 o Office equipment: $300,000 o Technology classes: $138,000 o Printing: $50,000 The company desires to increase sales by 20% per year in each category for the next five years. NHBP thinks that online sales will result in reaching its intended sales goals over the next five years. The company is currently unsure how to implement online sales and is seeking guidance in developing a website as well as the mechanics of online marketing and fulfilling online orders as well as offering its courses online.

Prompt

Using Excel, create a spreadsheet that clearly and functionally displays the numerical data provided in the final project scenario.

Specifically, the following critical elements must be addressed:

1. Spreadsheet: Create a spreadsheet that clearly and functionally displays the numerical data provided in the scenario.
   1. For current sales, display sales by category and total.
   2. For projected sales, display sales by category and total.
   3. Apply formatting conventions appropriate for a business audience.
      1. Select a consistent font and font size.
      2. Format the spreadsheet with row and column spacing, row and column alignments, and cell formatting.
      3. Apply labels that identify the values contained in each row and column.
   4. Apply formulas to calculate totals for current sales as well as projected sales.
   5. Embed a bar chart that accurately displays the total sales for the current year.
   6. Embed a bar chart that accurately displays the projected sales for the next five years.
   7. Embed a line graph that accurately displays the projected sales growth over the next five years.

Specifically, the following critical elements must be addressed:

1. Spreadsheet: Create a spreadsheet that clearly and functionally displays the numerical data provided in the scenario.
   1. For current sales, display sales by category and total.
   2. For projected sales, display sales by category and total.
   3. Apply formatting conventions appropriate for a business audience.
      1. Select a consistent font and font size.
      2. Format the spreadsheet with row and column spacing, row and column alignments, and cell formatting.
      3. Apply labels that identify the values contained in each row and column.
   4. Apply formulas to calculate totals for current sales as well as projected sales.
   5. Embed a bar chart that accurately displays the total sales for the current year.
   6. Embed a bar chart that accurately displays the projected sales for the next five years.
   7. Embed a line graph that accurately displays the projected sales growth over the next five years.