A solution to last week's challenge can be found here.
This week's challenge was submitted by @sara_burk - Thanks for your submission!
Flora is the owner of Flora's Flower Décor and More. Each year, she systematically plans out her delivery schedule for Mother's Day deliveries and what the most efficient delivery route will be.
1) Flora always creates her delivery schedule on the day before Mother's Day. This year Mother's Day falls on May 9th. Any order placed on or after May 8th will be available for in-store pick up only.
2) In order to qualify for delivery, the order cost must reach $50.
3) Flora only has time to deliver flowers to the closest 30 customers to the floral shop. The rest of the customers will have to pick up their flowers from the store.
Flora will start at the flower shop, and consecutively go to the next closest location (based on distance, Miles). Create a macro that will help Flora optimize her route and then map the outcome. How many miles will Flora drive?