PROBLEM 10 The Graphic Palette is a firm in Charleston, South Carolina, that does graphic artwork and produces color and black-and-white posters, lithographs, and banners. The firm’s owners, Kathleen and Lindsey Taylor, have been approached by a client to produce a spectacularly colored poster for an upcoming arts festival. The poster is more complex than anything Kathleen and Lindsey have previously worked on. It requires color screening in three stages, and the processing must proceed rapidly to produce the desired color effect. By suspending all their other jobs, they can devote three machines to the first stage, four to the second stage, and two to the last stage of the process. Posters that come off the machines at each stage can be processed on any of the machines at the next stage. However, all the machines are of different models and of varying ages, so they cannot process the same number of posters in the specified time frame necessary to complete the job. The different machine capacities at each stage are as follows: LLEASE REFER TO THE IMAGE FOR INSTRUCTIONS

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
PROBLEM 10 The Graphic Palette is a firm in Charleston, South Carolina, that does graphic artwork and produces color and black-and-white posters, lithographs, and banners. The firm’s owners, Kathleen and Lindsey Taylor, have been approached by a client to produce a spectacularly colored poster for an upcoming arts festival. The poster is more complex than anything Kathleen and Lindsey have previously worked on. It requires color screening in three stages, and the processing must proceed rapidly to produce the desired color effect. By suspending all their other jobs, they can devote three machines to the first stage, four to the second stage, and two to the last stage of the process. Posters that come off the machines at each stage can be processed on any of the machines at the next stage. However, all the machines are of different models and of varying ages, so they cannot process the same number of posters in the specified time frame necessary to complete the job. The different machine capacities at each stage are as follows: LLEASE REFER TO THE IMAGE FOR INSTRUCTIONS
>>>
3:08 Sat, Jul 9 A
determine how many units to ship from each plant, the quarterly customer demand forecasts are
aggregated at the distribution centers, and a modified transportation model is used to minimize the
cost of shipping from the production plants to the distribution centers.
PROBLEM 10
The Graphic Palette is a firm in Charleston, South Carolina, that does graphic artwork and produces
color and black-and-white posters, lithographs, and banners. The firm's owners, Kathleen and Lindsey
Taylor, have been approached by a client to produce a spectacularly colored poster for an upcoming
arts festival. The poster is more complex than anything Kathleen and Lindsey have previously worked
on. It requires color screening in three stages, and the processing must proceed rapidly to produce the
desired color effect.
By suspending all their other jobs, they can devote three machines to the first stage, four to the second
stage, and two to the last stage of the process. Posters that come off the machines at each stage can
be processed on any of the machines at the next stage. However, all the machines are of different
models and of varying ages, so they cannot process the same number of posters in the specified time
frame necessary to complete the job. The different machine capacities at each stage are as follows:
Stage 3
Machine 8 = 620
Machine 9 = 750
Stage 1
Machine 1 = 750
Machine 2 = 900
Machine 3 670
Machine
1
2
3
Because the machines are of different ages and types, the costs of producing posters on them differ.
For example, a poster that starts on machine 1 and then proceeds to machine 4 costs $18. If this poster
at machine 4 is then processed on machine 8, it costs an additional $36. The processing costs for each
combination of machines for stages 1, 2, and 3 are as follows:
4
$ 18
20
24
Machine (Cost)
5
6
$ 23
26
24
|||
Stage 2
Machine 4 = 530
Machine 5 = 320
$ 25
24
22
Machine 6 = 450
Machine 7 = 250
7
$ 21
19
23
8 of 10
Machine
4
5
6
7
Kathleen and Lindsey are unsure how to route the posters from one stage to the next to make as many
posters as they possibly can at the lowest cost. Determine how to route the posters through the
various stages for Graphic Palette to minimize costs.
0
Machine (Cost)
8
9
$36
$ 41
40
52
42
33
r
46
49
9%
Transcribed Image Text:>>> 3:08 Sat, Jul 9 A determine how many units to ship from each plant, the quarterly customer demand forecasts are aggregated at the distribution centers, and a modified transportation model is used to minimize the cost of shipping from the production plants to the distribution centers. PROBLEM 10 The Graphic Palette is a firm in Charleston, South Carolina, that does graphic artwork and produces color and black-and-white posters, lithographs, and banners. The firm's owners, Kathleen and Lindsey Taylor, have been approached by a client to produce a spectacularly colored poster for an upcoming arts festival. The poster is more complex than anything Kathleen and Lindsey have previously worked on. It requires color screening in three stages, and the processing must proceed rapidly to produce the desired color effect. By suspending all their other jobs, they can devote three machines to the first stage, four to the second stage, and two to the last stage of the process. Posters that come off the machines at each stage can be processed on any of the machines at the next stage. However, all the machines are of different models and of varying ages, so they cannot process the same number of posters in the specified time frame necessary to complete the job. The different machine capacities at each stage are as follows: Stage 3 Machine 8 = 620 Machine 9 = 750 Stage 1 Machine 1 = 750 Machine 2 = 900 Machine 3 670 Machine 1 2 3 Because the machines are of different ages and types, the costs of producing posters on them differ. For example, a poster that starts on machine 1 and then proceeds to machine 4 costs $18. If this poster at machine 4 is then processed on machine 8, it costs an additional $36. The processing costs for each combination of machines for stages 1, 2, and 3 are as follows: 4 $ 18 20 24 Machine (Cost) 5 6 $ 23 26 24 ||| Stage 2 Machine 4 = 530 Machine 5 = 320 $ 25 24 22 Machine 6 = 450 Machine 7 = 250 7 $ 21 19 23 8 of 10 Machine 4 5 6 7 Kathleen and Lindsey are unsure how to route the posters from one stage to the next to make as many posters as they possibly can at the lowest cost. Determine how to route the posters through the various stages for Graphic Palette to minimize costs. 0 Machine (Cost) 8 9 $36 $ 41 40 52 42 33 r 46 49 9%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.