Reference no: EM131431435 , Length: word count:1400
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 answers should include 1,400 words.
|
Calculate the dividend payout and dividend yield
: FINA 6001 Managing Finance Assignment. Provide answers to the following: Report the dividend payments over the last three years and Calculate the dividend payout and dividend yield
|
|
Explain factors in the organizations external environment
: Specify the nature, structure, and types of products or services of Apple, and identify two key factors in the organization's external environment that can affect its success.
|
|
What is the businesss current market value
: MBA 520- What does your assessment imply for future business health and performance? For example, what is the business's current market value? What is its price-to-earnings ratio?
|
|
What sampling method is used to select your sample data
: Statistics for Business and Finance (BUS5SBF). In this assignment you will be analysing and interpreting household data. Organise your sample data in a spreadsheet as per the instructions in the Excel sheet. What sampling method is used to select you..
|
|
List the make and model of desired hardware devices
: 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 w..
|
|
What percent of problems take more than five minutes
: What percent of the problems take more than 5 minutes to resolve? Suppose we wish to find the middle 50% of the problem-solving times. What are the end points of these two times?
|
|
Organizational learning and creativity play
: How does organizational learning and creativity play in helping managers to improve their decisions?
|
|
Discuss the importance of understanding cultural differences
: Discuss three nonverbal differences you might encounter if you are transferred to manage a company in Rio de Janeiro, Brazil. Discuss the importance of understanding cultural differences when negotiating with people in another country.
|
|
Human resource function or process
: Articulate a human resource function or process within the selected global organization. Analyze the influences the selected HR function or process has on achieving the organization's strategy. Does the function or process align with the organizati..
|