Reference no: EM131417748
Business Budget Assignment
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.
|
Organizational risks in a merger or acquisition situation
: What are some policies that could be put into place to mitigate the organizational risks in a merger or acquisition situation?
|
|
How ethics apply to professional responsibilities
: How the critical thinking process relates to your appraisal and recommendations for more community outreach and diversity in your organization. How ethics apply to professional and societal responsibilities
|
|
Discuss three major aspects of industrialization
: Discuss three (3) major aspects of industrialization between 1865 and 1920. In your response, consider society, the economy, and politics
|
|
Common errors made in research papers
: What is "clutter?" Why must you eliminate "clutter" in your paper and What are the ten most common errors made in research papers? Discuss methods you can use to avoid these errors in your own paper.
|
|
Prepare a business budget sheet using microsoft excel
: BIS/22- 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.
|
|
How does social wellness relate
: This assignment will be a personal reflection journal; you must include your reaction to the unit content (social wellness) and how the unit content relates, affects, and applies to you. Address the following question: How does social wellness rel..
|
|
E-business and e-commerce
: Using the Internet or Strayer online database, research at least three (3) recent examples, within the past five (5) years, of data breaches in which hackers stole customer data of companies that conduct business online.
|
|
Conduct research on an artist from any movement
: Conduct research on an artist from any movement that you find interesting. Choose one of their works. Analyze the image using the four visual cues from your reading: color, form, depth, and movement. Explain how the artist makes use of these four ..
|
|
Select an actor or actress of your choice
: In your opinion, is acting considered a "good" profession (regardless of the gender) or does it still have a taint of immorality attached to it?
|