BYU Student Author: @Jae
Reviewers: @IWillyerd, @Hyrum
Estimated Time to Solve: 60 Minutes
We provide the solution to this challenge using:
- Alteryx
This challenge is related to Challenge 2|ALTERYX – Little Chicken, considering doing that case if you like this one.
Need a program? Click here.
Overview
Little Chicken is a local fried chicken store located in Georgetown, Kentucky. The owner, your friend Tom, has successfully expanded his business, opening 5 other stores and converting his original stand into a brick-and-mortar restaurant.
This year, Tom started a delivery service from his various stores. He found that his employees enjoyed the opportunity to deliver to customers because of the additional wages in the form of tips. Tom also reimburses his drivers with a gas compensation, but after the first quarter of the year, he is concerned about how much he is reimbursing the employees at each store.
In order to lower costs, and make it fair to all of his employees, Tom established trade areas (10 mile-radius boundaries around each store) and made the following company-wide rules about delivering chicken orders:
- Employees must deliver only to those customers within a 10-mile radius of their store
- An exception is the Danville store, which, being located further from the other stores allows for a 20-mile radius
- Danville employees cannot deliver in the Danville-Richmond mutual zone (overlap of trade areas)
- Deliveries made within other mutual zones should be evenly distributed between both stores, and
- All deliveries outside of a store’s respective trade area should be made by the closest geographical store
Feeling something fowl is going on, Tom has asked you to look into the deliveries being made and report back on your findings, specifically highlighting those deliveries that fall outside of the rules Tom has set. He has provided a sample of deliveries made within the last quarter.
Instructions
Using the datasets containing the sample of deliveries and store locations, create the following reports (pdf files) for Tom:
- A general report of each store’s deliveries on a map
- Each map should feature the deliveries of only one store
- Include the trade areas of all stores on each map
- A summary of gas compensation for total, ambiguous, and problem deliveries
- Tom follows the 2022 IRS mileage rates of 58.5 cents per mile for compensation
- Tom compensates both the distance travelled to deliver the order to the customer, and the distance to return back to the store
- The summary table should follow the following output:
- ‘Deliveries’ are the total number of deliveries for the respective section
- ‘Compensation’ is the dollar value of the gas compensation for the respective section
- Ambiguous deliveries are deliveries outside of a store’s trade area boundary
- Problem deliveries are deliveries on aggregate that are concerning or in violation of Tom’s rules
- Maps of any ambiguous or problem deliveries
- These maps should be combined onto the same report as instruction 2 (gas compensation)
- Do not worry about the individual deliveries, Tom is concerned more about what the stores are doing as a whole (on aggregate) in where they are delivering
- These maps should be combined onto the same report as instruction 2 (gas compensation)
Bonus Question
If Tom wanted to open another store in the area, where would you suggest he build it?
Data Files
Suggestions and Hints
- Some of 3. may need to be completed in order to complete the table in 2.
- Create spatial objects for both the deliveries and the store locations
- Adding Browse tools throughout your workflow can help you track progress
- Be sure to select a base map for a better visual
- The Alteryx help section is a good resource to learn spatial tools
- Be creative, use styles and labels on your reports to make them visually appealing
Solution
Challenge55_Solution.yxzp
Solution Video: Challenge 55|ALTERYX – Delivery Chicken
