Management course : Linear programming problem

Feb 3rd, 2012
Studypool Tutor
Price: $15 USD

Tutor description

Paperco recycles newsprint (NP), coated paper (CP), and uncoated paper (UCP) into recycled newsprint (RNP), recycled uncoated paper (RUP), and recycled coated paper (RCP).Recycled newsprint can be produced by processing newsprint or uncoated paper. Recycled coated paper can be produced by recycling any type of paper. Recycled uncoated paper can be produced by processing uncoated paper or coated paper. The process used to produce recycled newsprint removes 20% of the input’s pulp, leaving 80% of the input’s pulp for recycled paper. The process used to produce recycled coated paper removes 10% of the input’s pulp. The process used to produce recycled uncoated paper removes 15% of the input’s pulp. The purchasing costs, processing costs, and availability of each type of paper are shown in the following table.

Word Count: 372
Showing Page: 1/4
Microsoft Excel 12.0 Answer ReportWorksheet: [tc_part_ii_0.xlsx]Sheet1Report Created: 3/20/2015 8:36:26 PMTarget Cell (Max)CellName$B$30 Minimize total cost Total InputOriginal Value0Final Value13750Adjustable CellsCellName$C$12 RNP Newsprint$D$12 RNP Uncoated$E$12 RNP Coated$C$13 RUP Newsprint$D$13 RUP Uncoated$E$13 RUP Coated$C$14 RCP Newsprint$D$14 RCP Uncoated$E$14 RCP CoatedOriginal Value000000000Final Value2500007.99361E-153002502000Cell Value5002003002503004502500007.99361E-153002502000Formula$B$18<=$D$18$B$19<=$D$19$B$20<=$D$20$B$23>=$D$23$B$24>=$D$24$B$25>=$D$25$C$12>=0$D$12>=0$E$12>=0$C$13>=0$D$13>=0$E$13>=0$C$14>=0$D$14>=0$E$14>=0ConstraintsCellName$B$18 Newsprint Total Input$B$19 Uncoated Total Input$B$20 Coated Total Input$B$23 RNP Total Input$B$24 RUP Total Input$B$25 RCP Total Input$C$12 RNP Newsprint$D$12 RNP Uncoated$E$12 RNP Coated$C$13 RUP Newsprint$D$13 RUP Uncoated$E$13 RUP Coated$C$14 RCP Newsprint$D$14 RCP Uncoated$E$14 RCP CoatedStatusSlackBinding0Binding0Binding0Binding0Binding0Not Binding 300Not Binding 250Binding0Binding0Binding0Bindi

Review from student

Studypool Student
" Thanks, good work "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1825 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors