please show model using excel. If excel can not be used please use screen shots in software to show exactly how its done

Question 1: The GN Inc. manufactures wooden soldiers and trains that their cost, revenue, and resource requirements are listed in the following table. Each week GN can obtain only 40 finishing labor hours and 24 carpentry labor hours. Production Finishing Products Revenue labor need Carpentry labor cost (hour) need (hour) Soldiers 10 22 2 3 Trains 8 15 1 2 Parta) formulate the problem to maximize weekly profit Part b) Ilse software to solve the problem and find the best production plan. Parc) Use sensitivity analysis to show how weekly optimal profit will change if production costs of the trains change. Part d) Model the same problem assuming that the products are sold in an uncertain environment that revenue may change depends on the market and other competitors. The distribution for each product distribution is listed in the table below: Products Revenue Probability Soldiers 20 22 0.8 0.2 Trains 10 15 0.1 0.9