Question

In: Statistics and Probability

The Rogers Construction Company is trying to decide whether to make a bid on a project...

The Rogers Construction Company is trying to decide whether to make a bid on a project against 4 competitors. The lowest bid will win the contract and be paid the amount they bid. It believes it will cost the company £10,000 to complete the project (if it wins the contract) and £350 to prepare the bid. Based on historical data, Rogers believes each competitor’s bid has a normal distribution with mean £15,000 and standard deviation £1,500.

a) Set up a simulation model in excel to help the company make the decision of how much to bid.

b) Discuss on the obtained results and make suggestions. For example, what if the competitor’s bid has different distributions?

Solutions

Expert Solution

SOLUTION:

From given data,

The lowest bid will win the contract and be paid the amount they bid. It believes it will cost the company £10,000 to complete the project (if it wins the contract) and £350 to prepare the bid. Based on historical data, Rogers believes each competitor’s bid has a normal distribution with mean £15,000 and standard deviation £1,500.

standard deviation = £1,500

mean = £15,000

a) Set up a simulation model in excel to help the company make the decision of how much to bid.

Simulation model for 500 trials is following:

EXCEL FORMULAS:

B3 =NORMINV(RAND(),15000,1500) copy to B3:E502

F3 =MIN(B3:E3) copy to F3:F502

I3 =AVERAGE(F3:F502)

I7 =SUM(I3:I6)

b) Discuss on the obtained results and make suggestions. For example, what if the competitor’s bid has different distributions?

Recommended bid amount = $ 13,407

This decision will result in estimated profit of $ 3,057

If the competitor's bid has different distributions,

the simulation model will be modified to incorporate distribution of each competitor's bid.


Related Solutions

You are trying to decide whether to bid on a construction contract for a new bridge...
You are trying to decide whether to bid on a construction contract for a new bridge in South Carolina. You think that it will take 36 months to build and that construction costs will be $2 million per month. You expect tolls to be $10 million per year once the bridge opens, which will be offset by toll collection and maintenance costs of $2 million per year. Your (minimally acceptable rate of return) MARR is 15% per year. To bid...
A company is trying to decide whether to bid for a certain contract or not. They...
A company is trying to decide whether to bid for a certain contract or not. They estimate that merely preparing the bid will cost $10000.If their company bids, then they estimate that there is a 50% chance that their bid will be put on the “short-list;” otherwise their bid will be rejected. Once “short-listed” the company will have to supply further detailed information (entailing costs estimated at $5000). After this stage their bid will either be accepted or rejected. The...
You are trying to decide whether to accept or reject a project. The project will generate...
You are trying to decide whether to accept or reject a project. The project will generate a cash flow of $15,000 in year one; $25,000 in year two; $20,000 in year three; and $4,000 in year four. The project costs $40,000 initially. The firm has a weighted average cost of capital of 8%. Your firm generally accepts projects that payback in three years or less. What is the discounted payback of the project? Should you accept or reject the project?
X Company is trying to decide whether to continue using old equipment to make Product A...
X Company is trying to decide whether to continue using old equipment to make Product A or replace it with new equipment that will have lower operating costs. The following information is available: The new equipment will cost $55,000. Disposal value at the end of its 5-year useful life will be $6,000. The old equipment was purchased 3 years ago for $24,000. It can be sold immediately for $5,000 but will have zero disposal value in 5 years. Maintenance work,...
X Company is trying to decide whether to continue using old equipment to make Product A...
X Company is trying to decide whether to continue using old equipment to make Product A or replace it with new equipment that will have lower operating costs. The following information is available: The new equipment will cost $45,000. Disposal value at the end of its 6-year useful life will be $6,000. The old equipment was purchased 3 years ago for $20,000. It can be sold immediately for $10,000 but will have zero disposal value in 6 years. Maintenance work,...
X Company is trying to decide whether to continue using old equipment to make Product A...
X Company is trying to decide whether to continue using old equipment to make Product A or replace it with new equipment that will have lower operating costs. The following information is available: The new equipment will cost $45,000. Disposal value at the end of its 6-year useful life will be $7,000. The old equipment was purchased 3 years ago for $21,000. It can be sold immediately for $5,000 but will have zero disposal value in 6 years. Maintenance work,...
X Company is trying to decide whether to continue using old equipment to make Product A...
X Company is trying to decide whether to continue using old equipment to make Product A or replace it with new equipment that will have lower operating costs. The following information is available: The new equipment will cost $48,000. Disposal value at the end of its 6-year useful life will be $7,000. The old equipment was purchased 3 years ago for $25,000. It can be sold immediately for $5,000 but will have zero disposal value in 6 years. Maintenance work,...
X Company is trying to decide whether to continue using old equipment to make Product A...
X Company is trying to decide whether to continue using old equipment to make Product A or replace it with new equipment that will have lower operating costs. The following information is available: The new equipment will cost $53,000. Disposal value at the end of its 6-year useful life will be $6,000. The old equipment was purchased 3 years ago for $20,000. It can be sold immediately for $5,000 but will have zero disposal value in 6 years. Maintenance work,...
X Company is trying to decide whether to continue using old equipment to make Product A...
X Company is trying to decide whether to continue using old equipment to make Product A or replace it with new equipment that will have lower operating costs. The following information is available: The new equipment will cost $51,000. Disposal value at the end of its 5-year useful life will be $5,000. The old equipment was purchased 3 years ago for $22,000. It can be sold immediately for $5,000 but will have zero disposal value in 5 years. Maintenance work,...
X Company is trying to decide whether to continue using old equipment to make Product A...
X Company is trying to decide whether to continue using old equipment to make Product A or replace it with new equipment that will have lower operating costs. The following information is available: The new equipment will cost $47,000. Disposal value at the end of its 5-year useful life will be $5,000. The old equipment was purchased 3 years ago for $23,000. It can be sold immediately for $5,000 but will have zero disposal value in 5 years. Maintenance work,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT