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?

MARKETING 2018
19th Edition
ISBN:9780357033753
Author:Pride
Publisher:Pride
Chapter1: An Overview Of Strategic Marketing
Section1.2: Dollar Shave Club: The Company For Men
Problem 1C
Question

needs excel solver 

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: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
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?
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer