Paper trim problem: The Oblivion Paper Company produces rolls of paper for use in adding machines,...

80.2K

Verified Solution

Question

Advance Math

Paper trim problem: The Oblivion Paper Companyproduces rolls of paper for use in adding machines, deskcalculators, and cash registers. The rolls, which are 200 feetlong, are produced in widths of 1½, 2½, and 3½ inches. Theproduction process provides 200-foot rolls in 10-inch widths only.The firm must therefore cut the rolls to the desired final productsizes. The five cutting alternatives and the amount of wastegenerated by each are as follows:

Cutting Alternative

Number of Rolls

1 ½ in

2 ½ in

3 ½ in

Waste
(inches)

1 6 0 0 1

2 0 1 2 0.5

3 1 3 0 1

4 1 2 1 0

5 4 0 1 0.5

The minimum product requirements for the three products are asfollows:

Roll Width (inches)

Units

1 ½

2000

2 ½

1000

3 ½

4500

With the goal of minimizing the number of units of the 10-inchrolls will be processed on each cutting alternative, find each ofthe following:
Total Number of 10-inch Rolls Processed =

Note: Value is between 2485 and 2535


Number of 1½ inch rolls produced =


Number of 2½ inch rolls produced =


Number of 3½ inch rolls produced =


Number of Rolls Cut Using Alternative 1 =


Number of Rolls Cut Using Alternative 4 =


Number of Rolls Cut Using Alternative 5 =

*******Complete in Excel and showFormulas*******

Answer & Explanation Solved by verified expert
4.4 Ratings (1071 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students