Suppose you work for a company that will install the FlexTime network. Assume that you have been given the task of creating spreadsheets to generate cost estimates, not just for FlexTime, but for many different clients.

a. Create a spreadsheet to estimate hardware costs. Assume that the user of the spreadsheet will enter the number of pieces of equipment and the standard cost for each type of equipment.
Assume that the networks can include the following components: NIC cards; WNIC cards; wireless access points; switches of two types, one faster, one slower, at two different prices; and routers. Also assume that the company will use both UTP and optical fiber cable and that prices for cable are stated as per foot.
Use the network in Figure 6-2 as an example.

b. Modify your spreadsheet to include labor costs. Assume there is a fixed cost for the installation of each type of equipment and a per foot cost for the installation of cable.

c. Give an example of how you might use this spreadsheet for planning network installations.
Explain how you could adapt this spreadsheet for project tracking and billing purposes.

Transcribed Image Text:

Employee ID First Name Last Name Department Computer Jane Ashley Mkt Serial Number - 100 Dell 800 HP Brand Purchase Cost $1,750 $750 Record: 1 of 2 No Filter Search Operating System Vista Windows XP