Question: URGENT HELP NEEDED WITH THIS PRACTICE QUESTION - PLEASE ASSIST Practice QUESTION 1 - Lantastic Pan Manufacturers Limited (LPML) has been given a contract to

URGENT HELP NEEDED WITH THIS PRACTICE QUESTION - PLEASE ASSIST

URGENT HELP NEEDED WITH THIS PRACTICE QUESTION -

URGENT HELP NEEDED WITH THIS PRACTICE QUESTION -

URGENT HELP NEEDED WITH THIS PRACTICE QUESTION -

Practice QUESTION 1 - 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 Type of Steel Pan Tenor Double Double Double Cello Tenor-Bass Six-Bass Tenor Second Guitar Profit per $3,000 $2.500 $2,250 $2.000 $1,750 $1,250 $1,250 pan Table 3 Type of Pan Tenor Double Double Double Cello Tenor-Bass Six-Bass Pans Tenor Second Guitar 8 8 8 8 8 16 20 4 4 4 4 8 8 16 Manufacturing Labour Hours Tuning Labour Hours Chrome Plating (days) Steel Drums (units) 4 2 2 2 NI N 2 2 2 3 8 12 a) State the Objective Function for this problem and list or show the constraints that LPML must take into consideration, in order to maximize the profit for this job. 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 maximize profit, how many Tenor, Double Tenor. Double Second. Double Guitar.Cello. Tenor-Bass and Six-Bass Pans should be manufactured? (Use excel to solve and show all steps). State the value of the maximum profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!