Question 1: pertains to the Cherokee School District scenario below. The school board for the Cherokee School District has made the decision to purchase 1370additional Macintosh computers for computer...

Question 1: pertains to the Cherokee School District scenario below. The school board for the Cherokee School District has made the decision to purchase 1370additional Macintosh computers for computer laboratories in all its schools. Based on the past experience, the school board has directed that these computers should be purchased from some combination of three companies Mc Comp, EduElectronics, and Macwin. In all three cases, the companies charge a discounted variable cost per computer and a fixed delivery and installation costs for these large sales to school districts. The table below shows these charges as well as the capacity (the maximum number of computers that can be sold from the limited inventory) for each of the companies.CapacityFixed cost variable costMcComp710 $45,000 $750 EduElectronics690$35,000$780

Macwin1000$50,000 $700

The school board wants to know the optimal plan for meeting its computer needs.

1.Identify the type of integer programming framework (Total Integer, Mixed Integer, or Binary)that applies to this problem, develop the appropriate formulation (decision variables, objective function, and constraints), and solve it using Excel Solver.