Business Consulting

Business Consulting
Name
Institutional Affiliation
Bill has set up a spreadsheet in Excel that will help him keep track of expenses. So far, he has this:

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? =Sum(B5:E5)
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? =Sum(F5:F11)
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:
Input the word “Yes” in any row in which the total daily expenses are greater than or equal to $100.00. Rows G6 and G9 are yes
If the daily expenses total is less than $100.00, abandon the Column G entry for the row blank. In this case, Row G5,G7,G8,B10, and B11 are all blank.
With Bill’s business expanding, he understands that there is a need to hire more employees, get additional computers for them and provide a room in his house for them. Explain to Bill the network options available, the pros and cons associated with each configuration and the networks required to;
• Make internet connection-Phone companies provide good internet connections with options such as Digital Subscriber Line and Cable connections. There are pros and cons associated with each option (“Infosec – Securing Your Company Network” N.p). The pros of DSL include; fast access to internet and phone lines and the cons are unavailability in remote areas and slow transmission.

The pros of cable include access to a connection that is not based on distance from the central provider while the cons are slow performance, high costs and unavailability in remote areas.
• WIFI networks-They offer an alternative option that encourages worker mobility and are less expensive. WPA2 security helps to protect against eavesdropping.
• Small Business Phone systems-they provide systems that are manageable via a web browser and are less expensive
• Network printers- They provide functions necessary in an office set up. Most printers have an inbuilt Wi-Fi. However models with Ethernet connection such as HP Officejet 7600 plus provides a more reliable connection.
The possibility of having three computers present challenges regarding protecting and defending Bills network. Advice Bill on the best safety and security networks for his computer connection and justify your recommendations on the best available software.
Weak passwords: 52% of people use weak passwords on computers. Make use of strong passwords and make changes every 90 days (“Infosec – Securing Your Company Network” N.p).
Put a strong firewall such as Comodo to help protect your network.
Secure your laptops: Make use of encrypted software to protect data on laptops.
Backup regularly: Regular backups in external hard disks help store and protect data.
Educate your employees: Employee education of safe online habits helps to protect the company’s data.
References
“Infosec – Securing Your Company Network.” Infosec.gov.hk. N.p., 2018. Web. 10 Aug. 2018.