Reference no: EM131406577
Assignment: Business Budget
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.
|
Explain the legal requirements of starting a business
: Analyze and develop a framework for sustainability using the triple bottom line (people, planet and profit). Understand the legal requirements of starting a business.
|
|
Database system-relational database architecture
: Accurately definethe terms "database system" and "relational database architecture".
|
|
Draw an e-r diagram for these relations
: Explain the assumptions you made about cardinalities in your answer to part b. Explain why it is said that the E-R data model is more expressive or more semantically rich than the relational data model.
|
|
Web security management
: Research and classify common weaknesses and attacks associated with e-commerce and social networking applications.
|
|
List software operating systems for each device
: List the make and model of desired hardware devices and their cost. List software operating systems and applications for each device and their costs.
|
|
Reducing the physical hardware needed
: Discuss how server virtualization has saved many organizations money by reducing the physical hardware needed. Using Microsoft® Excel® to do your calculations, create a Return on Investment (ROI) analysis comparing the cost of 10 physical servers t..
|
|
How about internal and external threats
: List and Describe the methods firms use to ensure the integrity of their software, their hardware, their networks, and their partners?Was Hardware, Software and Networks addressed?Was Wired and Wireless addressed?How about Internal and External thre..
|
|
What conduct is expected from employees
: What conduct is expected from employees? Your minimum 10 slides should be original work involving your company (or a friend or a relative's).
|
|
Did you articulate how a firm reconciles the risks
: To receive full credit you must satisfy the following criteria:Did you articulate the risks for applying and not applying a software patch, at least 4?Did you articulate how a firm reconciles the risks?
|