Reference no: EM131404775
Business Budget Assignemnt
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 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.
What is the influence on the correlation
: Plot the data in the table, and discuss the result. Does there appear to be an association? Are there any outliers? If so, what is their influence on the correlation?
|
Water and the implications of drough
: Analysis involves asking an important question. What, for example, are the most important features of a political conflict that generates notice of a relevant issue? Or, which features of a political issue or reform merits change and is signific..
|
What download speed would be idea
: What download speed would be ideal? Upload speed? How would it change how you communicate?
|
Are the cost components in the budget clearly defined
: Individual deliverable - continue work on the project plan by documenting the budget cost components for the marketing-related deliverables. Identify and describe the items that will be included in the budget and how those items will be tracked. R..
|
List the make and model of desired hardware devices
: BIS 221- List the make and model of desired hardware devices and their cost. List software operating systems and applications for each device and their costs.
|
Describe the impact of identified tensions among family
: When planning a family celebration, there is much more to consider than the simple details of guest list, location, food, and activities. Family dynamics must also be considered in order to minimize potential tensions between relationship dissolut..
|
Analysis and evaluation of a manufacturing organization
: GB519: Measurement and Decision Making Assignment. Part 1 of the Project, due at the end of this unit, requires you to complete an analysis and evaluation of a manufacturing organization. This evaluation will also provide the foundation for Part 2 ..
|
Would your answers be different in an academic setting
: Should you put in place a block to prevent access to sites that store huge numbers of streaming videos? As a manager, are there concerns you might have if employees have digital cameras on their cell phones? Would your answers be different in an a..
|
Are there ways to protect your data on mobile devices
: Can viruses attack cell phones? Is there any special software on the market to protect mobile devices from viruses? How much would it cost to equip 20 devices with virus protection?
|