esults in 100 – 99 = 1 foot of trim loss). Orders in hand for the coming week are 5,670 12-foot olls, 1,680 15-foot rolls, and 3,350 30-foot rolls. Any of the three types of rolls produced in excess f the orders in hand will be sold on the open market at the selling price. No inventory is held. a. Formulate an integer programming model that will determine how many 100-foot rolls to cut into each of the five patterns in order to minimize trim loss. b. Solve the model formulated in part (a). What is the minimal amount of trim loss? How many of each pattern should be used and how many of each type of roll will be sold on the open market?
esults in 100 – 99 = 1 foot of trim loss). Orders in hand for the coming week are 5,670 12-foot olls, 1,680 15-foot rolls, and 3,350 30-foot rolls. Any of the three types of rolls produced in excess f the orders in hand will be sold on the open market at the selling price. No inventory is held. a. Formulate an integer programming model that will determine how many 100-foot rolls to cut into each of the five patterns in order to minimize trim loss. b. Solve the model formulated in part (a). What is the minimal amount of trim loss? How many of each pattern should be used and how many of each type of roll will be sold on the open market?
Chapter1: An Overview Of Strategic Marketing
Section1.2: Dollar Shave Club: The Company For Men
Problem 1C
Related questions
Question
needs excel solver

Transcribed Image Text:3. Minimizing Scrap. STAR Co. provides paper to smaller companies with volumes that are not large
enough to warrant dealing directly with the paper mill. STAR receives 100-feet-wide paper rolls
from the mill and cuts the rolls into smaller rolls of widths 12, 15, and 30 feet. The demands for
these widths vary from week to week. The following cutting patterns have been established:
Pattern Number
1
2
3
4
5
12-ft
0
0
8
2
7
15-ft
6
0
0
1
1
30-ft
0
3
0
2
0
Trim Loss (ft)
10
10
4
1
1
Trim loss is the leftover paper from a pattern (e.g., for pattern 4, 2(12) + 1(15) + 2(30) = 99 feet used
results in 100 - 99 = 1 foot of trim loss). Orders in hand for the coming week are 5,670 12-foot
rolls, 1,680 15-foot rolls, and 3,350 30-foot rolls. Any of the three types of rolls produced in excess
of the orders in hand will be sold on the onen market at the selling price No inventory is held

Transcribed Image Text:esults in 100 – 99 = 1 foot of trim loss). Orders in hand for the coming week are 5,670 12-foot
olls, 1,680 15-foot rolls, and 3,350 30-foot rolls. Any of the three types of rolls produced in excess
of the orders in hand will be sold on the open market at the selling price. No inventory is held.
a.
Formulate an integer programming model that will determine how many 100-foot rolls to cut
into each of the five patterns in order to minimize trim loss.
b. Solve the model formulated in part (a). What is the minimal amount of trim loss? How many
of each pattern should be used and how many of each type of roll will be sold on the open
market?
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,