Please show full working of the solution using Microsoft Excel Solver. Screenshots of rhe formula would be appreciated

T\&T Optimistic Pan Manufacturers Limited (TTOPML) has been contracted to manufacture Steel Pans for TWO (2) steel orchestras, D'abadie Sweet Steel Band (DSSB) and Gasparillo Phantastic Steel Orchestra (GPSO). The standard number of steel pans for ONE (1) 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 1 below shows the unit profit for each type of Steel Pan. Table 2 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 orders, for D'abadie Sweet Steel Band (DSSB) and Gasparillo Phantastic Steel Orchestra (GPSO) Table 1 Table 2 a) State the Objective Function for this problem. (2 Marks) b) Present the constraints that TTOPML must take into consideration, in order to maximise the profit for this job. (5 Marks) c) If T\&T Optimistic 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? (7 Mark) d) State the value of the maximum profit. (1 Mark)