linear programming

Project Description:

provide answer in excel using solver add in

the composite rotorblade company (crc) is gearing up for the new v-280 helicopter contract. currently crc has 100 equally qualified workers. over the next three months crc has made the following commitments for blade production:

month blade production
may 20
june 24
july 30

each employee can either work in the factory or can train new recruits. a new recruit can be trained to be an apprentice in one month. the next month, he, himself, becomes a qualified worker (after two months from the start of training). each trainer can train two recruits. the production rate and salary per employee is estimated below.

employee production rate (blades/month) salary per month
production .6 $3,000
trainer .3 $3,300
apprentice .4 $2,600
recruit .05 $2,200

at the end of july, crc wishes to have no recruits or apprentices but have at least 140 full-time workers. formulate and solve a linear program for crc to accomplish this at minimum total cost.
Skills Required:
Project Stats:

Price Type: Negotiable

Completed
Total Proposals: 6
1 Current viewersl
42 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 0.0
    3 Jobs 0 Reviews
    $20 in 1 Day
  • 4.5
    355 Jobs 236 Reviews
    $15 in 1 Day
  • 4.9
    95 Jobs 45 Reviews
    $15 in 1 Day
  • 4.9
    303 Jobs 181 Reviews
    $20 in 1 Day
  • 5.0
    214 Jobs 139 Reviews
    $20 in 1 Day
  • 4.7
    71 Jobs 33 Reviews
    $20 in 1 Day