This problem is a difficult one. The file named Agingdata.xlsx gives the number of insurance claims projected

Question:

This problem is a difficult one. The file named Agingdata.xlsx gives the number of insurance claims projected to be received daily and the number of insurance company workers available. Each day, a worker can process up to 30 claims. Workers process the oldest claims in the system first. In the file named S22_6.xlsx from the Solution Files folder, cells H6:AL6 contain the number of claims already in the system on January 1, before new claims arrive. Set up a worksheet to track the aging of the claims. That is, for each day, how many one-day-old, two-day-old, ... 30-day old, and over 30-day-old claims will be in the system?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: