Business Budget
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 you 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-
lnsert a graph or chart displaying total costs graphically-
Label columns/rows with titles reflecting data they contain-