Develop a general spreadsheet implementation of in term ediate COCOMO. You should include a percent software reusability as part of your general model. Also, input labor and overhead rates to get a total cost model. This model should be general enough to be used as a first-cut software estimating tool. The VLOOKUP function in Excel could be a great help in developing a general model. 7.3 You are developing a new IT application that must operate within a strongly coupled complex environment of hardware, software, and operational procedures. You are in charge of estimating the development and installation costs of the data collection system. Given the following information, estimate the total cost of the system:

1. The system will consist of the following components:

a. Three COTS servers at $9000 each

b. Two COTS sensors at $13,000 each

c. 10 KLOC to integrate the systems

2. Your company uses the following rules of thumb when estimating costs:

a. The total project cost is estimated to be 2½ times the application development costs, which is allocated based on project management (8%), systems engineering (15%), development (40%), test (28%), and services delivery (11%).

b. Engineering costs are billed at $18,000 per month.

c. Software COTS integration is best estimated using the embedded mode and the organic COCOMO, with an effort adjustment factor of 1.33