My business transfers donuts to different store and has to use two different sized packages.
Large Package fits 60 donuts and the small packages fits 36 donuts.
How do I write a formula to maximize the efficiency for packing donuts in the proper packaging.
For example, if I need to package 36 donuts, I'd use small package, if I have to send out 60, I'd use one small package, if i needed 68, I'd use two small packages, and if I needed 92 i'd use a small and a large.
In a perfect world any formula I create would be flexible so I can change the number of donuts that fit in each package so the spreadsheet doesn't become void, if anything changes.
Thanks for any help....
Large Package fits 60 donuts and the small packages fits 36 donuts.
How do I write a formula to maximize the efficiency for packing donuts in the proper packaging.
For example, if I need to package 36 donuts, I'd use small package, if I have to send out 60, I'd use one small package, if i needed 68, I'd use two small packages, and if I needed 92 i'd use a small and a large.
In a perfect world any formula I create would be flexible so I can change the number of donuts that fit in each package so the spreadsheet doesn't become void, if anything changes.
Thanks for any help....