List the make and model of desired hardware devices

Assignment Help Accounting Basics

Reference no: EM131898218

Question: 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.

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

Save this document as Lastname_BusinessBudget_W3.xls.

Reference no: EM131898218

Questions Cloud

Hr roles in the strategic planning process : Have you ever seen a TED talk or other academic video about examining HR's roles in the strategic planning process?

Identify three potential kinds of ddos attackers : The purpose of this exercise is to think critically about ethical considerations for an IT-related scenario on denial-of-service attacks.

Effectiveness and efficiency of organization : What can you tell me about human resource planning -- in regards to it being a key factor in ensuring the effectiveness and efficiency of organization.

Explore type of market in which select product will compete : Explore the type of market in which your selected product will compete, along with an analysis of competitors and customers.

List the make and model of desired hardware devices : Purpose of Assignment: Electronic spreadsheets are useful tools, especially when creating a business budget. Once a spreadsheet is set up correctly in Excel.

Prepare a formal report to identify new techniques : You have been asked to prepare a formal report to identify new techniques and best practice that could be adopted to improve how key processes are monitored

Operations employees loyal to the organization : Choose training and/or development programs to implement in order to keep operations employees loyal to the organization.

What items are typically included in a job description : What items are typically included in a job description? What items are not shown?

Multilevel and strategic recruiting : What can you tell me about: Multilevel and Strategic Recruiting: Where Have We Been, Where Can We Go From Here?

User Account

All Pages