Paperco recycles newsprint (NP), coated paper (CP), and uncoated
paper (UCP) into recycled newsprint

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 inputAc€?cs pulp, leaving 80% of the inputAc€?cs pulp
for recycled paper. The process used to produce recycled coated
paper removes 10% of the inputAc€?cs pulp. The process used to produce
recycled uncoated paper removes 15% of the inputAc€?cs pulp. The
purchasing costs, processing costs, and availability of each type
of paper are shown in the following table. Purchase cost per ton of
pulp ($) Processing cost per ton of input ($) Available for
purchase (tons) Newsprint (NP) 10 500 Coated paper (CP) 9 300
Uncoated paper (UCP) 8 200 NP used for RNP 3 NP used for RCP 4 UCP
used for RNP 4 UCP used for RUP 1 UCP used for RCP 6 CP used for
RUP 5 CP used for RCP 3 To meet demand, Paperco must produce at
least 250 tons of recycled newsprint pulp, at least 300 tons of
recycled uncoated paper pulp, and at least 150 tons of recycled
coated paper pulp. Formulate a linear program that can be used to
minimize the cost of meeting PapercoAc€?cs demands. a) (2 points)
Define the decision variables? How many decision variables are
there in total? b) (2 points) What is the objective function? c) (3
points) What are the constraints including the sign restrictions
and type of variables? d) (8 points) Set up this problem in Excel
and solve it. Report how many tons of NP, CP and UCP used to
produce RNP, RUP and RCP? What is the minimum cost for the
recycler? Also include the screenshot of the spreadsheet model for
this problem and the Solver parameters window in your report. Do
not copy and paste your Excel sheet into your Word document.
Capture a screenshot and paste it into Word as an image. In
Windows, screenshot can be taken by pressing on both Ctrl and PrtSc
(Print Screen) together. e) (2 points) Would the optimal cost
change if NP availability is 600 tons instead of 500? If yes, why?
If not why not? f) (1 point) What is the optimal cost if UCP
availability is 300 tons instead of 200?