Develop a general spreadsheet implementation

Assignment Help Econometrics
Reference no: EM131045204

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

Reference no: EM131045204

Questions Cloud

Dividends are expected to grow at an annual rate : Last year the black water inc paid dividends $3.24. Company's dividends are expected to grow at an annual rate of 5% forever. The company's common stock is currently selling on the market for $52.68. The investments banker will change flotation costs..
The various privileges to defamation suits : Explain the application of the various privileges to defamation suits and how they are affected by whether the plaintiff is (a) a public figure, (b) a public official, or (c) a private person.
Problem regarding the diastolic blood pressure : Diastolic blood pressures are assumed to follow a normal distribution with a mean of 85 and a standard deviation of 12. What is the probability that a randomly selected individual has a diastolic blood pressure less than 90?
Write a literature review anout influential leadership : Write a literature review anout Influential Leadership. The paper is to be your original work and written solely for this course.
Develop a general spreadsheet implementation : Software COTS integration is best estimated using the embedded mode and the organic COCOMO, with an effort adjustment factor of 1.33
What is the maximum price that you would pay for share : You are considering the purchase of Zee Company stock. You anticipate that the company will pay dividends of $3.50 per share next year and $4.00 per share the following year. You believe that you can sell the stock for $20.00 per share two years from..
Familiarize students with the concepts of brand promotion : Brand promotion technique can benefit an organization by increasing its sales or hitting competitive brands may leave a negative impression on the customers?
What is the value of share of common stock : Diana Ltd. paid a $2.50 per share dividend yesterday. The dividend is expected to grow at 10 percent per year for the foreseeable future. Diana Ltd. has a beta of 1.6, a standard deviation of returns of 30 percent, and a required return of 18%. What ..
The business of manufacturing chemical refractories : Basic, Inc., was a publicly traded company engaged in the business of manufacturing chemical refractories for the steel industry. Beginning in September, Combustion Engineering, Inc., and Basic began discussions concerning the possibility of a mer..

Reviews

Write a Review

Econometrics Questions & Answers

  Recalculate the values of the four variables listed

A firm currently uses 50,000 workers to produce 200,000 units of output per day. The daily wage per worker is $80, and the price of the firm's output is $25. The cot of other variable inputs is $400,000 per day. Assume that total fixed cost equals..

  What amount would the two transactions added

Assume that a grower of flower bulbs sells its annual output of bulbs to an Internet retailer for $80,000. The retailer, in turn, brings in $125,000 from selling the bulbs directly to final customers. What amount would these two transactions added..

  Determine the output and price under a cournot equilibrium

Consider a market for a homgeneous product with demand given by Q = 37.5 - .25P. There are two firms, each with a constant marginal cost equal to 40. a. Determine the output and price under a cournot equilibrium.

  What is the operating cash flow at the level of output

A project has a contribution margin of $5, projected fixed costs of $12,000, a projected variable cost per unit of $12, and a projected present value break-even point of 5,000 units. What is the operating cash flow at this level of output

  Discoveries of your teams efforts this week

Write a 200-word summary discussing the challenges, milestones and discoveries of your teams efforts this week. Feel free to discuss task assignment however your summary should be based on reflection of collaboration and not exclusively on projec..

  What will happen to the price of the bond

Suppose that interest rates are 6 percent in the economy and a safe bond promises to pay $3 per year in interest forever. Interest rates suddenly fall to 3 percent. What will happen to the price of the bond that pays $3 per year

  Consider the following situation in the country as labor

consider the following situation in the country as labor market if the wage is w 700 workers will provide l 10 units

  What is the marginal cost of the 101st unit of output

In a short run, a firm's total costs of producing the hundredth unit of output equals $10,000. If it produces one more unit, its total cost will increase to $10,150. a. What is the marginal cost of the 101st unit of output

  Compute the predicted annual sales of the chrysler

quantity of Chrysler Crossfires sold annually, PC is the price of a Chrysler Crossfire, M is average household income, PBMW is the price of BMW's 330i sports sedan, and PP is the price of Porsche's Boxster S sports car. The marketing team at Chrys..

  Calculate the output of each firm

A duopoly faces a market demand of p=120-q. Firm 1 has a constant marginal cost of MC1=20. Firm 2's constant marginal cost is MC2=40. Calculate the output of each firm, market output, and price if there is a Stackelberg equilibrium with firm 1 as t..

  Describe the events that could create the sequence

an economy has an unemployment rate of4 percent and an inflation rate of 5 percent a year at point A on a graph. Some events occur that move the economy in a clockwise loop from A to B to D to C and back to A.

  How to determine the industrys market structure

Suppose that the market price for a bottle of vitamins is $2.50 and that at that price the total market quantity demanded is 75,000,000 bottles. How many firms will there be in this industry d.Suppose that, instead, the market quantity demanded at ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd