Question: Using Excel Solver!!!!! A local insurance company processes claims. At the beginning of month 1, they have a backlog of 40,000 difficult claims and 60,000
Using Excel Solver!!!!!
A local insurance company processes claims. At the beginning of month 1, they have a backlog of 40,000 difficult claims and 60,000 easy claims. The predicted claim volume for months 1 through 8 are listed below. At the beginning of month 1, the firm has 70 experienced claim processors. Each month it can hire up to 10 trainees. At the end of each month, 5% of experienced employees quit, and 20% of trainees are fired. Each worker is available for 160 hours per month. The number of minutes needed by each worker to process each type of claim is given. The firm wants ending inventory for months 2 through 7 to be no greater than 50,000 of each type of claim. All claims must be processed by the end of month 8. What is the minimum number of trainees that need to be hired during months 1 to 8? (Note: Trainees must be integers. Experienced workers will probably end up being fractional, which is fine. In addition, if a trainee who was hired at the beginning of a month is not fired by the end of the month, he/she will become an experienced worker for the next month).
please provide a detailed step-by-step answer including the column headers and row numbers and the formula and solver used in the process. thx

Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
