Could you please show me what you put into solver to get the lowest total cost for staffing please.

The yellow cels have to be solved with excel solver. There are certain constraints to put into the solver, but i do not know what to put in. Please could you help with that.

Q3. SOP in Service Sector (4 points) PPS Airline is doing aggregate planning of flight attendant staffing for the next 6 months. Demand is shown in Row 8 as the "Attendant Hours Needed". PPS Airline wishes to come up with a staffing plan for the months of October to March - specifically, they want to determine how many new attendants to hire each month. Each trained attendant supplies 150 hours per month. A newly hired attendant is called a trainee during the first month, and each trainee's net contribution is negative (-100 hours) as they require supervision, which detracts from the productivity of other attendants. Each trained attendant costs $1,500 in salary and benefits per month, and each trainee costs $700. Normal attrition (resignations and dismissals) in this occupation is high - 10% per month - So PPS Air never has any planned layoffs. Trainees are hired on the first day of each month and become attendants on the first day of the next month (with no attrition for these). As of October 1, PPS Air has 60 trained attendants. Requirements: Please use Solver to find the best plan which results in the lowest total staffing cost. You need to fill formulas into the yellow cells in Rows 9, 11, 12, and 14. (2 pt) Hints for setting Solver parameters: (1) What is the objective function? 0.5 pt (2) What is/are the decision variable(s)? 0.5 pt (3) What are the constraints? 1 pt (4) Please guarantee that "Trainees Hired" must be integers. For "Trained Attendants", do NOT round the numbers to the nearest integers. PPS Airline Flight Attendant Staffing Plan Jan Oct 8000 60 Nov 7000 Dec 8000 10000 Feb 9000 Mar 12000 Attendant Hours needed Trained Attendants Trainees Hired Attendant Hours Available Monthly Staffing Cost Attrition rate: Attendant cost Trainee cost: Attendant availability: Trainee availability: Total Staffing Cost: 10% /month $1,500 /person/month $700 /person/month 150 hrs/person/month -100 hrs/person/month Q3. SOP in Service Sector (4 points) PPS Airline is doing aggregate planning of flight attendant staffing for the next 6 months. Demand is shown in Row 8 as the "Attendant Hours Needed". PPS Airline wishes to come up with a staffing plan for the months of October to March - specifically, they want to determine how many new attendants to hire each month. Each trained attendant supplies 150 hours per month. A newly hired attendant is called a trainee during the first month, and each trainee's net contribution is negative (-100 hours) as they require supervision, which detracts from the productivity of other attendants. Each trained attendant costs $1,500 in salary and benefits per month, and each trainee costs $700. Normal attrition (resignations and dismissals) in this occupation is high - 10% per month - So PPS Air never has any planned layoffs. Trainees are hired on the first day of each month and become attendants on the first day of the next month (with no attrition for these). As of October 1, PPS Air has 60 trained attendants. Requirements: Please use Solver to find the best plan which results in the lowest total staffing cost. You need to fill formulas into the yellow cells in Rows 9, 11, 12, and 14. (2 pt) Hints for setting Solver parameters: (1) What is the objective function? 0.5 pt (2) What is/are the decision variable(s)? 0.5 pt (3) What are the constraints? 1 pt (4) Please guarantee that "Trainees Hired" must be integers. For "Trained Attendants", do NOT round the numbers to the nearest integers. PPS Airline Flight Attendant Staffing Plan Jan Oct 8000 60 Nov 7000 Dec 8000 10000 Feb 9000 Mar 12000 Attendant Hours needed Trained Attendants Trainees Hired Attendant Hours Available Monthly Staffing Cost Attrition rate: Attendant cost Trainee cost: Attendant availability: Trainee availability: Total Staffing Cost: 10% /month $1,500 /person/month $700 /person/month 150 hrs/person/month -100 hrs/person/month