Problem
The spreadsheet should have a clear title, stating the name of the project, then underneath list your name and title. List each task that you created (and add any changes based on feedback that your instructor may have provided). Research and list 3 sources for labor (local technical service firms will suffice) to determine installation labor rates. Research 3 well-known computer manufacturers to price hardware.
Note: All computers should be from the same manufacturer for consistency and ease of support. These sources should be listed at the bottom of the spreadsheet in the cells provided, you may have to scroll down to see the box. Only one spreadsheet is necessary, multiple tabs are not required here, but clarity of information is most important. A spreadsheet can look intimidating, but it really isn't, even if this is the first time you have seen it. The spreadsheet is really made up of horizontal rows and vertical columns. Each individual rectangle is called a cell or field. We are mostly just typing in this spreadsheet; the calculations are actually very easy for what we are doing and are already built in.
For each task, using the requirements outlined the last module course, provide the following:
Using this provided spreadsheet as a starter file, transfer your task list to the first column. Labor type refers to in-house labor versus contractor labor. If you have a line for devices, you will not need to fill this cell in. Units refers to the number of devices purchased or the number of hours of labor. Do not mix hours and numbers of devices, there should a separate line for devices and a line for labor. If you have a labor rate of $10.00, just type 10 in that cell. Then just type how many hours you think that task will take, based on the requirements and it is automatically calculated for you as the total cost. Do not bother with half hours, just use whole numbers. If you have 10 computers, put in 10 in the Units field and what you find as the price for the Price field, the total price will be calculated for you.