Share
Explore BrainMass

Explore BrainMass

  1. Statistics
  2. Probability
  3. 345448

Model to optimize number of possible bids given budgets

The attached files provide a definition of the problem, especially the powerpoint slide.

Given the information, I am trying to develop a linear programming model such that I maximize the number of possible bids given the limited resources of budgets and writers. Essentially, which of the 10 bids should I take on, given the limitations of availability and cost of writers.

I am assuming all bids are released for bid at the same time and are due at the same time over a 4 week period.

Attachments

Solution Preview

Please see attached files(s)

NOTE: There are 1 worksheet in the Excel file

I took into account the probability of the bid's success on the expected estimated profit

I also assumed that the problem at hand is only for 4 weeks, hence the constraint I defined for the labor requirements.

PROBLEM

I have ten targets
Project Project
Value
($) Probability of Success Estimated
Bid Cost ($) Allowed
Labor ($) Estimated Project Profit ...

Solution Summary

A linear programming model to optimize a number of possible bids given budgets are examined.

$2.19

Related Solutions

B2B vs. B2C

... resource planning (ERP) model to optimize the buying ... In this model, an ERP system
will prepare a ... is specified by a product identification number, some brief ...

Corporate Finance - Management

... with more and more different issues within the model. ... is its use in planning to optimize
operations and ... Scenario analysis analyzes a limited number of outcomes ...

Outline for capital budgeting paper

... A number of authors have noted that the ... simultaneously using a bivariate probit model
with selection ... Unfortunately, our numerical optimization routines did not ...

Budgeting Material and Labor Resources

... you assign resources, Project determines the number of person ... to review the cost
totals, optimize the budget ... high-level top-down business modeling contains more ...

Financial question

... The biggest advantage of this model is the fact ... continuous shifting in the portfolio
to optimize return to ... it is diversifiable if large number of securities ...

Creating Value Through E-business Strategy

... http://www.ashesh.com.np/optimization-for-yahoo-yahoos ... The company also uses the
"reverse auction model" which is also being used in a number of companies. ...