Question: SOLVE IT USING EXCEL DATA SOLVER LINEAR PROGRAMMING AND WRITE DOWN CONSTRAINTS Problem 4 A company produces paper from raw materials R1, with cost 80

SOLVE IT USING EXCEL DATA SOLVER LINEAR PROGRAMMING AND WRITE DOWN CONSTRAINTS

SOLVE IT USING EXCEL DATA SOLVER LINEAR

Problem 4 A company produces paper from raw materials R1, with cost 80 per tonne, R2, with cost 150 per tonne, and R3, with cost 110 per tonne. One available technological process uses 4 tonnes of R1 to produce one tonne of paper; a second process uses 7 tonnes of R1 and 5 tonnes of R2 to produce one tonne of paper; a third process uses 9 tonnes of R1 and 4 tonnes of R3; a fourth process uses 5 tonnes of R2. At the moment only 90 tonnes of R1 are available, while stocks of materials R2 and R3 are unlimited. What is the minimal cost of producing 60 tonnes of paper

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!