Can you please solve this in excel and post the excel screenshot. Please solve it in excel and post with the formulas. PLEASE.

2. Worktorce constraints: - PA+TA 100 (April Available workers) - PJ+TM+AppJ140 (June Requirement) 3. Training Constraints: - TA 2RA (Trainers can train recruits in April) - TM2RM (Trainers can train recruits in May) 4. Transition constraints: - PM=PA+TA (May producers equal April producers \& trainers) - PJ=PM+AppM(June producers equal May producers \& May apprentices) - AppM = RAtRM (May apprentices equal April \& May recruits) 5. Non-negativity Constraints: - PA, PM, PJ, TA, TM, RA, RM, AppM, AppJ 0 Operations Management Application- Workforce Assignment LP can be used in operations management to aid in decision-making about product mix, production scheduling, staffing, inventory control, capacity planning, and other issues. An important application of LP is multi-period planning such as production scheduling. Usually the objective is to establish an efficient, low-cost production schedule for one or more products over several time periods. Typical constraints include limitations on production capacity, labor capacity, storage space, and more. Example: National Wing Company (NWC) is gearing up for the new B-48 contract. NWC has agreed to produce 20 wings in April, 24 in May, and 30 in June. Currently, NWC has 100 fully qualified workers. A fully qualified worker can either be placed in production or can train new recruits. A new recruit can be trained to be an apprentice in one month. After another month, the apprentice becomes a qualified worker. Each trainer can train two recruits. The production rate and salary per employee type is listed below. At the end of June, NWC wishes to have no recruits or apprentices, but have at least 140 full-time workers. Considering the above limitations, write a linear programming model to help NWC determine the number of employees in each type at each month (April, May, June) so as to minimize total wedge cost. Hint 1: you need to define 9 decision variables; - 3 decision variables for the number of producers in April, May, and June, - 2 decision variables for the number of trainers in April and May (Why not June?) - 2 decision variables for the number of apprentices in May and June (Why not April?) - 2 decision variables for the number of recruits in April and May (Why not June?) Hint 2: The objective function is: Minimize total wage cost for producers, trainers, apprentices, and recruits for April, May, and June Hint 3: Constraints: - Total production in Month 1 (April) must equal or exceed contract for Month 1 - Total production in Months 1-2 (April, May) must equal or exceed total contracts for Months 1-2 - Total production in Months 1-3 (April, May, June) must equal or exceed total contracts for Months 1-3 - In April there are 100 employees that can be producers or trainers: - At the end of June, there are to be at least 140 employees - 2 constraints for each trainer can train at most two recruits in April and May - 2 constraints for the number of producers and trainers in a month must equal the number of producers, trainers, and apprentices in the previous month - 2 constraints for the number of apprentices in a month must equal the number of recruits in the previous month Hint 4: Can you consider negative number of employees at each month? - Decision Variables: - PA - Producers in April - PM- Producers in May - PJ - Producers in June - TA - Trainers in April - TM-Trainers in May - RA-Recruits in April - RM-Recruits in May - AppM-Apprentices in May - AppJ-Apprentices in June Objective Function: Minimize: 3000PA+3000PM+3000PJ+3300TA+3300TM+2600RA+2600RM+2200(APPM+APPJ) Constraints: 1. Production Constraints: - PA20 (April Contract) - PA+PM20+24 (April and May Contracts) - PA+PM+PJ20+24+30 (April, May, \& June contracts)