SOLVE USING EXCEL SOLVER. PROVIDE SCREENSHOTS OF THE EXCEL SHEET AND EXCEL SOLVER.

Objective: Maximize revenue while covering the cost of the payment due and operating expenses.

Let's define the decision variables:

X1: Number of students in Junior Casa

X2: Number of students in Senior Casa

X3: Number of students in Advanced Casa

X4: Number of students in Grade One

X5: Number of students in Grade Two

X6: Number of students in Grade Three

X7: Number of students in Grade Four

X8: Number of students in Grade Five

X9: Number of students in Grade Six

X10: Number of students in Grade Seven

X11: Number of students in Grade Eight

X12: Number of students in Grade Nine

X13: Number of students in Grade Ten

X14: Number of students in Grade Eleven

X15: Number of students in Grade Twelve

Objective function: Maximize Revenue

Revenue = (37,000 * X1) + (37,000 * X2) + (40,000 * X3) + (43,000 * X4) + (45,000 * X5) + (47,000 * X6) + (49,000 * X7) + (51,000 * X8) + (53,000 * X9) + (54,000 * X10) + (56,000 * X11) + (58,000 * X12) + (60,000 * X13) + (63,000 * X14) + (65,000 * X15)

CONSTRAINTS

Minimum Capacity Constraints:

X1 50

X2 75

X3 100

X4 70

X5 70

X6 70

X7 70

X8 70

X9 70

X10 80

X11 80

X12 80

X13 100

X14 60

X15 60

Maximum Capacity Constraints:

X1 75

X2 95

X3 150

X4 100

X5 100

X6 100

X7 100

X8 100

X9 100

X10 125

X11 125

X12 125

X13 150

X14 90

X15 90

Total student population constraint:

X1 + X2 + X3 + X4 + X5 + X6 + X7 + X8 + X9 + X10 + X11 + X12 + X13 + X14 + X15 1,500

Cost-to-Income Ratio constraint:

Revenue >= Total Cost

Revenue >= 38500 * (x1 + x2 + x3 + x4 + x5 + x6 + x7 + x8 + x9 + x10 + x11 + x12 + x13 + x14 + x15) + ((213,333.33*12)+1,920,000)

Non-negativity constraints:

X1, X2, X3, X4, X5, X6, X7, X8, X9, X10, X11, X12, X13, X14, X15 0