Linear Programming

  • Thread starter Thread starter Asif Mian
  • Start date Start date
A

Asif Mian

I am trying to formulate a Linear Programming Problem using SOLVER.
Having some difficulties, can anyone help. The problem is:

I have a works contract for 4 months. The contract requires (a) 9 trucks
in month-1, (b) 11 trucks in month-2, (c) 10 trucks in month-3, and (c)
7 trucks in month-4.

I can lease the trucks on 1-month, 2-months, 3-monts, and/or 4-months
lease. The cost of 1-month, 2-months, 3-months, and 4-months lease is
$3,200; $2,960, $2,580, and $2430, respectively.

What contracting strategy should I adopt in order to minimize costs.

Your prompt response will be very highly appreciated.
 
find the Solvsamp.xls file on your Computer and look at it. You should be
able to adapt one of the samples to this problem.

C:\Program Files\Microsoft Office\OFFICE11\SAMPLES
on my install, so look for the Samples subdirectory somewhere underneath
your Microsoft Office directory.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top