Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

National Paper runs a paper plant in Maine that buys pulp and turns it into three types of paper products: food contact paper, high-speed inkjet

National Paper runs a paper plant in Maine that buys pulp and turns it into three types of paper products: food contact paper, high-speed inkjet paper, and envelope paper. They need to plan their production schedule for the next quarter. The plant has two "machines" (each the size of a football field), and each machine works independently to produce the product it has been assigned. The plants run 24 hours per day, seven days a week, and so an entire quarter equals 2000 hours of useable production time (some hours during the quarter are set aside for cleaning and maintenance and are not included in this 2000 hours). Despite the plant's nonstop production, recent demand for their three products has skyrocketed, and the plant cannot satisfy demand for all of their products.

Quarterly forecasted demands for the three types of paper products are currently: 480000 tons of food contact paper, 280000 tons of inkjet paper, and 120000 tons of envelope paper. The two machines that make these three products are of different types and produce paper products at different rates. These rates (tons per hour) are given in the table below:

Machine

Food Contact

Inkjet

Envelope

Machine 1

150 tons/hour

200 tons/hour

180 tons/hour

Machine 2

135 tons/hour

200 tons/hour

170 tons/hour

Margins (profit margins), measured in dollars per ton, are given in the table below.

Food Contact

Inkjet

Envelope

$1250/ton

$1000/ton

$1100/ton

(12 pts)

a. Assuming machines can switch to different products without incurring any downtime, write out an LP formulation that helps National Paper decide which products to make as well as the appropriate production targets (quantities) of each type of paper product.

b. Solve your formulation in Excel and report the optimal production schedule.

Now suppose each machine must first be set up to make each type of paper product, and this requires 48 hours of preparation, which comes out of that machine's useable production time of 2000 hours. At the start of the quarter, assume neither machine is set up to make anything, so a setup is required.

(9 pts)

c. Write out a new formulation in its entirety that incorporates this set up requirement. Clearly label all decision variables and their types.

d. Solve your model in Excel and report your new optimal production schedule and your new optimal value.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Calculus With Applications

Authors: Margaret L Lial, Raymond N Greenwell, Nathan P Ritchey

10th Edition

0321831101, 9780321831101

More Books

Students also viewed these Mathematics questions

Question

When should you avoid using exhaust brake select all that apply

Answered: 1 week ago

Question

13. Give four examples of psychological Maginot lines.

Answered: 1 week ago