Lantastic Pan Manufacturers Limited (LPML) has been given a contract to manufacture Steel Pans for the Gasparillo Panasonic Steel Orchestra. The standard number of steel pans for a Steel Orchestra is: 4 Tenor Pans, 4 Double Tenor Pans, 4 Double Second Pans, 4 Double Guitar Pans, 6 Cello Pans, 8 Tenor-Bass Pans and 12 Six-Bass Pans. Table 2 below shows the unit profit for each type of Steel Pan. Table 3 provides details of the manufacturing labour hours, tuning labour hours, chrome plating days and the number of steel drums required, to make the instruments to fulfil the order, for the Gasparillo Panasonic Steel Orchestra Table 2 Туре of Steel Pan Tenor Double Tenor $3,000 $2,500 Double Double Cello Tenor-Bass Six-Bass Second $2,250 Guitar Profit per $2,000 $1,750 S1,250 $1,250 pan Table 3 Type of Pan Tenor Double Double Double Cello Tenor- Six- Total Pans Tenor Second Guitar Bass Bass Available Manufacturing Labour Hours Tuning Labour 8 8 8 16 20 625 4 4 4 4 8 16 400 Hours Chrome Plating (days) Steel Drums |(units) 4 2 2 56 4 2 3 8 12 300 a) State the Objective Function for this problem. b) Present the constraints that LPML must take into consideration, in order to maximise the profit for this job. c) If Lantastic Pan Manufacturers Limited's objective is to maximise profit: i. How many Tenor, Double Tenor, Double Second, Double Guitar, Cello, Tenor-Bass and Six-Bass Pans should be manufactured?
Lantastic Pan Manufacturers Limited (LPML) has been given a contract to manufacture Steel Pans for the Gasparillo Panasonic Steel Orchestra. The standard number of steel pans for a Steel Orchestra is: 4 Tenor Pans, 4 Double Tenor Pans, 4 Double Second Pans, 4 Double Guitar Pans, 6 Cello Pans, 8 Tenor-Bass Pans and 12 Six-Bass Pans. Table 2 below shows the unit profit for each type of Steel Pan. Table 3 provides details of the manufacturing labour hours, tuning labour hours, chrome plating days and the number of steel drums required, to make the instruments to fulfil the order, for the Gasparillo Panasonic Steel Orchestra Table 2 Туре of Steel Pan Tenor Double Tenor $3,000 $2,500 Double Double Cello Tenor-Bass Six-Bass Second $2,250 Guitar Profit per $2,000 $1,750 S1,250 $1,250 pan Table 3 Type of Pan Tenor Double Double Double Cello Tenor- Six- Total Pans Tenor Second Guitar Bass Bass Available Manufacturing Labour Hours Tuning Labour 8 8 8 16 20 625 4 4 4 4 8 16 400 Hours Chrome Plating (days) Steel Drums |(units) 4 2 2 56 4 2 3 8 12 300 a) State the Objective Function for this problem. b) Present the constraints that LPML must take into consideration, in order to maximise the profit for this job. c) If Lantastic Pan Manufacturers Limited's objective is to maximise profit: i. How many Tenor, Double Tenor, Double Second, Double Guitar, Cello, Tenor-Bass and Six-Bass Pans should be manufactured?
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...
Related questions
Question
Transcribed Image Text:Lantastic Pan Manufacturers Limited (LPML) has been given a
contract to manufacture Steel Pans for the Gasparillo Panasonic
Steel Orchestra.
The standard number of steel pans for a Steel Orchestra is: 4
Tenor Pans, 4 Double Tenor Pans, 4 Double Second Pans, 4 Double
Guitar Pans, 6 Cello Pans, 8 Tenor-Bass Pans and 12 Six-Bass Pans.
Table 2 below shows the unit profit for each type of Steel Pan.
Table 3 provides details of the manufacturing labour hours, tuning
labour hours, chrome plating days and the number of steel drums
required, to make the instruments to fulfil the order, for the
Gasparillo Panasonic Steel Orchestra
Table 2
Double
Second
S2,250
Double
Guitar
$2,000
Tenor Double
Cello Tenor-Bass Six-Bass
Туре of
Steel Pan
Tenor
Profit per
$3,000 $2,500
$1,750 S1,250
$1,250
pan
Table 3
Type of Pan
Tenor
Double
Double
Double Cello Tenor-
Six-
Total
Pans
Tenor
Second
Guitar
Bass
Bass
Available
Manufacturing
Labour Hours
8
8
8
16
20
625
Tuning Labour
Hours
Chrome Plating
(days)
Steel Drums
(units)
4
4
8
8
16
400
2
2
2
56
4
2
2
3
8
12
300
a) State the Objective Function for this
problem.
b) Present the constraints that LPML must take into consideration,
in order to maximise the profit for this
job.
c) If Lantastic Pan Manufacturers Limited's objective is to
maximise profit:
i. How many Tenor, Double Tenor, Double Second, Double
Guitar, Cello, Tenor-Bass and Six-Bass Pans should be
manufactured?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 6 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.