Reference no: EM131382167
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 should be 1,400 words.
Note: this assignment only requires that you submit an Excel® Workbook file. There are no written or APA guideline requirements.
|
Organisation use of templates and macros
: After undertaking a regular review of the organisation's use of templates and macros, Kim has become concerned that employees are not using templates and macros properly.
|
|
How to implement fundamental selling skills
: Bob has been working as a salesman at the same company for over 5 years, but has yet to receive the title of the Best of the Best like his friend, Bill. Bob considers himself good because he knows a lot about his company and how to implement funda..
|
|
What are the five practices of exemplary leaders
: What are the Five Practices of Exemplary Leaders? How can you best utilize assessment tools to develop your leadership style? Please frame in terms of valid assessments.
|
|
Calculate the maximum load p
: Calculate the maximum load P that may be applied on the Y-Y axis at the outside face of the flange without exceeding the maximum compressive stress of 20,000 psi.
|
|
Calculate a monthly budget for the equipment
: 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.
|
|
Why facts you presented did not meet legal requirements
: Then, based on the materials in the reading and lecture, explain why the facts you presented did or did not meet the legal requirements for a contract. Be sure to support your response.
|
|
Calculate the force p that may be applied the frame
: Calculate the force P that may be applied to this frame if the allowable stresses at section A-A are 6000 psi tension and 10,000 psi compression.
|
|
What will you do to overcome them in the future
: Before any nursing plan of care or intervention can be implemented or evaluated, the nurse assesses the individual through the collection of both subjective and objective data. The data collected are used to determine areas of need or problems to ..
|
|
What are the steps in the quality improvement model
: What are the steps in the quality improvement model and how is benchmarking involved? What are the stages in which data quality errors found in a health record most commonly occur
|