URGENT HELP NEEDED WITH THIS LINEAR PROGRAMMING PRACTICE QUESTION.

1. State the Objective Function for this problem and LIST all the constraints in order to maximize the profit for this job.
2. If Lantastic Pan Manufacturers Limiteds objective is to maximize profit:
   1. How many Tenor, Double Tenor, Double Second, Double Guitar, Cello, Tenor-Bass and Six-Bass Pans should be manufactured? SOLVE USING SIMPLEX LP IN EXCEL SOLVER.
3. State the value of the maximum profit.

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 Tenor Double Double Cello Tenor-Bass Six-Bass Double Tenor $2.500 Second Type of Steel Pan Profit per pan Guitar $3,000 $2,250 $2,000 $1,750 $1,250 $1.250 Table 3 Type of Pan Tenor Double Cello Six- Double Tenor Pans Double Guitar 8 Total Available Tenor- Bass 16 Second 8 Bass 8 8 lo 8 20 625 4 4 4 8 8 lo 16 400 Manufacturing Labour Hours Tuning Labour Hours Chrome Plating (days) Steel Drums (units) 4 2 2 2 2 2 0 0 56 I 4 2 2 2 3 8 12 300