Assignment

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 word 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.(Systems Unit, Printers, Monitors, Keyboards, Mouse and other necessary peripherals)

• List operating systems for each device and the related costs.

• List the Application Software for each device and the related costs.

• Sum up the cost for both hardware and software for each employee, and then calculate the average monthly costs to maintain these systems as total System Price/60.

• 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.