Imagine you are working as a computer support technician for a large company and your boss needs help. He has to create a spreadsheet to present to the Chief Technology Officer showing the financial information for your department and how much you spend on buying new and upgraded software and equipment.
He has the data, but does not have time to create the presentation. He sends you the Excel file with all the data and asks you to perform the calculations and make it look good.
Create a file with financial information for each month of one year. Include the following categories:
software expenses
hardware expenses
labor costs (employee salaries)
training costs
office expenses
It is okay to create dummy data for this file.
Format the data using a general format, a number format, an accounting format, and a currency format to see if there are any differences.
Copy the data onto two worksheets, one labeled 2012 and one labeled 2011. Working with either set of data, calculate the following information:
total expenses in each of the five categories
total expenses for each month
expenses in each category for each month
total costs for computer related items for each month
total costs for staff and training for each month
Your boss did not tell you how the CTO wants to see the data. So create one or more charts showing a breakdown of expenses by month. Use colors, shapes, and labels to make the charts. Also create one or more tables showing a breakdown of expenses by month. Use highlighting and formatting to create a readable table. Format each in a way that is visually appealing and tells the proper story of the data.
Answer: In summary, computers should be on a regular update and replacement schedule — update your software at least once a month, and replace your hardware at least every 5 years or
