Reference no: EM13948316
Suppose you are an electrical contractor bidding for a job wiring a new office building. The contract will be awarded to the lowest bidder. If you win the contract, profit will be the amount you bid minus the cost of completing the job. You are uncertain about the cost as well as about the bids your competitors will submit. You base-case analysis indicates that the most likely cost to you is $450,000, but it could be significantly higher or lower. After analyzing some more cost scenarios, taking into account various outcomes for price levels, negotiations, with subcontractors and time to complete the job, you estimate the range of costs is $360,000 to $540,000. You will be bidding against two other companies. You feel that competitor #1 is most likely to bid around $600,000, but the possible range could be from $420,000 to $780,000. Competitor #2 is believed to have higher costs. You feel that they are most likely to bid around $650,000, but you feel the range for competitor #2's bid is $400,000 to $1,000,000.
Write formulas in excel that calculate the following:
1. Whether or not you win the contract. Put a 1 in the win/lose cell if you win and a 0 in the win/lose ell if you lose.
2. The associated profit given four inputs: your bid, competitor #1's bid, competitor #2's bid, and your cost. To compute profit if you win, subtract your cost from your bid and multiply the difference by the win/loss cell.
|
Determine average grain size for steel specimen
: Employing the intercept technique, determine the average grain size for the steel specimen whose microstructure is shown in Figure 9.25(a); use at least seven straight-line segments.
|
|
Describe your company products or services
: "Describe your company's products or services. Why should someone buy them over the competition? What want or need do they fulfill?
|
|
Which of the two confidence interval is wider
: What is the margin of error of your estimate of the population mean at a 95% confidence level? Construct a 95% confidence interval for the mean such expenses for all the students.
|
|
Employees progress through four states of change
: Organizations invest sizable amounts every year, why would they spend monies on training and development? Explain
|
|
Write a formula in excel to calculate the problems
: Whether or not you win the contract. Put a 1 in the win/lose cell if you win and a 0 in the win/lose ell if you lose.
|
|
Culture affect an opinion of a public
: Give a present day example of a company facing ethical and moral issues in the press. (i.e. BP) How effectively is the company's PR team handling the crisis? Based on what you've learned from the text and class discussions, what recommendations wo..
|
|
A study of kickstarter projects showed
: A study of Kickstarter projects showed that 54.2% were successful, that is, achieved its goal and raised at least the targeted goal amount. In an effort to identify network dynamics that influences success, projects were subdivided into projects of o..
|
|
What are the benefits of idirect marketing
: What are the benefits of iDirect marketing for both the buyer and the seller? How would the business you chose have directly marketed its product or service ten years ago
|
|
Case study uses operations management functions
: Using the knowledge you have gained from this course, you will write a comprehensive analysis of the Nissan case study we have been analyzing throughout this course by addressing the critical elements below.
|