Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A pulp and paper company has three mills located in New Brunswick in Edmundston, Fredericton, and Moncton. The company produces three grades of pulp: long-fiber,

A pulp and paper company has three mills located in New Brunswick in Edmundston, Fredericton, and Moncton. The company produces three grades of pulp: long-fiber, medium-fiber, and short-fiber.
• The Edmundston mill is the largest of the three, but does not produce any long-fiber pulp, only 500 tonnes/day of medium-fiber pulp, and 420 tonnes/day of short-fiber pulp.
• The Fredericton mill produces 240 tonnes/day of each of long-fiber and medium-fiber pulp, along with 160 tonnes/day of short-fiber pulp
• The Moncton mill is the smallest of the three, and can produce 160 tonnes/day of long-fiber pulp, 210 tonnes/day of medium-fiber pulp, and 100 tonnes/day of short-fiber pulp.
The company is planning for some mill maintenance in an upcoming month, and needs to know how many days to run each mill in order to meet its anticipated pulp demand of 8,000 tonnes of long-fiber pulp, 17,700 tonnes of medium-fiber pulp, and 12,800 tonnes of short-fiber pulp. Determine how many days each mill should run to produce enough pulp to meet this exact level of demand.
In order to receive full marks, your solution must be prepared in Excel, and must use Excel's Matrix Algebra functionality (e.g. MMULT and MINVERSE). Please upload your Excel file within this question.

Step by Step Solution

3.41 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

so we have x no of days for ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Engineering economy

Authors: Leland Blank, Anthony Tarquin

7th Edition

9781259027406, 0073376302, 1259027406, 978-0073376301

More Books

Students also viewed these Accounting questions

Question

What is marginal cost Explain with an example.

Answered: 1 week ago

Question

=+c) Test the hypothesis and find the P-value.

Answered: 1 week ago