An Excel assignment with a few steps.
Don't use plagiarized sources. Get Your Custom Essay on
Excel Assignment 2
Just from $13/Page
I’ve attached 3 files, one for the instructions, one for the file that needs to be edited, one for the way the file is supposed to look at the end.
The instructor is very specific so please make sure you read everything very carefully.
Grader – Instructions Excel 2019 Project
Exp19_Excel_Ch04_ML1_Pet_Supplies
Project Description:
You are the inventory manager for Crafton’s Pet Supplies. You are currently preforming analysis to determine inventory levels, as well as the total value of inventory on hand. Your last steps will be to check the report for duplicate entries and format for printing.
Steps to Perform:
Step
Instructions
Points Possible
1
Start Excel. Download and open the file named EXP19_Excel_Ch04_ML1_HW_PetSupplies.xlsx. Grader has automatically added your last name to the beginning of the filename.
0
2
Freeze the top row so that the column labels do not scroll off screen.
5
3
Convert the data to a table and name the table Inventory2021.
10
4
Apply Table Style Medium 3 to the table.
Note, depending on the version of Office used, the table style name may be Orange, Table Style Medium 3.
5
5
Sort the table by Warehouse (A to Z), then by Unit Price (smallest to largest). Create a custom sort order for Department so that it appears in this sequence: Food & Health, Collars & Leashes, Toys, Clothes, Training, and Grooming.
Note, Mac users to create a custom order list, on the Excel menu, click Preferences, and then under Formulas and Lists, click Custom Lists.
Click Add.
10
6
Remove duplicate records from the table. Excel should find and remove one duplicate record.
5
7
Create an unqualified structured reference in column G to determine the value of the inventory on hand and apply Accounting Number Format. To calculate the inventory on hand, multiply the Unit Price and the Amount on Hand.
10
8
Apply a Total Row to the Inventory2021 table, set the Inventory Value to Sum, and the Amount on Hand to Average. Format the results to display with two decimal points.
16
9
Create a new conditional formatting rule that displays any Inventory Value in column G for the Food & Health department with a value of $30,000 or more as Red fill color (second column, last row). There will be two qualifying entries.
Note, Mac users select the range G2:G78. Then in the New Formatting Rule dialog box, select the style Classic.
14
10
Ensure the warehouse information is not broken up between pages when printed. Add a page break to make sure that each warehouse prints on its own consecutive page.
10
11
Set the worksheet to Landscape orientation, and repeat row 1 labels on all pages.
10
12
Insert a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of the sheet. Display the Inventory sheet in Page Break Preview.
5
13
Save and close EXP19_Excel_CH04_ML1_HW_PetSupplies.xlsx. Exit Excel. Submit the file as directed.
0
Total Points
100
Created On: 06/18/2020 1 Exp19_Excel_Ch04_ML1 – Pet Supplies 1.1
Inventory
| Inventory ID |
Warehouse |
Supplier ID |
Department |
Amount on Hand |
Unit Price |
Inventory Value |
| 11178 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Memphis |
24-
|
| 38 |
10
|
|
|
|
|
|
|
|
|
|
| Clothes |
654 |
$ 9.00 |
| 1
| 129 |
2
|
|
|
|
|
|
|
|
|
|
|
|
| San Diego |
43-5660 |
|
|
|
|
|
|
|
|
|
|
|
| Collars & Leashes |
82 |
| $ 42.00 |
| 11320 |
San Diego
40-1780 |
|
|
|
|
|
|
|
|
|
|
|
| Grooming |
470 |
|
|
|
|
| $ 16.00 |
| 11
| 48 |
2
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Potomac |
62-2793 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Toys |
| 23 |
1
| $ 26.00 |
|
| 11590 |
Potomac
| 62-9040 |
Clothes
| 440 |
| $ 37.00 |
| 18621 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Denver |
67-1881 |
Grooming
483 |
| $ 6.00 |
11590 Potomac 62-9040 Clothes 440 $ 37.00
| 11685 |
Potomac
57-4516 |
|
|
|
|
|
|
|
|
|
| Food & Health |
238 |
$ 16.00
| 15639 |
Denver
12-6662 |
Clothes
| 140 |
| $ 8.00 |
| 11724 |
Memphis
76-
| 916 |
0
Clothes
485 |
$ 55.00 |
| 16828 |
Denver
99-6880 |
Clothes
41 |
|
|
| $ 10.00 |
|
| 118 |
67
San Diego
55-2458 |
Food & Health
448 |
| $ 31.00 |
| 12015 |
Potomac
63-6657 |
|
|
|
|
|
|
|
|
|
| Training |
| 565 |
| $ 3.00 |
| 19801 |
Denver
32-3003 |
Toys
651 |
$ 10.00
| 18790 |
Denver
51-8095 |
Toys
985 |
$ 11.00 |
| 19074 |
Denver
83-1
| 147 |
Grooming 916
$ 12.00 |
| 1
| 213 |
6
Memphis
77-9113 |
Clothes
46 |
| $ 40.00 |
| 15320 |
Denver
43-2702 |
Toys
918 |
$ 14.00 |
| 16432 |
Denver
41-2655 |
Food & Health 140
$ 15.00 |
| 12258 |
Memphis
11-4558 |
Training
713 |
$ 21.00 |
| 12672 |
Memphis
15-8803 |
Training
196 |
|
|
|
| $ 22.00 |
| 12806 |
San Diego
58-4302 |
Toys
553 |
| $ 28.00 |
|
| 12832 |
San Diego
| 13-9209 |
Grooming
| 294 |
$ 16.00
12832 San Diego 13-9209 Collars & Leashes 294 $ 16.00
| 19007 |
Denver
7-5363 |
Clothes
543 |
$ 16.00
| 12843 |
Potomac
2-9636 |
Food & Health
593 |
$ 47.00 |
| 16342 |
Denver
9-6725 |
Grooming
498 |
$ 19.00 |
| 12
| 948 |
Memphis
34-7020 |
Collars & Leashes 948
$ 49.00 |
| 19473 |
Denver
96-1948 |
Collars & Leashes
712 |
| $ 20.00 |
| 13075 |
San Diego
53-8846 |
Collars & Leashes
692 |
$ 8.00
| 13404 |
Memphis
81-7230 |
Collars & Leashes
808 |
$ 6.00
| 13440 |
Potomac
4-7732 |
Toys
547 |
| $ 5.00 |
| 13505 |
Memphis
53-4573 |
Clothes
818 |
$ 3.00
| 13705 |
Memphis
21-
|
| 632 |
4
Toys
445 |
$ 39.00 |
| 13822 |
Potomac
43-5490 |
Toys 565
$ 51.00 |
| 14016 |
San Diego
23-6766 |
Toys 38 $ 22.00
| 17146 |
Denver
84-9406 |
Training 129
| $ 23.00 |
| 14184 |
San Diego
72-7913 |
Grooming
805 |
| $ 50.00 |
|
| 18797 |
Denver
| 32-
| 680 |
8
Food & Health
| 437 |
|
|
| $ 24.00 |
18797 Denver 32-6808 Grooming 437 $ 24.00
| 14448 |
Potomac
53-8404 |
Grooming
962 |
$ 23.00
| 14636 |
San Diego
74-3227 |
Grooming
677 |
|
| $ 44.00 |
| 15531 |
Potomac
66-6754 |
Clothes
709 |
$ 26.00
| 11711 |
Denver
24-3362 |
Grooming
329 |
$ 28.00
| 15687 |
San Diego
7-6023 |
Collars & Leashes
387 |
$ 42.00
| 11485 |
Denver
31-6267 |
Toys
696 |
| $ 29.00 |
| 17007 |
Denver
43-6210 |
Training
927 |
$ 29.00
| 15472 |
Denver
54-7909 |
Toys
408 |
$ 30.00 |
| 15930 |
Memphis
6-7306 |
Toys
569 |
$ 50.00
| 16146 |
Potomac
66-6102 |
Collars & Leashes
380 |
$ 41.00 |
| 19487 |
Denver
92-8378 |
Toys
236 |
$ 32.00 |
| 14261 |
Denver
80-8283 |
Collars & Leashes 118
|
| $ 33.00 |
| 16437 |
Memphis
89-3177 |
Collars & Leashes
836 |
$ 18.00 |
| 18638 |
Denver
2-1553 |
Training
584 |
$ 33.00
| 16745 |
Denver
57-2430 |
Grooming 632
$ 36.00 |
| 16849 |
Memphis
80-7774 |
Collars & Leashes
416 |
$ 7.00 |
| 16946 |
Memphis
97-7267 |
Training
748 |
$ 31.00
| 17020 |
Potomac
89-8450 |
Food & Health
999 |
$ 22.00
| 17513 |
San Diego
66-4757 |
Collars & Leashes 147 $ 24.00
| 17973 |
Memphis
32-1822 |
Clothes
760 |
$ 10.00
| 18113 |
Potomac
95-8142 |
Toys
452 |
$ 10.00
| 18254 |
Potomac
33-9096 |
Food & Health
721 |
$ 44.00
| 18455 |
Memphis
90-8867 |
Toys
202 |
$ 38.00 |
| 18554 |
Memphis
43-1802 |
Training
734 |
$ 33.00
| 16840 |
Denver
42-9356 |
Food & Health
386 |
$ 43.00 |
| 18698 |
San Diego
43-2218 |
Collars & Leashes
989 |
$ 40.00
| 17308 |
Denver
43-3691 |
Training
994 |
$ 44.00
| 18781 |
Potomac
2-2476 |
Toys 632 $ 16.00
| 18861 |
Memphis
83-4623 |
Food & Health 48 $ 22.00
| 19160 |
Memphis
81-2610 |
Grooming 38 $ 20.00
| 13136 |
Denver
63-2238 |
Food & Health 23
| $ 48.00 |
| 15651 |
Denver
15-6231 |
Food & Health 680 $ 48.00
| 19483 |
San Diego
15-
| 589 |
7
Toys
392 |
$ 5.00
| 19744 |
Potomac
10-5462 |
Grooming
914 |
$ 22.00
| 19754 |
Potomac
23-1749 |
Clothes 213 $ 24.00
| 19784 |
Potomac
69-3905 |
Toys
673 |
$ 45.00 |
| 19838 |
Potomac
26-5867 |
Training 589
$ 53.00 |
| 19859 |
Potomac
84-3864 |
Training
393 |
$ 13.00 |
Submission
| |
– MarkUp
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Submission MarkUp |
| This is a machine generated report of your submission document containing error details as annotations. |
|
| Details |
of all points deducted in the submitted document are listed on this sheet.
| Assignment Details |
| Submission ID |
| 48 |
747
553 |
00
| Assignment Name |
| Submission Date |
| 19 March,
| 202 |
1
| Report Generated on |
19 March, 2021
| Points Obtained |
68.167/100 (68.167%) |
Worksheet: ‘
Inventory
‘ (
Points Deducted |
: 31.833)
Points Deducted Details
| Error Description |
| 1
| 5.000 |
Incorrect Actions: Sheet (Inventory) |
5.000 point(s) deducted in instruction #2:
-In the Sheet ‘Inventory’ the ‘Freeze Panes’ were not applied at ‘Row 1’.
1
|
|
|
|
|
|
|
|
|
|
|
|
|
| 0.000 |
point(s) deducted in instruction #10:
-In the Sheet ‘Inventory’ the ‘Page Break set before Row’ was not set to ’28’.
5.000
| Incorrect Actions: Header(s)/Footer(s) |
5.000 point(s) deducted in instruction #12:
-In the Sheet ‘Inventory’ the ‘Center Footer Text Case’ was not set as per instruction.
-In the Sheet ‘Inventory’ the ‘Center Footer Content’ was not set to ‘&[Tab]’.
-In the Sheet ‘Inventory’ the ‘Right Footer Text Case’ was not set as per instruction.
-In the Sheet ‘Inventory’ the ‘Right Footer Content’ was not set to ‘&[File]’. |
| 2.500 |
Incorrect Actions: Table(s) |
2.500 point(s) deducted in instruction #3:
-In the ‘Inventory2021 [A1:G79]’ on Sheet ‘Inventory’ the ‘Table Name’ was not set to ‘Inventory2021’. |
| 9.333 |
Incorrect Actions: Conditional Format(s) |
9.333 point(s) deducted in instruction #9:
-In the Conditional formatting ‘expression’ on range ‘G2:G78’ of sheet ‘Inventory’, the ‘Range’ was not set to ‘G2:G78’.
-In the Conditional formatting ‘expression’ on range ‘G2:G78’ of sheet ‘Inventory’, the ‘Rule Type’ was not set to ‘Expression’. |
0.000
| Extra: Row 80 |
|
|
|
|
|
|
|
|
|
|
|
|
| This action did not result in any loss of points. |
0.000
| Extra: Row 81 |
This action did not result in any loss of points.
0.000
| Extra: Row
| 82 |
This action did not result in any loss of points.
0.000
| Extra: Row 83 |
This action did not result in any loss of points.
0.000
| Extra: Row 84 |
This action did not result in any loss of points.
0.000
| Extra: Row 85 |
This action did not result in any loss of points.
0.000
| Extra: Row 86 |
This action did not result in any loss of points.
0.000
| Extra: Row 87 |
This action did not result in any loss of points.
0.000
| Extra: Row 88 |
This action did not result in any loss of points.
0.000
| Extra: Row 89 |
This action did not result in any loss of points.
0.000
| Extra: Row 90 |
This action did not result in any loss of points.
0.000
| Extra: Row 91 |
This action did not result in any loss of points.
0.000
| Extra: Row 92 |
This action did not result in any loss of points.
0.000
| Extra: Row 93 |
This action did not result in any loss of points.
Inventory
| Inventory ID |
Warehouse |
Supplier ID |
Department |
Amount on Hand |
Unit Price |
Inventory Value |
| 18621 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Denver |
67-1881 |
|
|
|
|
|
|
|
|
|
|
|
| Grooming |
483 |
| $ 6.00 |
$ 2,898.00 |
| 15639 |
Denver
12-6662 |
|
|
|
|
|
|
|
|
|
| Clothes |
| 140 |
| $ 8.00 |
$ 1,120.00 |
| 19801 |
Denver
32-3003 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Toys |
651 |
|
|
| $ 10.00 |
$ 6,510.00 |
| 16828 |
Denver
99-6880 |
Clothes
41 |
$ 10.00
$ 410.00 |
| 18790 |
Denver
51-8095 |
Toys
985 |
$ 11.00 |
$ 10,835.00 |
| 19074 |
Denver
83-1
| 147 |
Grooming
916 |
$ 12.00 |
$ 10,992.00 |
| 15320 |
Denver
43-2702 |
Toys
918 |
$ 14.00 |
$ 12,852.00 |
| 16432 |
Denver
41-2655 |
|
|
|
|
|
|
|
|
|
| Food & Health |
140
$ 15.00 |
$ 2,100.00 |
| 19007 |
Denver
7-5363 |
Clothes
543 |
|
|
|
|
| $ 16.00 |
$ 8,688.00 |
| 16342 |
Denver
9-6725 |
Grooming
498 |
$ 19.00 |
$ 9,
| 46 |
2.00
| 19473 |
Denver
96-1
| 948 |
|
|
|
|
|
|
|
|
|
|
|
| Collars & Leashes |
712 |
| $ 20.00 |
$ 14,240.00 |
| 17146 |
Denver
84-9406 |
|
|
|
|
|
|
|
|
|
| Training |
129 |
$
| 23 |
.00
$ 2,967.00 |
|
| 18797 |
Denver
| 32-
| 680 |
8
Food & Health
| 437 |
|
|
| $ 24.00 |
| $ 10,488.00 |
18797 Denver 32-6
| 808 |
Grooming 437 $ 24.00 $ 10,488.00
| 11711 |
Denver
24-3362 |
Grooming
329 |
| $ 28.00 |
$ 9,212.00 |
| 11
| 485 |
Denver
31-6267 |
Toys
696 |
| $ 29.00 |
$ 20,184.00 |
| 17007 |
Denver
43-6210 |
Training
927 |
$ 29.00
$ 26,883.00 |
| 1
| 547 |
2
Denver
54-7909 |
Toys
408 |
$ 30.00 |
$ 12,240.00 |
| 19487 |
Denver
92-8378 |
Toys
236 |
$ 32.00 |
$ 7,552.00 |
| 14261 |
Denver
80-8283 |
Collars & Leashes
118 |
|
| $ 33.00 |
$ 3,894.00 |
| 186
|
| 38 |
Denver
2-1553 |
Training
584 |
$ 33.00
$ 19,272.00 |
| 16745 |
Denver
57-2430 |
Grooming
| 632 |
$ 36.00 |
$ 22,752.00 |
| 16840 |
Denver
42-9356 |
Food & Health
386 |
$ 43.00 |
$ 16,598.00 |
| 17308 |
Denver
43-3691 |
Training
994 |
|
| $ 44.00 |
$ 43,736.00 |
| 13136 |
Denver
63-2
| 238 |
Food & Health 23
| $ 48.00 |
$ 1,104.00 |
| 1
|
| 565 |
1
Denver
15-6
| 231 |
Food & Health 680 $ 48.00
$ 32,640.00 |
| 13505 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Memphis |
53-4573 |
Clothes
818 |
| $ 3.00 |
$ 2,454.00 |
| 13404 |
Memphis
81-7230 |
Collars & Leashes 808 $ 6.00
$ 4,848.00 |
| 16849 |
Memphis
80-7774 |
Collars & Leashes
416 |
$ 7.00 |
$ 2,912.00 |
| 11178 |
Memphis
24-3810 |
Clothes
654 |
$ 9.00 |
$ 5,886.00 |
| 17973 |
Memphis
32-1822 |
Clothes
760 |
$ 10.00
$ 7,600.00 |
| 16437 |
Memphis
89-3177 |
Collars & Leashes
836 |
$ 18.00 |
$ 15,048.00 |
| 19160 |
Memphis
81-2610 |
Grooming 38 $ 20.00
$ 760.00 |
| 12258 |
Memphis
11-4558 |
Training
713 |
$ 21.00 |
$ 14,973.00 |
| 18861 |
Memphis
83-4623 |
Food & Health 48
|
|
|
| $ 22.00 |
$ 1,056.00 |
| 12672 |
Memphis
15-8803 |
Training
196 |
$ 22.00
$ 4,312.00 |
| 16946 |
Memphis
97-7267 |
Training
748 |
| $ 31.00 |
$ 23,188.00 |
| 18554 |
Memphis
43-1802 |
Training
734 |
$ 33.00
$ 24,222.00 |
| 18455 |
Memphis
90-8867 |
Toys 202
$ 38.00 |
$ 7,676.00 |
| 13705 |
Memphis
21-6324 |
Toys
445 |
$ 39.00 |
$ 17,355.00 |
| 1
| 213 |
6
Memphis
77-9113 |
Clothes 46
| $ 40.00 |
$ 1,840.00 |
| 1
|
| 294 |
8
Memphis
34-7020 |
Collars & Leashes 948
$ 49.00 |
$ 46,
| 452 |
.00
| 1
| 593 |
0
Memphis
6-7306 |
Toys
569 |
| $ 50.00 |
$ 28,450.00 |
| 11724 |
Memphis
76-9160 |
Clothes 485
$ 55.00 |
$ 26,675.00 |
| 12015 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Potomac |
63-6657 |
Training 565 $ 3.00
$ 1,695.00 |
| 13
| 440 |
Potomac
4-7732 |
Toys 547
| $ 5.00 |
$ 2,735.00 |
| 18113 |
Potomac
95-8142 |
Toys 452 $ 10.00
$ 4,520.00 |
| 19859 |
Potomac
84-3864 |
Training
393 |
$ 13.00 |
$ 5,109.00 |
| 11685 |
Potomac
57-4516 |
Food & Health 238 $ 16.00
$ 3,808.00 |
| 18781 |
Potomac
2-2476 |
Toys 632 $ 16.00
$ 10,112.00 |
| 17020 |
Potomac
89-8450 |
Food & Health
999 |
$ 22.00
$ 21,978.00 |
| 19744 |
Potomac
10-5462 |
Grooming
914 |
$ 22.00
$ 20,108.00 |
| 14
| 448 |
Potomac
53-8404 |
Grooming
962 |
$ 23.00 |
$ 22,126.00 |
| 19754 |
Potomac
23-1749 |
Clothes 213 $ 24.00
$ 5,112.00 |
| 11482 |
Potomac
62-2793 |
Toys 231
| $ 26.00 |
$ 6,006.00 |
| 15531 |
Potomac
66-6754 |
Clothes
709 |
$ 26.00
$ 18,434.00 |
| 11590 |
Potomac
62-9040 |
Clothes 440
$ 37.00 |
$ 16,280.00 |
| 16146 |
Potomac
66-6102 |
Collars & Leashes
380 |
$ 41.00 |
$ 15,580.00 |
| 18254 |
Potomac
33-9096 |
Food & Health
721 |
$ 44.00
$ 31,724.00 |
| 19784 |
Potomac
69-3905 |
Toys
673 |
$ 45.00 |
$ 30,285.00 |
| 12843 |
Potomac
2-9636 |
Food & Health 593
$ 47.00 |
$ 27,871.00 |
| 13822 |
Potomac
43-5490 |
Toys 565
$ 51.00 |
$ 28,815.00 |
| 19838 |
Potomac
26-5867 |
Training
589 |
$ 53.00 |
$ 31,217.00 |
| 19483 |
|
|
|
|
|
|
|
|
|
|
|
|
| San Diego |
15-5897 |
Toys
392 |
$ 5.00
$ 1,960.00 |
| 13075 |
San Diego
53-8846 |
Collars & Leashes
692 |
$ 8.00
$ 5,536.00 |
|
| 12832 |
San Diego
| 13-9209 |
Collars & Leashes 294 $ 16.00
| $ 4,704.00 |
| 11320 |
San Diego
40-1780 |
Grooming
470 |
$ 16.00
$ 7,520.00 |
12832 San Diego 13-9209 Grooming 294 $ 16.00 $ 4,704.00
| 14016 |
San Diego
23-6766 |
Toys 38 $ 22.00
$ 836.00 |
| 17513 |
San Diego
66-4757 |
Collars & Leashes 147 $ 24.00
$ 3,528.00 |
| 12806 |
San Diego
58-4302 |
Toys 553 $ 28.00
$ 15,484.00 |
| 11867 |
San Diego
55-2458 |
Food & Health 448 $ 31.00
$ 13,888.00 |
| 18698 |
San Diego
43-2218 |
Collars & Leashes
989 |
$ 40.00
$ 39,560.00 |
| 11292 |
San Diego
43-5660 |
Collars & Leashes 82
| $ 42.00 |
$ 3,444.00 |
| 15687 |
San Diego
7-6023 |
Collars & Leashes
387 |
$ 42.00
$ 16,254.00 |
| 14636 |
San Diego
74-3227 |
Grooming
677 |
$ 44.00
$ 29,788.00 |
| 14184 |
San Diego
72-7913 |
Grooming
805 |
$ 50.00
$ 40,250.00 |
| Total |
514.17 |
$ 1,046,795.00 |
Taubasey
|
|
| 2 |
>Submission – MarkUp
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Submission MarkUp |
| This is a machine generated report of your submission document containing error details as annotations. |
|
|
| Details |
of all points deducted in the submitted document are listed on this sheet.
| Assignment Details |
| Submission ID |
|
| 48 |
66280700
| Assignment
| Name |
Excel Chapter 2 Mid-Level
|
|
|
|
| 1 |
–
Metropolitan Zoo |
(PC and Mac)
| Submission Date |
12 March,
| 20 |
21
| Report Generated on |
18 March, 2021 |
| Points Obtained |
85/100 (85%) |
| Worksheet: Extra/Missing information (
|
| Points Deducted |
:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 0.000 |
)
Points Deducted Details
|
| Error Description |
0.000
| Missing: Sheet (Overtime) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| This action did not result in any loss of points. |
Worksheet: ‘
Payroll Data
‘ (Points Deducted: 1
5.000 |
)
Points Deducted Details Error Description
| 10.000 |
Cell level Incorrect Actions |
11 cell(s) commented inplace. Please check the sheet. |
5.000
| Incorrect Actions: Header(s)/Footer(s) |
5.000 point(s) deducted in instruction #9:
-In the Sheet ‘Payroll Data’ the ‘Center Footer Content’ was not set to ‘&[Tab]’.
-In the Sheet ‘Payroll Data’ the ‘Right Footer Content’ was not set to ‘&[File]’. |
0.000
| Missing: Cell M1 |
This action did not result in any loss of points.
0.000
| Missing: Cell N1 |
This action did not result in any loss of points.
0.000
| Missing: Cell M2 |
This action did not result in any loss of points.
0.000
| Missing: Cell N2 |
This action did not result in any loss of points.
0.000
| Missing: Cell M
|
|
| 3 |
This action did not result in any loss of points.
0.000
| Missing: Cell N3 |
This action did not result in any loss of points.
0.000
| Missing: Cell M4 |
This action did not result in any loss of points.
0.000
| Missing: Cell N4 |
This action did not result in any loss of points.
0.000
| Missing: Cell M5 |
This action did not result in any loss of points.
0.000
| Missing: Cell N5 |
This action did not result in any loss of points.
0.000
| Missing: Cell M6 |
This action did not result in any loss of points.
0.000
| Missing: Cell N6 |
This action did not result in any loss of points.
0.000
| Missing: Cell M7 |
This action did not result in any loss of points.
0.000
| Missing: Cell N7 |
This action did not result in any loss of points.
0.000
| Missing: Cell M8 |
This action did not result in any loss of points.
0.000
| Missing: Cell N8 |
This action did not result in any loss of points.
0.000
| Missing: Cell M9 |
This action did not result in any loss of points.
0.000
| Missing: Cell N9 |
This action did not result in any loss of points.
0.000
| Missing: Cell M10 |
This action did not result in any loss of points.
0.000
| Missing: Cell N10 |
This action did not result in any loss of points.
0.000
| Missing: Cell M11 |
This action did not result in any loss of points.
0.000
| Missing: Cell N11 |
This action did not result in any loss of points.
0.000
| Missing: Cell M12 |
This action did not result in any loss of points.
0.000
| Missing: Cell N12 |
This action did not result in any loss of points.
0.000
| Missing: Cell M13 |
This action did not result in any loss of points.
0.000
| Missing: Cell N13 |
This action did not result in any loss of points.
0.000
| Missing: Cell M14 |
This action did not result in any loss of points.
0.000
| Missing: Cell N14 |
This action did not result in any loss of points.
0.000
| Missing: Cell M
| 15 |
This action did not result in any loss of points.
0.000
| Missing: Cell N15 |
This action did not result in any loss of points.
0.000
| Missing: Cell M16 |
This action did not result in any loss of points.
0.000
| Missing: Cell N16 |
This action did not result in any loss of points.
0.000
| Missing: Cell M17 |
This action did not result in any loss of points.
0.000
| Missing: Cell N17 |
This action did not result in any loss of points.
0.000
| Missing: Cell M18 |
This action did not result in any loss of points.
0.000
| Missing: Cell N18 |
This action did not result in any loss of points.
0.000
| Missing: Cell M19 |
This action did not result in any loss of points.
0.000
| Missing: Cell N19 |
This action did not result in any loss of points.
0.000
| Missing: Cell M20 |
This action did not result in any loss of points.
0.000
| Missing: Cell N20 |
This action did not result in any loss of points.
0.000
| Missing: Cell M21 |
This action did not result in any loss of points.
0.000
| Missing: Cell N21 |
This action did not result in any loss of points.
0.000
| Missing: Cell M22 |
This action did not result in any loss of points.
0.000
| Missing: Cell N22 |
This action did not result in any loss of points.
0.000
| Missing: Cell M23 |
This action did not result in any loss of points.
0.000
| Missing: Cell N23 |
This action did not result in any loss of points.
0.000
| Missing: Cell M24 |
This action did not result in any loss of points.
0.000
| Missing: Cell N24 |
This action did not result in any loss of points.
0.000
| Missing: Cell M25 |
This action did not result in any loss of points.
0.000
| Missing: Cell N25 |
This action did not result in any loss of points.
0.000
| Missing: Cell M26 |
This action did not result in any loss of points.
0.000
| Missing: Cell N26 |
This action did not result in any loss of points.
0.000
| Missing: Cell M27 |
This action did not result in any loss of points.
0.000
| Missing: Cell N27 |
This action did not result in any loss of points.
0.000
| Missing: Cell M28 |
This action did not result in any loss of points.
0.000
| Missing: Cell N28 |
This action did not result in any loss of points.
0.000
| Missing: Cell M29 |
This action did not result in any loss of points.
0.000
| Missing: Cell N29 |
This action did not result in any loss of points.
0.000
| Missing: Cell M30 |
This action did not result in any loss of points.
0.000
| Missing: Cell N30 |
This action did not result in any loss of points.
0.000
| Missing: Cell M31 |
This action did not result in any loss of points.
0.000
| Missing: Cell N31 |
This action did not result in any loss of points.
0.000
| Missing: Cell M32 |
This action did not result in any loss of points.
0.000
| Missing: Cell N32 |
This action did not result in any loss of points.
0.000
| Missing: Cell M33 |
This action did not result in any loss of points.
0.000
| Missing: Cell N33 |
This action did not result in any loss of points.
0.000
| Missing: Cell M34 |
This action did not result in any loss of points.
0.000
| Missing: Cell N34 |
This action did not result in any loss of points.
Payroll Data
Metropolitan Zoo
| Gift Shop Department |
Name
| No. of Dependents |
Hourly Wage |
Hours Worked |
Regular Pay |
Overtime Pay |
| Gross Pay |
| Taxable Pay |
Federal Withholding Tax |
FICA |
| Net Pay |
| Abram |
2
| $ 9.95 |
48
$ 398.00 |
$ 119.
|
|
| 40 |
$ 517.40
Project Error:: Project Error:
2 point(s) deducted in instruction #2:
– In the Cell ‘G5’ of Sheet ‘Payroll Data’, the ‘Formula’ was not set to ‘E5+F5’. |
$
| 41 |
7.40
$ 104.
| 35 |
$ 39.58 |
$ 373.47 |
| Acosta |
1
| $ 9.55 |
48
|
| 38 |
2.00
114.60 |
496.60 |
| 44 |
6.60
111.65 |
37.99 |
346.96 |
| Bordeaux |
3
|
| $ 11.75 |
50 |
| 470.00 |
176.25
Project Error:: Project Error:
1 point(s) deducted in instruction #5:
– In the Cell ‘F7’ of Sheet ‘Payroll Data’, the ‘Formula’ was not set to ‘IF(D7>$B$21,(D7-$B$21)*C7*$B$22,0)’. |
646.25 |
496.25 |
138.95 |
49.44 |
| 45 |
7.86
| Higinbotham |
1 $ 11.75 35
| 411.25 |
|
|
|
|
| – 0 |
411.25
361.25 |
90.31 |
31.46 |
289.48 |
| Ianziti |
1
| $ 10.00 |
40
|
| 400.00 |
Project Error:: Project Error:
1 point(s) deducted in instruction #5:
– In the Cell ‘E9’ of Sheet ‘Payroll Data’, the ‘Formula’ was not set to ‘IF(D9<=$B$21,D9,$B$21)*C9'.
– 0 400.00
3
| 50.0 |
0
87.50 |
30.60 |
281.90 |
| Jaussi |
1 $ 9.55 44 382.00
57.30 |
439.30 |
389.30 |
97.33 |
33.61 |
308.37 |
| Ling |
3
$ 15.75 |
40
| 630.00 |
– 0 630.00
480.00 |
134.40 |
48.20 |
447.41 |
| Munoz |
2
$ 12.25 |
20
| 245.00 |
– 0 245.00
145.00 |
21.75 |
18.74 |
204.51 |
| Riley |
3
$ 13.35 |
38
| 507.30 |
– 0 507.30
357.30 |
89.33 |
38.81 |
379.17 |
| Sabey |
2 $ 10.00 45 400.00
75.00 |
475.00 |
375.00 |
93.75 |
36.34 |
344.91 |
| Trujillo |
1 $ 9.95 15
| 149.25 |
– 0 149.25
99.25 |
14.89 |
11.42 |
122.94 |
| Weston |
2 $ 11.75 41 470.00
17.63
Project Error:: Project Error:
1 point(s) deducted in instruction #5:
– In the Cell ‘F16’ of Sheet ‘Payroll Data’, the ‘Formula’ was not set to ‘IF(D16>$B$21,(D16-$B$21)*C16*$B$22,0)’. |
487.63 |
387.63 |
96.91 |
37.30 |
353.42 |
| Totals |
$ 4,844.80
Project Error:: Project Error:
0.714 point(s) deducted in instruction #7:
– In the Cell(s) ‘E17’, ‘F17’, ‘G17’, ‘H17’, ‘I17’, ‘J17’, ‘K17’ of Sheet ‘Payroll Data’, the ‘Cell Style Name’ was not set to ‘Total’. |
$ 560.18
Project Error:: Project Error:
0.714 point(s) deducted in instruction #7:
– In the Cell(s) ‘E17’, ‘F17’, ‘G17’, ‘H17’, ‘I17’, ‘J17’, ‘K17’ of Sheet ‘Payroll Data’, the ‘Cell Style Name’ was not set to ‘Total’. |
$ 5,404.98
Project Error:: Project Error:
0.714 point(s) deducted in instruction #7:
– In the Cell(s) ‘E17’, ‘F17’, ‘G17’, ‘H17’, ‘I17’, ‘J17’, ‘K17’ of Sheet ‘Payroll Data’, the ‘Cell Style Name’ was not set to ‘Total’. |
$ 4,304.98
Project Error:: Project Error:
0.714 point(s) deducted in instruction #7:
– In the Cell(s) ‘E17’, ‘F17’, ‘G17’, ‘H17’, ‘I17’, ‘J17’, ‘K17’ of Sheet ‘Payroll Data’, the ‘Cell Style Name’ was not set to ‘Total’. |
$ 1,081.11
Project Error:: Project Error:
0.715 point(s) deducted in instruction #7:
– In the Cell(s) ‘E17’, ‘F17’, ‘G17’, ‘H17’, ‘I17’, ‘J17’, ‘K17’ of Sheet ‘Payroll Data’, the ‘Cell Style Name’ was not set to ‘Total’. |
$ 413.48
Project Error:: Project Error:
0.714 point(s) deducted in instruction #7:
– In the Cell(s) ‘E17’, ‘F17’, ‘G17’, ‘H17’, ‘I17’, ‘J17’, ‘K17’ of Sheet ‘Payroll Data’, the ‘Cell Style Name’ was not set to ‘Total’. |
Project Error:: Project Error:
2 point(s) deducted in instruction #2:
– In the Cell ‘G5’ of Sheet ‘Payroll Data’, the ‘Formula’ was not set to ‘E5+F5’. |
$ 3,910.39
Project Error:: Project Error:
0.715 point(s) deducted in instruction #7:
– In the Cell(s) ‘E17’, ‘F17’, ‘G17’, ‘H17’, ‘I17’, ‘J17’, ‘K17’ of Sheet ‘Payroll Data’, the ‘Cell Style Name’ was not set to ‘Total’. |
Project Error:: Project Error:
1 point(s) deducted in instruction #5:
– In the Cell ‘F7’ of Sheet ‘Payroll Data’, the ‘Formula’ was not set to ‘IF(D7>$B$21,(D7-$B$21)*C7*$B$22,0)’. |
Project Error:: Project Error:
1 point(s) deducted in instruction #5:
– In the Cell ‘E9’ of Sheet ‘Payroll Data’, the ‘Formula’ was not set to ‘IF(D9<=$B$21,D9,$B$21)*C9'. |
Assumptions |
Taxable Pay
Tax Rate |
Summary Statistics |
# of Hours |
Gross Pay Net Pay
| Base Work Hours |
40
$0 |
15% |
Average |
38.7 |
$ 450.41 |
$ 325.87 |
| Overtime rate |
1.5 |
$250 |
22% |
Highest |
50.0
$ 646.25 |
$ 457.86 |
| FICA rate |
7.65% |
$300 |
25% |
Lowest |
15.0 |
$ 149.25 |
$ 122.94 |
| Deduct per Depend |
$ 50.00 |
$450 |
28% |
| $525 |
31% |
| Notes |
| 1. The base workweek is 40 hours. Regular pay is based on hourly wage and hours worked up to 40. |
| 2. Overtime pay is based on overtime hours, the hourly wage, and the overtime rate. |
| 3. The gross pay is the total of the regular pay and overtime pay. |
4. The taxable pay is the difference between the gross pay
and the product of the number of dependents and deduction per dependent. |
| 5. Federal withholding tax is calculated on the taxable pay based on the tax table. |
| 6. FICA is calculated on the employee’s gross pay. |
| 7. The net pay is based on the gross pay, federal withholding tax, and FICA. |
toubasey Exp_Excel_Ch02_ML1_Payroll 2019 Project
Submission – MarkUp
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Submission MarkUp |
| This is a machine generated report of your submission document containing error details as annotations. |
|
| Details |
of all points deducted in the submitted document are listed on this sheet.
| Assignment Details |
| Submission ID |
| 48 |
75920500
| Assignment Name |
Excel Chapter 4 Mid-Level 1 – Pet Supplies (PC and Mac) |
| Submission Date |
| 20 March,
| 202 |
1
| Report Generated on |
20 March, 2021
| Points Obtained |
80.333/100 (80.333%) |
Worksheet: ‘
Inventory
‘ (
Points Deducted |
: 19.667)
Points Deducted Details
| Error Description |
| 10.000 |
Incorrect Actions: Sheet (Inventory) |
10.000 point(s) deducted in instruction #10:
-In the Sheet ‘Inventory’ the ‘Page Break set before Row’ was not set to ’28’. |
| 5.000 |
Incorrect Actions: Header(s)/Footer(s) |
5.000 point(s) deducted in instruction #12:
-In the Sheet ‘Inventory’ the ‘Center Footer Text Case’ was not set as per instruction.
-In the Sheet ‘Inventory’ the ‘Center Footer Content’ was not set to ‘&[Tab]’.
-In the Sheet ‘Inventory’ the ‘Right Footer Text Case’ was not set as per instruction.
-In the Sheet ‘Inventory’ the ‘Right Footer Content’ was not set to ‘&[File]’. |
| 4.667 |
Incorrect Actions: Conditional Format(s) |
4.667 point(s) deducted in instruction #9:
-In the Conditional formatting ‘expression’ on range ‘G2:G78’ of sheet ‘Inventory’, the ‘Background Color’ was not set to ‘Red’. |
Inventory
| Inventory ID |
Warehouse |
Supplier ID |
Department |
Amount on Hand |
Unit Price |
Inventory Value |
| 18621 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Denver |
67-1881 |
|
|
|
|
|
|
|
|
|
|
|
| Grooming |
483 |
| $ 6.00 |
$ 2,898.00 |
| 15639 |
Denver
12-6662 |
|
|
|
|
|
|
|
|
|
| Clothes |
| 140 |
| $ 8.00 |
$ 1,120.00 |
| 19801 |
Denver
32-3003 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Toys |
651 |
|
|
| $ 10.00 |
$ 6,510.00 |
| 16
| 82 |
8
Denver
99-6880 |
Clothes
41 |
$ 10.00
$ 410.00 |
| 18790 |
Denver
51-8095 |
Toys
985 |
$ 11.00 |
$ 10,835.00 |
| 19074 |
Denver
83-1
| 147 |
Grooming
916 |
$ 12.00 |
$ 10,992.00 |
| 15320 |
Denver
43-2702 |
Toys
918 |
$ 14.00 |
$ 12,852.00 |
| 16432 |
Denver
41-2655 |
|
|
|
|
|
|
|
|
|
| Food & Health |
140
$ 15.00 |
$ 2,100.00 |
| 19007 |
Denver
7-5363 |
Clothes
543 |
|
|
|
|
| $ 16.00 |
$ 8,688.00 |
| 16342 |
Denver
9-6725 |
Grooming
498 |
$ 19.00 |
$ 9,
| 46 |
2.00
| 19473 |
Denver
96-1
| 948 |
|
|
|
|
|
|
|
|
|
|
|
| Collars & Leashes |
712 |
| $ 20.00 |
$ 14,240.00 |
| 17146 |
Denver
84-9406 |
|
|
|
|
|
|
|
|
|
| Training |
129 |
$
| 23 |
.00
$ 2,967.00 |
|
| 18797 |
Denver
| 32-
| 680 |
8
Food & Health
| 437 |
|
|
| $ 24.00 |
| $ 10,488.00 |
18797 Denver 32-6
| 808 |
Grooming 437 $ 24.00 $ 10,488.00
| 11711 |
Denver
24-3362 |
Grooming
329 |
| $ 28.00 |
$ 9,212.00 |
| 11
| 485 |
Denver
31-6267 |
Toys
696 |
| $ 29.00 |
$ 20,184.00 |
| 17007 |
Denver
43-6210 |
Training
927 |
$ 29.00
$ 26,883.00 |
| 1
| 547 |
2
Denver
54-7909 |
Toys
408 |
$ 30.00 |
$ 12,240.00 |
| 19487 |
Denver
92-8378 |
Toys
236 |
$ 32.00 |
$ 7,552.00 |
| 14261 |
Denver
80-8283 |
Collars & Leashes
118 |
|
| $ 33.00 |
$ 3,894.00 |
| 186
|
| 38 |
Denver
2-1
| 553 |
Training
584 |
$ 33.00
$ 19,272.00 |
| 16745 |
Denver
57-2430 |
Grooming
| 632 |
$ 36.00 |
$ 22,752.00 |
| 16840 |
Denver
42-9356 |
Food & Health
386 |
$ 43.00 |
$ 16,598.00 |
| 17308 |
Denver
43-3691 |
Training
994 |
|
| $ 44.00 |
$ 43,736.00 |
| 13136 |
Denver
63-2
| 238 |
Food & Health 23
| $ 48.00 |
$ 1,104.00 |
| 1
|
| 565 |
1
Denver
15-6
| 231 |
Food & Health 680 $ 48.00
$ 32,640.00 |
| 13505 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Memphis |
53-4573 |
Clothes
818 |
| $ 3.00 |
$ 2,454.00 |
| 13404 |
Memphis
81-7230 |
Collars & Leashes 808 $ 6.00
$ 4,848.00 |
| 16849 |
Memphis
80-7774 |
Collars & Leashes
416 |
$ 7.00 |
$ 2,912.00 |
| 11178 |
Memphis
24-3810 |
Clothes
654 |
$ 9.00 |
$ 5,886.00 |
| 17973 |
Memphis
32-1822 |
Clothes
760 |
$ 10.00
$ 7,600.00 |
| 16437 |
Memphis
89-3177 |
Collars & Leashes
836 |
$ 18.00 |
$ 15,048.00 |
| 19160 |
Memphis
81-2610 |
Grooming 38 $ 20.00
$ 760.00 |
| 12258 |
Memphis
11-4558 |
Training
713 |
$ 21.00 |
$ 14,973.00 |
| 18861 |
Memphis
83-4623 |
Food & Health 48
|
|
|
| $ 22.00 |
$ 1,056.00 |
| 12672 |
Memphis
15-8803 |
Training
196 |
$ 22.00
$ 4,312.00 |
| 16946 |
Memphis
97-7267 |
Training
748 |
| $ 31.00 |
$ 23,188.00 |
| 18554 |
Memphis
43-1802 |
Training
734 |
$ 33.00
$ 24,222.00 |
| 18455 |
Memphis
90-8867 |
Toys 202
$ 38.00 |
$ 7,676.00 |
| 13705 |
Memphis
21-6324 |
Toys
445 |
$ 39.00 |
$ 17,355.00 |
| 1
| 213 |
6
Memphis
77-9113 |
Clothes 46
| $ 40.00 |
$ 1,840.00 |
| 1
|
| 294 |
8
Memphis
34-7020 |
Collars & Leashes 948
$ 49.00 |
$ 46,
| 452 |
.00
| 1
| 593 |
0
Memphis
6-7306 |
Toys
569 |
| $ 50.00 |
$ 28,450.00 |
| 11724 |
Memphis
76-9160 |
Clothes 485
$ 55.00 |
$ 26,675.00 |
| 12015 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Potomac |
63-6657 |
Training 565 $ 3.00
$ 1,695.00 |
| 13
| 440 |
Potomac
4-7732 |
Toys 547
| $ 5.00 |
$ 2,735.00 |
| 18113 |
Potomac
95-8142 |
Toys 452 $ 10.00
$ 4,520.00 |
| 19859 |
Potomac
84-3864 |
Training
393 |
$ 13.00 |
$ 5,109.00 |
| 11685 |
Potomac
57-4516 |
Food & Health 238 $ 16.00
$ 3,808.00 |
| 18781 |
Potomac
2-2476 |
Toys 632 $ 16.00
$ 10,112.00 |
| 17020 |
Potomac
89-8450 |
Food & Health
999 |
$ 22.00
$ 21,978.00 |
| 19744 |
Potomac
10-5462 |
Grooming
914 |
$ 22.00
$ 20,108.00 |
| 14
| 448 |
Potomac
53-8404 |
Grooming
962 |
$ 23.00 |
$ 22,126.00 |
| 19754 |
Potomac
23-1749 |
Clothes 213 $ 24.00
$ 5,112.00 |
| 11482 |
Potomac
62-2793 |
Toys 231
| $ 26.00 |
$ 6,006.00 |
| 15531 |
Potomac
66-6754 |
Clothes
709 |
$ 26.00
$ 18,434.00 |
| 11590 |
Potomac
62-9040 |
Clothes 440
$ 37.00 |
$ 16,280.00 |
| 16146 |
Potomac
66-6102 |
Collars & Leashes
380 |
$ 41.00 |
$ 15,580.00 |
| 18254 |
Potomac
33-9096 |
Food & Health
721 |
$ 44.00
$ 31,724.00 |
| 19784 |
Potomac
69-3905 |
Toys
673 |
$ 45.00 |
$ 30,285.00 |
| 12843 |
Potomac
2-9636 |
Food & Health 593
$ 47.00 |
$ 27,871.00 |
| 13822 |
Potomac
43-5490 |
Toys 565
$ 51.00 |
$ 28,815.00 |
| 19838 |
Potomac
26-5867 |
Training
589 |
$ 53.00 |
$ 31,217.00 |
| 19483 |
|
|
|
|
|
|
|
|
|
|
|
|
| San Diego |
15-5897 |
Toys
392 |
$ 5.00
$ 1,960.00 |
| 13075 |
San Diego
53-8846 |
Collars & Leashes
692 |
$ 8.00
$ 5,536.00 |
|
| 12832 |
San Diego
| 13-9209 |
Collars & Leashes 294 $ 16.00
| $ 4,704.00 |
| 11320 |
San Diego
40-1780 |
Grooming
470 |
$ 16.00
$ 7,520.00 |
12832 San Diego 13-9209 Grooming 294 $ 16.00 $ 4,704.00
| 14016 |
San Diego
23-6766 |
Toys 38 $ 22.00
$ 836.00 |
| 17513 |
San Diego
66-4757 |
Collars & Leashes 147 $ 24.00
$ 3,528.00 |
| 12806 |
San Diego
58-4302 |
Toys 553 $ 28.00
$ 15,484.00 |
| 11867 |
San Diego
55-2458 |
Food & Health 448 $ 31.00
$ 13,888.00 |
| 18698 |
San Diego
43-2218 |
Collars & Leashes
989 |
$ 40.00
$ 39,560.00 |
| 11292 |
San Diego
43-5660 |
Collars & Leashes 82
| $ 42.00 |
$ 3,444.00 |
| 15687 |
San Diego
7-6023 |
Collars & Leashes
387 |
$ 42.00
$ 16,254.00 |
| 14636 |
San Diego
74-3227 |
Grooming
677 |
$ 44.00
$ 29,788.00 |
| 14184 |
San Diego
72-7913 |
Grooming
805 |
$ 50.00
$ 40,250.00 |
| Total |
514.17 |
$ 1,046,795.00 |
toubasey ML1 pet supplies
