# 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
" Thank you, Thank you, for top quality work, this is your guy!! "

1819 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