Linear optimization spreadsheet model

Assignment Help Basic Statistics
Reference no: EM1313979

Paper Recycling Company Exercise:

A paper recycling company converts newspaper, mixed paper, white office paper, and cardboard into pulp for newsprint, packaging paper, and print stock quality paper. The following table summarizes the yield for each kind of pulp recovered from each ton of recycled material.

 

Recycling Yield

Newsprint

Packaging

Print Stock

Newspaper

85%

80%

 

Mixed Paper

90%

80%

70%

White Office Paper Cardboard

90%

85%

80%

Cardboard

80%

70%

 

For instance, a ton of newspaper can be recycled using a technique that yields 0.85 tons of newsprint pulp. Alternatively, a ton of newspaper can be recycled using a technique that yields 0.80 tons of packaging paper. Similarly, a ton of cardboard can be recycled to yield 0.80 tons of newsprint or 0.70 tons of packaging paper pulp. Note that newspaper and cardboard cannot be converted to print stock pulp using the techniques available to the recycler.

The costs of processing each ton of raw material into the various types of pulp is summarized in the following table, along with the amount of each of the for raw materials that can be purchased and their costs.

 

Processing Costs per Ton

Purchase Cost per Ton

Tons Available

Newsprint

Packaging

Print Stock

Newspaper

$6.5

$11.00

-

$15

600

Mixed Paper

$9.75

$12.25

$9.50

$16

500

White Office Paper

$4.47

$7.75

$8.50

$19

300

Cardboard

$7.50

$8.50

-

$17

400

The recycler wants to determine the least costly way of producing 500 tons of newsprint pulp, 600 tons of packaging pulp, and 300 tons of print stock quality pulp.

(a) Develop a linear optimization spreadsheet model to solve the recycler's problem. (Make sure to document your model sufficiently (i.e., decision variables, constraints, objective etc) so that it is clear what your model is without requiring the instructor to go into Solver!)

(b) What is the cost of the optimal solution?

(c) What is the optimal strategy for producing 500 tons of newsprint pulp, 600 tons of packaging pulp, and 300 tons of print stock quality pulp at minimum cost?

Reference no: EM1313979

Questions Cloud

Decision making-expected monetary value : Using the EMV criteria (you wish to maximize expected profits in this case) determine what course of action that Optel should take. Make sure to state the best strategy in words.
The linear equation related to the real life : Think of a mathematical function that represents something from your own life.  For example, Assume the number of beers you drink depends on the number of football games you watch.
Determine real rate of interest : Short term Treasury bills [3 and 6 month] have current annual rates of interest around 0.5%. Use that info plus your best forecast of inflation to calculate the real rate of interest on those bills.
Economic ordering quantity computation : Economic ordering quantity computation and calculate the EOQ/ELS for the following two cases
Linear optimization spreadsheet model : What is the optimal strategy for producing 500 tons of newsprint pulp, 600 tons of packaging pulp, and 300 tons of print stock quality pulp at minimum cost?
Questions based on business accounts : Multiple choice questions based on business accounts and A corporation and its' owners are distinct entities
Determining expected dividend per share : Dividend is expected to grow 7% a year for next 3 years and then at 5% a year after that. Determine the expected dividend per share for each of the next five years?
Select a usa from the index also bring in additional source : Select a USA from the Index also bring in additional source material to Explicate its ranking also Explain how it has changed over the last 5-10 years.
Gdp forecast and inflation : If I told you that GDP was forecast to rise by a bit more than 3% over the next year, what would that mean to you?  What should you be asking about the forecast?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd