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

Using Excel Solver!!!!! A local insurance company

B D E F G H 1 3 4 5 6 7 8 42465 2 57842 77015 55085 60789 1 Processing claims 2 3 Volumes 4 Month 5 Difficult 6 Easy 7 Minutes per claim 8 for each type of worker 9 10 Difficult 11 Easy 64917 47488 75020 40391 96601 64809 75154 78767 81739 83607 88450 Experienced Training 6 10 4 7

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!