Need a solution of a linear programming problem in 2 variables and obtain the solution graphically. - repost

Closed

Description

I want this to be solved like in 5 hours:

A factory makes 3 components, A, B and C using the same production process for each. A unit of A take 1 hr, a unit of B takes [url removed, login to view] hrs and a unit of C takes 0.5 hrs. In addition, C has to be hand finished, an activity taking [url removed, login to view] hrs per unit. Each week total production time (excluding hand finishing) must not exceed 300 hrs and hand finishing must not exceed 45 hrs.

The components are finally assembled to make two finished products. One product consists of 1 unit of A and 1 unit of C selling for 30 pounds whilst the other consists of 2 units of B and 1 unit of C and sells for 45 pounds. At most 130 of the first product and 100 of the second product can be sold each week.

3. a. Formulate the problem of planning weekly production to maximize total proceeds as a linear programming problem in 2 variables and obtain the solution graphically.

3. b. Revise the price for the first product from £30 to £35 and resolve the problem graphically to find out and show the new optimum solution. Compare the old and new solutions with respect to the impact of the price.

3. c. Revise the limit for the number of the second product from 100 to 120 and resolve it graphically to find out and show the new optimum solution. Compare the old and new solutions with respect to the impact of the capacity limit.

3. d. Solve the problem with MS Excel Solver in-built functionality for all three cases to verify your solutions found graphically.

Skills: Algorithm, Education & Tutoring, Linear Programming, Mathematics, Matlab and Mathematica

See more: linear programming factory makes components using production process, variables in programming, to find a solution, solution programming, solution algorithm, programming with matlab, programming variables, programming solution, programming programming, programming process, programming in matlab, programming in mathematica, programming in excel 2013, programming factory, programming and algorithm, problem algorithm, planning problem, optimum it solutions, number algorithm solver, ms excel programming, make algorithm, linear programming solver excel, linear programming problem, linear programming matlab, linear programming in excel

Project ID: #4114774

10 freelancers are bidding on average $8/hour for this job

clockwell

Hi, I have already done some of required work, both by hand and using Excel. I have tested the obtained results and I am sure they are correct. You will get a Word file with calculation and an Excel file with Solver co More

$12.5 USD / hour
(33 Reviews)
4.8
camurtuza5552

Dear Sir..I am Chartered Accountant, Company Secretary and Cost & Management Accountant ( CMA )[Equivalent to CIMA-London]..I have expert knowledge in Higher Mathematics and Operation Research Techniques..I can easily More

$8 USD / hour
(9 Reviews)
3.6
satsin7

Hi I haev experience of linear programming. Pls check my reviews.

$7 USD / hour
(6 Reviews)
3.3
sanketpatelcom

Ready to start

$8 USD / hour
(4 Reviews)
2.4
moustafaa

Dear Sir, I am a Professional Operation Research Engineer, I used to get an Excellent grade in OR "Operation Research" related subjects. I have already formulated the problem. Kindly check your PMB for more de More

$8 USD / hour
(1 Review)
1.0
gpodol

I can resolve the case using Excel - Solver. It'll take maximum 3 hours.

$8 USD / hour
(0 Reviews)
0.0
edconda

I am a Professor in Computer Science for 21 years and this problem is quite easy to work on. Contact me right away to solve this.

$8 USD / hour
(0 Reviews)
0.0
lazuch

OK, I can do this

$8 USD / hour
(0 Reviews)
0.0
MuhammadNiazAwan

Sir,can i help u

$7 USD / hour
(0 Reviews)
0.0
shabbir05

i can do it ..

$5 USD / hour
(0 Reviews)
0.0