Simple Excel Exercise

/in /by

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
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!