Number of shifts needed to fill the orders. Blue Diamond’s processing plant could produce 90,000 pounds of inshell almonds total each day using two 10-hour shifts. If the plant did nothing else but fill these new orders for Jeanne, how many days of work would each order require? (Please note that this information is just hypothetical, provided to make work on the spreadsheet more straightforward. It does not necessarily reflect Blue Diamond’s actual production capability.)

The date each order would be ready. It was now Tuesday, September 14th. Jeanne knew the processing plant would be operating 20 hours a day, six days a week during the harvest season. That meant the plant would be processing almonds on Wednesday the 15th, Thursday the 16th, Friday the 17th, Saturday the 18th, Monday the 20th and so on. If Jeanne had the plant fill each customer’s order starting on September 15th in the order in which it had arrived at her desk, on what day would each order of almonds be ready to leave the plant? (Again, please note that the production capabilities listed here are hypothetical, designed to make work on the spreadsheet more straightforward.)

Jeanne created a spreadsheet. Then she made the calculations needed to fill it in.