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

  Mean time between failures

Establish an approximate design to MTBF required for a system that will result in an approximate minimum total cost over a five year period if the system is to be operated 7500 hours per year

  Determining p value using one-way anova

Results were analyzed using one -way ANOVA and included SSTR =7 , 102 and SSE = 10 ,511. Are all 8 tapes equally appealing on average? Determine p value?

  Finds the confidence interval

Find the relative risk for moderate beer drinkers as compared to nondrinkers, finds the 95% confidence interval

  Probability for economy is expanding this month

At.05 significance level, can we conclude that larger proportion of the agents think the economy is expanding this month?

  Estimating probability values-discrete distribution

The probability that the daily demand at this store is at least one and at most three is:

  Confidence interval and population mean

Determine a 95% confidence interval for the population mean.

  Computing critical values by null and alternative hypotheses

By constructing null and alternative hypotheses, computing critical values, and comparing test statistic to critical value.

  Computing value of correlation coefficient between variables

Determine the value of correlation coefficient between these 2 variables?

  What is the minimum score

A survey of college students collected information on several variables: Distance from Home, Age, Major, Gender, and Class. The variable Major is

  Estimated bootstrap standard error of the median

What is the approximate estimated bootstrap standard error of the median, What is the approximate bias of the median estimated from bootstrapping - What is the bootstrap t confidence interval for the median

  Probability of person graduating with master-s degree

Determine the probability of randomly selecting a person graduating with Master's degree who didn't major in Education.

  One population mean-hypothesis test

Then explain your answer to someone who has never had course in statistics (but who is familiar with mean, standard deviation, and Z scores.)

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