Lymaris Dalian Santiago
ID# AC1404116
CV10 Intro to Computers
Assignment #8 Business Consulting
May 24, 2015
Business Consulting
What formula or function does he put in Column F that will show the total expenses for each day?
=SUM()
In the parenthesis enter the cell letter and number to find total expenses per day. (i.e.) =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()
In the parenthesis enter the cell number and letter to find total expenses per week. (i.e.) =sum(b5:b11)
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
…show more content…
All computers must be running Microsoft operating systems so Bill will have to purchase Microsoft operating computers for his new employees.
2. 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.
Listed are five important concerns for safety and security and recommendations for prevention:
1. Internet and Network Security
Covers malware and hacking techniques.
Recommendation: When browsing always remember to use high level SSL encryption to keep your data safe.
2. Data Loss by Accidents
Caused by problems with data storage devices.
Recommendation: To recover data packets lost in transit; the data loss caused by a computer/server crash can be prevented using a solid backup plan. Data files can be replicated over a remote server as well as on different computers on a network.
3. Misuse of User rights
Users with certain rights may misuse their privileges to steal company data and sell it competitors.
Recommendation: Monitor what files are shared between workgroup networks. You can monitor
For my project, I will be creating the accounting portions of a business plan for a Chickfil-
According to the Patton Fuller hospital’s unaudited balance sheet, their total operating expenses equals 462,293, after subtracting the value of depreciation the total equals 426,257. Dividing 426,257 by 365 equals $1,168 which represents the daily operating amount. Next, the total for cash and cash equivalents must be divided by $1,168 which equals 20, or the days of cash on hand. This indicates that the hospital has 20 days of cash on hand in average and need to slow down on expenditures and utilize cash sparingly.
2.) For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour.
CSEC 630 Lab2 -Intrusion Detection System and Protocol Analysis Lab (n.d.). University of Maryland University College. Retrieved from: https://learn.umuc.edu/d2l/common/viewFile.d2lfile/Database/NzkyMzkw/CSEC630_lab2_LEO.pdf?ou=33745
Worksheet Thomas Gordon Vanessa Best Jason Lechlar Line Item Dollar Value Change Percentage Change Revenues Net Patient Revenue $41391 9.90% Other Revenues $277 9.90% Total Revenues $41668 9.90% Expenses Salaries and Benefits $6623 3.10% Supplies $3238 4.50% Physician and Professional Fees $3311 3.10% Utilities $36 3.10% Other $55 3.10% Depreciation and Amortization (Non-Cash Expenses) $11081 44.40% Interest $111 3.10% Provision for Doubtful Accounts $1414 10.6% Total Expenses $25869 5.90% Operating Income $15799 98.10% Non-Operating Income (Loss) $15597 9.80% Investment Income $326 123.50% Net Income $15473 97.65%
Then to make sure that the value of book tokens does not exceed the budget I decided to have a total cell as well. But when trying to insert the total I had problem doing it effectively in one cell. Therefore I decided to get a total of the pupils from education and sports then add them all up in one cell.
Enter a row for "Total Monthly Expense" under the ITEM column. For Total Monthly Expense row set up the cells under each monthly column with a formula that will use the SUM function to add the amounts and show the result. Enter a Column for “Total” to the right of your last month. Enter a formula using the AutoSum drop-down option on your tool bar and insert the Sum function in the first budget item row, under Total. Then copy this formula down for all the other categories.
Next we find the amount contributed from each Customer to the overall general and selling expenses based on the number of cartons ordered by each. The end result leads us to each customers overall profitability.
The company paid $18,000 on October 1 of the current year to Vantage Property Management. The payment was for 6 months’ rent of Sally Corporation’s headquarters, beginning on November 1.
93). Formulas for addition, subtraction multiplication and division were created to provide accurate information. Overall, these specific spreadsheets were designed to accept the income values for each property, subtract the expenses for this property and calculate the total profit for that property on a monthly basis, as well as provide a year to date summary for both income and expenses.
Types of expense |1 |2 |3 |4 |5 |Total | | | | | | | | | |Gas |$3,600.00 |$3,600.00 |$3,600.00 |$3,600.00 |$3,600.00 |$18,000.00 | |Repairs and Maintenance |$800.00 |$928.00 |$1,048.00 |$1,160.00 |$1,264.00 |$5,200.00 | |Tires | |$760.00 |$760.00 |$760.00 |$760.00 |$3,040.00 | |Insurance |$2,400.00 |$2,400.00 |$2,400.00 |$2,400.00 |$2,400.00 |$12,000.00 | |Registration and taxes |$848.00 |$720.00 |$600.00 |$488.00 |$384.00 |$3,040.00 | |Depreciation |$9,720.00 |$5,832.00 |$3,500.00 |$2,100.00 |$1,348.00 |$22,500.00 | |Purchase
See Excel Model 1.1 In March 2003 PC = $800, QC = 138 hours In March 2003, management feels: $800 PC ↑ by $200 → 30% ↓ QC PC ↓ by $200 → 30% ↑ QC
Security in the age of internet has become a tremendously important issue to provide comfort not only for paranoid people but for many others who are naïve to believe that protection in digital era is essential to communication between millions of people that increasingly used as a tool for commerce.
Grading Notes: You need to provide 18 different risks, identify an impact on business for each, and identify (1) security control to control that risk (your example shows three, however only 1 is required).