IT100 SNHU NHBP key numerical data spreadsheet you will create a spreadsheet that clearly and functionally displays key numerical data about the organizati
IT100 SNHU NHBP key numerical data spreadsheet you will create a spreadsheet that clearly and functionally displays key numerical data about the organization described in the given scenario. You will need to use formatting conventions, labeling, formulas, and style conventions appropriate for the business audience. IT 100 Final Project 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 three categories: office supplies, office equipment, and printing services.
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).
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:
The total current sales (2016) are $500,000, divided into the following categories:
o
o
o
Office supplies: $150,000
Office equipment: $300,000
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.
Rent
Childcare
Food
Car
Utilities
Total
$
$
$
$
$
$
Monthly Spending 2018
1,200
600
500
300
350
2,950
Current Budget
Make sure your charts
have all necessary
elements (title, legend,
labeled axes, etc.) and
that coloring of each
category is consistent
throughout the three
graphs
$3,500
$3,000
$2,500
$2,000
$1,500
$1,000
$500
Rubric element II.A.:
This information will come
from your final project
scenario. Determine best
number format (type of
number, number of decimals,
etc.)
Remember to name each
worksheet in your workbook
$
Monthly Spending 2018
Rent
Childcare
Food
Car
Utilities
Total
Rubric element II.E.:
Vertical bar chart (AKA column chart) or horizontal bar
chart can be used here
This example uses data on a fictional monthly household budget which expects a 5%
increase in spending for each budget item each year. Use this as a guide to help you
create your own spreadsheet using the data from the final project scenario. Please
post any question you have to your class General Questions forum.
Rubric element II.D.:
Use formulas to calculate projections for each new year (growth rate for each year provided in the final project scenario) and for totals, using best
number format for the data presented
Rent
Childcare
Food
Car
Utilities
Total
Monthly Spending 2018
Monthly Spending 2019
Monthly Spending 2020
Monthly Spending 2021
Monthly Spending 2022
Monthly Spending 2023
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
1,200.00
600.00
500.00
300.00
350.00
2,950.00
1,260.00
630.00
525.00
315.00
367.50
3,097.50
1,323.00
661.50
551.25
330.75
385.88
3,252.38
1,389.15
694.58
578.81
347.29
405.17
3,414.99
Projected Monthly Budget
1,458.61
729.30
607.75
364.65
425.43
3,585.74
1,531.54
765.77
638.14
382.88
446.70
3,765.03
Budget Growth
$4,000
$4,000
$3,500
$3,500
$3,000
$3,000
$2,500
$2,500
$2,000
$2,000
$1,500
$1,500
$1,000
$1,000
$500
$500
$
$
Monthly
Spending 2018
Monthly
Spending 2019
Rent
Monthly
Spending 2020
Childcare
Food
Monthly
Spending 2021
Car
Utilities
Monthly
Spending 2022
Total
Rubric element II.F.:
Vertical bar chart (AKA column chart) or
horizontal bar chart can be used here
Monthly
Spending 2023
Monthly Spending Monthly Spending Monthly Spending Monthly Spending Monthly Spending Monthly Spending
2018
2019
2020
2021
2022
2023
Rent
Childcare
Food
Car
Rubric element II.G.:
Line graph used here
Make sure your charts have all necessary elements (title, legend, labeled axes, etc.) and that coloring of each
category is consistent throughout the three graphs
Utilities
Total
Purchase answer to see full
attachment
