I gang

solve a linear programming problem in 2 variables and obtain the solution graphically using MS Excel.

I want this to be solved like ASAP, please only the experienced ones or those who are dead sure they can do it, thanks:

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 maximise 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.

Færdigheder: Lineær Programmering, Matematik

Se mere: variables programming, solution programming, programming variables, programming solution, programming process, programming excel 2013, programming factory, planning problem, optimum solutions, number mathematics, linear programming solver excel, linear programming problem, impact products, find mathematics, find factory, factory programming, d programming, asap solutions, excel solver variables, excel linear programming, a b, weekly limit, solve, solve problem, production planning

Om arbejdsgiveren:
( 5 bedømmelser ) Luton, United Kingdom

Projekt-ID: #4115222

Tildelt til:

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 Mere

£25 GBP på 1 dag
(1 bedømmelse)
1.3

3 freelancere byder i gennemsnit £42 for dette job

romanuwa

I can do this quickly, Please check the PMB.

£40 GBP på 1 dag
(5 bedømmelser)
3.1
engrsalman

Respected Sir I am an electrical engineer and can currently doing research as a research assistance in high performance computing and networking lab in Al Khawarzimi institute of Computer science. I can do your job wi Mere

£60 GBP in 4 dage
(0 bedømmelser)
0.0