Business Budget using excel

User Generated

sngqnqql

Business Finance

Description

Purpose of Assignment

Electronic spreadsheets are useful tools, especially when creating a business budget. Once a spreadsheet is set up correctly in Excel®, values can be modified at any time, and the electronic spreadsheet will automatically update itself. Students will create a spreadsheet of computer equipment for a small fictional business where they are the owner. They will include the cost of all hardware and software needed for their employees, and calculate a monthly budget for the equipment.

Assignment Steps

Resources:

  • Research hardware and software to satisfy operational requirements described above
  • Microsoft Office 365, Office 2016: Introductory: Module 1: Creating a Worksheet and a Chart
  • Microsoft Office 365, Office 2016: Introductory: Module 2: Formulas, Function, and Formatting

Scenario: Imagine you are the owner of a small internet business where you employ five people. You need to budget for the cost of hardware and software needed to run company operations. Each employee is required to work both in the office and remotely, and needs access to company data at all times.

Choose the hardware and software that will provide your employees with the ability to stay connected to internal company data, communicate and collaborate with coworkers, and process data and sales information using wording, processing, and spreadsheet software applications.

Create a business budget sheet using Microsoft® Excel®. In the budget sheet, do the following:

  • List the make and model of desired hardware devices and their cost.
  • List software operating systems and applications for each device and their costs.
  • Sum up the cost for both hardware and software for each employee, and then calculate the average monthly costs to maintain these systems.
  • Insert a graph or chart displaying total costs graphically.
  • Label columns/rows with titles reflecting data they contain.
  • Use no more than two sheets in one workbook to display required data.
  • Format data to highlight important totals.

The Budget sheet answers should include 1,400 words.

Note: this assignment only requires that you submit an Excel® Workbook file. There are no written or APA guideline requirements.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Sorry to worry you.

Running head: PROJECT BUDGET: SMALL INTERNET BUSINESS

Project Budget: Small Internet Business
Name
Professors Name
Institution Affiliation
Submission Date

1

PROJECT BUDGET: SMALL INTERNET BUSINESS

2

Table of Content
Scalable IT Solution ........................................................................................................ 3
Project Budget ............................................................................................................................. 4
Small Internet Business................................................................................................... 5
Project Product Cost ................................................................................................................... 6
Hardware ......................................................................................................................... 7
Hardware Cost Budget ................................................................................................................ 8
Software .......................................................................................................................... 9
Software Cost Budget ................................................................................................................. 9
Project Ratio.................................................................................................................. 10
Product Cost Ratio .................................................................................................................... 10
Conclusion .................................................................................................................... 10
References .................................................................................................................... 11
Appendix ....................................................................................................................... 13
Typical IT Project Budget ......................................................................................................... 13
Budget Breakdown.................................................................................................................... 14
Project Ratio.............................................................................................................................. 14

PROJECT BUDGET: SMALL INTERNET BUSINESS

3

Scalable IT Solution
Upon completion of developing a scalable information technology network, a small internet
business will spend roughly $87,237.85 for their IT infrastructure project. The company will
need to acquire both hardware and compatible software that ensures networking resource
availability and connectivity. The budgeting expense1 for a building a functional information
technology systems includes hardware and software cost per units, amounts of units needed, cost
associated with products, product descriptions and the unit purposes. The small internet business
with five employees connecting to internal resources through public and private domains
requires safeguards such as technical, physical and administrative controls incorporating
software and hardware configurations. Facilitating connections between users and IT resources is
the use of a third party internet service provider monthly contracted cost, which is also budgeted.
Total units, total units cost, and total project cost is furthered calculated to represent a percentage
of the overall project amount.

See Appendix
1
Typical Seven Domain IT Project Budget

PROJECT BUDGET: SMALL INTERNET BUSINESS

4

Project Budget
ITEM

Hardware/Software

Product

Employee/Employees

Software

User Management
Controls

$500.00

1

$500.00

Technical & Physical
Control

Hardware

UAP Policy
Development

$5,000.00

1

$5,000.00

iMac

Hardware

27-inch iMac with
Retina 5K display

$2,999.00

5.00

$14,995.00

Microsoft Office
Business- Annual
Subscription

Software

Office
Professional 2016

$399.99

5.00

$1,999.95

Switch’s & Hub

Hardware

Cisco Catalyst
2960-L

$2,399.99

2.00

$4,799.98

Internet Service
Provider (ISP)

Software

$249.95

1.00

$249.95

Ethernet Hardware

Hardware

$1,299.99

1.00

$1,299.99

Encryption

Software

$945.00

1.00

$945.00

IDS/IPS Hardware

Hardware

$2,349.00

1.00

$2,349.00

Firewalls

Hardware/Software

$4,999.99

2.00

$9,999.98

Router/s

Hardware

Cisco 4000 Series
Router

$1,259.00

1.00

$1,259.00

Server Application

Software

IBM WebSphere
Application Server

$16,000.00

2.00

$32,000.00

Servers

Hardware

Fujitsu SPARC
M12 Servers

$2,500.00

3.00

$7,500.00

Remote Access
Server

Hardware

Cisco AS5300
Remote Access
Server

$390.00

1.00

$390.00

Cloud Technology

Software

Oracle Cloud

$3,950.00

1.00

$3,950.00

$39,741.91

28.00

$87,237.85

Business Project
Total

Comcast Business
Deluxe 150
Service
Cisco Catalyst
6500 16-Port 10
Gigabit Ethernet
Copper Module
Symantec
Endpoint
Encryption
Cisco IOS
Intrusion
Prevention System
(IPS)
Cisco ASA5525
ASA5525-K9
Security Firewall
Appliance

Cost

Units/ Amount

Unit Total Cost

PROJECT BUDGET: SMALL INTERNET BUSINESS

5

Small Internet Business
The smal...


Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Content

Related Tags