What formula or function does he put

Assignment Help Business Management
Reference no: EM13804447

Assignment: Business Consulting

Remember Bill? He was the gentleman that you helpedto start up his business. Well his business is doing well, but he has come to you with some questions and concerns. You discuss each of these with Bill and promise to send him a written report with your suggestions and recommendations. Submit your written response to Bill's questions and concerns below.

1. Bill has set up a spreadsheet in Excel that will help him keep track of expenses. So far, he has this:

1968_bills.png

Tell Bill how to do the following tasks:

• What formula or function does he put in Column F that will show the total expenses for each day?

• What formula or function does he put in columns B through F in Row 13 that will give him the total expenses for the week in each category?

• Bill wants the entry in Column G to remind him of expenses that require receipts for the accountant. Tell Bill what to put in Column G to do this:

a. Print the word "Yes" in any row where the total daily expenses are greater than or equal to $100.00.

b. If the daily expenses total is less than $100.00, leave the Column G entry for that row blank.

2. Bill's business is already expanding. He thinks that in a few weeks, he will need to hire one or two employees to help him. He knows that each new employee will need their own computer. He is also making the necessary changes so that the new employees will be working in a spare room in Bill's house. Explain to Bill what networking options he has. Go through each type or configuration of network possible for him, making sure that you explain the pros and cons of each configuration. Finish with your suggestion for the network that he should set up and explain what new hardware will be required to do this.

3. With the possibility of three business computers in his home, and all of his business records possibly vulnerable, this would be a good time to advise Bill on how to set up a routine plan to protect and defend his new network. Provide a list of the five most important concerns for safety and security of the network and the computers in the network. For each concern, specify the action to be taken, and if applicable, what software you recommend be added to the system. Justify each of your recommendations.

Reference no: EM13804447

Questions Cloud

Evaluation of an active portfolio management strategy : How is the Sharpe measure different from the Treynor measures of portfolio performance evaluation? What is the problem with using the Sharpe measure for evaluation of an active portfolio management strategy?
Deviation of returns on the following two asset portfolio : What is the standard deviation of returns on the following two asset portfolio?
Discuss the mutual fund theorem : Discuss the advantages and disadvantages of common stock ownership, relative to other investment alternatives? Discuss the mutual fund theorem? Discuss rate anticipation waps as a bond portfolio management strategy?
What is the role of tourism policy : 1. What is the role of tourism policy? Why is it important? Give 3 examples of different types of tourism policies. 2. Define sustainable tourism? What is the significance of the concept in the 21st century?
What formula or function does he put : Remember Bill? He was the gentleman that you helpedto start up his business. Well his business is doing well, but he has come to you with some questions and concerns. What formula or function does he put in Column F that will show the total expense..
Presentation an content of information : 1) On the Internet find, examine, and provide the web addresses of 3 T&T news sites. 2) Comment on the presentation an content of information.
Prepare income statement and retained earnings statement : These financial statement items are for below Corporation at year-end, Instructions (a) prepare an adjusted trial balance. Then use adjusted tiral to prepare income statement and a retained earnings statement for the year. Above Corporation did not i..
Short commentary on the poem : Write a short commentary on the poem "The Triple Fool" by John Donne answering the following question: How do specific motifs (patterns) in the poem help to present ideas or impressions that are central to the work?
Compute the standard deviation of this portfolio : An equally weighted portfolio consists of 33 assets which all have a standard deviation of 0.21. The average covariance between the assets is 0.101. Compute the standard deviation of this portfolio. Please enter your answer as a percentage to three d..

Reviews

Write a Review

 

Business Management Questions & Answers

  Organizational culture and organizational effectiveness

Organizational Culture and Organizational Effectiveness - In what ways can organizational culture increase organizational effectiveness?

  Show the value of security and control

Value of Security and Control - Explain what is the business value of security and control

  Describe the artifacts that define the culture at southwest

describe the artifacts that define the culture at southwest airlines.using the internet library andor personal

  Pacific banks startup division establishes new branch banks

pacific banks startup division establishes new branch banks. each branch opens with three tellers. total teller cost

  State financial information is reported in real sec filings

The general objective of the project is to provide an opportunity for you to see how financial information is reported in real SEC filings. The primary focus is on ACC 100C topics and how they are reported in the financial statements and footnoted..

  What are the answers to the vega food company case

What are the answers to The Vega Food Company Case in Family Business book by Ernesto Poza and Mary S Daugherty.

  Analyze the situation using hofstede''s original four dimen

1.Individually: Select a situation that is currently in the news that involves two or more cultures. Analyze the situation using Hofstede's original four dimensions, plus the universalism/particularism and task/relationship dimensions.

  Develop a public relations campaign

Develop a public relations campaign for a financial services company which will provide services to customers via the internet as well as have regional offices in 5 states.

  Create a professional development plan

Create a professional development plan to address the characteristics of the Learning Team members both individually and as a group and your ability to lead them

  Hospitality management questions1 describe the components

hospitality management questions1. describe the components of effective communication2. how do effective communication

  Market commonality and resource similarity

Determine what additional steps Apple's competitors are likely to take and how Apple will most likely respond. Explain your rationale.

  What is the relationship between transportation resource

What is the relationship between Transportation Resource Planning solutions and ERP solutions

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd