Grouping Orders from Multiple Customers

[etsmarines]

I have a database that I am using for a coffee ordering solution. I can go to a customers profile and through a portal create a new order for a specific amount of coffee by weight and bags. I want to be able to see how much I have to make without having to go to each customers order profile and add the order amounts together. So for example I want to be able to click on a button and it takes me to a portal and shows me how much i need to make by automatically adding all the orders together and displaying them in like 5 pound increments. So if i have order from like 11 people totaling 10 pounds of coffee I want something to tell me to make to 5 pound batches, and then once I have made it i can check it off and the total will decrease from my batch order. Does this make any sense? Has someone done something like this?

Thanks!

Erik