Blog
Uncategorized
Simple Excel Exercise
Documentation
| Athey Department Store | |||
| Author | |||
| Date | |||
| Purpose | To create a return routing slip. | ||
| Data Definition Table – Return Data | |||
| Field | Description | Data Type | Notes |
| Date | Date of Return | Date | Enter dates using mm/dd/yyyy |
| Department | Department | Text | Accessories, Baby, Clothing, Electronics, Furniture, Luggage, Office, Sports, and Toys |
| Resolution | Resolution of return | Text | Destroy, Repack, Restock, or Return to Mfg |
| Inventory Cart | Cart holding return merchandise | Text | Determined by Department and Resolution using the Return Table |
Return Routing
| Athey Department Store | |
| 1500 Main Street | |
| Fort Dodge, IA 50501 | |
| Return Routing Slip | |
| Date | |
| Product Name | |
| Department | |
| Resolution | |
| Inventory Cart | |
| Customer Assistant | |
| Inventory Assistant |
Return Table
| Department | Destroy | Return to Mfg | Repack | Restock |
| Accessories | Trash | Trash | Trash | Stock A |
| Baby | Trash | Trash | Trash | Stock B |
| Clothing | Trash | Trash | Repack C | Stock C |
| Electronics | Trash | Return E | Repack E | Stock E |
| Furniture | Trash | Return F | Repack F | Stock F |
| Luggage | Trash | Return L | Repack L | Stock L |
| Office | Trash | Trash | Trash | Stock O |
| Sports | Trash | Return S | Repack S | Stock S |
| Toys | Trash | Return T | Repack T | Stock T |
Return Analysis
| Depatment | Total Returns |
| Accessories | |
| Baby | |
| Clothing | |
| Electronics | |
| Furniture | |
| Luggage | |
| Office | |
| Sports | |
| Toys | |
| Total | |
| Resolution | Total Returns |
| Destroy | |
| Return to Mfg | |
| Repack | |
| Restock | |
| Total |
Return Data
| Date | Department | Resolution | Inventory Cart |
| 4/3/17 | Baby | Repack | Trash |
| 4/6/17 | Clothing | Return to Mfg | Trash |
| 4/23/17 | Toys | Destroy | Trash |
| 7/12/17 | Clothing | Return to Mfg | Trash |
| 4/26/17 | Electronics | Return to Mfg | Return E |
| 8/16/17 | Luggage | Return to Mfg | Return L |
| 1/21/17 | Clothing | Repack | Repack C |
| 2/20/17 | Clothing | Destroy | Trash |
| 3/22/17 | Office | Destroy | Trash |
| 6/10/17 | Baby | Repack | Trash |
| 6/30/17 | Electronics | Restock | Stock E |
| 12/27/17 | Electronics | Repack | Repack E |
| 1/1/17 | Furniture | Destroy | Trash |
| 1/18/17 | Toys | Destroy | Trash |
| 1/29/17 | Toys | Repack | Repack T |
| 2/5/17 | Baby | Return to Mfg | Trash |
| 4/6/17 | Electronics | Repack | Repack E |
| 4/11/17 | Clothing | Destroy | Trash |
| 4/17/17 | Baby | Return to Mfg | Trash |
| 4/26/17 | Toys | Restock | Stock S |
| 7/5/17 | Baby | Restock | Stock B |
| 7/6/17 | Baby | Destroy | Trash |
| 7/15/17 | Sports | Destroy | Trash |
| 8/14/17 | Toys | Repack | Repack T |
| 10/23/17 | Accessories | Restock | Stock A |
| 11/2/17 | Toys | Return to Mfg | Return T |
| 3/1/17 | Toys | Restock | Stock S |
| 5/12/17 | Clothing | Destroy | Trash |
| 5/13/17 | Toys | Destroy | Trash |
| 5/20/17 | Accessories | Destroy | Trash |
| 9/27/17 | Clothing | Restock | Stock C |
| 10/14/17 | Toys | Repack | Repack T |
| 1/5/17 | Clothing | Restock | Stock C |
| 1/11/17 | Baby | Restock | Stock B |
| 4/20/17 | Sports | Restock | Stock S |
| 6/29/17 | Sports | Restock | Stock S |
| 2/6/17 | Luggage | Return to Mfg | Return L |
| 2/14/17 | Electronics | Repack | Repack E |
| 3/16/17 | Sports | Repack | Repack S |
| 12/21/17 | Baby | Return to Mfg | Trash |
| 6/18/17 | Accessories | Return to Mfg | Trash |
| 6/23/17 | Clothing | Restock | Stock C |
| 6/28/17 | Sports | Repack | Repack S |
| 7/8/17 | Baby | Return to Mfg | Trash |
| 7/10/17 | Toys | Restock | Stock S |
| 7/18/17 | Furniture | Repack | Repack F |
| 7/28/17 | Toys | Return to Mfg | Return T |
| 8/7/17 | Sports | Return to Mfg | Return S |
| 10/1/17 | Clothing | Restock | Stock C |
| 10/7/17 | Baby | Return to Mfg | Trash |
| 1/14/17 | Sports | Restock | Stock S |
| 3/25/17 | Sports | Repack | Repack S |
| 11/2/17 | Clothing | Return to Mfg | Trash |
| 11/10/17 | Electronics | Restock | Stock E |
| 12/10/17 | Sports | Return to Mfg | Return S |
| 9/16/17 | Clothing | Return to Mfg | Trash |
| 12/15/17 | Electronics | Return to Mfg | Return E |
| 3/15/17 | Office | Destroy | Trash |
| 3/17/17 | Baby | Repack | Trash |
| 3/20/17 | Furniture | Return to Mfg | Return F |
| 4/6/17 | Toys | Return to Mfg | Return T |
| 6/28/17 | Clothing | Repack | Repack C |
| 7/4/17 | Baby | Restock | Stock B |
| 10/11/17 | Sports | Return to Mfg | Return S |
| 12/20/17 | Sports | Destroy | Trash |
| 7/27/17 | Accessories | Restock | Stock A |
| 7/29/17 | Clothing | Repack | Repack C |
| 8/6/17 | Office | Restock | Stock O |
| 9/5/17 | Sports | Restock | Stock S |
| 10/10/17 | Office | Restock | Stock O |
| 1/28/17 | Clothing | Destroy | Trash |
| 6/12/17 | Electronics | Destroy | Trash |
| 9/10/17 | Clothing | Destroy | Trash |
| 12/9/17 | Accessories | Destroy | Trash |
| 12/11/17 | Baby | Restock | Stock B |
| 12/14/17 | Luggage | Return to Mfg | Return L |
| 12/31/17 | Toys | Repack | Repack T |
| 3/24/17 | Clothing | Restock | Stock C |
| 3/30/17 | Baby | Return to Mfg | Trash |
| 7/7/17 | Sports | Restock | Stock S |
| 7/27/17 | Toys | Restock | Stock S |
| 9/15/17 | Sports | Repack | Repack S |
| 4/23/17 | Office | Return to Mfg | Trash |
| 4/25/17 | Clothing | Restock | Stock C |
| 5/3/17 | Baby | Destroy | Trash |
| 6/2/17 | Sports | Repack | Repack S |
| 10/15/17 | Accessories | Destroy | Trash |
| 3/8/17 | Furniture | Restock | Stock F |
| 6/6/17 | Electronics | Destroy | Trash |
| 9/4/17 | Office | Restock | Stock O |
| 9/6/17 | Baby | Destroy | Trash |
| 9/9/17 | Clothing | Restock | Stock C |
| 9/26/17 | Toys | Return to Mfg | Return T |
| 12/18/17 | Furniture | Return to Mfg | Return F |
| 12/24/17 | Baby | Destroy | Trash |
| 1/7/17 | Clothing | Restock | Stock C |
| 1/17/17 | Clothing | Restock | Stock C |
| 4/2/17 | Sports | Return to Mfg | Return S |
| 6/11/17 | Sports | Return to Mfg | Return S |
| 7/21/17 | Toys | Destroy | Trash |
| 1/17/17 | Accessories | Restock | Stock A |
| 1/19/17 | Clothing | Repack | Repack C |
| 1/27/17 | Electronics | Repack | Repack E |
| 10/19/17 | Office | Repack | Trash |
| 12/3/17 | Sports | Destroy | Trash |
| 3/3/17 | Accessories | Repack | Trash |
| 6/1/17 | Accessories | Repack | Trash |
| 6/3/17 | Baby | Destroy | Trash |
| 6/6/17 | Furniture | Repack | Repack F |
| 6/23/17 | Toys | Repack | Repack T |
| 6/24/17 | Toys | Destroy | Trash |
| 9/14/17 | Clothing | Repack | Repack C |
| 9/20/17 | Baby | Restock | Stock B |
| 12/28/17 | Office | Restock | Stock O |
| 1/2/17 | Sports | Restock | Stock S |
| 10/13/17 | Accessories | Restock | Stock A |
| 10/15/17 | Clothing | Return to Mfg | Trash |
| 10/16/17 | Clothing | Return to Mfg | Trash |
| 10/23/17 | Electronics | Return to Mfg | Return E |
| 4/1/17 | Luggage | Return to Mfg | Return L |
| 10/23/17 | Office | Destroy | Trash |
| 11/27/17 | Sports | Repack | Repack S |
| 2/25/17 | Accessories | Return to Mfg | Trash |
| 2/26/17 | Furniture | Restock | Stock F |
| 2/27/17 | Baby | Return to Mfg | Trash |
| 3/2/17 | Clothing | Return to Mfg | Trash |
| 3/8/17 | Toys | Restock | Stock S |
| 3/19/17 | Toys | Return to Mfg | Return T |
| 6/10/17 | Clothing | Destroy | Trash |
| 6/16/17 | Baby | Return to Mfg | Trash |
| 9/23/17 | Sports | Restock | Stock S |
| 9/24/17 | Electronics | Restock | Stock E |
| 12/2/17 | Sports | Restock | Stock S |
| 7/10/17 | Office | Return to Mfg | Trash |
| 7/20/17 | Electronics | Return to Mfg | Return E |
| 5/15/17 | Electronics | Restock | Stock E |
| 5/25/17 | Clothing | Destroy | Trash |
| 8/23/17 | Baby | Return to Mfg | Trash |
| 9/7/17 | Accessories | Destroy | Trash |