Use excel solver. No paperwork please. Use formulas and models step by step so that i can do it easily

Q3. (20 points) The B W Harris Company is a steel fabrication company that has recently negotiated a contract to supply T. Breuner Industries with steel trusses on a monthly basis. It employs both skilled workers and apprentices. The average output of a skilled worker is three trusses per hour; apprentices average two trusses per hour. Including benefits, each skilled worker costs the BW Harris Company $3840 per month, and each apprentice costs Harris $2400 per month. The BW Harris Company is a "union shop" and has negotiated the following agreements with the union which requires that the workforce to be used for the contract with T. Breuner Industries: At least 25 skilled workers will be used. - At least 15 more skilled workers than apprentices will be used. The maximum budget for labor costs is $200,000. Assume cach worker works 160 hours per month and both skilled workers and apprentices can be assigned "part- time" so that fractional values are permitted, Required: Solve this LP model by using Excel and computer Molly Fitzgerald in the Human Resources Dept of BW Harris Company has been assigned the task to determine: a) How many skilled workers and apprentices should be assigned to the project to maximize the total monthly production of trusses? b.) Suppose the second restriction is eliminated. What effect will this have on the optimal solution? c.) Suppose that the monthly contract with T. Breuner Industries called for production of 30,000 trusses. How much over the $200,000 budget for labor costs will BW Harris Company be required to spend on the project to meet this objective? d.) How many skilled workers and apprentices would now be assigned to the project