Question: Plz, answer PART C using EXCEL-SOLVER, Formulate this problem using TOTAL INTEGER PROGRAMMING MODEL. Provide excel screenshots with explanations. 2. Northwoods Backpackers is a retail

Plz, answer PART C using EXCEL-SOLVER, Formulate this problem using TOTAL INTEGER PROGRAMMING MODEL. Provide excel screenshots with explanations.

Plz, answer PART C using EXCEL-SOLVER, Formulate

2. Northwoods Backpackers is a retail catalog store in Vermont that specializes in outdoor clothing and camping equipment. Phone orders are taken each day by a large pool of computer operators, which consists of permanent and temporary operators. A permanent operator can process an average 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 errors each day, whereas a temporary operator processes averagely 6.0 orders with errors each day. The store wants to limit total errors to 32 per day. A permanent operator is paid $100 per day, including benefits, and a temporary operator is paid $50 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 feasible solution area and optimal solutions in (a) and (c) graphically

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!