please do not use previous answers for this question. use Excel and provide the formula. Thank you in advance!

2. Northwoods Backpackers is a retail catalog store in Vermont that specializes in outdoor clothing and camping equipment. Phone orders are taken cach day by a large pool of computer operators, which consists of permanent and temporary operators. A permanent operator can process an av- crage of 70 orders per day, whereas a temporary operator can process an average of 50 orders per day. The company averages at least 850 orders per day. The store has 15 computer workstations. A permanent operator processes averagely 1.5 orders with crrors cach day, whercas a temporary operator processes averagely 6.0 orders with crrors cach day. The store wants to limit total errors to 32 per day. A permanent opcrator is paid $150 per day, including benefits, and a temporary op- crator is paid $100 per day. The company wants to know the number of permanent and temporary operators to hire to minimize total cost. (a) Formulating the problem as a linear programming model, find the minimal total cost and the optimal solution point by using the computer. (b) Choose which of the following constraint(s) will be violated by a new solution from rounding down the coordinates of the optimal solution point in (a) to the nearest integer. (i) The minimal number of orders (ii) Available computer workstations (iii) Total error limitation (iv) None (c) Formulating the problem as a total integer programming model, find the minimal total cost and the optimal solution point by using the computer. (d) Illustrate the fcasible solution area and optimal solutions in (a) and (c) graphically