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.

Answer rating: 100% (QA)

so we have x no of days for ... View the full answer